Thanks,
yes, i will add to tracker, i had opened a request yesterday, then spotted i had no phase data, so cancelled. given that there is a warning in the doco that you want O/S's to be a generic as possible, should a ups os be created, with an allowance for a brand ?
emerson.inc.php is a copy of liebert.inc.php. cat ./includes/polling/os/emerson.inc.php <?php
/** * Observium * * This file is part of Observium. * * @package observium * @subpackage poller * @copyright (C) 2006-2014 Adam Armstrong * */
// Uses UPS-MIB include("includes/polling/os/ups-mib.inc.php");
// EOF
DEBUG! -[0;32mObservium v0.14.4.5185 -[1;37mDiscovery -[0m-[0m
SQL[-[0;33mSELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1-[0m] -[0m
SQL[-[0;33mSELECT revision FROM `dbSchema`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `devices` WHERE status = 1 AND disabled = 0 AND `hostname` LIKE 'dc6ups01' ORDER BY device_id DESC-[0m] -[0m
SQL[-[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '6'-[0m] -[0m dc6ups01 6 emerson DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Ovq -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' sysDescr.0 Mfgr=Chloride, Model=AM-P3-CN, SN=1112-b27a, OSVer=2.6.17.7-090219, AgentVer=3.15.3397
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Ovqn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' sysObjectID.0 .1.3.6.1.2.1.33
| Mfgr=Chloride, Model=AM-P3-CN, SN=1112-b27a, OSVer=2.6.17.7-090219, AgentVer=3.15.3397 | .1.3.6.1.2.1.33 | Ports : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifDescr ifDescr.1 = lo0 ifDescr.2 = eth0
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifAlias ifAlias = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifName ifName = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifType ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd
SQL[-[0;33mSELECT * FROM `ports` WHERE `device_id` = '6'-[0m] -[0m ignored (by descr): lo0 [ lo ] X. Port Stacks: SQL[-[0;33mSELECT * FROM `ports_stack` WHERE `device_id` = '6'-[0m] -[0m DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifStackStatus ifStackStatus = No Such Object available on this agent at this OID
Processors : hrDevice: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrDevice hrDevice = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrProcessorLoad hrProcessorLoad = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT COUNT(*) FROM processors WHERE device_id = '6' AND processor_type != 'ucd-old'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `processors` WHERE `device_id` = '6'-[0m] -[0m
Memory : HOST-RESOURCES-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrStorageEntry hrStorageEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `mempools` WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `port_id`, `ifIndex` FROM `ports` WHERE `device_id` = '6' GROUP BY `port_id`-[0m] -[0m IPv4 Addresses : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAdEntIfIndex ipAdEntIfIndex.10.251.2.41 = 2 ipAdEntIfIndex.127.0.0.1 = 1
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAdEntNetMask ipAdEntNetMask.10.251.2.41 = 255.255.128.0 ipAdEntNetMask.127.0.0.1 = 255.0.0.0
IP-MIB Array ( [2] => Array ( [10.251.2.41] => Array ( [ipAdEntIfIndex] => 2 [ipAdEntNetMask] => 255.255.128.0 )
)
[1] => Array ( [127.0.0.1] => Array ( [ipAdEntIfIndex] => 1 [ipAdEntNetMask] => 255.0.0.0 )
)
)
$vars
========= array( [2] => array( [10.251.2.41] => array( [ipAdEntIfIndex] => string(1) "2" [ipAdEntNetMask] => string(13) "255.255.128.0" ) ) [1] => array( [127.0.0.1] => array( [ipAdEntIfIndex] => string(1) "1" [ipAdEntNetMask] => string(9) "255.0.0.0" ) ) )
SQL[-[0;33mSELECT * FROM `ipv4_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.251.0.0/17'-[0m] -[0m . SQL[-[0;33mSELECT * FROM `ipv4_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `port_id`, `ifIndex` FROM `ports` WHERE `device_id` = '6' GROUP BY `port_id`-[0m] -[0m IPv6 Addresses : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressIfIndex.ipv6 ipAddressIfIndex.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressPrefix.ipv6 ipAddressPrefix.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressOrigin.ipv6 ipAddressOrigin.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUn -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipv6AddrPfxLength .1.3.6.1.2.1.55.1.8.1.2 = No Such Object available on this agent at this OID
TRANSLATE (REWRITE):[.1.3.6.1.2.1.55.1.8.1.2] DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUn -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipv6AddrType .1.3.6.1.2.1.55.1.8.1.3 = No Such Object available on this agent at this OID
TRANSLATE (REWRITE):[.1.3.6.1.2.1.55.1.8.1.3]
SQL[-[0;33mSELECT * FROM `ipv6_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `ipv6_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
Sensors: UPS-MIB Caching OIDs: upsInput DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsInput upsInputLineBads.0 = 56 upsInputNumLines.0 = 3 upsInputFrequency.1 = 498 upsInputFrequency.2 = 498 upsInputFrequency.3 = 498 upsInputVoltage.1 = 247 upsInputVoltage.2 = 247 upsInputVoltage.3 = 246 upsInputCurrent.1 = 30 upsInputCurrent.2 = 30 upsInputCurrent.3 = 30 upsInputTruePower.1 = 7600 upsInputTruePower.2 = 7600 upsInputTruePower.3 = 7400
upsOutput DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsOutput upsOutputSource.0 = normal upsOutputFrequency.0 = 499 upsOutputNumLines.0 = 3 upsOutputVoltage.1 = 240 upsOutputVoltage.2 = 239 upsOutputVoltage.3 = 240 upsOutputCurrent.1 = 384 upsOutputCurrent.2 = 288 upsOutputCurrent.3 = 328 upsOutputPower.1 = 7900 upsOutputPower.2 = 6200 upsOutputPower.3 = 7100 upsOutputPercentLoad.1 = 27 upsOutputPercentLoad.2 = 20 upsOutputPercentLoad.3 = 23
upsBypass DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsBypass upsBypass = No Such Object available on this agent at this OID
Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 247, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 760, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 240, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 38.4, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 7900, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 27, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 247, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 760, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 239, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 28.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 6200, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 20, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 246, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 740, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 240, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 32.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 7100, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 23, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsBattery upsBatteryStatus.0 = batteryNormal upsSecondsOnBattery.0 = 0 upsEstimatedMinutesRemaining.0 = 164 upsEstimatedChargeRemaining.0 = 100 upsBatteryVoltage.0 = 5430 upsBatteryCurrent.0 = 65533 upsBatteryTemperature.0 = 19
Discover sensor: temperature, dc6ups01, 1.3.6.1.2.1.33.1.2.7.0, upsBatteryTemperature, ups-mib, Battery, 1, 1, , , , , 19, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryTemperature'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryTemperature'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.2.6.0, upsBatteryCurrent, ups-mib, Battery, 10, 1, , , , , 6553.3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryCurrent'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryCurrent'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.2.5.0, upsBatteryVoltage, ups-mib, Battery, 10, 1, , , , , 543, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryVoltage'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryVoltage'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqc -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsConfigLowBattTime.0
Discover sensor: runtime, dc6ups01, .1.3.6.1.2.1.33.1.2.3.0, upsEstimatedMinutesRemaining.0, mge, Battery Runtime Remaining, 1, 1, , , , , 164, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'runtime' AND `device_id` = '6' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsEstimatedMinutesRemaining.0'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '6' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsEstimatedMinutesRemaining.0'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.33.1.4.2.0 499
Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.4.2.0, upsOutputFrequency, ups-mib, Output, 10, 1, , , , , 49.9, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputFrequency'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputFrequency'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.33.1.5.1.0 No Such Object available on this agent at this OID
Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.5.1.0, upsBypassFrequency, ups-mib, Bypass, 10, 1, , , , , 0, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBypassFrequency'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBypassFrequency'-[0m] -[0m .Array ( [ups-mib] => Array ( [upsBatteryTemperature] => 1 )
)
== array( [ups-mib] => array( [upsBatteryTemperature] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'temperature' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsBatteryTemperature -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'humidity' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'fanspeed' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'airflow' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 [upsBatteryVoltage] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) [upsBatteryVoltage] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'voltage' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib upsBatteryVoltage -> ups-mib Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 [upsBatteryCurrent] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) [upsBatteryCurrent] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'current' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib upsBatteryCurrent -> ups-mib Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'power' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'apower' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputFrequency] => 1 [upsBypassFrequency] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputFrequency] => int(1) [upsBypassFrequency] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'frequency' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputFrequency -> ups-mib upsBypassFrequency -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'dbm' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsOutputPercentLoad.] => 1 )
)
== array( [ups-mib] => array( [upsOutputPercentLoad.] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'capacity' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsOutputPercentLoad. -> ups-mib Array ( [mge] => Array ( [upsEstimatedMinutesRemaining.0] => 1 )
)
== array( [mge] => array( [upsEstimatedMinutesRemaining.0] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'runtime' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsEstimatedMinutesRemaining.0 -> mge
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'state' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
Storage : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrStorageEntry hrStorageEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `storage` WHERE `device_id` = '6'-[0m] -[0m
Inventory: Physical Inventory : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'dc6ups01':'161' entPhysicalEntry entPhysicalEntry = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' entAliasMappingIdentifier entAliasMappingIdentifier = No Such Object available on this agent at this OID
hrDevice : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs 'udp':'dc6ups01':'161' hrDeviceEntry hrDeviceEntry = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs 'udp':'dc6ups01':'161' hrProcessorEntry hrProcessorEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '6'-[0m] -[0m Discovery protocols: LLDP-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' lldpRemoteSystemsData lldpRemoteSystemsData = No Such Object available on this agent at this OID
|| || || || CISCO-CDP-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'dc6ups01':'161' cdpCache cdpCache = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.`local_port_id` = I.`port_id` AND I.`device_id` = '6'-[0m] -[0m
OSPF Neighbours: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' OSPF-MIB::ospfNbrIpAddr ospfNbrIpAddr = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT port_id, ifIndex FROM ports WHERE device_id = '6' GROUP BY port_id-[0m] -[0m ARP/NDP Tables : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IP-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipNetToPhysicalPhysAddress ipNetToPhysicalPhysAddress No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IPV6-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipv6NetToMediaPhysAddress ipv6NetToMediaPhysAddress No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IP-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipNetToMediaPhysAddress ipNetToMediaPhysAddress[1][1.0.251.10] 0:0:c:9f:f0:1
Used IP-MIB::ipNetToMediaPhysAddress
SQL[-[0;33mSELECT mac_id, mac_address, ip_address, ip_version, ifIndex FROM ip_mac AS M LEFT JOIN ports AS I ON M.port_id = I.port_id WHERE I.device_id = '6'-[0m] -[0m
BGP Sessions: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' bgpLocalAs.0 No Such Object available on this agent at this OID
No BGP on host SQL[-[0;33mSELECT * FROM bgpPeers WHERE device_id = '6'-[0m] -[0m
VLANs:
SQL[-[0;33mSELECT * FROM `vlans` WHERE `device_id` = '6';-[0m] -[0m
SQL[-[0;33mSELECT * FROM `ports_vlans` WHERE `device_id` = '6';-[0m] -[0m Q-BRIDGE-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -m Q-BRIDGE-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' dot1qVlanVersionNumber.0 No Such Object available on this agent at this OID
Toner : Checking ... Array ( )
== array() DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -OUqnv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.43.10.2.1.4.1.1 No Such Object available on this agent at this OID
UCD Disk IO : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' diskIOEntry diskIOEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='3.569' WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mINSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('6','discover','1396996109.8388','3.5698199272156')-[0m] -[0m Discovered in 3.569 seconds
<h4>Building alerts for device dc6ups01</h4> SQL[-[0;33mSELECT * FROM `alert_tests`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `alert_assoc`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `alert_table` WHERE `device_id` = '6'-[0m] -[0m <h5>Checkers matching this device</h5> <h5>Matching entities</h5> Checking for stale entries:
SQL[-[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','dc6ups01','1396996109.8298','3.603','1')-[0m] -[0m ./discovery.php dc6ups01 April 8, 2014, 22:28 - 1 devices discovered in 3.603 secs
SQL[-[0;33mSELECT count(*) FROM ports-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM devices-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `sensors`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `services`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `applications`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `bgpPeers`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `ospf_ports`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `eigrp_ports`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `ipsec_tunnels`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `munin_plugins`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `pseudowires`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `vrfs`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `vminfo`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `users`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `bills`-[0m] -[0m
SQL[-[0;33mSELECT SUM(`last_polled_timetaken`) FROM devices-[0m] -[0m
SQL[-[0;33mSELECT sysObjectID, COUNT( * ) as count FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS count,os from devices group by `os`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`-[0m] -[0m MySQL: Cell[2/0s] Row[79/0.07s] Rows[24/0.02s] Column[0/0s] Update[1/0.02s] Insert[2/0s] Delete[0/0s]
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************