snmpoid.sql

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

--
-- Automated dump by dumpsnmpoid.py initiated at 2005-07-05 11:10:01 GMT
--
BEGIN;
DELETE FROM snmpoid WHERE oidkey='3c9300Mac';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3c9300Mac','1.3.6.1.4.1.43.29.4.10.8.1.5.1','Bridge table for 3Com SuperStack 1900','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3c9300Serial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3c9300Serial','1.3.6.1.4.1.43.29.4.18.2.1.7.1','3com9300',NULL,'0',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cDescr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cDescr','1.3.6.1.4.1.43.10.27.1.1.1.5','Description','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cHubMac';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cHubMac','1.3.6.1.4.1.43.10.9.5.1.6','Bridge table for 3Com HUBs','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cHwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cHwVer','1.3.6.1.4.1.43.10.27.1.1.1.11','Hardware version number','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cIfDescr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cIfDescr','1.3.6.1.2.1.2.2.1.2','3Com ifDescr for port and unit','3com','1','.*(Unit|Port) (\\d+)\\b.*','1','ifDescr','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='3cIfMauType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cIfMauType','1.3.6.1.2.1.26.2.1.1.3','Speed and dupelx for SWxx00','3com','1',NULL,'0','ifMauType','MAU-MIB');

DELETE FROM snmpoid WHERE oidkey='3cMac';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cMac','1.3.6.1.4.1.43.10.27.1.1.1.2','MACs on this port','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cModel';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cModel','1.3.6.1.4.1.43.10.27.1.1.1.19','Model','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cPS40PortState';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cPS40PortState','1.3.6.1.2.1.26.1.1.1.6','Port state for 3Com PS40','3com','1',NULL,'0','rpMauMediaAvailable','MAU-MIB');

DELETE FROM snmpoid WHERE oidkey='3cSSMac';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cSSMac','1.3.6.1.4.1.43.10.22.2.1.3','Bridge table for 3Com SuperStack','3com','1',NULL,'0','secureAddrMAC','SECURITY-MIB');

DELETE FROM snmpoid WHERE oidkey='3cSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cSerial','1.3.6.1.4.1.43.10.27.1.1.1.13','Serial number','3com','1',NULL,'0',NULL,NULL);

DELETE FROM snmpoid WHERE oidkey='3cSwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('3cSwVer','1.3.6.1.4.1.43.10.27.1.1.1.12','Software version number','3com','1',NULL,'0',NULL,NULL);

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

DELETE FROM snmpoid WHERE oidkey='basePortIfIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('basePortIfIndex','1.3.6.1.2.1.17.1.4.1.2','Port ifindex mapping','bridge-mib','1',NULL,'0','dot1dBasePortIfIndex','BRIDGE-MIB');

DELETE FROM snmpoid WHERE oidkey='c1900Bandwidth';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c1900Bandwidth','1.3.6.1.4.1.437.1.1.3.7.1.0','','Cricket','0',NULL,'0','bandwidthUsageCurrent','ESSWITCH.MIB');

DELETE FROM snmpoid WHERE oidkey='c1900BandwidthMax';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c1900BandwidthMax','1.3.6.1.4.1.437.1.1.3.7.5.0','','Cricket','0',NULL,'0','bandwidthUsageCurrentPeakEntry','ESSWITCH.MIB');

DELETE FROM snmpoid WHERE oidkey='c1900Duplex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c1900Duplex','1.3.6.1.4.1.437.1.1.3.3.1.1.8','Duplex status','Cisco','1',NULL,'0','swPortFullDuplex','ESSWITCH.MIB');

DELETE FROM snmpoid WHERE oidkey='c1900Portname';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c1900Portname','1.3.6.1.4.1.437.1.1.3.3.1.1.3','Portname','Cisco','1',NULL,'0','swPortName','ESSWITCH.MIB');

DELETE FROM snmpoid WHERE oidkey='c2900Bandwidth';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c2900Bandwidth','1.3.6.1.4.1.9.9.87.1.5.1.0','','Cricket','0',NULL,'0','c2900BandwidthUsageCurrent','CISCO-C2900-MIB');

DELETE FROM snmpoid WHERE oidkey='c5000Bandwidth';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c5000Bandwidth','1.3.6.1.4.1.9.5.1.1.8.0','','Cricket','0',NULL,'0','sysTraffic','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='c5000BandwidthMax';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('c5000BandwidthMax','1.3.6.1.4.1.9.5.1.1.19.0','','Cricket','0',NULL,'0','sysTrafficPeak','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardContainedByIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardContainedByIndex','1.3.6.1.4.1.9.3.6.11.1.8','cardIndex of the parent card which directly contains this card, or 0 if contained by the chassis','Cisco','1',NULL,'0',NULL,'OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardDescr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardDescr','1.3.6.1.4.1.9.3.6.11.1.3','Slot card description','Cisco','1',NULL,'0','cardDescr','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardHwVersion';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardHwVersion','1.3.6.1.4.1.9.3.6.11.1.5','Slot card hardware version','Cisco','1',NULL,'0','cardHwVersion','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardIndex';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardIndex','1.3.6.1.4.1.9.3.6.11.1.1','Slot card type','Cisco','1',NULL,'0','cardIndex','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardSerial','1.3.6.1.4.1.9.3.6.11.1.4','Slot card serial','Cisco','1','[^0]|\\w{2,}','0','cardSerial','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardSlotNumber';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardSlotNumber','1.3.6.1.4.1.9.3.6.11.1.7','Slot card slotnumber mapping','Cisco','1',NULL,'0','cardSlotNumber','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cCardSwVersion';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cCardSwVersion','1.3.6.1.4.1.9.3.6.11.1.6','Slot card software version','Cisco','1',NULL,'0','cardSwVersion','OLD-CISCO-CHASSIS-MIB');

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

DELETE FROM snmpoid WHERE oidkey='cChassisSlots';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cChassisSlots','1.3.6.1.4.1.9.3.6.12','Cisco',NULL,'1',NULL,'0','chassisSlots','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cChassisType';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cChassisType','1.3.6.1.4.1.9.3.6.1','Cisco',NULL,'1',NULL,'0','chassisType','OLD-CISCO-CHASSIS-MIB');

DELETE FROM snmpoid WHERE oidkey='cChassisVersion';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cChassisVersion','1.3.6.1.4.1.9.3.6.2','Cisco',NULL,'1',NULL,'0','chassisVersion','OLD-CISCO-CHASSIS-MIB');

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

DELETE FROM snmpoid WHERE oidkey='cHsrpGrpStandbyState';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cHsrpGrpStandbyState','1.3.6.1.4.1.9.9.106.1.2.1.1.15','cgw',NULL,'1',NULL,'0','cHsrpGrpStandbyState','CISCO-HSRP-MIB');

DELETE FROM snmpoid WHERE oidkey='cHsrpGrpVirtualIpAddr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cHsrpGrpVirtualIpAddr','1.3.6.1.4.1.9.9.106.1.2.1.1.11','cgw',NULL,'1',NULL,'0','cHsrpGrpVirtualIpAddr','CISCO-HSRP-MIB');

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

DELETE FROM snmpoid WHERE oidkey='cL3FwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cL3FwVer','1.3.6.1.4.1.9.9.92.1.1.1.7','Firmware version','cL3','1',NULL,'0',NULL,'CISCO-ENTITY-ASSET-MIB');

DELETE FROM snmpoid WHERE oidkey='cL3HwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cL3HwVer','1.3.6.1.4.1.9.9.92.1.1.1.4','Hardware version','cL3','1',NULL,'0','ceAssetHardwareRevision','CISCO-ENTITY-ASSET-MIB');

DELETE FROM snmpoid WHERE oidkey='cL3Model';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cL3Model','1.3.6.1.4.1.9.9.92.1.1.1.3','Model number','cL3','1',NULL,'0','ceAssetOrderablePartNumber','CISCO-ENTITY-ASSET-MIB');

DELETE FROM snmpoid WHERE oidkey='cL3Serial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('cL3Serial','1.3.6.1.4.1.9.9.92.1.1.1.2','Serial number','cL3','1',NULL,'0','ceAssetSerialNumber','CISCO-ENTITY-ASSET-MIB');

DELETE FROM snmpoid WHERE oidkey='cL3SwVer';