Home | History | Annotate | Line # | Download | only in contrib
dhcp-lease-list.pl revision 1.1
      1  1.1  christos #!/usr/bin/perl
      2  1.1  christos #
      3  1.1  christos # Shows current leases.
      4  1.1  christos #
      5  1.1  christos # THIS SCRIPT IS PUBLIC DOMAIN, NO RIGHTS RESERVED!
      6  1.1  christos #
      7  1.1  christos # I've removed the email addresses of Christian and vom to avoid
      8  1.1  christos # putting them on spam lists.  If either of you would like to have
      9  1.1  christos # your email in here please send mail to the DHCP bugs list at ISC.
     10  1.1  christos #
     11  1.1  christos # 2008-07-13, Christian Hammers
     12  1.1  christos #
     13  1.1  christos # 2009-06-?? - added loading progress counter, pulls hostname, adjusted formatting
     14  1.1  christos #        vom
     15  1.1  christos #
     16  1.1  christos # 2013-04-22 - added option to choose lease file, made manufacture information
     17  1.1  christos #              optional, sar
     18  1.1  christos #
     19  1.1  christos # 2016-01-19 - updated to better trim the manu string and output the hostnames, sar
     20  1.1  christos #
     21  1.1  christos # 2016-01-18 - Mainly cosmetics. Eliminated spurious output in "parsable" mode.
     22  1.1  christos #              Provided for the various conventional lease file locations. (cbp)
     23  1.1  christos 
     24  1.1  christos use strict;
     25  1.1  christos use warnings;
     26  1.1  christos use POSIX qw(strftime);
     27  1.1  christos 
     28  1.1  christos my @LEASES = ('/var/db/dhcpd.leases', '/var/lib/dhcp/dhcpd.leases', '/var/lib/dhcp3/dhcpd.leases');
     29  1.1  christos my @all_leases;
     30  1.1  christos my @leases;
     31  1.1  christos 
     32  1.1  christos my @OUIS = ('/usr/share/misc/oui.txt', '/usr/local/etc/oui.txt');
     33  1.1  christos my $OUI_URL = 'http://standards.ieee.org/regauth/oui/oui.txt';
     34  1.1  christos my $oui;
     35  1.1  christos 
     36  1.1  christos my %data;
     37  1.1  christos 
     38  1.1  christos my $opt_format = 'human';
     39  1.1  christos my $opt_keep = 'active';
     40  1.1  christos 
     41  1.1  christos our $total_leases = 0;
     42  1.1  christos 
     43  1.1  christos ## Return manufactorer name for specified MAC address (aa:bb:cc:dd:ee:ff).
     44  1.1  christos sub get_manufactorer_for_mac($) {
     45  1.1  christos     my $manu = "-NA-";
     46  1.1  christos 
     47  1.1  christos     if (defined $oui) {
     48  1.1  christos 	$manu = join('-', ($_[0] =~ /^(..):(..):(..):/));
     49  1.1  christos 	$manu = `grep -i '$manu' $oui | cut -f3`;
     50  1.1  christos 	$manu =~ s/^\s+|\s+$//g;
     51  1.1  christos     }
     52  1.1  christos 
     53  1.1  christos     return $manu;
     54  1.1  christos }
     55  1.1  christos 
     56  1.1  christos ## Read oui.txt or print warning.
     57  1.1  christos sub check_oui_file() {
     58  1.1  christos 
     59  1.1  christos     for my $oui_cand (@OUIS) {
     60  1.1  christos         if ( -r $oui_cand) {
     61  1.1  christos         $oui = $oui_cand;
     62  1.1  christos         last;
     63  1.1  christos         }
     64  1.1  christos     }
     65  1.1  christos 
     66  1.1  christos     if (not defined $oui) {
     67  1.1  christos 	print(STDERR "To get manufacturer names please download $OUI_URL ");
     68  1.1  christos 	print(STDERR "to /usr/local/etc/oui.txt\n");
     69  1.1  christos     }
     70  1.1  christos }
     71  1.1  christos 
     72  1.1  christos ## Read current leases file into array.
     73  1.1  christos sub read_dhcpd_leases() {
     74  1.1  christos 
     75  1.1  christos     my $db;
     76  1.1  christos     for my $db_cand (@LEASES) {
     77  1.1  christos         if ( -r $db_cand) {
     78  1.1  christos     $db = $db_cand;
     79  1.1  christos     last;
     80  1.1  christos         }
     81  1.1  christos     }
     82  1.1  christos     die("Cannot find leases db") unless defined $db;
     83  1.1  christos     open(F, $db) or die("Cannot open $db: $!");
     84  1.1  christos     print("Reading leases from $db\n") if $opt_format eq 'human';
     85  1.1  christos     my $content = join('', <F>);
     86  1.1  christos     close(F);
     87  1.1  christos     @all_leases = split(/lease/, $content);
     88  1.1  christos 
     89  1.1  christos     foreach my $lease (@all_leases) {
     90  1.1  christos     if ($lease =~ /^\s+([\.\d]+)\s+{.*starts \d+ ([\/\d\ \:]+);.*ends \d+ ([\/\d\ \:]+);.*ethernet ([a-f0-9:]+);/s) {
     91  1.1  christos        ++$total_leases;
     92  1.1  christos        }
     93  1.1  christos     }
     94  1.1  christos }
     95  1.1  christos 
     96  1.1  christos ## Add manufactor name and sort out obsolet assignements.
     97  1.1  christos sub process_leases() {
     98  1.1  christos     my $gm_now = strftime("%Y/%m/%d %H:%M:%S", gmtime());
     99  1.1  christos     my %tmp_leases; # for sorting and filtering
    100  1.1  christos 
    101  1.1  christos     my $counter = $opt_format eq 'human' ? 1 : 0;
    102  1.1  christos 
    103  1.1  christos     # parse entries
    104  1.1  christos     foreach my $lease (@all_leases) {
    105  1.1  christos 	# skip invalid lines
    106  1.1  christos 	next if not ($lease =~ /^\s+([\.\d]+)\s+{.*starts \d+ ([\/\d\ \:]+);.*ends \d+ ([\/\d\ \:]+);.*ethernet ([a-f0-9:]+);(.*client-hostname \"(\S+)\";)*/s);
    107  1.1  christos 	# skip outdated lines
    108  1.1  christos 	next if ($opt_keep eq 'active'  and  $3 lt $gm_now);
    109  1.1  christos 
    110  1.1  christos 	if ($counter) {
    111  1.1  christos 	    my $percent = (($counter / $total_leases)*100);
    112  1.1  christos 	    printf "Processing: %2d%% complete\r", $percent;
    113  1.1  christos 	    ++$counter;
    114  1.1  christos 	}
    115  1.1  christos 
    116  1.1  christos 	my $hostname = "-NA-";
    117  1.1  christos 	if ($6) {
    118  1.1  christos 	    $hostname = $6;
    119  1.1  christos 	}
    120  1.1  christos 
    121  1.1  christos 	my $mac = $4;
    122  1.1  christos 	my $date_end = $3;
    123  1.1  christos 	my %entry = (
    124  1.1  christos 	    'ip' => $1,
    125  1.1  christos 	    'date_begin' => $2,
    126  1.1  christos 	    'date_end' => $date_end,
    127  1.1  christos 	    'mac' => $mac,
    128  1.1  christos 	    'hostname' => $hostname,
    129  1.1  christos 	    'manu' => get_manufactorer_for_mac($mac),
    130  1.1  christos 	    );
    131  1.1  christos 
    132  1.1  christos 	$entry{'date_begin'} =~ s#\/#-#g; # long live ISO 8601
    133  1.1  christos 	$entry{'date_end'}   =~ s#\/#-#g;
    134  1.1  christos 
    135  1.1  christos 	if ($opt_keep eq 'all') {
    136  1.1  christos 	    push(@leases, \%entry);
    137  1.1  christos 	} elsif (not defined $tmp_leases{$mac}  or  $tmp_leases{$mac}{'date_end'} gt $date_end) {
    138  1.1  christos 	    $tmp_leases{$mac} = \%entry;
    139  1.1  christos 	}
    140  1.1  christos     }
    141  1.1  christos 
    142  1.1  christos     # In case we used the hash to filtered
    143  1.1  christos     if (%tmp_leases) {
    144  1.1  christos 	foreach (sort keys %tmp_leases) {
    145  1.1  christos 	    my $h = $tmp_leases{$_};
    146  1.1  christos 	    push(@leases, $h);
    147  1.1  christos 	}
    148  1.1  christos     }
    149  1.1  christos 
    150  1.1  christos     # print "\n";
    151  1.1  christos 
    152  1.1  christos }
    153  1.1  christos 
    154  1.1  christos # Output all valid leases.
    155  1.1  christos sub output_leases() {
    156  1.1  christos     if ($opt_format eq 'human') {
    157  1.1  christos 	printf "%-19s%-16s%-15s%-20s%-20s\n","MAC","IP","hostname","valid until","manufacturer";
    158  1.1  christos 	print("===============================================================================================\n");
    159  1.1  christos     }
    160  1.1  christos     foreach (@leases) {
    161  1.1  christos        if ($opt_format eq 'human') {
    162  1.1  christos 	   printf("%-19s%-16s%-14.14s %-20s%-20s\n",
    163  1.1  christos 		  $_->{'mac'},       # MAC
    164  1.1  christos 		  $_->{'ip'},        # IP address
    165  1.1  christos 		  $_->{'hostname'},  # hostname
    166  1.1  christos 		  $_->{'date_end'},  # Date
    167  1.1  christos 		  $_->{'manu'});     # manufactor name
    168  1.1  christos        } else {
    169  1.1  christos 	   printf("MAC %s IP %s HOSTNAME %s BEGIN %s END %s MANUFACTURER %s\n",
    170  1.1  christos 		  $_->{'mac'},
    171  1.1  christos 		  $_->{'ip'},
    172  1.1  christos 		  $_->{'hostname'},
    173  1.1  christos 		  $_->{'date_begin'},
    174  1.1  christos 		  $_->{'date_end'},
    175  1.1  christos 		  $_->{'manu'});
    176  1.1  christos        }
    177  1.1  christos     }
    178  1.1  christos }
    179  1.1  christos 
    180  1.1  christos # Commandline Processing.
    181  1.1  christos sub cli_processing() {
    182  1.1  christos     while (my $arg = shift(@ARGV)) {
    183  1.1  christos 	if ($arg eq '--help') {
    184  1.1  christos 	    print(
    185  1.1  christos 		"Prints active DHCP leases.\n\n".
    186  1.1  christos 		"Usage: $0 [options]\n".
    187  1.1  christos 		" --help      shows this help\n".
    188  1.1  christos 		" --parsable  machine readable output with full dates\n".
    189  1.1  christos 		" --last      prints the last (even if end<now) entry for every MAC\n".
    190  1.1  christos 		" --all       prints all entries i.e. more than one per MAC\n".
    191  1.1  christos 		" --lease     uses the next argument as the name of the lease file\n".
    192  1.1  christos 		"             the default is to try /var/db/dhcpd.leases then\n".
    193  1.1  christos 		"             /var/lib/dhcp/dhcpd.leases then\n".
    194  1.1  christos 		"             /var/lib/dhcp3/dhcpd.leases\n".
    195  1.1  christos 		"\n");
    196  1.1  christos 	    exit(0);
    197  1.1  christos 	} elsif ($arg eq '--parsable') {
    198  1.1  christos 	    $opt_format = 'parsable';
    199  1.1  christos 	} elsif ($arg eq '--last') {
    200  1.1  christos 	    $opt_keep = 'last';
    201  1.1  christos 	} elsif ($arg eq '--all') {
    202  1.1  christos 	    $opt_keep = 'all';
    203  1.1  christos 	} elsif ($arg eq '--lease') {
    204  1.1  christos 	    unshift @LEASES, shift(@ARGV);
    205  1.1  christos 	} else {
    206  1.1  christos 	    die("Unknown option $arg");
    207  1.1  christos 	}
    208  1.1  christos     }
    209  1.1  christos }
    210  1.1  christos 
    211  1.1  christos #
    212  1.1  christos # main()
    213  1.1  christos #
    214  1.1  christos cli_processing();
    215  1.1  christos check_oui_file();
    216  1.1  christos read_dhcpd_leases();
    217  1.1  christos process_leases();
    218  1.1  christos output_leases();
    219