Export dhcp reservations in readable format

[Tutek]

Hello,

is any way to export from fortigate dhcp reservations in any readeble (table) format, export from cli config is not usable to read?

[ebilcari]

The easiest way is to extract from GUI using the command: #execute dhcp lease-list

copy the output and while saving on an Excel file use the Text import wizard

The other way is to use API with the call: https://fw/api/v2/monitor/system/dhcp
The format is JSON formatted and can be easily integrated with any other application

      "ip":"192.168.1.102",
      "reserved":true,
      "mac":"e8:1c:ba:86:eb:66",
      "vci":"FortiSwitch-108E-POE",
      "hostname":"S108EP5918010897",
      "expire_time":1677776786,
      "status":"leased",
      "interface":"port5",
      "type":"ipv4",
      "server_mkey":3,
      "server_ipam_enabled":false