migrating from AIX to Linux, DHCP admin question

[Glenn Satchell]

There are many free scripts that parse the lease and config files to 
display counts, status and the like. If you search the list archives for 
"dhcp status apps", there was a long thread on this about May-August 
2008. Perhaps one of these will do, or might be readily adaptable to the 
format you like. Syslog contains a record of ip / mac address pairings.

regards,
-glenn

On 09/24/10 05:49, Stewart Dean wrote:
> AIX's DHCP has a nifty administration utility callled dadmin, which,
> among other things, spits out lease reports, that look like this:
>> IP Address Status Lease Time Start Time Last Leased Proxy ClientID
>>
>> 10.20.10.45 Free
>> 10.20.10.46 Leased 24:00:00 09/23 10:01 09/23 10:01 FALSE 1-0022412c60d2
>> 10.20.10.47 Expired 24:00:00 10/09 12:36 FALSE 1-00204ab6cf2b
>> 10.20.10.48 Expired 24:00:00 09/25 09:02 FALSE 1-00204a84e7ee
> I have a mess of execs that use this, among them:
> 1) A copyright violator track-down exec that first consults the firewall
> logs to determine the internal address that was using a NAT'ed external
> address pool address at the time of the violation. It then consults
> snapshots of the entire DHCP leases and looks up the MAC that was
> leasing that address at the time of the violation. We can then track
> down that MAC and deal with the student who violated the copyright.
> 2) A DHCP lease report exec that we use to track DHCP lease saturation:
>
> DHCP Client Report - based on dadmin -s output<<<<<<<<<<
>
>>>>>>>>>> 726 Facstaff Leases on Thu Sep 23 15:18:32 EDT 2010<<<<<<<<<
>
> Lsd / Usd / RoE / Fre / Tot
> All 10.20 except 80/110/141/150 ========== 329 / 0 / 1105 / 2068 / 3502
> All 10.40 except 40/60 =================== 195 / 0 / 830 / 1199 / 4523
> 10.70.25/100/180/220/225 ================= 36 / 0 / 243 / 814 / 1093
> 10.100.20/50/70/80/90/120/130/170/180 ==== 141 / 0 / 908 / 829 / 1717
> 10.130 (PAC) ============================= 25 / 0 / 175 / 251 / 451
>
>>>>>>>>>> >>>>>>>>> 927 Student Leases on Thu Sep 23 15:18:33 EDT
>>>>>>>>>> 2010<<<<<<<<<
> Lsd / Usd / RoE / Fre / Tot
> 10.20.12/80/110/141/150 ================== 181 / 2 / 641 / 458 / 1455
> 10.40.40/60 ============================== 40 / 0 / 304 / 87 / 432
> All 10.70 except 10.70.25/100/180/220,5 == 469 / 0 / 4645 / 981 / 5766
> 10.100.10/30/40/60/81/91/100/110/140-160 = 237 / 0 / 1949 / 709 / 3041
>
>>>>>>>>>> >>>>>>>>> 1711 Wireless Leases on Thu Sep 23 15:18:33 EDT
>>>>>>>>>> 2010<<<<<<<<<
> Lsd / Usd / RoE / Fre / Tot
> 10.10.16-23 ========================= 1711 / 2 / 311 / 1 / 2031
>
>>>>>>>>>>>> >>>>>>>>>>> Archived DHCP history report in
>>>>>>>>>>>> /var/dhcpinfo<<<<<<<<<<
> Like that.....
> THE QUESTION:
> I'm to understand that Open Source ISC DHCP doesn't have dadmin. Is
> there a) a similar facility or b) has anyone out there created its
> equivalent and would be willing to share it?
>


-- 
regards,
-glenn
--
Glenn Satchell                            |  Miss 9: What do you
Uniq Advances Pty Ltd, Sydney Australia   |  do at work Dad?
mailto:glenn.satchell at uniq.com.au         |  Miss 6: He just
http://www.uniq.com.au tel:0409-458-580   |  types random stuff.