DEBUG!
Observium v0.14.7.5601
Discovery


SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1] 

SQL[SELECT revision FROM `dbSchema`] 

SQL[SELECT count(*) FROM ports] 

SQL[SELECT count(*) FROM devices] 

SQL[SELECT count(*) FROM `sensors`] 

SQL[SELECT count(*) FROM `services`] 

SQL[SELECT count(*) FROM `applications`] 

SQL[SELECT count(*) FROM `bgpPeers`] 

SQL[SELECT count(*) FROM `ospf_ports`] 

SQL[SELECT count(*) FROM `eigrp_ports`] 

SQL[SELECT count(*) FROM `ipsec_tunnels`] 

SQL[SELECT count(*) FROM `munin_plugins`] 

SQL[SELECT count(*) FROM `pseudowires`] 

SQL[SELECT count(*) FROM `vrfs`] 

SQL[SELECT count(*) FROM `vminfo`] 

SQL[SELECT count(*) FROM `users`] 

SQL[SELECT count(*) FROM `bills`] 

SQL[SELECT count(*) FROM `alert_table`] 

SQL[SELECT count(*) FROM `alert_tests`] 

SQL[SELECT count(*) FROM `groups`] 

SQL[SELECT SUM(`last_polled_timetaken`) FROM devices] 

SQL[SELECT sysObjectID, COUNT( * ) as count FROM  `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`] 

SQL[SELECT COUNT(*) AS count,os from devices group by `os`] 

SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`] 

SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`] 
Current Revision : 5601
New Revision   : 5601


SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'secret-device-name' ORDER BY `device_id` DESC] 

SQL[SELECT * FROM devices_attribs WHERE `device_id` = '439'] 
secret-device-name 439 ios  (cisco)
Processors :  hrDevice: DEBUG: SNMP Auth options =  -v2c -c 'secretcommunity'
/usr/bin/snmpbulkwalk -v2c -c 'secretcommunity' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'secret-device-name':'161' hrDevice
hrDevice = No Such Object available on this agent at this OID

DEBUG: SNMP Auth options =  -v2c -c 'secretcommunity'
/usr/bin/snmpbulkwalk -v2c -c 'secretcommunity' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'secret-device-name':'161' hrProcessorLoad
hrProcessorLoad = No Such Object available on this agent at this OID


SQL[SELECT COUNT(*) FROM processors WHERE device_id = '439' AND processor_type != 'ucd-old'] 

SQL[SELECT * FROM `processors` WHERE `device_id` = '439'] 


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.040' WHERE `device_id` = '439'] 

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('439','discover','1404247178.0722','0.04081392288208')] 
Discovered in 0.040 seconds


SQL[SELECT * FROM `alert_tests`] 

SQL[SELECT * FROM `alert_assoc`] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439'] 

SQL[SELECT count(*) FROM `devices` WHERE device_id = '439' AND `hostname` LIKE 'perfectbox%'] 

SQL[SELECT * FROM `alert_table` WHERE `device_id` = '439'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `ifAlias` LIKE 'Swisscom CES ELAN%' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Cust' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Transit' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `storage` WHERE device_id = '439'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Core%' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Core' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Transit' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Peering' AND `ifSpeed` > '0'] 

SQL[SELECT * FROM `ports` WHERE device_id = '439' AND `deleted` != '1' AND `port_descr_type` LIKE 'Peering' AND `ifSpeed` > '0'] 
Building alerts for device secret-device-name:
  Checkers matching this device: CES ELAN Customer port over 90Transit High Disk over 90full Core Port high usage Core Port Errors Transit Port Error Peering Error Peering Port High Usage 
  Matching entities: 
  Checking for stale entries: 

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','secret-device-name','1404247177.9577','0.175','1')] 
./discovery.php: secret-device-name - 1 devices discovered in 0.175 secs
MySQL: Cell[1/0s] Row[31/0.01s] Rows[12/0s] Column[0/0s] Update[1/0.01s] Insert[2/0.01s] Delete[0/0s]