# DHCP Leases to CSV

## CSV output of DHPC related items in RouterOS

### Static DHCP leases to CSV output

```
{
    # process only static leases
    :local staticLeases [/ip dhcp-server lease find where dynamic=no]
    :foreach l in=$staticLeases do={
        :local lma [/ip dhcp-server lease get $l mac-address]
        :local la [/ip dhcp-server lease get $l address]
        :local lc [/ip dhcp-server lease get $l comment]
        :put "$lma,$la,\"$lc\""
    }
}
```

### All DHCP leases to CSV output

```
{
    # process all leases
    :local staticLeases [/ip dhcp-server lease find]
    :foreach l in=$staticLeases do={
        :local lma [/ip dhcp-server lease get $l mac-address]
        :local la [/ip dhcp-server lease get $l address]
        :local lc [/ip dhcp-server lease get $l comment]
        :local ld [/ip dhcp-server lease get $l dynamic]
        :put "$lma,$la,$ld,\"$lc\""
    }
}
```

-end