[root@observium observium]# ./discovery.php -d -m os -h pt-uk-olivetti01.company.local
DEBUG!
Observium v0.14.4.5229
Discovery


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

SQL[SELECT revision FROM `dbSchema`]

SQL[SELECT * FROM `devices` WHERE status = 1 AND disabled = 0 AND `hostname` LIKE 'pt-uk-olivetti01.company.local' ORDER BY device_id DESC]

SQL[SELECT * FROM devices_attribs WHERE `device_id` = '7']
pt-uk-olivetti01.company.local 7 generic DEBUG: SNMP Auth options =  -v2c -c 'SNMPcommunity'
/usr/bin/snmpget -v2c -c 'SNMPcommunity' -Ovq -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pt-uk-olivetti01.company.local':'161' sysDescr.0
Generic 28C-6e

DEBUG: SNMP Auth options =  -v2c -c 'SNMPcommunity'
/usr/bin/snmpget -v2c -c 'SNMPcommunity' -Ovqn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pt-uk-olivetti01.company.local':'161' sysObjectID.0
.1.3.6.1.4.1.18334.1.2.1.2.1.106.2.4

| Generic 28C-6e | .1.3.6.1.4.1.18334.1.2.1.2.1.106.2.4 |
Including sentry3.inc.php
Including airport.inc.php
Including vyatta.inc.php
Including axisdocserver.inc.php
Including extremeware.inc.php
Including wlc.inc.php
Including powerconnect.inc.php
Including dlink.inc.php
Including netbsd.inc.php
Including arubaos.inc.php
Including asyncos.inc.php
Including freebsd.inc.php
Including cisco.inc.php
Including cometsystem-p85xx.inc.php
Including ricoh.inc.php
Including speedtouch.inc.php
Including routeros.inc.php
Including mgeups.inc.php
Including edgeos.inc.php
Including cs121.inc.php
Including poweralert.inc.php
Including sanos.inc.php
Including bcm963.inc.php
Including sonicwall.inc.php
Including lcos.inc.php
Including darwin.inc.php
Including watchguard.inc.php
Including panos.inc.php
Including brother.inc.php
Including vrp.inc.php
Including sensorprobe.inc.php
Including avocent.inc.php
Including ftos.inc.php
Including allied.inc.php
Including epson.inc.php
Including gamatronicups.inc.php
Including toshiba.inc.php
Including netopia.inc.php
Including xerox.inc.php
Including roomalert.inc.php
Including wxgoos.inc.php
Including okilan.inc.php
Including dlinkap.inc.php
Including supermicro-switch.inc.php
Including seos.inc.php
Including windows.inc.php
Including zyxel.inc.php
Including raritan.inc.php
Including netmanplus.inc.php
Including arista_eos.inc.php
Including netware.inc.php
Including acsw.inc.php
Including barracudangfw.inc.php
Including nxos.inc.php
Including packetshaper.inc.php
Including ciena.inc.php
Including kyocera.inc.php
Including bnt.inc.php
Including zxr10.inc.php
Including nos.inc.php
Including netvision.inc.php
Including solaris.inc.php
Including tranzeo.inc.php
Including axiscam.inc.php
Including terastation.inc.php
Including mrvld.inc.php
Including jetdirect.inc.php
Including linux.inc.php
Including samsung.inc.php
DEBUG: SNMP Auth options =  -v2c -c 'SNMPcommunity'
/usr/bin/snmpget -v2c -c 'SNMPcommunity' -OQv -M /opt/observium/mibs 'udp':'pt-uk-olivetti01.company.local':'161' Printer-MIB::prtGeneralServicePerson.1
""

Including radlan.inc.php
Including dell-laser.inc.php
Including mgepdu.inc.php
Including nrg.inc.php
Including draytek.inc.php
Including jdsu_edfa.inc.php
DEBUG: SNMP Auth options =  -v2c -c 'SNMPcommunity'
/usr/bin/snmpget -v2c -c 'SNMPcommunity' -OQv -M /opt/observium/mibs 'udp':'pt-uk-olivetti01.company.local':'161' NSCRTV-ROOT::commonDeviceVendorInfo.1
No Such Object available on this agent at this OID



SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='printer',`last_discovered_timetaken` ='1.132' WHERE `device_id` = '7']

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('7','discover','1418480731.3292','1.1320009231567')]
Discovered in 1.132 seconds


SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','pt-uk-olivetti01.company.local','1418480731.3237','1.139','1')]
./discovery.php pt-uk-olivetti01.company.local December 13, 2014, 14:25 - 1 devices discovered in 1.139 secs

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 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 : 5229
New Revision   : 6104

MySQL: Cell[2/0s] Row[16/0.01s] Rows[2/0s] Column[0/0s] Update[1/0s] Insert[2/0s] Delete[0/0s]
[root@observium observium]#