Export list of online dhcp leases

[arcel]

We have static dhcp mapping, and i need to get the list of active lease.
In dynamic, i can see which is online like below:
(Some details redacted)

Leases
Actions
192.168.213.141 xx:xx:7f:5c:4c:b6 ATP8105 2024/04/30 15:38:23 2024/04/30 17:38:23 online active
192.168.211.140 xx:xx:16:71:82:f8 Redmi5A-james 2024/04/30 15:38:22 2024/04/30 17:38:22 online active
192.168.209.32 xx:xx:a701:4c realme-9-Pro 2024/04/30 15:38:19 2024/04/30 17:38:19 online active

But with static mapping:
Leases
Actions
172.29.192.227 xx:xx:f4:97:5f:ac (Universal Global Scientific Industrial) LTT113545 Chris Gabo n/a n/a
172.29.192.226 fc:5c:ee:xx:xx:xx LTT113543 Lily n/a n/a
172.29.192.225 xx:xx:ee:93:ee:ff LTT113555 Irish n/a n/a

Is there a way i can generate a list of active lease?

Thanks

[Gertjan]

@arcel

These :

are all static dhcp leases.

To make the arrow 'up green' == 'online' :
Ping the them all. They reply, or don't, that not important.
What did happen : all the IP-MACs are now loaded into the local pfSense arp table ( see here : Diagnostics > ARP Table ). Take note : the arp cache will get flushed after xx seconds. If needed, an arm request will update the info.
Now the arrows will be green, and you think they are online.

If you really want to know if devices are reachable :
Make them all reply to ping. You'll discover that this can't be done with all devices. Replying to ping is optional, not mandatory.
Install something like smokeping on one of your LAN devices and have it ping everybody all the time.

[arcel]

@Gertjan

Thanks for that wonderful suggestion.
I did not notice that icon.

Actually, the icon was already lit up on device that has active lease, which i all are black until i scroll down to see other status, I just need to get the list of active one's. tried to put "online" query on Search term and voila!

Reason why i need to get numbers of active device daily for a period of time to see how many are connected for a particular project.

Thanks you very much!