blob: 52e433ac868e82cc1bcfd4e17175b9b6a774f284 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
#! /usr/bin/perl
my ($host,$switchtype,$community) = @ARGV;
open SNMP, "snmpwalk -Os -c $community -v 2c $host -mALL ifDescr |"
or die "snmpwalk: $!";
print "begin;\n";
print "delete from portnames where switchtype='$switchtype';\n";
while (<SNMP>) {
chomp;
/^ifDescr\.(\d+) = STRING: (.*)$/ or next;
print "insert into portnames (switchtype,port,description) values ('$switchtype',$1,'$2 (port $1)');\n";
}
print "end;\n";
|
