root@observer:/opt#  /opt/observium/discovery.php -d -m cisco-pw -h sw1.dc1.north.redacted.net
DEBUG!
Observium 0.15.1.6203
Discovery


SQL[SELECT `version` 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 count(*) FROM `group_table`]

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`]

SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'sw1.dc1.north.redacted.net' ORDER BY `last_discovered_timetaken` ASC]

CMD[/usr/bin/snmpget -v2c -c *** -Pu  -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sw1.dc1.north.redacted.net':'161' sysObjectID.0 sysUpTime.0]
EXITCODE[0]
RUNTIME[0.0174s]
STDOUT[
sysObjectID.0 = enterprises.9.1.449
sysUpTime.0 = 3979968413
]
SNMP_STATUS[TRUE]

SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '16']
sw1.dc1.north.redacted.net 16 ios  (cisco)

SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '16']
Cisco Pseudowires :
SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '16']

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcID]
EXITCODE[0]
RUNTIME[0.0226s]
STDOUT[
cpwVcID.8 = 10009
cpwVcID.9 = 10010
cpwVcID.11 = 1002
cpwVcID.13 = 1001
cpwVcID.14 = 10012
cpwVcID.15 = 10025
cpwVcID.16 = 10029
cpwVcID.17 = 10031
cpwVcID.22 = 9000
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcName]
EXITCODE[0]
RUNTIME[0.0321s]
STDOUT[
cpwVcName.8 = GigabitEthernet1/1
cpwVcName.9 = GigabitEthernet1/2
cpwVcName.11 = GigabitEthernet3/38
cpwVcName.13 = GigabitEthernet1/3
cpwVcName.14 = GigabitEthernet1/4
cpwVcName.15 = GigabitEthernet3/48
cpwVcName.16 = GigabitEthernet3/24
cpwVcName.17 = GigabitEthernet3/36
cpwVcName.22 = GigabitEthernet3/47
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcType]
EXITCODE[0]
RUNTIME[0.0301s]
STDOUT[
cpwVcType.8 = ethernet
cpwVcType.9 = ethernet
cpwVcType.11 = ethernet
cpwVcType.13 = ethernet
cpwVcType.14 = ethernet
cpwVcType.15 = ethernet
cpwVcType.16 = ethernet
cpwVcType.17 = ethernet
cpwVcType.22 = ethernet
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcDescr]
EXITCODE[0]
RUNTIME[0.0223s]
STDOUT[
cpwVcDescr.8 =
cpwVcDescr.9 = XC: XC/10010 - XConnect between customer in BL and NN
cpwVcDescr.11 = Backbone 10. range
cpwVcDescr.13 = XC: XC/1001 - XConnect between NN and BL Internal Network
cpwVcDescr.14 = XC: XC/10012 - XConnect between NN and BL Internal Network
cpwVcDescr.15 =
cpwVcDescr.16 = Cust: Redacted Ltd XC/10029
cpwVcDescr.17 = Cust: Redacted Ltd XC/10031
cpwVcDescr.22 =
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcPsnType]
EXITCODE[0]
RUNTIME[0.0299s]
STDOUT[
cpwVcPsnType.8 = mpls
cpwVcPsnType.9 = mpls
cpwVcPsnType.11 = mpls
cpwVcPsnType.13 = mpls
cpwVcPsnType.14 = mpls
cpwVcPsnType.15 = mpls
cpwVcPsnType.16 = mpls
cpwVcPsnType.17 = mpls
cpwVcPsnType.22 = mpls
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcPeerAddrType]
EXITCODE[0]
RUNTIME[0.0292s]
STDOUT[
cpwVcPeerAddrType.8 = ipv4
cpwVcPeerAddrType.9 = ipv4
cpwVcPeerAddrType.11 = ipv4
cpwVcPeerAddrType.13 = ipv4
cpwVcPeerAddrType.14 = ipv4
cpwVcPeerAddrType.15 = ipv4
cpwVcPeerAddrType.16 = ipv4
cpwVcPeerAddrType.17 = ipv4
cpwVcPeerAddrType.22 = ipv4
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcPeerAddr]
EXITCODE[0]
RUNTIME[0.0319s]
STDOUT[
cpwVcPeerAddr.8 = "\\<h&"
cpwVcPeerAddr.9 = "\\<h
cpwVcPeerAddr.11 = "\\<h\""
cpwVcPeerAddr.13 = "\\<h
cpwVcPeerAddr.14 = "\\<h+"
cpwVcPeerAddr.15 = "\\<h+"
cpwVcPeerAddr.16 = "\\<h\""
cpwVcPeerAddr.17 = "\\<h)"
cpwVcPeerAddr.22 = "\\<h)"
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcLocalIfMtu]
EXITCODE[0]
RUNTIME[0.0223s]
STDOUT[
cpwVcLocalIfMtu.8 = 2856
cpwVcLocalIfMtu.9 = 2036
cpwVcLocalIfMtu.11 = 1500
cpwVcLocalIfMtu.13 = 1500
cpwVcLocalIfMtu.14 = 1500
cpwVcLocalIfMtu.15 = 1500
cpwVcLocalIfMtu.16 = 1500
cpwVcLocalIfMtu.17 = 1500
cpwVcLocalIfMtu.22 = 1500
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcRemoteIfMtu]
EXITCODE[0]
RUNTIME[0.0319s]
STDOUT[
cpwVcRemoteIfMtu.8 = 2856
cpwVcRemoteIfMtu.9 = 2036
cpwVcRemoteIfMtu.11 = 1500
cpwVcRemoteIfMtu.13 = 1500
cpwVcRemoteIfMtu.14 = 1500
cpwVcRemoteIfMtu.15 = 1500
cpwVcRemoteIfMtu.16 = 1500
cpwVcRemoteIfMtu.17 = 1500
cpwVcRemoteIfMtu.22 = 1500
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcRemoteIfString]
EXITCODE[0]
RUNTIME[0.0223s]
STDOUT[
cpwVcRemoteIfString.8 = XCONNECT FOR NN PX TIC-XXXXX
cpwVcRemoteIfString.9 = XC: XC/10010 - XConnect between Customer in BL and NN
cpwVcRemoteIfString.11 = Backboone 10. range
cpwVcRemoteIfString.13 = MPLS LINK TO sw1.rtr.dc1.redacted.co.uk (NN mpls switch)
cpwVcRemoteIfString.14 = XC: XC/10012 - XConnect between BL and KF Internal Network
cpwVcRemoteIfString.15 = XConnect to NN DC1 XC/10025
cpwVcRemoteIfString.16 = Cust: Redacted Ltd XC/10028
cpwVcRemoteIfString.17 = Cust: Redacted Ltd XC/10031
cpwVcRemoteIfString.22 =
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MPLS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcMplsLocalLdpID]
EXITCODE[0]
RUNTIME[0.0376s]
STDOUT[
cpwVcMplsLocalLdpID.8 = 192.168.0.40:0
cpwVcMplsLocalLdpID.9 = 192.168.0.40:0
cpwVcMplsLocalLdpID.11 = 192.168.0.40:0
cpwVcMplsLocalLdpID.13 = 192.168.0.40:0
cpwVcMplsLocalLdpID.14 = 192.168.0.40:0
cpwVcMplsLocalLdpID.15 = 192.168.0.40:0
cpwVcMplsLocalLdpID.16 = 192.168.0.40:0
cpwVcMplsLocalLdpID.17 = 192.168.0.40:0
cpwVcMplsLocalLdpID.22 = 192.168.0.40:0
]
SNMP_STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu  -OQUs -m CISCO-IETF-PW-MPLS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'sw1.dc1.north.redacted.net':'161' cpwVcMplsPeerLdpID]
EXITCODE[0]
RUNTIME[0.0377s]
STDOUT[
cpwVcMplsPeerLdpID.8 = 192.168.0.38:0
cpwVcMplsPeerLdpID.9 = 192.168.0.37:0
cpwVcMplsPeerLdpID.11 = 192.168.0.34:0
cpwVcMplsPeerLdpID.13 = 192.168.0.37:0
cpwVcMplsPeerLdpID.14 = 192.168.0.43:0
cpwVcMplsPeerLdpID.15 = 192.168.0.43:0
cpwVcMplsPeerLdpID.16 = 192.168.0.34:0
cpwVcMplsPeerLdpID.17 = 192.168.0.41:0
cpwVcMplsPeerLdpID.22 = 192.168.0.41:0
]
SNMP_STATUS[TRUE]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h&' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet1/1' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h%' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet1/2' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h\\' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet3/38' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h%' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet1/3' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h+' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet1/4' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h+' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet3/48' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h\\' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet3/24' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h)' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet3/36' AND `device_id` = '16' LIMIT 1;]

SQL[SELECT `device_id` FROM `ipv4_addresses` AS A, `ports` AS I WHERE A.`ipv4_address` = '\\\\<h)' AND A.`port_id` = I.`port_id` LIMIT 1;]

SQL[SELECT `port_id` FROM `ports` WHERE `ifDescr` = 'GigabitEthernet3/47' AND `device_id` = '16' LIMIT 1;]
9 unchanged.
Module [ cisco-pw ] time: 0.3709s

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

SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`)  VALUES ('16','discover','1421919614.164','0.37100005149841')]
Discovered in 0.371 seconds


SQL[SELECT * FROM `alert_tests`]

SQL[SELECT * FROM `alert_assoc`]

SQL[SELECT count(*) FROM `devices` WHERE device_id = '16' AND `type` = 'network']

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

SQL[SELECT * FROM `ports` WHERE device_id = '16' AND `deleted` != '1']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2991']

SQL[SELECT * FROM `devices` WHERE `device_id` = '16']

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '16']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2992']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2993']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2994']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2995']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2996']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2997']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2998']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '2999']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3000']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3001']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3002']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3003']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3004']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3005']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3006']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3007']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3008']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3009']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3010']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3011']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3012']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3013']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3014']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3015']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3016']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3017']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3018']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3019']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3020']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3021']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3022']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3023']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3024']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3025']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3026']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3027']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3028']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3029']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3030']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3031']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3032']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3033']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3034']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3035']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3036']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3037']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3038']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3039']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3040']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3041']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3042']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3043']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3044']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3045']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3046']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3047']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3048']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3049']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3050']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3051']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3052']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3053']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3054']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3055']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3056']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3057']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3058']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3059']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3060']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3061']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3062']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3063']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3064']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3065']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3066']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3067']

SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id`  WHERE `ports`.`port_id` = '3068']

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`)  VALUES ('discover','sw1.dc1.north.redacted.net','1421919614.0564','0.598','1')]
/opt/observium/discovery.php: sw1.dc1.north.redacted.net - 1 devices discovered in 0.598 secs
NOTE, $config['snmp']['hide_auth'] sets as TRUE, snmp community and snmp v3 auth hidden from debug output.
Memory usage: 6MB (peak: 6.25MB)
MySQL: Cell[40/0.01s] Row[79/0.05s] Rows[11/0.01s] Column[0/0s] Update[1/0.03s] Insert[2/0.05s] Delete[0/0s]