snmpoid.sql

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

INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cL3SwVer','1.3.6.1.4.1.9.9.92.1.1.1.8','Software version','cL3','1',NULL,'0','ceAssetFirmwareRevision','CISCO-ENTITY-ASSET-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuDuplex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuDuplex','1.3.6.1.4.1.9.5.14.4.1.1.5','Port duplex state','Cisco','1',NULL,'0','ciscoEsPortDuplex','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuIfIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuIfIndex','1.3.6.1.4.1.9.5.14.4.1.1.4','Ifindex to port mapping','Cisco','1',NULL,'0','ciscoEsPortIfIndex','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuMac';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuMac','1.3.6.1.4.1.9.5.14.4.3.1.4.1','Bridge table for Cisco menu type switch','cisco','1',NULL,'0','ciscoEsPortStnLocation','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuPortStatus';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuPortStatus','1.3.6.1.4.1.9.5.14.4.1.1.29','Port state, up or down','Cisco','1',NULL,'0','ciscoEsPortLinkState','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuPortType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuPortType','1.3.6.1.4.1.9.5.14.4.1.1.41','Port type, media','Cisco','1',NULL,'0','ciscoEsPortType','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuTrunk';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuTrunk','1.3.6.1.4.1.9.5.14.4.1.1.44','Port trunk state','Cisco','1',NULL,'0','ciscoEsPortISLOperStatus','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cMenuVlan';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cMenuVlan','1.3.6.1.4.1.9.5.14.8.1.1.3','Port trunk state','Cisco','1',NULL,'0','ciscoEsVLANPortPorts','CISCO-ES-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cModel';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cModel','1.3.6.1.4.1.9.3.6.11.1.2','cgw',NULL,'1',NULL,'0','cardType','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cSerial','1.3.6.1.4.1.9.3.6.3','cgw',NULL,'1',NULL,'0','chassisId','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cSw';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cSw','1.3.6.1.4.1.9.3.6.11.1.6','cgw',NULL,'1',NULL,'0','cardSwVersion','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='catModuleFwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catModuleFwVer','1.3.6.1.4.1.9.5.1.3.1.1.19','Module firmware version','cat','1',NULL,'0',NULL,'CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='catModuleHwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catModuleHwVer','1.3.6.1.4.1.9.5.1.3.1.1.18','Module hardware version','cat','1',NULL,'0',NULL,'CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='catModuleModel';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catModuleModel','1.3.6.1.4.1.9.5.1.3.1.1.17','Module model','cat','1',NULL,'0',NULL,'CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='catModuleSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catModuleSerial','1.3.6.1.4.1.9.5.1.3.1.1.26','Serial number','cat','1',NULL,'0',NULL,'CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='catModuleSwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catModuleSwVer','1.3.6.1.4.1.9.5.1.3.1.1.20','Module software version','cat','1',NULL,'0',NULL,'CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='catSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('catSerial','1.3.6.1.4.1.9.5.1.2.19','Serial number','cat','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='cdpNeighbour';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cdpNeighbour','1.3.6.1.4.1.9.9.23.1.2.1.1.6','CDP neighbour','cisco','1',NULL,'0','cdpCacheDeviceId','CISCO-CDP-MIB');

DELETE FROM snmpoid WHERE oidkey='cdpRemoteIf';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cdpRemoteIf','1.3.6.1.4.1.9.9.23.1.2.1.1.7','CDP remote interface','cisco','1',NULL,'0','cdpCacheDevicePort','CISCO-CDP-MIB');

DELETE FROM snmpoid WHERE oidkey='cpu1min';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cpu1min','1.3.6.1.4.1.9.2.1.57.0','','Cricket','0',NULL,'0','avgBusy1','OLD-CISCO-CPU-MIB');

DELETE FROM snmpoid WHERE oidkey='cpu5min';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cpu5min','1.3.6.1.4.1.9.2.1.58.0','','Cricket','0',NULL,'0','avgBusy5','OLD-CISCO-CPU-MIB');

DELETE FROM snmpoid WHERE oidkey='dnscheck';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('dnscheck','1.3.6.1.2.1.1.5.0','Used by the DNSCheck plugin; is identical to sysname','mib-II','0',NULL,'1','sysName','SNMPv2-MIB');

DELETE FROM snmpoid WHERE oidkey='flashFree';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('flashFree','1.3.6.1.4.1.9.9.10.1.1.4.1.1.5','Flash free','cisco','1',NULL,'0','ciscoFlashPartitionFreeSpace','CISCO-FLASH-MIB');

DELETE FROM snmpoid WHERE oidkey='flashName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('flashName','1.3.6.1.4.1.9.9.10.1.1.4.1.1.10','Flash name','cisco','1',NULL,'0',' ciscoFlashPartitionName','CISCO-FLASH-MIB');

DELETE FROM snmpoid WHERE oidkey='flashSize';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('flashSize','1.3.6.1.4.1.9.9.10.1.1.4.1.1.4','Flash size','cisco','1',NULL,'0','ciscoFlashPartitionSize','CISCO-FLASH-MIB');

DELETE FROM snmpoid WHERE oidkey='hpFwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpFwVer','1.3.6.1.4.1.11.2.14.11.5.1.1.4.0','Firmware revision number','hp','0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpModules';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpModules','1.3.6.1.4.1.11.2.14.11.5.1.10.4.1.4','unitChange','hp','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpPortType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpPortType','1.3.6.1.4.1.11.2.14.11.5.1.7.1.3.1.1.2','Type of each port (media, duplex)','hp','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpStack';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpStack','1.3.6.1.4.1.11.2.14.11.5.1.10.4.1.1','Lists modules in the stack','hp','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpStackName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpStackName','1.3.6.1.4.1.11.2.14.11.5.1.10.3.1.0','Name of stack','hp','0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpStackStatsMemberOperStatus';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpStackStatsMemberOperStatus','1.3.6.1.4.1.11.2.14.11.5.1.10.4.1.5','HP stack member status','hp','1',NULL,'0','hpStackStatsMemberOperStatus','HP-MIB');

DELETE FROM snmpoid WHERE oidkey='hpSwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpSwVer','1.3.6.1.4.1.11.2.14.11.5.1.1.3.0','Software version number','hp','0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpVlan';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpVlan','1.3.6.1.4.1.11.2.14.11.5.1.7.1.15.3.1.1','Vlan for each port','hp','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpcpu';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpcpu','1.3.6.1.4.1.11.2.14.11.5.1.9.6.1.0','','Cricket','0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpmem5minFree';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpmem5minFree','1.3.6.1.4.1.11.2.14.11.5.1.1.2.2.1.1.6.1','','Cricket','0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='hpmem5minUsed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('hpmem5minUsed','1.3.6.1.4.1.11.2.14.11.5.1.1.2.2.1.1.7.1','','Cricket','0',NULL,'0',NULL,NULL);

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

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

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

DELETE FROM snmpoid WHERE oidkey='ifHCInOctets';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifHCInOctets','1.3.6.1.2.1.31.1.1.1.6','The total number of octets received on the interface, including framing characters. This object is a 64-bit version of ifInOctets.','mib-II','1',NULL,'0','ifHCInOctets','IF-MIB');

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

DELETE FROM snmpoid WHERE oidkey='ifHCOutOctets';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ifHCOutOctets','1.3.6.1.2.1.31.1.1.1.10','The total number of octets transmitted out of the interface, including framing characters. This object is a 64-bit version of ifOutOctets.','mib-II','1',NULL,'0','ifHCOutOctets','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ifHCOutUcastPkts';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)