SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00006700s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00008512s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00006700s]
SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00004697s]
CMD[/bin/hostname -f]
CMD EXITCODE[0]
CMD RUNTIME[0.0031s]
CMD EXITDELAY[10ms]
STDOUT[
observium.interdata.local
]
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
Observium Professional 0.16.7.8003
http://www.observium.org
CMD[/opt/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0532s]
STDOUT[
Linux|3.13.0-91-generic|amd64|Ubuntu|14.04
]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
Python 2.7.6
]
SQL[SELECT version();]
SQL RUNTIME[0.00016713s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
NET-SNMP version: 5.7.2
]
CMD[/usr/bin/rrdtool --version |head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0042s]
STDOUT[
RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch>
]
CMD[date "+%:z"]
CMD EXITCODE[0]
CMD RUNTIME[0.0015s]
STDOUT[
+02:00
]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00017619s]
CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.0454s]
STDOUT[
Apache/2.4.7
]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00013494s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00049496s]
##### Software versions #####
o OS Linux 3.13.0-91-generic [amd64] (Ubuntu 14.04)
o Apache 2.4.7
o PHP 5.5.9-1ubuntu4.17 (OPcache: DISABLED)
o Python 2.7.6
o MySQL 5.5.49-0ubuntu0.14.04.1 (extension: mysqli 5.5.49)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.4.7
##### MySQL mode #####
o MySQL
##### Charset info #####
o PHP UTF-8
o MySQL utf8
##### Timezones info #####
o Date Friday, 29-Jul-16 08:17:57 CEST
o PHP +02:00
o MySQL +02:00
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00024915s]
SQL[SELECT COUNT(*) FROM ports]
SQL RUNTIME[0.00023580s]
SQL[SELECT COUNT(*) FROM devices]
SQL RUNTIME[0.00016403s]
SQL[SELECT COUNT(*) FROM `sensors`]
SQL RUNTIME[0.00012207s]
SQL[SELECT COUNT(*) FROM `services`]
SQL RUNTIME[0.00019813s]
SQL[SELECT COUNT(*) FROM `applications`]
SQL RUNTIME[0.00018406s]
SQL[SELECT COUNT(*) FROM `bgpPeers`]
SQL RUNTIME[0.00014901s]
SQL[SELECT COUNT(*) FROM `ospf_ports`]
SQL RUNTIME[0.00014710s]
SQL[SELECT COUNT(*) FROM `eigrp_ports`]
SQL RUNTIME[0.00014901s]
SQL[SELECT COUNT(*) FROM `ipsec_tunnels`]
SQL RUNTIME[0.00015092s]
SQL[SELECT COUNT(*) FROM `munin_plugins`]
SQL RUNTIME[0.00016809s]
SQL[SELECT COUNT(*) FROM `pseudowires`]
SQL RUNTIME[0.00011611s]
SQL[SELECT COUNT(*) FROM `vrfs`]
SQL RUNTIME[0.00010586s]
SQL[SELECT COUNT(*) FROM `vminfo`]
SQL RUNTIME[0.00025916s]
SQL[SELECT COUNT(*) FROM `users`]
SQL RUNTIME[0.00011802s]
SQL[SELECT COUNT(*) FROM `bills`]
SQL RUNTIME[0.00014281s]
SQL[SELECT COUNT(*) FROM `alert_table`]
SQL RUNTIME[0.00015497s]
SQL[SELECT COUNT(*) FROM `alert_tests`]
SQL RUNTIME[0.00017118s]
SQL[SELECT COUNT(*) FROM `slas`]
SQL RUNTIME[0.00012684s]
SQL[SELECT COUNT(*) FROM `status`]
SQL RUNTIME[0.00013399s]
SQL[SELECT COUNT(*) FROM `groups`]
SQL RUNTIME[0.00018501s]
SQL[SELECT COUNT(*) FROM `group_table`]
SQL RUNTIME[0.00016093s]
SQL[SELECT SUM(`last_polled_timetaken`) FROM devices]
SQL RUNTIME[0.00021291s]
SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices]
SQL RUNTIME[0.00017619s]
CMD[DISTROFORMAT=export /opt/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0547s]
STDOUT[
OS=Linux
KERNEL=3.13.0-91-generic
ARCH=amd64
DISTRO=Ubuntu
VERSION=14.04
DISTROVER=14.04
SCRIPTVER=1.1.0
]
SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`]
SQL RUNTIME[0.00105906s]
SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`]
SQL RUNTIME[0.00032783s]
SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`]
SQL RUNTIME[0.00042605s]
SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`]
SQL RUNTIME[0.00048399s]
SQL[SELECT MAX(LENGTH(`port_label`)) FROM `ports`]
SQL RUNTIME[0.00063992s]
SQL[SELECT MAX(LENGTH(`port_label_short`)) FROM `ports`]
SQL RUNTIME[0.00057483s]
SQL[SELECT MAX(LENGTH(`port_label_base`)) FROM `ports`]
SQL RUNTIME[0.00065899s]
SQL[SELECT MAX(LENGTH(`port_label_num`)) FROM `ports`]
SQL RUNTIME[0.00063801s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';]
SQL RUNTIME[0.00018597s]
REQUEST[http://www.observium.org/versions.php]
REQUEST STATUS[200 OK]
REQUEST RUNTIME[0.4308s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00026703s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='0.16.7.8003' WHERE `attrib_type` = 'latest_ver']
SQL RUNTIME[0.00104904s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00021505s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='8003' WHERE `attrib_type` = 'latest_rev']
SQL RUNTIME[0.00038600s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00019503s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='2016-07-22' WHERE `attrib_type` = 'latest_rev_date']
SQL RUNTIME[0.00033903s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00019598s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='1469773078' WHERE `attrib_type` = 'last_versioncheck']
SQL RUNTIME[0.00068378s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00022006s]
##### Starting discovery run at 2016-07-29 08:17:58 #####
SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'r3002' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00039411s]
CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' sysObjectID.0 sysUpTime.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0059s]
STDOUT[
sysObjectID.0 = enterprises.272.4.157.82.78.50.48.0.0
sysUpTime.0 = 309042439
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '3']
SQL RUNTIME[0.00013590s]
SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '3']
SQL RUNTIME[0.00028396s]
CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 31432]
CMD EXITCODE[0]
CMD RUNTIME[0.0065s]
STDOUT[
PID PPID UID GID TT STAT TIME STARTED COMMAND
31432 6538 0 0 pts/1 S+ 00:00:00 Fri Jul 29 08:17:56 2016 php ./discovery.php -d -h r3002
]
SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('31432','discovery.php','6538','0','php ./discovery.php -d -h r3002','1469773076','3')]
SQL RUNTIME[0.00083303s]
##### r3002 [3] #####
o OS Type bintec-os
o OS Group bintec
o SNMP Version v2c
o Last discovery 2016-07-29 06:34:48
o Last duration 1.33 seconds
##### Module Start: os #####
CMD[/usr/bin/snmpget -v2c -c *** -Pu -Ovq -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' sysDescr.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0057s]
STDOUT[
R3002
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpget -v2c -c *** -Pu -Ovqn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' sysObjectID.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0089s]
CMD EXITDELAY[10ms]
STDOUT[
.1.3.6.1.4.1.272.4.157.82.78.50.48.0.0
]
SNMP STATUS[TRUE]
| R3002 | .1.3.6.1.4.1.272.4.157.82.78.50.48.0.0 |
o sysORID table
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' sysORID]
CMD EXITCODE[0]
CMD RUNTIME[0.0067s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmptranslate -On -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID']
CMD EXITCODE[0]
CMD RUNTIME[0.0059s]
CMD EXITDELAY[10ms]
STDOUT[
.1.3.6.1.2.1.1.9.1.2
]
SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2'
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' sysORDescr]
CMD EXITCODE[0]
CMD RUNTIME[0.0087s]
STDOUT[
]
SNMP STATUS[TRUE]
<empty>
SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '3' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00025797s]
o Duration 0.0671s
##### Module Start: ports #####
o Caching OIDs ifDescr
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifDescr]
CMD EXITCODE[0]
CMD RUNTIME[0.0854s]
STDOUT[
ifDescr.0 = REFUSE
ifDescr.1 = LOCAL
ifDescr.2 = IGNORE
ifDescr.1000 = en1-0
ifDescr.1001 = en1-0-llc
ifDescr.1400 = en1-4
ifDescr.1401 = en1-4-llc
ifDescr.1200 = en1-2
ifDescr.1201 = en1-2-llc
ifDescr.1300 = en1-3
ifDescr.1301 = en1-3-llc
ifDescr.50000 = ethoa50-0
ifDescr.50001 = ethoa50-0-llc
(*Deleted Info*)
]
SNMP STATUS[TRUE]
ifAlias
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifAlias]
CMD EXITCODE[0]
CMD RUNTIME[0.008s]
STDOUT[
]
SNMP STATUS[TRUE]
ifName
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifName]
CMD EXITCODE[0]
CMD RUNTIME[0.0088s]
STDOUT[
]
SNMP STATUS[TRUE]
ifType
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifType]
CMD EXITCODE[0]
CMD RUNTIME[0.0842s]
STDOUT[
ifType.0 = other
ifType.1 = other
ifType.2 = other
ifType.1000 = ethernetCsmacd
ifType.1001 = iso88023Csmacd
ifType.1400 = ethernetCsmacd
ifType.1401 = iso88023Csmacd
ifType.1200 = ethernetCsmacd
ifType.1201 = iso88023Csmacd
ifType.1300 = ethernetCsmacd
ifType.1301 = iso88023Csmacd
ifType.50000 = ethernetCsmacd
ifType.50001 = iso88023Csmacd
(*Deleted Info*)
]
SNMP STATUS[TRUE]
ifOperStatus
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifOperStatus]
CMD EXITCODE[0]
CMD RUNTIME[0.0829s]
STDOUT[
ifOperStatus.0 = up
ifOperStatus.1 = up
ifOperStatus.2 = up
ifOperStatus.1000 = up
ifOperStatus.1001 = up
ifOperStatus.1400 = down
ifOperStatus.1401 = down
ifOperStatus.1200 = up
ifOperStatus.1201 = up
ifOperStatus.1300 = down
ifOperStatus.1301 = down
ifOperStatus.50000 = up
ifOperStatus.50001 = up
(*Deleted Info*)
]
SNMP STATUS[TRUE]
SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '3' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00008798s]
SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '3']
SQL RUNTIME[0.00004983s]
SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00021601s]
> $port_stats - /opt/observium/discovery.php:183
/opt/observium/includes/discovery/ports.inc.php:36
==================================================
array(
[0] => array(
[ifDescr] => string(6) "REFUSE"
[ifType] => string(5) "other"
[ifOperStatus] => string(2) "up"
)
[1] => array(
[ifDescr] => string(5) "LOCAL"
[ifType] => string(5) "other"
[ifOperStatus] => string(2) "up"
)
[2] => array(
[ifDescr] => string(6) "IGNORE"
[ifType] => string(5) "other"
[ifOperStatus] => string(2) "up"
)
[1000] => array(
[ifDescr] => string(5) "en1-0"
[ifType] => string(14) "ethernetCsmacd"
[ifOperStatus] => string(2) "up"
)
[1001] => array(
[ifDescr] => string(9) "en1-0-llc"
[ifType] => string(14) "iso88023Csmacd"
[ifOperStatus] => string(2) "up"
)
[1400] => array(
[ifDescr] => string(5) "en1-4"
[ifType] => string(14) "ethernetCsmacd"
[ifOperStatus] => string(4) "down"
)
[1401] => array(
[ifDescr] => string(9) "en1-4-llc"
[ifType] => string(14) "iso88023Csmacd"
[ifOperStatus] => string(4) "down"
)
[1200] => array(
[ifDescr] => string(5) "en1-2"
[ifType] => string(14) "ethernetCsmacd"
[ifOperStatus] => string(2) "up"
)
[1201] => array(
[ifDescr] => string(9) "en1-2-llc"
[ifType] => string(14) "iso88023Csmacd"
[ifOperStatus] => string(2) "up"
)
[1300] => array(
[ifDescr] => string(5) "en1-3"
[ifType] => string(14) "ethernetCsmacd"
[ifOperStatus] => string(4) "down"
)
[1301] => array(
[ifDescr] => string(9) "en1-3-llc"
[ifType] => string(14) "iso88023Csmacd"
[ifOperStatus] => string(4) "down"
)
[50000] => array(
[ifDescr] => string(9) "ethoa50-0"
[ifType] => string(14) "ethernetCsmacd"
[ifOperStatus] => string(2) "up"
)
[50001] => array(
[ifDescr] => string(13) "ethoa50-0-llc"
[ifType] => string(14) "iso88023Csmacd"
[ifOperStatus] => string(2) "up"
)
(*Deleted Info*)
)
o Caching DB
SQL[SELECT * FROM `ports` WHERE `device_id` = '3']
SQL RUNTIME[0.00249815s]
120 ports
o Discovering ports ......................................................................................
+---------+-----------------+--------+---------+----------------+-------------+---------+
| ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored |
+---------+-----------------+--------+---------+----------------+-------------+---------+
| 0 | REFUSE | | ... | other | up | no |
| 1 | LOCAL | | ... | other | up | no |
| 2 | IGNORE | | ... | other | up | no |
| 1000 | en1-0 | | ... | ethernetCsmacd | up | no |
| 1001 | en1-0-llc | | ... | iso88023Csmacd | up | no |
| 1400 | en1-4 | | ... | ethernetCsmacd | down | no |
| 1401 | en1-4-llc | | ... | iso88023Csmacd | down | no |
| 1200 | en1-2 | | ... | ethernetCsmacd | up | no |
| 1201 | en1-2-llc | | ... | iso88023Csmacd | up | no |
| 1300 | en1-3 | | ... | ethernetCsmacd | down | no |
| 1301 | en1-3-llc | | ... | iso88023Csmacd | down | no |
| 50000 | ethoa50-0 | | ... | ethernetCsmacd | up | no |
| 50001 | ethoa50-0-llc | | ... | iso88023Csmacd | up | no |
(*Deleted Info*)
+---------+-----------------+--------+---------+----------------+-------------+---------+
o Duration 0.8713s
##### Module Start: ports-stack #####
Port Stacks:
SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '3']
SQL RUNTIME[0.00045490s]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ifStackStatus]
CMD EXITCODE[0]
CMD RUNTIME[0.0097s]
STDOUT[
]
SNMP STATUS[TRUE]
o Duration 0.0125s
##### Module Start: vlans #####
VLANs:
SQL[SELECT * FROM `vlans` WHERE `device_id` = '3';]
SQL RUNTIME[0.00028491s]
SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '3';]
SQL RUNTIME[0.00021100s]
Q-BRIDGE-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' dot1qVlanStaticTable]
CMD EXITCODE[0]
CMD RUNTIME[0.0182s]
STDOUT[
]
SNMP STATUS[TRUE]
o Duration 0.0233s
##### Module Start: ip-addresses #####
o Discovering IP Addresses IP-MIB IP-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAdEntIfIndex]
CMD EXITCODE[0]
CMD RUNTIME[0.0529s]
STDOUT[
ipAdEntIfIndex.192.168.0.84.0 = 1000
ipAdEntIfIndex.192.168.0.84.1 = 100028
ipAdEntIfIndex.192.168.0.84.2 = 100032
ipAdEntIfIndex.192.168.0.84.3 = 100034
ipAdEntIfIndex.192.168.0.84.4 = 100044
ipAdEntIfIndex.192.168.0.84.5 = 100048
ipAdEntIfIndex.192.168.0.84.6 = 100052
ipAdEntIfIndex.192.168.0.84.7 = 100056
ipAdEntIfIndex.192.168.0.84.8 = 100057
ipAdEntIfIndex.192.168.0.84.9 = 100061
ipAdEntIfIndex.192.168.0.84.10 = 100071
ipAdEntIfIndex.192.168.0.84.11 = 100073
ipAdEntIfIndex.192.168.0.84.12 = 100075
ipAdEntIfIndex.192.168.0.84.13 = 100085
ipAdEntIfIndex.192.168.0.84.14 = 100088
ipAdEntIfIndex.192.168.0.84.15 = 100092
ipAdEntIfIndex.192.168.0.84.16 = 100101
ipAdEntIfIndex.192.168.0.84.18 = 100114
ipAdEntIfIndex.192.168.0.84.19 = 100116
ipAdEntIfIndex.192.168.0.84.20 = 100117
ipAdEntIfIndex.192.168.0.84.21 = 100119
ipAdEntIfIndex.192.168.0.84.22 = 100122
ipAdEntIfIndex.192.168.0.84.23 = 100123
ipAdEntIfIndex.192.168.0.84.24 = 100125
ipAdEntIfIndex.192.168.0.84.25 = 100132
ipAdEntIfIndex.192.168.0.84.26 = 100134
ipAdEntIfIndex.192.168.0.84.27 = 100138
ipAdEntIfIndex.192.168.0.84.28 = 100143
ipAdEntIfIndex.192.168.0.84.29 = 100150
ipAdEntIfIndex.192.168.0.84.30 = 100152
ipAdEntIfIndex.192.168.0.84.31 = 100155
ipAdEntIfIndex.192.168.0.84.32 = 100169
(*Deleted Info*)
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAdEntNetMask]
CMD EXITCODE[0]
CMD RUNTIME[0.0506s]
STDOUT[
ipAdEntNetMask.192.168.0.84.0 = 255.255.255.0
ipAdEntNetMask.192.168.0.84.1 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.2 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.3 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.4 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.5 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.6 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.7 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.8 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.9 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.10 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.11 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.12 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.13 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.14 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.15 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.16 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.18 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.19 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.20 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.21 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.22 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.23 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.24 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.25 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.26 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.27 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.28 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.29 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.30 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.31 = 255.255.255.255
ipAdEntNetMask.192.168.0.84.32 = 255.255.255.255
(*Deleted Info*)
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAddressIfIndex]
CMD EXITCODE[0]
CMD RUNTIME[0.0158s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAddressType]
CMD EXITCODE[0]
CMD RUNTIME[0.0159s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAddressPrefix]
CMD EXITCODE[0]
CMD RUNTIME[0.0108s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipAddressOrigin]
CMD EXITCODE[0]
CMD RUNTIME[0.011s]
STDOUT[
]
SNMP STATUS[TRUE]
> $ip_data[$ip_version] - /opt/observium/discovery.php:183
/opt/observium/includes/discovery/ip-addresses.inc.php:29
===========================================================
array(
[1000] => array(
[168.0.84.0] => array(
[ifIndex] => string(4) "1000"
[ip] => string(10) "168.0.84.0"
[mask] => string(13) "255.255.255.0"
[type] => string(7) "unicast"
)
)
[100028] => array(
[168.0.84.1] => array(
[ifIndex] => string(6) "100028"
[ip] => string(10) "168.0.84.1"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100032] => array(
[168.0.84.2] => array(
[ifIndex] => string(6) "100032"
[ip] => string(10) "168.0.84.2"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100034] => array(
[168.0.84.3] => array(
[ifIndex] => string(6) "100034"
[ip] => string(10) "168.0.84.3"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100044] => array(
[168.0.84.4] => array(
[ifIndex] => string(6) "100044"
[ip] => string(10) "168.0.84.4"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100048] => array(
[168.0.84.5] => array(
[ifIndex] => string(6) "100048"
[ip] => string(10) "168.0.84.5"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100052] => array(
[168.0.84.6] => array(
[ifIndex] => string(6) "100052"
[ip] => string(10) "168.0.84.6"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100056] => array(
[168.0.84.7] => array(
[ifIndex] => string(6) "100056"
[ip] => string(10) "168.0.84.7"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100057] => array(
[168.0.84.8] => array(
[ifIndex] => string(6) "100057"
[ip] => string(10) "168.0.84.8"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100061] => array(
[168.0.84.9] => array(
[ifIndex] => string(6) "100061"
[ip] => string(10) "168.0.84.9"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100071] => array(
[168.0.84.10] => array(
[ifIndex] => string(6) "100071"
[ip] => string(11) "168.0.84.10"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100073] => array(
[168.0.84.11] => array(
[ifIndex] => string(6) "100073"
[ip] => string(11) "168.0.84.11"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100075] => array(
[168.0.84.12] => array(
[ifIndex] => string(6) "100075"
[ip] => string(11) "168.0.84.12"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100085] => array(
[168.0.84.13] => array(
[ifIndex] => string(6) "100085"
[ip] => string(11) "168.0.84.13"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100088] => array(
[168.0.84.14] => array(
[ifIndex] => string(6) "100088"
[ip] => string(11) "168.0.84.14"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100092] => array(
[168.0.84.15] => array(
[ifIndex] => string(6) "100092"
[ip] => string(11) "168.0.84.15"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100101] => array(
[168.0.84.16] => array(
[ifIndex] => string(6) "100101"
[ip] => string(11) "168.0.84.16"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100114] => array(
[168.0.84.18] => array(
[ifIndex] => string(6) "100114"
[ip] => string(11) "168.0.84.18"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100116] => array(
[168.0.84.19] => array(
[ifIndex] => string(6) "100116"
[ip] => string(11) "168.0.84.19"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100117] => array(
[168.0.84.20] => array(
[ifIndex] => string(6) "100117"
[ip] => string(11) "168.0.84.20"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100119] => array(
[168.0.84.21] => array(
[ifIndex] => string(6) "100119"
[ip] => string(11) "168.0.84.21"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100122] => array(
[168.0.84.22] => array(
[ifIndex] => string(6) "100122"
[ip] => string(11) "168.0.84.22"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100123] => array(
[168.0.84.23] => array(
[ifIndex] => string(6) "100123"
[ip] => string(11) "168.0.84.23"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100125] => array(
[168.0.84.24] => array(
[ifIndex] => string(6) "100125"
[ip] => string(11) "168.0.84.24"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100132] => array(
[168.0.84.25] => array(
[ifIndex] => string(6) "100132"
[ip] => string(11) "168.0.84.25"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100134] => array(
[168.0.84.26] => array(
[ifIndex] => string(6) "100134"
[ip] => string(11) "168.0.84.26"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100138] => array(
[168.0.84.27] => array(
[ifIndex] => string(6) "100138"
[ip] => string(11) "168.0.84.27"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100143] => array(
[168.0.84.28] => array(
[ifIndex] => string(6) "100143"
[ip] => string(11) "168.0.84.28"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100150] => array(
[168.0.84.29] => array(
[ifIndex] => string(6) "100150"
[ip] => string(11) "168.0.84.29"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100152] => array(
[168.0.84.30] => array(
[ifIndex] => string(6) "100152"
[ip] => string(11) "168.0.84.30"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100155] => array(
[168.0.84.31] => array(
[ifIndex] => string(6) "100155"
[ip] => string(11) "168.0.84.31"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
[100169] => array(
[168.0.84.32] => array(
[ifIndex] => string(6) "100169"
[ip] => string(11) "168.0.84.32"
[mask] => string(15) "255.255.255.255"
[type] => string(7) "unicast"
)
)
(*Deleted Info*)
)
SQL[SELECT * FROM `ipv4_addresses`
LEFT JOIN `ports` USING(`port_id`)
WHERE `device_id` = '3']
SQL RUNTIME[0.00228596s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '1000' LIMIT 1]
SQL RUNTIME[0.00015783s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3038']
SQL RUNTIME[0.00023603s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '3']
SQL RUNTIME[0.00021315s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '3']
SQL RUNTIME[0.00005293s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.0/24']
SQL RUNTIME[0.00020504s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100028' LIMIT 1]
SQL RUNTIME[0.00019097s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3048']
SQL RUNTIME[0.00028181s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.1/32']
SQL RUNTIME[0.00016999s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100032' LIMIT 1]
SQL RUNTIME[0.00016189s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3049']
SQL RUNTIME[0.00024700s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.2/32']
SQL RUNTIME[0.00016189s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100034' LIMIT 1]
SQL RUNTIME[0.00013399s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3050']
SQL RUNTIME[0.00030613s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.3/32']
SQL RUNTIME[0.00014806s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100044' LIMIT 1]
SQL RUNTIME[0.00013208s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3051']
SQL RUNTIME[0.00022388s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.4/32']
SQL RUNTIME[0.00015903s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100048' LIMIT 1]
SQL RUNTIME[0.00013781s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3052']
SQL RUNTIME[0.00023198s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.5/32']
SQL RUNTIME[0.00019407s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100052' LIMIT 1]
SQL RUNTIME[0.00019598s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3053']
SQL RUNTIME[0.00028515s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.6/32']
SQL RUNTIME[0.00033593s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100056' LIMIT 1]
SQL RUNTIME[0.00019598s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3054']
SQL RUNTIME[0.00034714s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.7/32']
SQL RUNTIME[0.00018406s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100057' LIMIT 1]
SQL RUNTIME[0.00023913s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3055']
SQL RUNTIME[0.00022793s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.8/32']
SQL RUNTIME[0.00019598s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100061' LIMIT 1]
SQL RUNTIME[0.00015211s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3056']
SQL RUNTIME[0.00070500s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.9/32']
SQL RUNTIME[0.00016904s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100071' LIMIT 1]
SQL RUNTIME[0.00013399s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3057']
SQL RUNTIME[0.00022197s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.10/32']
SQL RUNTIME[0.00019002s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100073' LIMIT 1]
SQL RUNTIME[0.00014400s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3058']
SQL RUNTIME[0.00023198s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.11/32']
SQL RUNTIME[0.00018787s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100075' LIMIT 1]
SQL RUNTIME[0.00014806s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3059']
SQL RUNTIME[0.00024199s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.12/32']
SQL RUNTIME[0.00016689s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100085' LIMIT 1]
SQL RUNTIME[0.00015092s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3060']
SQL RUNTIME[0.00028086s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.13/32']
SQL RUNTIME[0.00015306s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100088' LIMIT 1]
SQL RUNTIME[0.00013494s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3061']
SQL RUNTIME[0.00025010s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.14/32']
SQL RUNTIME[0.00016403s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100092' LIMIT 1]
SQL RUNTIME[0.00013399s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3062']
SQL RUNTIME[0.00027418s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.15/32']
SQL RUNTIME[0.00018597s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100101' LIMIT 1]
SQL RUNTIME[0.00013590s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3063']
SQL RUNTIME[0.00022817s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.16/32']
SQL RUNTIME[0.00015903s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100114' LIMIT 1]
SQL RUNTIME[0.00016499s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3066']
SQL RUNTIME[0.00022197s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.18/32']
SQL RUNTIME[0.00023198s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100116' LIMIT 1]
SQL RUNTIME[0.00015092s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3067']
SQL RUNTIME[0.00024605s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.19/32']
SQL RUNTIME[0.00018597s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100117' LIMIT 1]
SQL RUNTIME[0.00017881s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3068']
SQL RUNTIME[0.00025892s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.20/32']
SQL RUNTIME[0.00017095s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100119' LIMIT 1]
SQL RUNTIME[0.00017786s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3069']
SQL RUNTIME[0.00024390s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.21/32']
SQL RUNTIME[0.00017881s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100122' LIMIT 1]
SQL RUNTIME[0.00014806s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3070']
SQL RUNTIME[0.00024700s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.22/32']
SQL RUNTIME[0.00015783s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100123' LIMIT 1]
SQL RUNTIME[0.00016594s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3071']
SQL RUNTIME[0.00022006s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.23/32']
SQL RUNTIME[0.00016093s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100125' LIMIT 1]
SQL RUNTIME[0.00015497s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3072']
SQL RUNTIME[0.00025105s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.24/32']
SQL RUNTIME[0.00020599s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100132' LIMIT 1]
SQL RUNTIME[0.00020599s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3073']
SQL RUNTIME[0.00022984s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.25/32']
SQL RUNTIME[0.00016618s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100134' LIMIT 1]
SQL RUNTIME[0.00014591s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3074']
SQL RUNTIME[0.00023293s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.26/32']
SQL RUNTIME[0.00018692s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100138' LIMIT 1]
SQL RUNTIME[0.00016689s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3075']
SQL RUNTIME[0.00025392s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.27/32']
SQL RUNTIME[0.00016713s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100143' LIMIT 1]
SQL RUNTIME[0.00014496s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3076']
SQL RUNTIME[0.00023198s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.28/32']
SQL RUNTIME[0.00016403s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100150' LIMIT 1]
SQL RUNTIME[0.00015807s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3077']
SQL RUNTIME[0.00030112s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.29/32']
SQL RUNTIME[0.00014901s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100152' LIMIT 1]
SQL RUNTIME[0.00013590s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3078']
SQL RUNTIME[0.00022697s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.30/32']
SQL RUNTIME[0.00016284s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100155' LIMIT 1]
SQL RUNTIME[0.00015092s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3079']
SQL RUNTIME[0.00025892s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.31/32']
SQL RUNTIME[0.00016904s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '100169' LIMIT 1]
SQL RUNTIME[0.00014687s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3081']
SQL RUNTIME[0.00024700s]
SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '168.0.84.32/32']
SQL RUNTIME[0.00015211s]
SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '3' AND `ifIndex` = '1200' LIMIT 1]
SQL RUNTIME[0.00013185s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3042']
SQL RUNTIME[0.00024891s]
(*Deleted Info*)
SQL[SELECT * FROM `ipv4_addresses`
LEFT JOIN `ports` USING(`port_id`)
WHERE `device_id` = '3']
SQL RUNTIME[0.00013900s]
SQL[DELETE FROM `ipv4_addresses` WHERE `ipv4_address_id` = '8572']
SQL RUNTIME[0.00094485s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '3500']
SQL RUNTIME[0.00022507s]
SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('3','3500','port',NOW(),'6','IP address removed: 0.1.50.198/32')]
SQL RUNTIME[0.00064683s]
SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_network_id` = '1354']
SQL RUNTIME[0.00021291s]
SQL[DELETE FROM `ipv4_networks` WHERE `ipv4_network_id` = '1354']
SQL RUNTIME[0.00046492s]
SQL[SELECT * FROM `ipv6_addresses`
LEFT JOIN `ports` USING(`port_id`)
WHERE `device_id` = '3']
SQL RUNTIME[0.00042892s]
+---------+---------------+-------------+------------------+------------------+--------+
| ifIndex | ifDescr | IP: Version | Address | Network | Origin |
+---------+---------------+-------------+------------------+------------------+--------+
| 1000 | en1-0 | IPv4 | 168.0.84.0/24 | 168.0.84.0/24 | |
(*Deleted Info*)
| 1200 | en1-2 | IPv4 | 225.241.19.33/28 | 225.241.19.32/28 | |
| 1200 | en1-2 | IPv4 | 225.241.27.37/32 | 225.241.27.37/32 | |
| 1200 | en1-2 | IPv4 | 225.241.18.38/28 | 225.241.18.32/28 | |
(*Deleted Info*)
+---------+---------------+-------------+------------------+------------------+--------+
o Changes 1 deleted, 41 unchanged
o Duration 0.4787s
SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('3','3','device',NOW(),'6','Ip-addresses: 1 deleted, 41 unchanged.')]
SQL RUNTIME[0.00079679s]
##### Module Start: processors #####
o Discovering MIBs UCD-SNMP-MIB
SQL[SELECT COUNT(*) FROM processors WHERE device_id = '3' AND processor_type != 'ucd-old']
SQL RUNTIME[0.00028920s]
BIANCA-BRICK-MIBRES-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m BIANCA-BRICK-MIBRES-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/bintec 'udp':'r3002':'161' cpuTable]
CMD EXITCODE[0]
CMD RUNTIME[0.0212s]
STDOUT[
cpuNumber.1.0 = 1
cpuDescr.1.0 = "Onboard MPC 8272"
cpuTotalUser.1.0 = 11105
cpuTotalSystem.1.0 = 9652
cpuTotalStreams.1.0 = 101940
cpuTotalIdle.1.0 = 2967727
cpuLoadUser.1.0 = 8
cpuLoadSystem.1.0 = 4
cpuLoadStreams.1.0 = 7
cpuLoadIdle.1.0 = 81
cpuLoadUser10s.1.0 = 1
cpuLoadSystem10s.1.0 = 0
cpuLoadStreams10s.1.0 = 2
cpuLoadIdle10s.1.0 = 97
cpuLoadUser60s.1.0 = 0
cpuLoadSystem60s.1.0 = 0
cpuLoadStreams60s.1.0 = 1
cpuLoadIdle60s.1.0 = 99
]
SNMP STATUS[TRUE]
3 -> .1.3.6.1.4.1.272.4.17.4.1.1.18.1.0, cpuTable.1.0, cpuTable, Processor 1, 1, 99, ,
SQL[SELECT * FROM `processors` WHERE `device_id` = '3' AND `processor_index` = 'cpuTable.1.0' AND `processor_type` = 'cpuTable']
SQL RUNTIME[0.00030398s]
SQL[SELECT * FROM `processors` WHERE `device_id` = '3']
SQL RUNTIME[0.00023413s]
cpuTable.1.0 -> cpuTable
> $valid['processor'] - /opt/observium/discovery.php:183
/opt/observium/includes/discovery/processors.inc.php:155
=========================================================
array(
[cpuTable] => array(
[cpuTable.1.0] => int(1)
)
)
o Changes 1 unchanged
o Duration 0.0275s
##### Module Start: mempools #####
o Discovering MIBs BIANCA-BRICK-MIBRES-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUsb -m BIANCA-BRICK-MIBRES-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/bintec 'udp':'r3002':'161' memoryTable]
CMD EXITCODE[0]
CMD RUNTIME[0.1135s]
STDOUT[
memoryType.1.0 = flash
memoryType.2.1 = dram
memoryType.3.2 = dpool
memoryType.3.3 = dpool
memoryType.3.4 = dpool
memoryType.3.5 = dpool
memoryType.3.6 = dpool
memoryType.3.7 = dpool
memoryType.3.8 = dpool
memoryType.3.10 = dpool
memoryType.3.11 = dpool
memoryType.3.12 = dpool
memoryType.3.13 = dpool
memoryType.3.14 = dpool
memoryType.3.15 = dpool
memoryDescr.1.0 = "4F 6E 62 6F 61 72 64 20 46 6C 61 73 68 00 "
memoryDescr.2.1 = "4D 61 69 6E 20 4D 65 6D 6F 72 79 00 "
memoryDescr.3.2 = "STREAMS Class 0"
memoryDescr.3.3 = "STREAMS Class 1"
memoryDescr.3.4 = "STREAMS Class 2"
memoryDescr.3.5 = "STREAMS Class 3"
memoryDescr.3.6 = "STREAMS Class 4"
memoryDescr.3.7 = "STREAMS Class 5"
memoryDescr.3.8 = "STREAMS Class 6"
memoryDescr.3.10 = "KMEM Class 0"
memoryDescr.3.11 = "KMEM Class 1"
memoryDescr.3.12 = "KMEM Class 2"
memoryDescr.3.13 = "KMEM Class 3"
memoryDescr.3.14 = "KMEM Class 4"
memoryDescr.3.15 = "KMEM Class 5"
memoryBlockSize.1.0 = 0
memoryBlockSize.2.1 = 0
memoryBlockSize.3.2 = 0
memoryBlockSize.3.3 = 32
memoryBlockSize.3.4 = 64
memoryBlockSize.3.5 = 288
memoryBlockSize.3.6 = 1024
memoryBlockSize.3.7 = 1632
memoryBlockSize.3.8 = 4096
memoryBlockSize.3.10 = 32
memoryBlockSize.3.11 = 64
memoryBlockSize.3.12 = 128
memoryBlockSize.3.13 = 256
memoryBlockSize.3.14 = 512
memoryBlockSize.3.15 = 1024
memoryTotal.1.0 = 16777216
memoryTotal.2.1 = 67043328
memoryTotal.3.2 = 32
memoryTotal.3.3 = 2592
memoryTotal.3.4 = 352
memoryTotal.3.5 = 17856
memoryTotal.3.6 = 160
memoryTotal.3.7 = 408
memoryTotal.3.8 = 100
memoryTotal.3.10 = 9152
memoryTotal.3.11 = 7136
memoryTotal.3.12 = 19584
memoryTotal.3.13 = 448
memoryTotal.3.14 = 832
memoryTotal.3.15 = 256
memoryInuse.1.0 = 0
memoryInuse.2.1 = 41058624
memoryInuse.3.2 = 0
memoryInuse.3.3 = 16
memoryInuse.3.4 = 60
memoryInuse.3.5 = 17720
memoryInuse.3.6 = 136
memoryInuse.3.7 = 129
memoryInuse.3.8 = 49
memoryInuse.3.10 = 5851
memoryInuse.3.11 = 3571
memoryInuse.3.12 = 12720
memoryInuse.3.13 = 389
memoryInuse.3.14 = 801
memoryInuse.3.15 = 221
memoryDramUse.1.0 = 0
memoryDramUse.2.1 = 0
memoryDramUse.3.2 = 1664
memoryDramUse.3.3 = 259200
memoryDramUse.3.4 = 46464
memoryDramUse.3.5 = 6356736
memoryDramUse.3.6 = 174720
memoryDramUse.3.7 = 693600
memoryDramUse.3.8 = 416400
memoryDramUse.3.10 = 292864
memoryDramUse.3.11 = 456704
memoryDramUse.3.12 = 2506752
memoryDramUse.3.13 = 114688
memoryDramUse.3.14 = 425984
memoryDramUse.3.15 = 262144
memoryNAllocs.1.0 = 0
memoryNAllocs.2.1 = 140759
memoryNAllocs.3.2 = 152553542
memoryNAllocs.3.3 = 403396314
memoryNAllocs.3.4 = 256868252
memoryNAllocs.3.5 = 107450234
memoryNAllocs.3.6 = 11124080
memoryNAllocs.3.7 = 1018072203
memoryNAllocs.3.8 = 190843082
memoryNAllocs.3.10 = 1302041177
memoryNAllocs.3.11 = 245339016
memoryNAllocs.3.12 = 110611924
memoryNAllocs.3.13 = 42733162
memoryNAllocs.3.14 = 4161189
memoryNAllocs.3.15 = 5464
memoryNFrees.1.0 = 0
memoryNFrees.2.1 = 100972
memoryNFrees.3.2 = 152553557
memoryNFrees.3.3 = 403396327
memoryNFrees.3.4 = 256868273
memoryNFrees.3.5 = 107432514
memoryNFrees.3.6 = 11123944
memoryNFrees.3.7 = 1018072090
memoryNFrees.3.8 = 190843033
memoryNFrees.3.10 = 1302035476
memoryNFrees.3.11 = 245335445
memoryNFrees.3.12 = 110599219
memoryNFrees.3.13 = 42732773
memoryNFrees.3.14 = 4160388
memoryNFrees.3.15 = 5243
memoryNFails.1.0 = 0
memoryNFails.2.1 = 0
memoryNFails.3.2 = 0
memoryNFails.3.3 = 0
memoryNFails.3.4 = 0
memoryNFails.3.5 = 0
memoryNFails.3.6 = 0
memoryNFails.3.7 = 0
memoryNFails.3.8 = 0
memoryNFails.3.10 = 0
memoryNFails.3.11 = 0
memoryNFails.3.12 = 0
memoryNFails.3.13 = 0
memoryNFails.3.14 = 0
memoryNFails.3.15 = 0
]
SNMP STATUS[TRUE]
3 -> 1.0, BIANCA-BRICK-MIBRES-MIB, Onboard Flash, 1, 16777216, 0
SQL[SELECT * FROM `mempools` WHERE `device_id` = '3' AND `mempool_index` = '1.0' AND `mempool_mib` = 'bianca-brick-mibres-mib']
SQL RUNTIME[0.00037694s]
3 -> 2.1, BIANCA-BRICK-MIBRES-MIB, Main Memory, 1, 67043328, 41058624
SQL[SELECT * FROM `mempools` WHERE `device_id` = '3' AND `mempool_index` = '2.1' AND `mempool_mib` = 'bianca-brick-mibres-mib']
SQL RUNTIME[0.00024390s]
UCD-SNMP-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs 'udp':'r3002':'161' mem]
CMD EXITCODE[0]
CMD RUNTIME[0.007s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `mempools` WHERE `device_id` = '3']
SQL RUNTIME[0.00031209s]
1.0 -> bianca-brick-mibres-mib
2.1 -> bianca-brick-mibres-mib
> $valid['mempool'] - /opt/observium/discovery.php:183
/opt/observium/includes/discovery/mempools.inc.php:40
=======================================================
array(
[bianca-brick-mibres-mib] => array(
[1.0] => int(1)
[2.1] => int(1)
)
)
o Changes 2 unchanged
o Duration 0.1304s
##### Module Start: inventory #####
o Discovering MIBs
SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '3']
SQL RUNTIME[0.00020814s]
o Duration 0.0016s
##### Module Start: printersupplies #####
Printer supplies:
SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '3']
SQL RUNTIME[0.00007606s]
o Duration 0.0013s
##### Module Start: sensors #####
ENTITY-SENSOR-MIB ENTITY-SENSOR-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entPhySensorValue]
CMD EXITCODE[0]
CMD RUNTIME[0.0077s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entPhySensorType]
CMD EXITCODE[0]
CMD RUNTIME[0.0094s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entPhySensorScale]
CMD EXITCODE[0]
CMD RUNTIME[0.0093s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entPhySensorPrecision]
CMD EXITCODE[0]
CMD RUNTIME[0.0121s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entPhySensorOperStatus]
CMD EXITCODE[0]
CMD RUNTIME[0.0082s]
CMD EXITDELAY[10ms]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' entPhysicalDescr]
CMD EXITCODE[0]
CMD RUNTIME[0.0483s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' entPhysicalName]
CMD EXITCODE[0]
CMD RUNTIME[0.0439s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' entPhysicalClass]
CMD EXITCODE[0]
CMD RUNTIME[0.044s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' entPhysicalContainedIn]
CMD EXITCODE[0]
CMD RUNTIME[0.0431s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' entPhysicalParentRelPos]
CMD EXITCODE[0]
CMD RUNTIME[0.0445s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' entAliasMappingIdentifier]
CMD EXITCODE[0]
CMD RUNTIME[0.0102s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00044918s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00019908s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018001s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018406s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018406s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'current' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018501s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'power' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00017691s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00017500s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021696s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018215s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00019598s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00029278s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021100s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00020218s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00018907s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021505s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00022197s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'load' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021005s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023413s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'state' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021100s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00021505s]
SQL[SELECT * FROM `sensors` WHERE `device_id` = '3' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00022388s]
SQL[SELECT * FROM `status` WHERE `device_id` = '3' AND `poller_type` = 'snmp']
SQL RUNTIME[0.00023007s]
o Duration 0.3279s
##### Module Start: storage #####
Storage : UCD-SNMP-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' dskEntry]
CMD EXITCODE[0]
CMD RUNTIME[0.0076s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `storage` WHERE `device_id` = '3']
SQL RUNTIME[0.00031495s]
o Duration 0.011s
##### Module Start: neighbours #####
Neighbours discovery: LLDP-MIB LLDP-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' lldpRemoteSystemsData]
CMD EXITCODE[0]
CMD RUNTIME[0.021s]
STDOUT[
]
SNMP STATUS[TRUE]
|| || || ||
CISCO-CDP-MIB CISCO-CDP-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' cdpCache]
CMD EXITCODE[0]
CMD RUNTIME[0.0266s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `neighbours` LEFT JOIN `ports` USING(`port_id`) WHERE `device_id` = '3']
SQL RUNTIME[0.00092101s]
o Duration 0.0553s
##### Module Start: arp-table #####
SQL[SELECT port_id, ifIndex FROM ports WHERE device_id = '3' GROUP BY port_id]
SQL RUNTIME[0.00039577s]
ARP/NDP Tables :
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipNetToPhysicalPhysAddress]
CMD EXITCODE[0]
CMD RUNTIME[0.0175s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OXqs -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipv6NetToMediaPhysAddress]
CMD EXITCODE[0]
CMD RUNTIME[0.0108s]
STDOUT[
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' ipNetToMediaPhysAddress]
CMD EXITCODE[0]
CMD RUNTIME[0.0412s]
STDOUT[
(*Deleted Info*)
]
SNMP STATUS[TRUE]
Used IP-MIB::ipNetToMediaPhysAddress
SQL[SELECT 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 = '3']
SQL RUNTIME[0.00096297s]
o Duration 0.0796s
##### Module Start: junose-atm-vp #####
o Duration 0.0004s
##### Module Start: bgp-peers #####
CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUQvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' bgpLocalAs.0]
CMD EXITCODE[2]
CMD RUNTIME[0.007s]
STDOUT[
]
STDERR[
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: .1.3.6.1.2.1.15.2.0
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
No BGP on host
SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '3']
SQL RUNTIME[0.00038099s]
o Duration 0.0121s
##### Module Start: mac-accounting #####
o Duration 0.0004s
##### Module Start: cisco-vrf #####
o Duration 0.0005s
##### Module Start: sla #####
o Discovering MIBs DISMAN-PING-MIB DISMAN-PING-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' pingCtlEntry]
CMD EXITCODE[0]
CMD RUNTIME[0.0123s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `slas` WHERE `device_id` = '3']
SQL RUNTIME[0.00027609s]
o Duration 0.016s
##### Module Start: pseudowires #####
o Discovering MIBs
SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '3']
SQL RUNTIME[0.00019121s]
PW-STD-MIB PW-STD-MIB
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' pwID]
CMD EXITCODE[0]
CMD RUNTIME[0.0134s]
STDOUT[
End of MIB
]
SNMP STATUS[FALSE]
SNMP ERROR[#999 - Unknown]
o Duration 0.0176s
##### Module Start: virtual-machines #####
Virtual machines:
o Duration 0.001s
##### Module Start: cisco-cbqos #####
Cisco Class-based QoS:
SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '3']
SQL RUNTIME[0.00025201s]
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'r3002':'161' cbQosIfType]
CMD EXITCODE[0]
CMD RUNTIME[0.0484s]
STDOUT[
]
SNMP STATUS[TRUE]
QoS not configured.
o Duration 0.0515s
##### Module Start: ucd-diskio #####
UCD Disk IO :
CMD[/usr/bin/snmpwalk -Cc -v2c -c *** -Pu -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'r3002':'161' diskIOEntry]
CMD EXITCODE[0]
CMD RUNTIME[0.0071s]
STDOUT[
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '3']
SQL RUNTIME[0.00020099s]
o Duration 0.0097s
##### Module Start: wifi #####
Wifi:
SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '3']
SQL RUNTIME[0.00008607s]
SQL[SELECT * FROM `wifi_wlans` WHERE `device_id` = '3']
SQL RUNTIME[0.00008988s]
o Duration 0.0018s
##### Module Start: p2p-radios #####
o Duration 0.0002s
##### Module Start: graphs #####
o Duration 0.0007s
Module [ services ] disabled globally.
Module [ raid ] disabled globally.
SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='firewall',`last_discovered_timetaken` ='2.231',`force_discovery` ='0' WHERE `device_id` = '3']
SQL RUNTIME[0.01027489s]
SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('3','discover','1469773078.1026','2.2310299873352')]
SQL RUNTIME[0.00134397s]
##### r3002 [3] completed discovery modules at 2016-07-29 08:18:00 #####
o Discovery time 2.231 seconds