snmpoid.sql

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

DELETE FROM snmpoid WHERE oidkey='memFree';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('memFree','1.3.6.1.4.1.9.9.48.1.1.1.6','Mem free','cisco','1',NULL,'0','ciscoMemoryPoolFree','CISCO-MEMORY-POOL-MIB');

DELETE FROM snmpoid WHERE oidkey='memName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('memName','1.3.6.1.4.1.9.9.48.1.1.1.2','Mem name','cisco','1',NULL,'0','ciscoMemoryPoolName','CISCO-MEMORY-POOL-MIB');

DELETE FROM snmpoid WHERE oidkey='memUsed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('memUsed','1.3.6.1.4.1.9.9.48.1.1.1.5','Mem used','cisco','1',NULL,'0','ciscoMemoryPoolUsed','CISCO-MEMORY-POOL-MIB');

DELETE FROM snmpoid WHERE oidkey='moduleMon';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('moduleMon','1.3.6.1.2.1.2.2.1.1','Used by the module monitor; is identical to ifIndex','mib-II','1',NULL,'0','ifIndex','IF-MIB');

DELETE FROM snmpoid WHERE oidkey='ospfIfMetricMetric';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('ospfIfMetricMetric','1.3.6.1.2.1.14.8.1.4','cgw',NULL,'1',NULL,'0','ospfIfMetricValue','OSPF-MIB');

DELETE FROM snmpoid WHERE oidkey='physClass';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physClass','1.3.6.1.2.1.47.1.1.1.1.5','An indication of the general hardware type of the physical entity','mib-II','1',NULL,'0','entPhysicalClass','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physContainedIn';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physContainedIn','1.3.6.1.2.1.47.1.1.1.1.4','The value of entPhysicalIndex for the physical entity which contains this physical entity','mib-II','1',NULL,'0','entPhysicalContainedIn','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physDescr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physDescr','1.3.6.1.2.1.47.1.1.1.1.2','A textual description of physical entity','mib-II','1',NULL,'0','entPhysicalDescr','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physFwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physFwVer','1.3.6.1.2.1.47.1.1.1.1.9','The vendor-specific firmware revision string for the physical entity','mib-II','1',NULL,'0','entPhysicalFirmwareRev','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physHwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physHwVer','1.3.6.1.2.1.47.1.1.1.1.8','The vendor-specific hardware revision string for the physical entity','mib-II','1',NULL,'0','entPhysicalHardwareRev','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physMfgName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physMfgName','1.3.6.1.2.1.47.1.1.1.1.12','The name of the manufacturer of this physical component','mib-II','1',NULL,'0','entPhysicalMfgName','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physModelName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physModelName','1.3.6.1.2.1.47.1.1.1.1.13','The vendor-specific model name identifier string associated with this physical component','mib-II','1',NULL,'0','entPhysicalModelName','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physName','1.3.6.1.2.1.47.1.1.1.1.7','The textual name of the physical entity','mib-II','1',NULL,'0','entPhysicalName','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physParentRelPos';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physParentRelPos','1.3.6.1.2.1.47.1.1.1.1.6','','mib-II','1',NULL,'0','entPhysicalParentRelPos','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physSerial';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physSerial','1.3.6.1.2.1.47.1.1.1.1.11','The vendor-specific serial number string for the physical entity','mib-II','1',NULL,'0','entPhysicalSerialNum','ENTITY-MIB');

DELETE FROM snmpoid WHERE oidkey='physSwVer';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('physSwVer','1.3.6.1.2.1.47.1.1.1.1.10','The vendor-specific software revision string for the physical entity','mib-II','1',NULL,'0','entPhysicalSoftwareRev','ENTITY-MIB');

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

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

DELETE FROM snmpoid WHERE oidkey='portPortName';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('portPortName','1.3.6.1.4.1.9.5.1.4.1.1.4','cat-sw',NULL,'1',NULL,'0','portName','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='portTrunk';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('portTrunk','1.3.6.1.4.1.9.5.1.9.3.1.8','cat-sw',NULL,'1',NULL,'0','vlanPortIslOperStatus','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='portVlan';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('portVlan','1.3.6.1.4.1.9.5.1.9.3.1.3','cat-sw',NULL,'1',NULL,'0','vlanPortVlan','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='portVlansAllowed';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('portVlansAllowed','1.3.6.1.4.1.9.5.1.9.3.1.5','cat-sw',NULL,'1',NULL,'0','vlanPortIslVlansAllowed','CISCO-STACK-MIB');

DELETE FROM snmpoid WHERE oidkey='stpPortState';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('stpPortState','1.3.6.1.2.1.17.2.15.1.3','Spanning tree port state','bridge-mib','1',NULL,'0','dot1dStpPortState','BRIDGE-MIB');

DELETE FROM snmpoid WHERE oidkey='sysDescr';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('sysDescr','1.3.6.1.2.1.1.1.0','','mib-II','0',NULL,'0','sysDescr','SNMPv2-MIB');

DELETE FROM snmpoid WHERE oidkey='sysLocation';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('sysLocation','1.3.6.1.2.1.1.6','System location','mib-II','1',NULL,'0','sysLocation','SNMPv2-MIB');

DELETE FROM snmpoid WHERE oidkey='sysUpTime';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('sysUpTime','1.3.6.1.2.1.1.3.0','','mib-II','0',NULL,'0','sysUpTime','SNMPv2-MIB');

DELETE FROM snmpoid WHERE oidkey='sysname';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('sysname','1.3.6.1.2.1.1.5.0','all',NULL,'0',NULL,'0','sysName','SNMPv2-MIB');

DELETE FROM snmpoid WHERE oidkey='tempInlet';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('tempInlet','1.3.6.1.4.1.9.9.13.1.3.1.3.1','','Cricket','0',NULL,'0','ciscoEnvMonTemperatureStatusValue','CISCO-ENVMON-MIB');

DELETE FROM snmpoid WHERE oidkey='tempOutlet';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('tempOutlet','1.3.6.1.4.1.9.9.13.1.3.1.3.3','','Cricket','0',NULL,'0','ciscoEnvMonTemperatureStatusValue','CISCO-ENVMON-MIB');

DELETE FROM snmpoid WHERE oidkey='typeoid';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('typeoid','1.3.6.1.2.1.1.2.0','all',NULL,'0',NULL,'0','sysObjectID','SNMPv2-MIB');

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

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

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

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

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

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

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

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

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

DELETE FROM snmpoid WHERE oidkey='vtpVlanState';
INSERT INTO snmpoid (oidkey, snmpoid, descr, oidsource, getnext, match_regex, decodehex, oidname, mib)
VALUES ('vtpVlanState','1.3.6.1.4.1.9.9.46.1.3.1.1.2','The state of this VLAN','cisco','1',NULL,'0','vtpVlanState','CISCO-VTP-MIB');

UPDATE snmpoid SET defaultfreq=3600 WHERE oidkey IN ('moduleMon', '3cPS40PortState', 'hpStackStatsMemberOperStatus');

UPDATE snmpoid SET getnext=true, uptodate=true;
UPDATE netbox SET uptodate=false;

COMMIT;