snmpoid.sql

Network Administration Visualized 网络管理可视化源码

VALUES ('ifHCOutUcastPkts','1.3.6.1.2.1.31.1.1.1.11','','mib-II','1',NULL,'0','ifHCOutUcastPkts','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInDiscards';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInDiscards','1.3.6.1.2.1.2.2.1.13','','mib-II','1',NULL,'0','ifInDiscards','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInErrors';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInErrors','1.3.6.1.2.1.2.2.1.14','Number of inbound packets that contained errors','mib-II','1',NULL,'0','ifInErrors','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInNUcastPkts';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInNUcastPkts','1.3.6.1.2.1.2.2.1.12','','mib-II','1',NULL,'0','ifInNUcastPkts','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInOctets';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInOctets','1.3.6.1.2.1.2.2.1.10','Number of octets received on the interface','mib-II','1',NULL,'0','ifInOctets','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInUcastPkts';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInUcastPkts','1.3.6.1.2.1.2.2.1.11','Packets which were not addressed to a multicast or broadcast address at this sub-layer','mib-II','1',NULL,'0','ifInUcastPkts','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifInUnknownProtos';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifInUnknownProtos','1.3.6.1.2.1.2.2.1.15','','mib-II','1',NULL,'0','ifInUnknownProtos','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifIndex','1.3.6.1.2.1.2.2.1.1','standard','mib-II','1',NULL,'0','ifIndex','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifLastChange';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifLastChange','1.3.6.1.2.1.2.2.1.9','standard','mib-II','1',NULL,'0','ifLastChange','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifMtu';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifMtu','1.3.6.1.2.1.2.2.1.4','standard','mib-II','1',NULL,'0','ifMtu','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifName','1.3.6.1.2.1.31.1.1.1.1','standard','mib-II','1',NULL,'0','ifName','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifNumber';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifNumber','1.3.6.1.2.1.2.1.0','standard','mib-II','0',NULL,'0','ifNumber','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOperStatus';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOperStatus','1.3.6.1.2.1.2.2.1.8','standard','mib-II','1',NULL,'0','ifOperStatus','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutDiscards';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutDiscards','1.3.6.1.2.1.2.2.1.19','','mib-II','1',NULL,'0','ifOutDiscards','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutErrors';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutErrors','1.3.6.1.2.1.2.2.1.20','Number of outbound packets that could not be transmitted because of errors','mib-II','1',NULL,'0','ifOutErrors','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutNUcastPkts';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutNUcastPkts','1.3.6.1.2.1.2.2.1.18','','mib-II','1',NULL,'0','ifOutNUcastPkts','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutOctets';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutOctets','1.3.6.1.2.1.2.2.1.16','Number of octets transmitted out of the interface','mib-II','1',NULL,'0','ifOutOctets','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutQLen';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutQLen','1.3.6.1.2.1.2.2.1.21','','mib-II','1',NULL,'0','ifOutQLen','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifOutUcastPkts';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifOutUcastPkts','1.3.6.1.2.1.2.2.1.17','Packets that higher-level protocols requested be transmitted, and which were not addressed to a multicast or broadcast address at this sub-layer','mib-II','1',NULL,'0','ifOutUcastPkts','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifPhysAddress';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifPhysAddress','1.3.6.1.2.1.2.2.1.6','standard','mib-II','1',NULL,'0','ifPhysAddress','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifPortName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifPortName','1.3.6.1.4.1.9.2.2.1.1.28','ios-sw',NULL,'1',NULL,'0','locIfDescr','OLD-CISCO-INTERFACES-MIB');

DELETE FROM snmpoid WHERE oidkey='ifSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifSerial','1.3.6.1.2.1.47.1.1.1.1.11.1','standard',NULL,'0',NULL,'0','entPhysicalSerialNum','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='ifSpeed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifSpeed','1.3.6.1.2.1.2.2.1.5','standard','mib-II','1',NULL,'0','ifSpeed','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifHighSpeed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifHighSpeed','1.3.6.1.2.1.31.1.1.1.15','Interface speed as a number of Mbps','mib-II','1',NULL,'0','ifHighSpeed','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifTrunk';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifTrunk','1.3.6.1.4.1.9.9.46.1.6.1.1.14','cL3-sw',NULL,'1',NULL,'0','vlanTrunkPortDynamicStatus','CISCO-VTP-MIB');

DELETE FROM snmpoid WHERE oidkey='ifType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifType','1.3.6.1.2.1.2.2.1.3','standard','mib-II','1',NULL,'0','ifType','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifVlan';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifVlan','1.3.6.1.4.1.9.9.68.1.2.2.1.2','ios-sw',NULL,'1',NULL,'0','vmVlan','CISCO-VLAN-MEMBERSHIP-MIB');

DELETE FROM snmpoid WHERE oidkey='ifVlansAllowed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifVlansAllowed','1.3.6.1.4.1.9.9.46.1.6.1.1.4','cL3-sw',NULL,'1',NULL,'0','vlanTrunkPortVlansEnabled','CISCO-VTP-MIB');

DELETE FROM snmpoid WHERE oidkey='iosDuplex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('iosDuplex','1.3.6.1.4.1.9.9.87.1.4.1.1.32.0','ios-sw',NULL,'1',NULL,'0','c2900PortDuplexStatus','CISCO-C2900-MIB');

DELETE FROM snmpoid WHERE oidkey='iosPortIfindex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('iosPortIfindex','1.3.6.1.4.1.9.9.87.1.4.1.1.25.0','ios-sw',NULL,'1',NULL,'0','c2900PortIfIndex','CISCO-C2900-MIB');

DELETE FROM snmpoid WHERE oidkey='iosTrunk';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('iosTrunk','1.3.6.1.4.1.9.9.87.1.4.1.1.6.0','ios-sw',NULL,'1',NULL,'0','c2900PortMayForwardFrames','CISCO-C2900-MIB');

DELETE FROM snmpoid WHERE oidkey='ipAdEntIfIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipAdEntIfIndex','1.3.6.1.2.1.4.20.1.2','cgw',NULL,'1',NULL,'0','ipAdEntIfIndex','IP-MIB');

DELETE FROM snmpoid WHERE oidkey='ipAdEntIfNetMask';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipAdEntIfNetMask','1.3.6.1.2.1.4.20.1.3','cgw',NULL,'1',NULL,'0','ipAdEntNetMas','IP-MIB');

DELETE FROM snmpoid WHERE oidkey='ipNetToMediaPhysAddress';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipNetToMediaPhysAddress','1.3.6.1.2.1.4.22.1.2','ARP cache','mib-II','1',NULL,'0','ipNetToMediaPhysAddress','RFC1213-MIB');

DELETE FROM snmpoid WHERE oidkey='ipRouteDest';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteDest','1.3.6.1.2.1.4.21.1.1','The destination IP address of this route',NULL,'1',NULL,'0','ipRouteDest','RFC1213');

DELETE FROM snmpoid WHERE oidkey='ipRouteIfIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteIfIndex','1.3.6.1.2.1.4.21.1.2','The index value which uniquely identifies the local interface through which the next hop of this route should be reached',NULL,'1',NULL,'0','ipRouteIfIndex','RFC1213');

DELETE FROM snmpoid WHERE oidkey='ipRouteMask';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteMask','1.3.6.1.2.1.4.21.1.11','Indicate the mask to be logical-ANDed with the destination address before being compared to the value in the ipRouteDest field',NULL,'1',NULL,'0','ipRouteMask','RFC1213');

DELETE FROM snmpoid WHERE oidkey='ipRouteNextHop';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteNextHop','1.3.6.1.2.1.4.21.1.7','The IP address of the next hop of this route',NULL,'1',NULL,'0','ipRouteNextHop','RFC1213');

DELETE FROM snmpoid WHERE oidkey='ipRouteProto';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteProto','1.3.6.1.2.1.4.21.1.9','The routing mechanism via which this route was learned',NULL,'1',NULL,'0','ipRouteProto','RFC1213');

DELETE FROM snmpoid WHERE oidkey='ipRouteType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ipRouteType','1.3.6.1.2.1.4.21.1.8','The type of route, 1=other, 2=invalid, 3=direct, 4=indirect',NULL,'1',NULL,'0','ipRouteType','RFC1213');

DELETE FROM snmpoid WHERE oidkey='macPortEntry';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('macPortEntry','1.3.6.1.2.1.17.4.3.1.2','Bridge table for various switches','bridge-mib','1',NULL,'0','dot1dTpFdbPort','BRIDGE-MIB');

DELETE FROM snmpoid WHERE oidkey='mem5minFree';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('mem5minFree','1.3.6.1.4.1.9.9.48.1.1.1.6.1','','Cricket','0',NULL,'0','ciscoMemoryPoolFree','CISCO-MEMORY-POOL-MIB');

DELETE FROM snmpoid WHERE oidkey='mem5minUsed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('mem5minUsed','1.3.6.1.4.1.9.9.48.1.1.1.5.1','','Cricket','0',NULL,'0','ciscoMemoryPoolUsed','CISCO-MEMORY-POOL-MIB');