DEBUG!
CMD[[0;33m/usr/bin/svn info /opt/observium[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0061s[0m][0m
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 8487
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 8487
Last Changed Date: 2017-04-28 21:50:15 +0200 (Fri, 28 Apr 2017)
][0m
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00017786s[0m][0m
SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00006604s[0m][0m
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';[0m][0m
SQL RUNTIME[[0;32m0.00010300s[0m][0m
SQL[[0;33mSELECT * FROM `config`[0m][0m
SQL RUNTIME[[0;32m0.00004792s[0m][0m
[1;37m
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|[0;36m
Observium Professional 17.4.8487
http://www.observium.org[0m
[0m
CMD[[0;33m/opt/observium/scripts/distro[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0108s[0m][0m
STDOUT[
Linux|4.4.0-45-generic|amd64|Ubuntu|14.04|none
][0m
CMD[[0;33m/usr/bin/env python --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0016s[0m][0m
STDOUT[
Python 2.7.6
][0m
SQL[[0;33mSELECT version();[0m][0m
SQL RUNTIME[[0;32m0.00141883s[0m][0m
CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0016s[0m][0m
STDOUT[
NET-SNMP version: 5.7.2
][0m
CMD[[0;33m/usr/bin/rrdtool --version | head -n1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0031s[0m][0m
STDOUT[
RRDtool 1.4.7 Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch>
][0m
CMD[[0;33m/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}'[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0339s[0m][0m
STDOUT[
Apache/2.4.7
][0m
CMD[[0;33mdate "+%:z"[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0012s[0m][0m
STDOUT[
+02:00
][0m
SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m
SQL RUNTIME[[0;32m0.00010800s[0m][0m
SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00007796s[0m][0m
SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m
SQL RUNTIME[[0;32m0.01753497s[0m][0m
[0;36m##### [1;37mSoftware versions[0;36m #####[0m
[0m
[0;36m o [1;37mOS [0m Linux 4.4.0-45-generic [amd64] (Ubuntu 14.04)
[0;36m o [1;37mApache [0m 2.4.7
[0;36m o [1;37mPHP [0m 5.5.9-1ubuntu4.21 (OPcache: ENABLED)
[0;36m o [1;37mPython [0m 2.7.6
[0;36m o [1;37mMySQL [0m 5.5.55-0ubuntu0.14.04.1 (extension: mysqli 5.5.55)
[0;36m o [1;37mSNMP [0m NET-SNMP 5.7.2
[0;36m o [1;37mRRDtool [0m 1.4.7
[0;35m##### [1;37mMemory Limit[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m Unlimited
[0;35m##### [1;37mMySQL mode[0;35m #####[0m
[0m
[0;35m o [1;37mMySQL [0m
[0;35m##### [1;37mCharset info[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m UTF-8
[0;35m o [1;37mMySQL [0m utf8
[0;35m##### [1;37mTimezones info[0;35m #####[0m
[0m
[0;35m o [1;37mDate [0m Tuesday, 02-May-17 08:52:11 CEST
[0;35m o [1;37mPHP [0m +02:00
[0;35m o [1;37mMySQL [0m +02:00
[1;37m##### [1;37m[1;37mStarting discovery run at 2017-05-02 08:52:11[1;37m #####[0m
[0m
SQL[[0;33mSELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `hostname` LIKE 'hx-core' ORDER BY `last_discovered_timetaken` ASC[0m][0m
SQL RUNTIME[[0;32m0.00033808s[0m][0m
CMD[[0;33m/usr/bin/snmpget -t '10' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hx-core':'161' sysObjectID.0 sysUpTime.0[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.5149s[0m][0m
STDOUT[
sysObjectID.0 = enterprises.1916.2.93
sysUpTime.0 = 3603578700
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
SQL[[0;33mSELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00009394s[0m][0m
SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00020313s[0m][0m
CMD[[0;33m/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 31154[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0054s[0m][0m
STDOUT[
PID PPID UID GID TT STAT TIME STARTED COMMAND
31154 31137 1000 1000 pts/0 S+ 00:00:00 Tue May 2 08:52:10 2017 php ./discovery.php -d -m neighbours -h hx-core
][0m
SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('31154','discovery.php','31137','1000','php ./discovery.php -d -m neighbours -h hx-core','1493707930','6')[0m][0m
SQL RUNTIME[[0;32m0.00381708s[0m][0m
[0;32m##### [1;37mhx-core [6][0;32m #####[0m
[0m
[0;32m o [1;37mOS Type [0m xos
[0;32m o [1;37mOS Group [0m extremeware
[0;32m o [1;37mSNMP Version [0m v2c
[0;32m o [1;37mLast discovery [0m 2017-05-02 07:02:49
[0;32m o [1;37mLast duration [0m 61.57 seconds
[0;36m##### [1;37mModule Start: [1;31mneighbours[0;36m #####[0m
[0m
Neighbours discovery:
SQL[[0;33mSELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '6' AND `attrib_type` = 'sysORID'[0m][0m
SQL RUNTIME[[0;32m0.00005507s[0m][0m
SQL[[0;33mSELECT * FROM `observium_attribs`[0m][0m
SQL RUNTIME[[0;32m0.00010800s[0m][0m
[0;36m o [1;37mLLDP-MIB [0m
CMD[[0;33m/usr/bin/snmpbulkwalk -t '10' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hx-core':'161' lldpRemoteSystemsData[0m]
[0m
CMD EXITCODE[[0;31m2[0m]
CMD RUNTIME[[0;32m1.5356s[0m][0m
STDOUT[
lldpRemChassisIdSubtype.0.1.2 = macAddress
lldpRemChassisIdSubtype.0.2.1 = macAddress
lldpRemChassisIdSubtype.0.3.2 = macAddress
lldpRemChassisIdSubtype.0.4.1 = macAddress
lldpRemChassisIdSubtype.0.5.1 = macAddress
lldpRemChassisIdSubtype.0.6.1 = macAddress
lldpRemChassisIdSubtype.0.7.1 = macAddress
lldpRemChassisIdSubtype.0.8.1 = macAddress
lldpRemChassisIdSubtype.0.9.1 = macAddress
lldpRemChassisIdSubtype.0.18.1 = macAddress
lldpRemChassisIdSubtype.0.21.1 = macAddress
lldpRemChassisIdSubtype.0.23.4 = macAddress
lldpRemChassisIdSubtype.0.28.1 = macAddress
lldpRemChassisIdSubtype.0.35.2 = macAddress
lldpRemChassisIdSubtype.0.36.4 = macAddress
lldpRemChassisIdSubtype.0.37.3 = macAddress
lldpRemChassisIdSubtype.0.38.2 = macAddress
lldpRemChassisIdSubtype.0.39.3 = macAddress
lldpRemChassisIdSubtype.0.40.2 = macAddress
lldpRemChassisIdSubtype.0.41.4 = macAddress
lldpRemChassisIdSubtype.0.42.2 = macAddress
lldpRemChassisIdSubtype.0.43.2 = macAddress
lldpRemChassisIdSubtype.0.61.2 = macAddress
lldpRemChassisId.0.1.2 = "00 04 96 36 6B 34 "
lldpRemChassisId.0.2.1 = "00 04 96 36 6D A4 "
lldpRemChassisId.0.3.2 = "00 04 96 8F 9A 89 "
lldpRemChassisId.0.4.1 = "00 04 96 8F 9C 0D "
lldpRemChassisId.0.5.1 = "00 04 96 8F 9A 23 "
lldpRemChassisId.0.6.1 = "00 04 96 36 6B 3C "
lldpRemChassisId.0.7.1 = "00 04 96 8B CB 04 "
lldpRemChassisId.0.8.1 = "00 04 96 36 77 6F "
lldpRemChassisId.0.9.1 = "00 04 96 36 6B 5B "
lldpRemChassisId.0.18.1 = "08 17 35 8D 6B 00 "
lldpRemChassisId.0.21.1 = "90 E2 BA 35 2F 60 "
lldpRemChassisId.0.23.4 = "90 E2 BA 35 2F 60 "
lldpRemChassisId.0.28.1 = "90 E2 BA 35 2F 60 "
lldpRemChassisId.0.35.2 = "00 04 96 36 76 E5 "
lldpRemChassisId.0.36.4 = "00 04 96 36 6B 3D "
lldpRemChassisId.0.37.3 = "00 04 96 8F 9A 31 "
lldpRemChassisId.0.38.2 = "00 04 96 36 77 04 "
lldpRemChassisId.0.39.3 = "00 04 96 8F 9A 8C "
lldpRemChassisId.0.40.2 = "00 04 96 36 77 B2 "
lldpRemChassisId.0.41.4 = "00 04 96 8F 9C 06 "
lldpRemChassisId.0.42.2 = "00 04 96 36 77 DF "
lldpRemChassisId.0.43.2 = "00 04 96 36 77 9C "
lldpRemChassisId.0.61.2 = "8C B6 4F 4C AA 80 "
lldpRemPortIdSubtype.0.1.2 = interfaceName
lldpRemPortIdSubtype.0.2.1 = interfaceName
lldpRemPortIdSubtype.0.3.2 = interfaceName
lldpRemPortIdSubtype.0.4.1 = interfaceName
lldpRemPortIdSubtype.0.5.1 = interfaceName
lldpRemPortIdSubtype.0.6.1 = interfaceName
lldpRemPortIdSubtype.0.7.1 = interfaceName
lldpRemPortIdSubtype.0.8.1 = interfaceName
lldpRemPortIdSubtype.0.9.1 = interfaceName
lldpRemPortIdSubtype.0.18.1 = interfaceName
lldpRemPortIdSubtype.0.21.1 = interfaceName
lldpRemPortIdSubtype.0.23.4 = interfaceName
lldpRemPortIdSubtype.0.28.1 = interfaceName
lldpRemPortIdSubtype.0.35.2 = interfaceName
lldpRemPortIdSubtype.0.36.4 = interfaceName
lldpRemPortIdSubtype.0.37.3 = interfaceName
lldpRemPortIdSubtype.0.38.2 = interfaceName
lldpRemPortIdSubtype.0.39.3 = interfaceName
lldpRemPortIdSubtype.0.40.2 = interfaceName
lldpRemPortIdSubtype.0.41.4 = interfaceName
lldpRemPortIdSubtype.0.42.2 = interfaceName
lldpRemPortIdSubtype.0.43.2 = interfaceName
lldpRemPortIdSubtype.0.61.2 = interfaceName
lldpRemPortId.0.1.2 = "25"
lldpRemPortId.0.2.1 = "25"
lldpRemPortId.0.3.2 = "49"
lldpRemPortId.0.4.1 = "49"
lldpRemPortId.0.5.1 = "50"
lldpRemPortId.0.6.1 = "25"
lldpRemPortId.0.7.1 = "50"
lldpRemPortId.0.8.1 = "25"
lldpRemPortId.0.9.1 = "25"
lldpRemPortId.0.18.1 = "Gi1/0/52"
lldpRemPortId.0.21.1 = "igb3"
lldpRemPortId.0.23.4 = "bge0"
lldpRemPortId.0.28.1 = "igb2"
lldpRemPortId.0.35.2 = "26"
lldpRemPortId.0.36.4 = "26"
lldpRemPortId.0.37.3 = "50"
lldpRemPortId.0.38.2 = "26"
lldpRemPortId.0.39.3 = "50"
lldpRemPortId.0.40.2 = "26"
lldpRemPortId.0.41.4 = "50"
lldpRemPortId.0.42.2 = "26"
lldpRemPortId.0.43.2 = "26"
lldpRemPortId.0.61.2 = "Gi1/0/48"
lldpRemPortDesc.0.1.2 =
lldpRemPortDesc.0.2.1 =
lldpRemPortDesc.0.3.2 =
lldpRemPortDesc.0.4.1 =
lldpRemPortDesc.0.5.1 =
lldpRemPortDesc.0.6.1 =
lldpRemPortDesc.0.7.1 =
lldpRemPortDesc.0.8.1 =
lldpRemPortDesc.0.9.1 =
lldpRemPortDesc.0.18.1 = GigabitEthernet1/0/52
lldpRemPortDesc.0.21.1 = Intel(R) PRO/1000 Network Connection, Version - 2.5.3-k
lldpRemPortDesc.0.23.4 = Broadcom NetXtreme Gigabit Ethernet Controller, ASIC rev. 0x0042
lldpRemPortDesc.0.28.1 = Intel(R) PRO/1000 Network Connection, Version - 2.5.3-k
lldpRemPortDesc.0.35.2 =
lldpRemPortDesc.0.36.4 =
lldpRemPortDesc.0.37.3 =
lldpRemPortDesc.0.38.2 =
lldpRemPortDesc.0.39.3 =
lldpRemPortDesc.0.40.2 =
lldpRemPortDesc.0.41.4 =
lldpRemPortDesc.0.42.2 =
lldpRemPortDesc.0.43.2 =
lldpRemPortDesc.0.61.2 = GigabitEthernet1/0/48
lldpRemSysName.0.1.2 = R1-UX26-1
lldpRemSysName.0.2.1 = R2-UX21-1
lldpRemSysName.0.3.2 = R3-UX06-1
lldpRemSysName.0.4.1 = R4-UX08-1
lldpRemSysName.0.5.1 = R5-UX48.3-1
lldpRemSysName.0.6.1 = R6-UX23-1
lldpRemSysName.0.7.1 = R7-UX50a-1
lldpRemSysName.0.8.1 = R8-UXG83-1
lldpRemSysName.0.9.1 = R9-UXG71-1
lldpRemSysName.0.18.1 = hx3750-esxi.bredalsparken.dk
lldpRemSysName.0.21.1 = pfsense-hx.itgrp.dk
lldpRemSysName.0.23.4 = pfsense-hx.itgrp.dk
lldpRemSysName.0.28.1 = pfsense-hx.itgrp.dk
lldpRemSysName.0.35.2 = R1-UX30-1.1
lldpRemSysName.0.36.4 = R2-UX15-1.1
lldpRemSysName.0.37.3 = R3-UX13-1
lldpRemSysName.0.38.2 = R4-UX37-1.1
lldpRemSysName.0.39.3 = R5-UX49.2-1
lldpRemSysName.0.40.2 = R6-UX24-1.1
lldpRemSysName.0.41.4 = R7-UX52-1
lldpRemSysName.0.42.2 = R8-UXG32-1.1
lldpRemSysName.0.43.2 = R9-UXG39-1
lldpRemSysName.0.61.2 = wan-sw.itgrp.dk
lldpRemSysDesc.0.1.2 = ExtremeXOS (X250e-24t) version 15.3.4.6 v1534b6-patch1-5 by release-manager on Fri Sep 5 12:37:21 EDT 2014
lldpRemSysDesc.0.2.1 = ExtremeXOS (X250e-24t) version 15.3.4.6 v1534b6-patch1-5 by release-manager on Fri Sep 5 12:37:21 EDT 2014
][0m
STDERR[
Error in packet.
Reason: (tooBig) Response message would have been too large.
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#4 - Too big max-repetition in GETBULK[0m][0m
CMD[[0;33m/usr/bin/snmpbulkwalk -t '10' -v2c -c *** -Pu -OQUs -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hx-core':'161' dot1dBasePortIfIndex[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m1.15s[0m][0m
STDOUT[
dot1dBasePortIfIndex.1 = 1001
dot1dBasePortIfIndex.2 = 1002
dot1dBasePortIfIndex.3 = 1003
dot1dBasePortIfIndex.4 = 1004
dot1dBasePortIfIndex.5 = 1005
dot1dBasePortIfIndex.6 = 1006
dot1dBasePortIfIndex.7 = 1007
dot1dBasePortIfIndex.8 = 1008
dot1dBasePortIfIndex.9 = 1009
dot1dBasePortIfIndex.10 = 1010
dot1dBasePortIfIndex.11 = 1011
dot1dBasePortIfIndex.12 = 1012
dot1dBasePortIfIndex.13 = 1013
dot1dBasePortIfIndex.14 = 1014
dot1dBasePortIfIndex.15 = 1015
dot1dBasePortIfIndex.16 = 1016
dot1dBasePortIfIndex.17 = 1017
dot1dBasePortIfIndex.18 = 1018
dot1dBasePortIfIndex.19 = 1019
dot1dBasePortIfIndex.20 = 1020
dot1dBasePortIfIndex.21 = 1021
dot1dBasePortIfIndex.22 = 1022
dot1dBasePortIfIndex.23 = 1023
dot1dBasePortIfIndex.24 = 1024
dot1dBasePortIfIndex.25 = 1025
dot1dBasePortIfIndex.26 = 1026
dot1dBasePortIfIndex.27 = 1027
dot1dBasePortIfIndex.28 = 1028
dot1dBasePortIfIndex.29 = 1029
dot1dBasePortIfIndex.30 = 1030
dot1dBasePortIfIndex.31 = 1031
dot1dBasePortIfIndex.32 = 1032
dot1dBasePortIfIndex.33 = 1033
dot1dBasePortIfIndex.34 = 1034
dot1dBasePortIfIndex.129 = 2001
dot1dBasePortIfIndex.130 = 2002
dot1dBasePortIfIndex.131 = 2003
dot1dBasePortIfIndex.132 = 2004
dot1dBasePortIfIndex.133 = 2005
dot1dBasePortIfIndex.134 = 2006
dot1dBasePortIfIndex.135 = 2007
dot1dBasePortIfIndex.136 = 2008
dot1dBasePortIfIndex.137 = 2009
dot1dBasePortIfIndex.138 = 2010
dot1dBasePortIfIndex.139 = 2011
dot1dBasePortIfIndex.140 = 2012
dot1dBasePortIfIndex.141 = 2013
dot1dBasePortIfIndex.142 = 2014
dot1dBasePortIfIndex.143 = 2015
dot1dBasePortIfIndex.144 = 2016
dot1dBasePortIfIndex.145 = 2017
dot1dBasePortIfIndex.146 = 2018
dot1dBasePortIfIndex.147 = 2019
dot1dBasePortIfIndex.148 = 2020
dot1dBasePortIfIndex.149 = 2021
dot1dBasePortIfIndex.150 = 2022
dot1dBasePortIfIndex.151 = 2023
dot1dBasePortIfIndex.152 = 2024
dot1dBasePortIfIndex.153 = 2025
dot1dBasePortIfIndex.154 = 2026
dot1dBasePortIfIndex.155 = 2027
dot1dBasePortIfIndex.156 = 2028
dot1dBasePortIfIndex.157 = 2029
dot1dBasePortIfIndex.158 = 2030
dot1dBasePortIfIndex.159 = 2031
dot1dBasePortIfIndex.160 = 2032
dot1dBasePortIfIndex.161 = 2033
dot1dBasePortIfIndex.162 = 2034
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
CMD[[0;33m/usr/bin/snmpbulkwalk -t '10' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hx-core':'161' lldpLocPortEntry[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m1.7848s[0m][0m
STDOUT[
lldpLocPortIdSubtype.1 = interfaceName
lldpLocPortIdSubtype.2 = interfaceName
lldpLocPortIdSubtype.3 = interfaceName
lldpLocPortIdSubtype.4 = interfaceName
lldpLocPortIdSubtype.5 = interfaceName
lldpLocPortIdSubtype.6 = interfaceName
lldpLocPortIdSubtype.7 = interfaceName
lldpLocPortIdSubtype.8 = interfaceName
lldpLocPortIdSubtype.9 = interfaceName
lldpLocPortIdSubtype.10 = interfaceName
lldpLocPortIdSubtype.11 = interfaceName
lldpLocPortIdSubtype.12 = interfaceName
lldpLocPortIdSubtype.13 = interfaceName
lldpLocPortIdSubtype.14 = interfaceName
lldpLocPortIdSubtype.15 = interfaceName
lldpLocPortIdSubtype.16 = interfaceName
lldpLocPortIdSubtype.17 = interfaceName
lldpLocPortIdSubtype.18 = interfaceName
lldpLocPortIdSubtype.19 = interfaceName
lldpLocPortIdSubtype.20 = interfaceName
lldpLocPortIdSubtype.21 = interfaceName
lldpLocPortIdSubtype.22 = interfaceName
lldpLocPortIdSubtype.23 = interfaceName
lldpLocPortIdSubtype.24 = interfaceName
lldpLocPortIdSubtype.25 = interfaceName
lldpLocPortIdSubtype.26 = interfaceName
lldpLocPortIdSubtype.27 = interfaceName
lldpLocPortIdSubtype.28 = interfaceName
lldpLocPortIdSubtype.29 = interfaceName
lldpLocPortIdSubtype.30 = interfaceName
lldpLocPortIdSubtype.31 = interfaceName
lldpLocPortIdSubtype.32 = interfaceName
lldpLocPortIdSubtype.33 = interfaceName
lldpLocPortIdSubtype.34 = interfaceName
lldpLocPortIdSubtype.35 = interfaceName
lldpLocPortIdSubtype.36 = interfaceName
lldpLocPortIdSubtype.37 = interfaceName
lldpLocPortIdSubtype.38 = interfaceName
lldpLocPortIdSubtype.39 = interfaceName
lldpLocPortIdSubtype.40 = interfaceName
lldpLocPortIdSubtype.41 = interfaceName
lldpLocPortIdSubtype.42 = interfaceName
lldpLocPortIdSubtype.43 = interfaceName
lldpLocPortIdSubtype.44 = interfaceName
lldpLocPortIdSubtype.45 = interfaceName
lldpLocPortIdSubtype.46 = interfaceName
lldpLocPortIdSubtype.47 = interfaceName
lldpLocPortIdSubtype.48 = interfaceName
lldpLocPortIdSubtype.49 = interfaceName
lldpLocPortIdSubtype.50 = interfaceName
lldpLocPortIdSubtype.51 = interfaceName
lldpLocPortIdSubtype.52 = interfaceName
lldpLocPortIdSubtype.53 = interfaceName
lldpLocPortIdSubtype.54 = interfaceName
lldpLocPortIdSubtype.55 = interfaceName
lldpLocPortIdSubtype.56 = interfaceName
lldpLocPortIdSubtype.57 = interfaceName
lldpLocPortIdSubtype.58 = interfaceName
lldpLocPortIdSubtype.59 = interfaceName
lldpLocPortIdSubtype.60 = interfaceName
lldpLocPortIdSubtype.61 = interfaceName
lldpLocPortIdSubtype.62 = interfaceName
lldpLocPortIdSubtype.63 = interfaceName
lldpLocPortIdSubtype.64 = interfaceName
lldpLocPortIdSubtype.65 = interfaceName
lldpLocPortIdSubtype.66 = interfaceName
lldpLocPortIdSubtype.67 = interfaceName
lldpLocPortIdSubtype.68 = interfaceName
lldpLocPortId.1 = "1:1"
lldpLocPortId.2 = "1:2"
lldpLocPortId.3 = "1:3"
lldpLocPortId.4 = "1:4"
lldpLocPortId.5 = "1:5"
lldpLocPortId.6 = "1:6"
lldpLocPortId.7 = "1:7"
lldpLocPortId.8 = "1:8"
lldpLocPortId.9 = "1:9"
lldpLocPortId.10 = "1:10"
lldpLocPortId.11 = "1:11"
lldpLocPortId.12 = "1:12"
lldpLocPortId.13 = "1:13"
lldpLocPortId.14 = "1:14"
lldpLocPortId.15 = "1:15"
lldpLocPortId.16 = "1:16"
lldpLocPortId.17 = "1:17"
lldpLocPortId.18 = "1:18"
lldpLocPortId.19 = "1:19"
lldpLocPortId.20 = "1:20"
lldpLocPortId.21 = "1:21"
lldpLocPortId.22 = "1:22"
lldpLocPortId.23 = "1:23"
lldpLocPortId.24 = "1:24"
lldpLocPortId.25 = "1:25"
lldpLocPortId.26 = "1:26"
lldpLocPortId.27 = "1:27"
lldpLocPortId.28 = "1:28"
lldpLocPortId.29 = "1:29"
lldpLocPortId.30 = "1:30"
lldpLocPortId.31 = "1:31"
lldpLocPortId.32 = "1:32"
lldpLocPortId.33 = "1:33"
lldpLocPortId.34 = "1:34"
lldpLocPortId.35 = "2:1"
lldpLocPortId.36 = "2:2"
lldpLocPortId.37 = "2:3"
lldpLocPortId.38 = "2:4"
lldpLocPortId.39 = "2:5"
lldpLocPortId.40 = "2:6"
lldpLocPortId.41 = "2:7"
lldpLocPortId.42 = "2:8"
lldpLocPortId.43 = "2:9"
lldpLocPortId.44 = "2:10"
lldpLocPortId.45 = "2:11"
lldpLocPortId.46 = "2:12"
lldpLocPortId.47 = "2:13"
lldpLocPortId.48 = "2:14"
lldpLocPortId.49 = "2:15"
lldpLocPortId.50 = "2:16"
lldpLocPortId.51 = "2:17"
lldpLocPortId.52 = "2:18"
lldpLocPortId.53 = "2:19"
lldpLocPortId.54 = "2:20"
lldpLocPortId.55 = "2:21"
lldpLocPortId.56 = "2:22"
lldpLocPortId.57 = "2:23"
lldpLocPortId.58 = "2:24"
lldpLocPortId.59 = "2:25"
lldpLocPortId.60 = "2:26"
lldpLocPortId.61 = "2:27"
lldpLocPortId.62 = "2:28"
lldpLocPortId.63 = "2:29"
lldpLocPortId.64 = "2:30"
lldpLocPortId.65 = "2:31"
lldpLocPortId.66 = "2:32"
lldpLocPortId.67 = "2:33"
lldpLocPortId.68 = "2:34"
lldpLocPortDesc.1 = Ring1-Pri
lldpLocPortDesc.2 = Ring2-Pri
lldpLocPortDesc.3 = Ring3-Pri
lldpLocPortDesc.4 = Ring4-Pri
lldpLocPortDesc.5 = Ring5-Pri
lldpLocPortDesc.6 = Ring6-Pri
lldpLocPortDesc.7 = Ring7-Pri
lldpLocPortDesc.8 = Ring8-Pri
lldpLocPortDesc.9 = Ring9-Pri
lldpLocPortDesc.10 =
lldpLocPortDesc.11 =
lldpLocPortDesc.12 =
lldpLocPortDesc.13 =
lldpLocPortDesc.14 =
lldpLocPortDesc.15 =
lldpLocPortDesc.16 =
lldpLocPortDesc.17 =
lldpLocPortDesc.18 = esxi-sw
lldpLocPortDesc.19 =
lldpLocPortDesc.20 = netlog-10.x.x.x-nat
lldpLocPortDesc.21 = pfsense-lagg1
lldpLocPortDesc.22 = netlog-public
lldpLocPortDesc.23 = pfsense-opt1
lldpLocPortDesc.24 =
lldpLocPortDesc.25 = pfsense-mgmt
lldpLocPortDesc.26 =
lldpLocPortDesc.27 = Poseidon
lldpLocPortDesc.28 = pfsense-lagg1
lldpLocPortDesc.29 =
lldpLocPortDesc.30 =
lldpLocPortDesc.31 =
lldpLocPortDesc.32 =
lldpLocPortDesc.33 =
lldpLocPortDesc.34 =
lldpLocPortDesc.35 = Ring1-Sec
lldpLocPortDesc.36 = Ring2-Sec
lldpLocPortDesc.37 = Ring3-Sec
lldpLocPortDesc.38 = Ring4-Sec
lldpLocPortDesc.39 = Ring5-Sec
lldpLocPortDesc.40 = Ring6-Sec
lldpLocPortDesc.41 = Ring7-Sec
lldpLocPortDesc.42 = Ring8-Sec
lldpLocPortDesc.43 = Ring9-Sec
lldpLocPortDesc.44 =
lldpLocPortDesc.45 =
lldpLocPortDesc.46 =
lldpLocPortDesc.47 =
lldpLocPortDesc.48 =
lldpLocPortDesc.49 =
lldpLocPortDesc.50 =
lldpLocPortDesc.51 =
lldpLocPortDesc.52 =
lldpLocPortDesc.53 =
lldpLocPortDesc.54 =
lldpLocPortDesc.55 =
lldpLocPortDesc.56 =
lldpLocPortDesc.57 =
lldpLocPortDesc.58 =
lldpLocPortDesc.59 =
lldpLocPortDesc.60 =
lldpLocPortDesc.61 =
lldpLocPortDesc.62 =
lldpLocPortDesc.63 =
lldpLocPortDesc.64 =
lldpLocPortDesc.65 =
lldpLocPortDesc.66 =
lldpLocPortDesc.67 =
lldpLocPortDesc.68 =
][0m
SNMP STATUS[[0;32mTRUE[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1001' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00029898s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R1-UX26-1' OR `hostname` = 'R1-UX26-1'[0m][0m
SQL RUNTIME[[0;32m0.00021315s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '%' OR `ifDescr` = '%' OR `port_label_short` = '%') AND `device_id` = '9'[0m][0m
SQL RUNTIME[[0;32m0.00030684s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '9'[0m][0m
SQL RUNTIME[[0;32m0.00023890s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '%' OR `ifDescr` = '') AND `device_id` = '9'[0m][0m
SQL RUNTIME[[0;32m0.00023198s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496366b34' AND `device_id` = '9'[0m][0m
SQL RUNTIME[[0;32m0.00023293s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '527'[0m][0m
SQL RUNTIME[[0;32m0.00020695s[0m][0m
SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00015712s[0m][0m
SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00004792s[0m][0m
Discover neighbour: 6 -> lldp, 527, , r1-ux26-1, %, , ExtremeXOS (X250e-24t) version 15.3.4.6 v1534b6-patch1-5 by release-manager on Fri Sep 5 12:37:21 EDT 2014,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '527' AND `protocol` = 'lldp' AND `remote_hostname` = 'r1-ux26-1' AND `remote_port` = '%'[0m][0m
SQL RUNTIME[[0;32m0.00005603s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1002' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00018501s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R2-UX21-1' OR `hostname` = 'R2-UX21-1'[0m][0m
SQL RUNTIME[[0;32m0.00020695s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '%' OR `ifDescr` = '%' OR `port_label_short` = '%') AND `device_id` = '16'[0m][0m
SQL RUNTIME[[0;32m0.00029922s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '16'[0m][0m
SQL RUNTIME[[0;32m0.00022507s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '%' OR `ifDescr` = '') AND `device_id` = '16'[0m][0m
SQL RUNTIME[[0;32m0.00023389s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496366da4' AND `device_id` = '16'[0m][0m
SQL RUNTIME[[0;32m0.00025988s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '528'[0m][0m
SQL RUNTIME[[0;32m0.00021815s[0m][0m
Discover neighbour: 6 -> lldp, 528, , r2-ux21-1, %, , ExtremeXOS (X250e-24t) version 15.3.4.6 v1534b6-patch1-5 by release-manager on Fri Sep 5 12:37:21 EDT 2014,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '528' AND `protocol` = 'lldp' AND `remote_hostname` = 'r2-ux21-1' AND `remote_port` = '%'[0m][0m
SQL RUNTIME[[0;32m0.00004506s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1003' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00020814s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R3-UX06-1' OR `hostname` = 'R3-UX06-1'[0m][0m
SQL RUNTIME[[0;32m0.00017285s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'I' OR `ifDescr` = 'I' OR `port_label_short` = 'I') AND `device_id` = '17'[0m][0m
SQL RUNTIME[[0;32m0.00036502s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '17'[0m][0m
SQL RUNTIME[[0;32m0.00033784s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'I' OR `ifDescr` = '') AND `device_id` = '17'[0m][0m
SQL RUNTIME[[0;32m0.00031090s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9a89' AND `device_id` = '17'[0m][0m
SQL RUNTIME[[0;32m0.00033712s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '529'[0m][0m
SQL RUNTIME[[0;32m0.00017309s[0m][0m
Discover neighbour: 6 -> lldp, 529, , r3-ux06-1, I, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '529' AND `protocol` = 'lldp' AND `remote_hostname` = 'r3-ux06-1' AND `remote_port` = 'I'[0m][0m
SQL RUNTIME[[0;32m0.00005484s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1004' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00019598s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R4-UX08-1' OR `hostname` = 'R4-UX08-1'[0m][0m
SQL RUNTIME[[0;32m0.00018311s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'I' OR `ifDescr` = 'I' OR `port_label_short` = 'I') AND `device_id` = '19'[0m][0m
SQL RUNTIME[[0;32m0.00033808s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '19'[0m][0m
SQL RUNTIME[[0;32m0.00032496s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'I' OR `ifDescr` = '') AND `device_id` = '19'[0m][0m
SQL RUNTIME[[0;32m0.00030708s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9c0d' AND `device_id` = '19'[0m][0m
SQL RUNTIME[[0;32m0.00035405s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '530'[0m][0m
SQL RUNTIME[[0;32m0.00018907s[0m][0m
Discover neighbour: 6 -> lldp, 530, , r4-ux08-1, I, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '530' AND `protocol` = 'lldp' AND `remote_hostname` = 'r4-ux08-1' AND `remote_port` = 'I'[0m][0m
SQL RUNTIME[[0;32m0.00005388s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1005' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00019407s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R5-UX48.3-1' OR `hostname` = 'R5-UX48.3-1'[0m][0m
SQL RUNTIME[[0;32m0.00030422s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'P' OR `ifDescr` = 'P' OR `port_label_short` = 'P') AND `device_id` = '20'[0m][0m
SQL RUNTIME[[0;32m0.00037599s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '20'[0m][0m
SQL RUNTIME[[0;32m0.00039911s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'P' OR `ifDescr` = '') AND `device_id` = '20'[0m][0m
SQL RUNTIME[[0;32m0.00031805s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9a23' AND `device_id` = '20'[0m][0m
SQL RUNTIME[[0;32m0.00033402s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '531'[0m][0m
SQL RUNTIME[[0;32m0.00020218s[0m][0m
Discover neighbour: 6 -> lldp, 531, , r5-ux48.3-1, P, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '531' AND `protocol` = 'lldp' AND `remote_hostname` = 'r5-ux48.3-1' AND `remote_port` = 'P'[0m][0m
SQL RUNTIME[[0;32m0.00004888s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1006' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00031805s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R6-UX23-1' OR `hostname` = 'R6-UX23-1'[0m][0m
SQL RUNTIME[[0;32m0.00017715s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '%' OR `ifDescr` = '%' OR `port_label_short` = '%') AND `device_id` = '23'[0m][0m
SQL RUNTIME[[0;32m0.00028896s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '23'[0m][0m
SQL RUNTIME[[0;32m0.00029898s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '%' OR `ifDescr` = '') AND `device_id` = '23'[0m][0m
SQL RUNTIME[[0;32m0.00024819s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496366b3c' AND `device_id` = '23'[0m][0m
SQL RUNTIME[[0;32m0.00024295s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '532'[0m][0m
SQL RUNTIME[[0;32m0.00024700s[0m][0m
Discover neighbour: 6 -> lldp, 532, , r6-ux23-1, %, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '532' AND `protocol` = 'lldp' AND `remote_hostname` = 'r6-ux23-1' AND `remote_port` = '%'[0m][0m
SQL RUNTIME[[0;32m0.00005293s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1007' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00024796s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R7-UX50a-1' OR `hostname` = 'R7-UX50a-1'[0m][0m
SQL RUNTIME[[0;32m0.00017214s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'P' OR `ifDescr` = 'P' OR `port_label_short` = 'P') AND `device_id` = '25'[0m][0m
SQL RUNTIME[[0;32m0.00036097s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '25'[0m][0m
SQL RUNTIME[[0;32m0.00028896s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'P' OR `ifDescr` = '') AND `device_id` = '25'[0m][0m
SQL RUNTIME[[0;32m0.00027514s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968bcb04' AND `device_id` = '25'[0m][0m
SQL RUNTIME[[0;32m0.00030303s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '533'[0m][0m
SQL RUNTIME[[0;32m0.00016117s[0m][0m
Discover neighbour: 6 -> lldp, 533, , r7-ux50a-1, P, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '533' AND `protocol` = 'lldp' AND `remote_hostname` = 'r7-ux50a-1' AND `remote_port` = 'P'[0m][0m
SQL RUNTIME[[0;32m0.00004888s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1008' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00018001s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R8-UXG83-1' OR `hostname` = 'R8-UXG83-1'[0m][0m
SQL RUNTIME[[0;32m0.00015998s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '%' OR `ifDescr` = '%' OR `port_label_short` = '%') AND `device_id` = '26'[0m][0m
SQL RUNTIME[[0;32m0.00025702s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '26'[0m][0m
SQL RUNTIME[[0;32m0.00021195s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '%' OR `ifDescr` = '') AND `device_id` = '26'[0m][0m
SQL RUNTIME[[0;32m0.00020409s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '00049636776f' AND `device_id` = '26'[0m][0m
SQL RUNTIME[[0;32m0.00021410s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '534'[0m][0m
SQL RUNTIME[[0;32m0.00015903s[0m][0m
Discover neighbour: 6 -> lldp, 534, , r8-uxg83-1, %, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '534' AND `protocol` = 'lldp' AND `remote_hostname` = 'r8-uxg83-1' AND `remote_port` = '%'[0m][0m
SQL RUNTIME[[0;32m0.00004721s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1009' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00017309s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R9-UXG71-1' OR `hostname` = 'R9-UXG71-1'[0m][0m
SQL RUNTIME[[0;32m0.00015306s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '%' OR `ifDescr` = '%' OR `port_label_short` = '%') AND `device_id` = '27'[0m][0m
SQL RUNTIME[[0;32m0.00022793s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '27'[0m][0m
SQL RUNTIME[[0;32m0.00021100s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '%' OR `ifDescr` = '') AND `device_id` = '27'[0m][0m
SQL RUNTIME[[0;32m0.00020218s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496366b5b' AND `device_id` = '27'[0m][0m
SQL RUNTIME[[0;32m0.00022793s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '535'[0m][0m
SQL RUNTIME[[0;32m0.00016594s[0m][0m
Discover neighbour: 6 -> lldp, 535, , r9-uxg71-1, %, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '535' AND `protocol` = 'lldp' AND `remote_hostname` = 'r9-uxg71-1' AND `remote_port` = '%'[0m][0m
SQL RUNTIME[[0;32m0.00004888s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1018' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00016904s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'hx3750-esxi.bredalsparken.dk' OR `hostname` = 'hx3750-esxi.bredalsparken.dk'[0m][0m
SQL RUNTIME[[0;32m0.00015903s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'Gi1/0/52' OR `ifDescr` = 'Gi1/0/52' OR `port_label_short` = 'Gi1/0/52') AND `device_id` = '24'[0m][0m
SQL RUNTIME[[0;32m0.00021911s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '544'[0m][0m
SQL RUNTIME[[0;32m0.00015903s[0m][0m
Discover neighbour: 6 -> lldp, 544, 1928, hx3750-esxi.bredalsparken.dk, Gi1/0/52, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '544' AND `protocol` = 'lldp' AND `remote_hostname` = 'hx3750-esxi.bredalsparken.dk' AND `remote_port` = 'Gi1/0/52'[0m][0m
SQL RUNTIME[[0;32m0.00004697s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1021' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00016999s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'pfsense-hx.itgrp.dk' OR `hostname` = 'pfsense-hx.itgrp.dk'[0m][0m
SQL RUNTIME[[0;32m0.00014710s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'igb3' OR `ifDescr` = 'igb3' OR `port_label_short` = 'igb3') AND `device_id` = '13'[0m][0m
SQL RUNTIME[[0;32m0.00014901s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '547'[0m][0m
SQL RUNTIME[[0;32m0.00017500s[0m][0m
Discover neighbour: 6 -> lldp, 547, 1127, pfsense-hx.itgrp.dk, igb3, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '547' AND `protocol` = 'lldp' AND `remote_hostname` = 'pfsense-hx.itgrp.dk' AND `remote_port` = 'igb3'[0m][0m
SQL RUNTIME[[0;32m0.00003791s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1023' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00016999s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'bge0' OR `ifDescr` = 'bge0' OR `port_label_short` = 'bge0') AND `device_id` = '13'[0m][0m
SQL RUNTIME[[0;32m0.00013590s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '549'[0m][0m
SQL RUNTIME[[0;32m0.00015497s[0m][0m
Discover neighbour: 6 -> lldp, 549, 1128, pfsense-hx.itgrp.dk, bge0, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '549' AND `protocol` = 'lldp' AND `remote_hostname` = 'pfsense-hx.itgrp.dk' AND `remote_port` = 'bge0'[0m][0m
SQL RUNTIME[[0;32m0.00004578s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '1028' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00016785s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'igb2' OR `ifDescr` = 'igb2' OR `port_label_short` = 'igb2') AND `device_id` = '13'[0m][0m
SQL RUNTIME[[0;32m0.00013804s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '554'[0m][0m
SQL RUNTIME[[0;32m0.00015593s[0m][0m
Discover neighbour: 6 -> lldp, 554, 1126, pfsense-hx.itgrp.dk, igb2, , ,
SQL[[0;33mSELECT * FROM `neighbours` WHERE `port_id` = '554' AND `protocol` = 'lldp' AND `remote_hostname` = 'pfsense-hx.itgrp.dk' AND `remote_port` = 'igb2'[0m][0m
SQL RUNTIME[[0;32m0.00004816s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '35' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00014997s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring1-Sec' OR `ifDescr` = 'Ring1-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00051904s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R1-UX30-1.1' OR `hostname` = 'R1-UX30-1.1'[0m][0m
SQL RUNTIME[[0;32m0.00016189s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '28'[0m][0m
SQL RUNTIME[[0;32m0.00025606s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '28'[0m][0m
SQL RUNTIME[[0;32m0.00045609s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '28'[0m][0m
SQL RUNTIME[[0;32m0.00027490s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004963676e5' AND `device_id` = '28'[0m][0m
SQL RUNTIME[[0;32m0.00023103s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '36' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00018406s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring2-Sec' OR `ifDescr` = 'Ring2-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00048900s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R2-UX15-1.1' OR `hostname` = 'R2-UX15-1.1'[0m][0m
SQL RUNTIME[[0;32m0.00016809s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '30'[0m][0m
SQL RUNTIME[[0;32m0.00023293s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '30'[0m][0m
SQL RUNTIME[[0;32m0.00021410s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '30'[0m][0m
SQL RUNTIME[[0;32m0.00020218s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496366b3d' AND `device_id` = '30'[0m][0m
SQL RUNTIME[[0;32m0.00020909s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '37' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015402s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring3-Sec' OR `ifDescr` = 'Ring3-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00047898s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R3-UX13-1' OR `hostname` = 'R3-UX13-1'[0m][0m
SQL RUNTIME[[0;32m0.00016713s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'P' OR `ifDescr` = 'P' OR `port_label_short` = 'P') AND `device_id` = '31'[0m][0m
SQL RUNTIME[[0;32m0.00032496s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '31'[0m][0m
SQL RUNTIME[[0;32m0.00030208s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'P' OR `ifDescr` = '') AND `device_id` = '31'[0m][0m
SQL RUNTIME[[0;32m0.00027800s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9a31' AND `device_id` = '31'[0m][0m
SQL RUNTIME[[0;32m0.00030208s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '38' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015497s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring4-Sec' OR `ifDescr` = 'Ring4-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00048995s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R4-UX37-1.1' OR `hostname` = 'R4-UX37-1.1'[0m][0m
SQL RUNTIME[[0;32m0.00015593s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '32'[0m][0m
SQL RUNTIME[[0;32m0.00024605s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '32'[0m][0m
SQL RUNTIME[[0;32m0.00020885s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '32'[0m][0m
SQL RUNTIME[[0;32m0.00021195s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '000496367704' AND `device_id` = '32'[0m][0m
SQL RUNTIME[[0;32m0.00023818s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '39' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00016689s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring5-Sec' OR `ifDescr` = 'Ring5-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00047588s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R5-UX49.2-1' OR `hostname` = 'R5-UX49.2-1'[0m][0m
SQL RUNTIME[[0;32m0.00016403s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'P' OR `ifDescr` = 'P' OR `port_label_short` = 'P') AND `device_id` = '33'[0m][0m
SQL RUNTIME[[0;32m0.00032592s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '33'[0m][0m
SQL RUNTIME[[0;32m0.00029302s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'P' OR `ifDescr` = '') AND `device_id` = '33'[0m][0m
SQL RUNTIME[[0;32m0.00028086s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9a8c' AND `device_id` = '33'[0m][0m
SQL RUNTIME[[0;32m0.00030518s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '40' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00017381s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring6-Sec' OR `ifDescr` = 'Ring6-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00048018s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R6-UX24-1.1' OR `hostname` = 'R6-UX24-1.1'[0m][0m
SQL RUNTIME[[0;32m0.00015998s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '35'[0m][0m
SQL RUNTIME[[0;32m0.00023103s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '35'[0m][0m
SQL RUNTIME[[0;32m0.00020599s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '35'[0m][0m
SQL RUNTIME[[0;32m0.00020099s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004963677b2' AND `device_id` = '35'[0m][0m
SQL RUNTIME[[0;32m0.00020885s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '41' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015306s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring7-Sec' OR `ifDescr` = 'Ring7-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00047302s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R7-UX52-1' OR `hostname` = 'R7-UX52-1'[0m][0m
SQL RUNTIME[[0;32m0.00016212s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'P' OR `ifDescr` = 'P' OR `port_label_short` = 'P') AND `device_id` = '36'[0m][0m
SQL RUNTIME[[0;32m0.00034618s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '36'[0m][0m
SQL RUNTIME[[0;32m0.00028706s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'P' OR `ifDescr` = '') AND `device_id` = '36'[0m][0m
SQL RUNTIME[[0;32m0.00027514s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004968f9c06' AND `device_id` = '36'[0m][0m
SQL RUNTIME[[0;32m0.00030112s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '42' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015497s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring8-Sec' OR `ifDescr` = 'Ring8-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00047278s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R8-UXG32-1.1' OR `hostname` = 'R8-UXG32-1.1'[0m][0m
SQL RUNTIME[[0;32m0.00016594s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '40'[0m][0m
SQL RUNTIME[[0;32m0.00023484s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '40'[0m][0m
SQL RUNTIME[[0;32m0.00020599s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '40'[0m][0m
SQL RUNTIME[[0;32m0.00021482s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '0004963677df' AND `device_id` = '40'[0m][0m
SQL RUNTIME[[0;32m0.00021291s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '43' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015187s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= 'Ring9-Sec' OR `ifDescr` = 'Ring9-Sec')[0m][0m
SQL RUNTIME[[0;32m0.00047207s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'R9-UXG39-1' OR `hostname` = 'R9-UXG39-1'[0m][0m
SQL RUNTIME[[0;32m0.00016499s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '&' OR `ifDescr` = '&' OR `port_label_short` = '&') AND `device_id` = '42'[0m][0m
SQL RUNTIME[[0;32m0.00023484s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '42'[0m][0m
SQL RUNTIME[[0;32m0.00020885s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifIndex`= '&' OR `ifDescr` = '') AND `device_id` = '42'[0m][0m
SQL RUNTIME[[0;32m0.00020194s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '00049636779c' AND `device_id` = '42'[0m][0m
SQL RUNTIME[[0;32m0.00021100s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND `ifIndex` = '61' AND `ifDescr` NOT LIKE 'Vlan%'[0m][0m
SQL RUNTIME[[0;32m0.00015187s[0m][0m
SQL[[0;33mSELECT * FROM `ports` WHERE `device_id` = '6' AND (`ifName`= '' OR `ifDescr` = '')[0m][0m
SQL RUNTIME[[0;32m0.00048494s[0m][0m
SQL[[0;33mSELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'wan-sw.itgrp.dk' OR `hostname` = 'wan-sw.itgrp.dk'[0m][0m
SQL RUNTIME[[0;32m0.00016403s[0m][0m
SQL[[0;33mSELECT `port_id` FROM `ports` WHERE (`ifName` = 'Gi1/0/48' OR `ifDescr` = 'Gi1/0/48' OR `port_label_short` = 'Gi1/0/48') AND `device_id` = '11'[0m][0m
SQL RUNTIME[[0;32m0.00022316s[0m][0m
[0;36m o [1;37mOSPF-MIB [0m OSPF Neighbours:
CMD[[0;33m/usr/bin/snmpbulkwalk -t '10' -v2c -c *** -Pu -OQUs -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'hx-core':'161' ospfNbrIpAddr[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.1555s[0m][0m
STDOUT[
ospfNbrIpAddr = No Such Object available on this agent at this OID
][0m
SNMP STATUS[[0;31mFALSE[0m][0m
SNMP ERROR[[0;31m#1000 - Failed response[0m][0m
SQL[[0;33mSELECT * FROM `neighbours` LEFT JOIN `ports` USING(`port_id`) WHERE `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00332785s[0m][0m
527 -> r1-ux26-1 -> %
528 -> r2-ux21-1 -> %
529 -> r3-ux06-1 -> I
530 -> r4-ux08-1 -> I
531 -> r5-ux48.3-1 -> P
532 -> r6-ux23-1 -> %
533 -> r7-ux50a-1 -> P
534 -> r8-uxg83-1 -> %
535 -> r9-uxg71-1 -> %
544 -> hx3750-esxi.bredalsparken.dk -> Gi1/0/52
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '1928'[0m][0m
SQL RUNTIME[[0;32m0.00053811s[0m][0m
SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '24'[0m][0m
SQL RUNTIME[[0;32m0.00016093s[0m][0m
SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '24'[0m][0m
SQL RUNTIME[[0;32m0.00023913s[0m][0m
547 -> pfsense-hx.itgrp.dk -> igb3
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '1127'[0m][0m
SQL RUNTIME[[0;32m0.00017691s[0m][0m
SQL[[0;33mSELECT * FROM `devices` WHERE `device_id` = '13'[0m][0m
SQL RUNTIME[[0;32m0.00015903s[0m][0m
SQL[[0;33mSELECT * FROM `device_graphs` WHERE `device_id` = '13'[0m][0m
SQL RUNTIME[[0;32m0.00004816s[0m][0m
549 -> pfsense-hx.itgrp.dk -> bge0
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '1128'[0m][0m
SQL RUNTIME[[0;32m0.00016594s[0m][0m
554 -> pfsense-hx.itgrp.dk -> igb2
SQL[[0;33mSELECT * FROM `ports` WHERE `ports`.`port_id` = '1126'[0m][0m
SQL RUNTIME[[0;32m0.00017500s[0m][0m
Protocol ifName Remote: hostname port platform version
LLDP 1:1 r1-ux26-1 % ... ExtremeXOS (X250e-24t) version 15.3.4...
LLDP 1:2 r2-ux21-1 % ... ExtremeXOS (X250e-24t) version 15.3.4...
LLDP 1:3 r3-ux06-1 I ... ...
LLDP 1:4 r4-ux08-1 I ... ...
LLDP 1:5 r5-ux48.3-1 P ... ...
LLDP 1:6 r6-ux23-1 % ... ...
LLDP 1:7 r7-ux50a-1 P ... ...
LLDP 1:8 r8-uxg83-1 % ... ...
LLDP 1:9 r9-uxg71-1 % ... ...
LLDP 1:18 hx3750-esxi.bredalsparken.dk GigabitEthernet1/0/52 ... ...
LLDP 1:21 pfsense-hx.itgrp.dk igb3 ... ...
LLDP 1:23 pfsense-hx.itgrp.dk bge0 ... ...
LLDP 1:28 pfsense-hx.itgrp.dk igb2 ... ...
[1;44;96m > $valid[$module][0m[44;36m /opt/observium/includes/discovery/neighbours.inc.php:56 [0m
array(
[527] => array(
[r1-ux26-1] => array(
[%] => int(1)
)
)
[528] => array(
[r2-ux21-1] => array(
[%] => int(1)
)
)
[529] => array(
[r3-ux06-1] => array(
[I] => int(1)
)
)
[530] => array(
[r4-ux08-1] => array(
[I] => int(1)
)
)
[531] => array(
[r5-ux48.3-1] => array(
[P] => int(1)
)
)
[532] => array(
[r6-ux23-1] => array(
[%] => int(1)
)
)
[533] => array(
[r7-ux50a-1] => array(
[P] => int(1)
)
)
[534] => array(
[r8-uxg83-1] => array(
[%] => int(1)
)
)
[535] => array(
[r9-uxg71-1] => array(
[%] => int(1)
)
)
[544] => array(
[hx3750-esxi.bredalsparken.dk] => array(
[Gi1/0/52] => int(1)
)
)
[547] => array(
[pfsense-hx.itgrp.dk] => array(
[igb3] => int(1)
)
)
[549] => array(
[pfsense-hx.itgrp.dk] => array(
[bge0] => int(1)
)
)
[554] => array(
[pfsense-hx.itgrp.dk] => array(
[igb2] => int(1)
)
)
)
[0;36m o [1;37mChanges [0m 13 unchanged
[0;36m o [1;37mDuration [0m 4.7373s
SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='4.749',`force_discovery` ='0' WHERE `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00193906s[0m][0m
SQL[[0;33mINSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('6','discover','1493707932.0055','4.7495930194855')[0m][0m
SQL RUNTIME[[0;32m0.00169182s[0m][0m
[0;32m##### [1;37mhx-core [6] completed discovery modules at 2017-05-02 08:52:16[0;32m #####[0m
[0m
[0;32m o [1;37mDiscovery time [0m 4.749 seconds
SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '31154' AND `process_name` = 'discovery.php' AND `device_id` = '6'[0m][0m
SQL RUNTIME[[0;32m0.00056791s[0m][0m
[1;37m##### [1;37m[1;37mFinished discovery run at 2017-05-02 08:52:16[1;37m #####[0m
[0m
SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','hx-core','1493707931.4063','5.354','1')[0m][0m
SQL RUNTIME[[0;32m0.00183487s[0m][0m
./discovery.php: hx-core - 1 devices discovered in 5.354 secs
SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_start` < '1493693531'[0m][0m
SQL RUNTIME[[0;32m0.00010586s[0m][0m
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
[1;37m o [1;37mDevices Discovered [0m 1
[1;37m o [1;37mDiscovery Time [0m 5.354 secs
[1;37m o [1;37mMemory usage [0m 7.5MB (peak: 11.5MB)
[1;37m o [1;37mMySQL Usage [0m Cell[63/0.03s] Row[90/0.035s] Rows[29/0.034s] Column[0/0s] Update[1/0.002s] Insert[3/0.008s] Delete[1/0.001s]
[1;37m o [1;37mRRDTool Usage [0m