DEBUG!

CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0118s]
CMD EXITDELAY[10ms]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: https://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: https://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 11588
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 11588
Last Changed Date: 2021-09-14 18:59:55 +0200 (Tue, 14 Sep 2021)

]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00021505s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00006986s]

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00004911s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0017s]
CMD EXITDELAY[10ms]
STDOUT[
+02:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00011706s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00060701s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00010586s]

CMD[/usr/sbin/fping -v 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0024s]
STDOUT[
/usr/sbin/fping: Version 4.2
/usr/sbin/fping: comments to david@schweikert.ch
]

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                          Observium Professional 21.9.11588
                                  https://www.observium.org


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0197s]
STDOUT[
Linux|4.18.0-305.12.1.el8_4.x86_64|amd64|CentOS|8|vmware|
]

CMD[/usr/bin/env python --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0029s]
STDOUT[
Python 3.6.8
]

SQL[SELECT version();]
SQL RUNTIME[0.00012898s]

CMD[/usr/bin/snmpget --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0031s]
CMD EXITDELAY[10ms]
STDOUT[
NET-SNMP version: 5.8
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0076s]
STDOUT[
RRDtool 1.7.0  Copyright by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[/usr/bin/rrdcached -h | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0082s]
STDOUT[
RRDCacheD 1.7.0
]

CMD[/usr/sbin/fping -v 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0021s]
STDOUT[
/usr/sbin/fping: Version 4.2
/usr/sbin/fping: comments to david@schweikert.ch
]

CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0033s]
STDOUT[

]

CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0278s]
STDOUT[
Apache/2.4.37
]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00013208s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00039792s]

#####  Software versions  #####

 o OS                   Linux 4.18.0-305.12.1.el8_4.x86_64 [amd64] (CentOS 8)
 o Apache               2.4.37
 o PHP                  7.4.6 (OPcache: ENABLED)
 o Python               3.6.8
 o MariaDB              10.5.12-MariaDB (extension: mysqli 7.4.6)
 o SNMP                 NET-SNMP 5.8
 o RRDtool              1.7.0 (rrdcached 1.7.0: unix:/run/rrdcached.sock)
 o Fping                4.2 (IPv4 and IPv6)

#####  Memory Limit  #####

 o PHP                  512MB

#####  MariaDB mode  #####

 o MariaDB              NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#####  Charset info  #####

 o PHP                  UTF-8
 o MariaDB              utf8

#####  Timezones info  #####

 o Date                 Thursday, 16-Sep-21 18:36:03 CEST
 o PHP                  +02:00
 o MariaDB              +02:00

#####  Starting discovery run at 2021-09-16 18:36:03  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '797' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00030613s]

CMD[/usr/bin/snmpget -t '20' -v2c -c *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' .1.3.6.1.2.1.1.2.0 .1.3.6.1.2.1.1.3.0]

CMD EXITCODE[0]
CMD RUNTIME[0.2639s]
STDOUT[
.1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.674.10895.3010
.1.3.6.1.2.1.1.3.0 = 286:4:19:35.00
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '797']
SQL RUNTIME[0.00031209s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '797' AND `poller_id` = '0']
SQL RUNTIME[0.00012803s]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('1416249','discovery.php','1861602','0','php ./discovery.php -h 797 -m neighbours -d','1631810164','797')]
SQL RUNTIME[0.00056791s]
#####  loc-swi-core01.fqdn.net [797]  #####

 o OS Type              powerconnect-fastpath
 o OS Group             fastpath
 o SNMP Version         v2c
 o Last discovery       2021-09-16 12:57:23
 o Last duration        52.16 seconds

#####  Module Start: neighbours  #####


SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '797' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00013900s]
 o OSPF-MIB             Autodiscovery for OSPF disabled.

 o DNOS-ISDP-MIB        
CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m DNOS-ISDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/dell 'udp':'loc-swi-core01.fqdn.net':'161' agentIsdpCacheTable]

CMD EXITCODE[0]
CMD RUNTIME[0.7834s]
STDOUT[
agentIsdpCacheLocalIntf.1.1 = "1/0/1"
agentIsdpCacheLocalIntf.1.2 = "1/0/1"
agentIsdpCacheLocalIntf.1.3 = "1/0/1"
agentIsdpCacheLocalIntf.1.4 = "1/0/1"
agentIsdpCacheLocalIntf.1.5 = "1/0/1"
agentIsdpCacheLocalIntf.1.6 = "1/0/1"
agentIsdpCacheLocalIntf.1.7 = "1/0/1"
agentIsdpCacheLocalIntf.1.8 = "1/0/1"
agentIsdpCacheLocalIntf.1.9 = "1/0/1"
agentIsdpCacheLocalIntf.1.10 = "1/0/1"
agentIsdpCacheLocalIntf.1.11 = "1/0/1"
agentIsdpCacheLocalIntf.1.12 = "1/0/1"
agentIsdpCacheLocalIntf.1.13 = "1/0/1"
agentIsdpCacheLocalIntf.1.14 = "1/0/1"
agentIsdpCacheDeviceId.1.1 = "MikroTik - RB750Gr3 - "
agentIsdpCacheDeviceId.1.2 = "loc-RTR01.fqdn.net"
agentIsdpCacheDeviceId.1.3 = "loc-RTR02.fqdn.net"
agentIsdpCacheDeviceId.1.4 = "loc-SWI-ADM01"
agentIsdpCacheDeviceId.1.5 = "loc-SWI-DC-PROCESSO"
agentIsdpCacheDeviceId.1.6 = "loc-SWI-ECD-MANUTENCAO"
agentIsdpCacheDeviceId.1.7 = "loc-SWI-GO"
agentIsdpCacheDeviceId.1.8 = "loc-SWI-SALA-CONTROLE"
agentIsdpCacheDeviceId.1.9 = "SEPA89D21484323"
agentIsdpCacheDeviceId.1.10 = "SEPE4C7226AD30D"
agentIsdpCacheDeviceId.1.11 = "loc-swi-dc-ta"
agentIsdpCacheDeviceId.1.12 = "loc-swi-expedicao"
agentIsdpCacheDeviceId.1.13 = "loc-swi-ligantes"
agentIsdpCacheDeviceId.1.14 = "loc-swi-manutencao"
]
SNMP STATUS[TRUE]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '797' AND `ifIndex` = '1' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00019097s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12292667']
SQL RUNTIME[0.00020194s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12292667']
SQL RUNTIME[0.00012898s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '797']
SQL RUNTIME[0.00018215s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '797']
SQL RUNTIME[0.00019717s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'mikrotik - rb750gr3 - ']
SQL RUNTIME[0.00013304s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'mikrotik - rb750gr3 - ' AND `disabled` = '0']
SQL RUNTIME[0.00018001s]
Invalid hostname mikrotik - rb750gr3 -  and empty IP, skipped.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => MikroTik - RB750Gr3 - 
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'MikroTik - RB750Gr3 - ' AND `remote_port` = '']
SQL RUNTIME[0.00016308s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'MikroTik - RB750Gr3 - ',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00007415s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-rtr01.fqdn.net' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018907s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '1790']
SQL RUNTIME[0.00143099s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '59' AND `deleted` = '0']
SQL RUNTIME[0.00020790s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-RTR01.fqdn.net
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-rtr01.fqdn.net' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00020003s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-RTR01.fqdn.net' AND `remote_port` = '']
SQL RUNTIME[0.00015712s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-RTR01.fqdn.net',NULL,NULL,NULL,NULL,'1790','1')]
SQL RUNTIME[0.00007796s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-rtr02.fqdn.net' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00017595s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '1791']
SQL RUNTIME[0.00074100s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '856' AND `deleted` = '0']
SQL RUNTIME[0.00016594s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-RTR02.fqdn.net
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-rtr02.fqdn.net' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00016809s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-RTR02.fqdn.net' AND `remote_port` = '']
SQL RUNTIME[0.00013304s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-RTR02.fqdn.net',NULL,NULL,NULL,NULL,'1791','1')]
SQL RUNTIME[0.00006700s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-adm01' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00016880s]

SQL[UPDATE `autodiscovery` set `device_id` ='797' WHERE `autodiscovery_id` = '950']
SQL RUNTIME[0.00113606s]
AUTODISCOVERY UPDATED

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '1662' AND `deleted` = '0']
SQL RUNTIME[0.00039005s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-SWI-ADM01
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-adm01' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018597s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-SWI-ADM01' AND `remote_port` = '']
SQL RUNTIME[0.00012612s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-SWI-ADM01',NULL,NULL,NULL,NULL,'950','1')]
SQL RUNTIME[0.00006914s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-dc-processo' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00016499s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '47392']
SQL RUNTIME[0.00082684s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '1703' AND `deleted` = '0']
SQL RUNTIME[0.00043607s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-SWI-DC-PROCESSO
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-dc-processo' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018001s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-SWI-DC-PROCESSO' AND `remote_port` = '']
SQL RUNTIME[0.00013113s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-SWI-DC-PROCESSO',NULL,NULL,NULL,NULL,'47392','1')]
SQL RUNTIME[0.00006890s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-ecd-manutencao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00016403s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '47391']
SQL RUNTIME[0.00082898s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '802' AND `deleted` = '0']
SQL RUNTIME[0.00030994s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-SWI-ECD-MANUTENCAO
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-ecd-manutencao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00017405s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-SWI-ECD-MANUTENCAO' AND `remote_port` = '']
SQL RUNTIME[0.00012994s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-SWI-ECD-MANUTENCAO',NULL,NULL,NULL,NULL,'47391','1')]
SQL RUNTIME[0.00006580s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-go' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00017715s]

SQL[UPDATE `autodiscovery` set `device_id` ='797' WHERE `autodiscovery_id` = '951']
SQL RUNTIME[0.00095201s]
AUTODISCOVERY UPDATED

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '837' AND `deleted` = '0']
SQL RUNTIME[0.00041509s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-SWI-GO
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-go' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00019813s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-SWI-GO' AND `remote_port` = '']
SQL RUNTIME[0.00014400s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-SWI-GO',NULL,NULL,NULL,NULL,'951','1')]
SQL RUNTIME[0.00007010s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-sala-controle' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00017500s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '26472']
SQL RUNTIME[0.00073195s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '1704' AND `deleted` = '0']
SQL RUNTIME[0.00035691s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-SWI-SALA-CONTROLE
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-sala-controle' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00020599s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-SWI-SALA-CONTROLE' AND `remote_port` = '']
SQL RUNTIME[0.00014210s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-SWI-SALA-CONTROLE',NULL,NULL,NULL,NULL,'26472','1')]
SQL RUNTIME[0.00006819s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepa89d21484323' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00015593s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'sepa89d21484323']
SQL RUNTIME[0.00010300s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'sepa89d21484323' AND `disabled` = '0']
SQL RUNTIME[0.00018811s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepa89d21484323' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::'))]
SQL RUNTIME[0.00015211s]
Autodiscovery for protocol ISDP (xdp) disabled.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => SEPA89D21484323
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepa89d21484323' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00014305s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'SEPA89D21484323' AND `remote_port` = '']
SQL RUNTIME[0.00012398s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'SEPA89D21484323',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00006390s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepe4c7226ad30d' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00014615s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'sepe4c7226ad30d']
SQL RUNTIME[0.00010586s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'sepe4c7226ad30d' AND `disabled` = '0']
SQL RUNTIME[0.00016093s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepe4c7226ad30d' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::'))]
SQL RUNTIME[0.00014186s]
Autodiscovery for protocol ISDP (xdp) disabled.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => SEPE4C7226AD30D
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'sepe4c7226ad30d' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00013995s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'SEPE4C7226AD30D' AND `remote_port` = '']
SQL RUNTIME[0.00012016s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'SEPE4C7226AD30D',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00006294s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-dc-ta' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00015903s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'loc-swi-dc-ta']
SQL RUNTIME[0.00009298s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'loc-swi-dc-ta' AND `disabled` = '0']
SQL RUNTIME[0.00014615s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-dc-ta' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::'))]
SQL RUNTIME[0.00014210s]
Autodiscovery for protocol ISDP (xdp) disabled.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-swi-dc-ta
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-dc-ta' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00014400s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-swi-dc-ta' AND `remote_port` = '']
SQL RUNTIME[0.00013304s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-swi-dc-ta',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00006413s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-expedicao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00014615s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'loc-swi-expedicao']
SQL RUNTIME[0.00009108s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'loc-swi-expedicao' AND `disabled` = '0']
SQL RUNTIME[0.00014520s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-expedicao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::'))]
SQL RUNTIME[0.00014806s]
Autodiscovery for protocol ISDP (xdp) disabled.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-swi-expedicao
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-expedicao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00015402s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-swi-expedicao' AND `remote_port` = '']
SQL RUNTIME[0.00012803s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-swi-expedicao',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00006199s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-ligantes' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00015306s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'loc-swi-ligantes']
SQL RUNTIME[0.00009799s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'loc-swi-ligantes' AND `disabled` = '0']
SQL RUNTIME[0.00020814s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-ligantes' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::'))]
SQL RUNTIME[0.00015497s]
Autodiscovery for protocol ISDP (xdp) disabled.
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-swi-ligantes
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-ligantes' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00014400s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-swi-ligantes' AND `remote_port` = '']
SQL RUNTIME[0.00015998s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-swi-ligantes',NULL,NULL,NULL,NULL,NULL,'1')]
SQL RUNTIME[0.00006819s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-manutencao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00019407s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '946']
SQL RUNTIME[0.00095296s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = '' OR `ifDescr` = '' OR `port_label_short` = '') AND `device_id` = '798' AND `deleted` = '0']
SQL RUNTIME[0.00038815s]
Discover neighbour: proto[isdp], port_id[12292667], Array
(
    [remote_port_id] => 
    [remote_hostname] => loc-swi-manutencao
    [remote_port] => 
    [remote_platform] => 
    [remote_version] => 
    [remote_address] => 
    [last_change] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-manutencao' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018907s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292667' AND `protocol` = 'isdp' AND `remote_hostname` = 'loc-swi-manutencao' AND `remote_port` = '']
SQL RUNTIME[0.00014687s]

SQL[INSERT INTO `neighbours` (`port_id`,`device_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`,`autodiscovery_id`,`active`)  VALUES ('12292667','797','isdp',NULL,'loc-swi-manutencao',NULL,NULL,NULL,NULL,'946','1')]
SQL RUNTIME[0.00007200s]
SQL ERROR[Error in query: (Column 'remote_port' cannot be null) 1048]

 o LLDP-MIB             
CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemChassisIdSubtype]

CMD EXITCODE[0]
CMD RUNTIME[0.2694s]
STDOUT[
lldpRemChassisIdSubtype.22.3.1 = macAddress
lldpRemChassisIdSubtype.22.7.2 = macAddress
lldpRemChassisIdSubtype.23.24.3 = macAddress
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemChassisId]

CMD EXITCODE[0]
CMD RUNTIME[0.2714s]
STDOUT[
lldpRemChassisId.22.3.1 = "48 8F 5A 50 F0 55 "
lldpRemChassisId.22.7.2 = "14 18 77 DB A7 73 "
lldpRemChassisId.23.24.3 = "14 18 77 DB A7 73 "
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemPortIdSubtype]

CMD EXITCODE[0]
CMD RUNTIME[0.2699s]
STDOUT[
lldpRemPortIdSubtype.22.3.1 = interfaceName
lldpRemPortIdSubtype.22.7.2 = interfaceName
lldpRemPortIdSubtype.23.24.3 = interfaceName
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemPortId]

CMD EXITCODE[0]
CMD RUNTIME[0.2702s]
STDOUT[
lldpRemPortId.22.3.1 = "ether2 - Rede Cliente"
lldpRemPortId.22.7.2 = "ManagementEthernet 1/1"
lldpRemPortId.23.24.3 = "TenGigabitEthernet 1/22"
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemPortDesc]

CMD EXITCODE[0]
CMD RUNTIME[0.2699s]
STDOUT[
lldpRemPortDesc.22.3.1 = 
lldpRemPortDesc.22.7.2 = 
lldpRemPortDesc.23.24.3 = 
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemSysName]

CMD EXITCODE[0]
CMD RUNTIME[0.2706s]
CMD EXITDELAY[10ms]
STDOUT[
lldpRemSysName.22.3.1 = MikroTik - RB750Gr3 - 
lldpRemSysName.22.7.2 = loc-SWI-CORE
lldpRemSysName.23.24.3 = loc-SWI-CORE
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemSysDesc]

CMD EXITCODE[0]
CMD RUNTIME[0.2715s]
STDOUT[
lldpRemSysDesc.22.3.1 = MikroTik RouterOS 6.47 (stable) RB750Gr3
lldpRemSysDesc.22.7.2 = Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017
lldpRemSysDesc.23.24.3 = Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUsb -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemManAddrIfId]

CMD EXITCODE[0]
CMD RUNTIME[0.2682s]
STDOUT[
lldpRemManAddrIfId.22.3.1.1.4.177.137.237.209 = 2
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUsb -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpRemManAddr]

CMD EXITCODE[0]
CMD RUNTIME[0.5238s]
CMD EXITDELAY[10ms]
STDOUT[
lldpRemManAddr = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]


  /opt/observium/includes/discovery/neighbours/lldp-mib.inc.php:136 
array(
  [22.3.1]  => array(
                 [lldpRemChassisIdSubtype] => string(10) "macAddress"
                 [lldpRemChassisId]        => string(18) "48 8F 5A 50 F0 55 "
                 [lldpRemPortIdSubtype]    => string(13) "interfaceName"
                 [lldpRemPortId]           => string(21) "ether2 - Rede Cliente"
                 [lldpRemPortDesc]         => string(0) ""
                 [lldpRemSysName]          => string(27) "MikroTik - RB750Gr3 - "
                 [lldpRemSysDesc]          => string(40) "MikroTik RouterOS 6.47 (stable) RB750Gr3"
                 [lldpRemManAddrIfId]      => string(1) "2"
                 [lldpRemManAddr]          => string(15) "177.137.237.209"
                 [lldpRemMan]              => array(
                                                [177.137.237.209] => array(
                                                                       [lldpRemManAddrIfId] => string(1) "2"
                                                                     )
                                              )
               )
  [22.7.2]  => array(
                 [lldpRemChassisIdSubtype] => string(10) "macAddress"
                 [lldpRemChassisId]        => string(18) "14 18 77 DB A7 73 "
                 [lldpRemPortIdSubtype]    => string(13) "interfaceName"
                 [lldpRemPortId]           => string(22) "ManagementEthernet 1/1"
                 [lldpRemPortDesc]         => string(0) ""
                 [lldpRemSysName]          => string(12) "loc-SWI-CORE"
                 [lldpRemSysDesc]          => string(214) "Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017"
               )
  [23.24.3] => array(
                 [lldpRemChassisIdSubtype] => string(10) "macAddress"
                 [lldpRemChassisId]        => string(18) "14 18 77 DB A7 73 "
                 [lldpRemPortIdSubtype]    => string(13) "interfaceName"
                 [lldpRemPortId]           => string(23) "TenGigabitEthernet 1/22"
                 [lldpRemPortDesc]         => string(0) ""
                 [lldpRemSysName]          => string(12) "loc-SWI-CORE"
                 [lldpRemSysDesc]          => string(214) "Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017"
               )
)

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' dot1dBasePortIfIndex]

CMD EXITCODE[0]
CMD RUNTIME[2.0644s]
STDOUT[
dot1dBasePortIfIndex.1 = 1
dot1dBasePortIfIndex.2 = 2
dot1dBasePortIfIndex.3 = 3
dot1dBasePortIfIndex.4 = 4
dot1dBasePortIfIndex.5 = 5
dot1dBasePortIfIndex.6 = 6
dot1dBasePortIfIndex.7 = 7
dot1dBasePortIfIndex.8 = 8
dot1dBasePortIfIndex.9 = 9
dot1dBasePortIfIndex.10 = 10
dot1dBasePortIfIndex.11 = 11
dot1dBasePortIfIndex.12 = 12
dot1dBasePortIfIndex.13 = 13
dot1dBasePortIfIndex.14 = 14
dot1dBasePortIfIndex.15 = 15
dot1dBasePortIfIndex.16 = 16
dot1dBasePortIfIndex.17 = 17
dot1dBasePortIfIndex.18 = 18
dot1dBasePortIfIndex.19 = 19
dot1dBasePortIfIndex.20 = 20
dot1dBasePortIfIndex.21 = 21
dot1dBasePortIfIndex.22 = 22
dot1dBasePortIfIndex.23 = 23
dot1dBasePortIfIndex.24 = 24
dot1dBasePortIfIndex.25 = 25
dot1dBasePortIfIndex.26 = 26
dot1dBasePortIfIndex.27 = 27
dot1dBasePortIfIndex.28 = 28
dot1dBasePortIfIndex.626 = 626
dot1dBasePortIfIndex.627 = 627
dot1dBasePortIfIndex.628 = 628
dot1dBasePortIfIndex.629 = 629
dot1dBasePortIfIndex.630 = 630
dot1dBasePortIfIndex.631 = 631
dot1dBasePortIfIndex.632 = 632
dot1dBasePortIfIndex.633 = 633
dot1dBasePortIfIndex.634 = 634
dot1dBasePortIfIndex.635 = 635
dot1dBasePortIfIndex.636 = 636
dot1dBasePortIfIndex.637 = 637
dot1dBasePortIfIndex.638 = 638
dot1dBasePortIfIndex.639 = 639
dot1dBasePortIfIndex.640 = 640
dot1dBasePortIfIndex.641 = 641
dot1dBasePortIfIndex.642 = 642
dot1dBasePortIfIndex.643 = 643
dot1dBasePortIfIndex.644 = 644
dot1dBasePortIfIndex.645 = 645
dot1dBasePortIfIndex.646 = 646
dot1dBasePortIfIndex.647 = 647
dot1dBasePortIfIndex.648 = 648
dot1dBasePortIfIndex.649 = 649
dot1dBasePortIfIndex.650 = 650
dot1dBasePortIfIndex.651 = 651
dot1dBasePortIfIndex.652 = 652
dot1dBasePortIfIndex.653 = 653
dot1dBasePortIfIndex.654 = 654
dot1dBasePortIfIndex.655 = 655
dot1dBasePortIfIndex.656 = 656
dot1dBasePortIfIndex.657 = 657
dot1dBasePortIfIndex.658 = 658
dot1dBasePortIfIndex.659 = 659
dot1dBasePortIfIndex.660 = 660
dot1dBasePortIfIndex.661 = 661
dot1dBasePortIfIndex.662 = 662
dot1dBasePortIfIndex.663 = 663
dot1dBasePortIfIndex.664 = 664
dot1dBasePortIfIndex.665 = 665
dot1dBasePortIfIndex.666 = 666
dot1dBasePortIfIndex.667 = 667
dot1dBasePortIfIndex.668 = 668
dot1dBasePortIfIndex.669 = 669
dot1dBasePortIfIndex.670 = 670
dot1dBasePortIfIndex.671 = 671
dot1dBasePortIfIndex.672 = 672
dot1dBasePortIfIndex.673 = 673
]
SNMP STATUS[TRUE]
Store in cache Table OID: BRIDGE-MIB::dot1dBasePortIfIndex

CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'loc-swi-core01.fqdn.net':'161' lldpLocPortEntry]

CMD EXITCODE[0]
CMD RUNTIME[2.3273s]
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
lldpLocPortId.1 = "1/0/1"
lldpLocPortId.2 = "1/0/2"
lldpLocPortId.3 = "1/0/3"
lldpLocPortId.4 = "1/0/4"
lldpLocPortId.5 = "1/0/5"
lldpLocPortId.6 = "1/0/6"
lldpLocPortId.7 = "1/0/7"
lldpLocPortId.8 = "1/0/8"
lldpLocPortId.9 = "1/0/9"
lldpLocPortId.10 = "1/0/10"
lldpLocPortId.11 = "1/0/11"
lldpLocPortId.12 = "1/0/12"
lldpLocPortId.13 = "1/0/13"
lldpLocPortId.14 = "1/0/14"
lldpLocPortId.15 = "1/0/15"
lldpLocPortId.16 = "1/0/16"
lldpLocPortId.17 = "1/0/17"
lldpLocPortId.18 = "1/0/18"
lldpLocPortId.19 = "1/0/19"
lldpLocPortId.20 = "1/0/20"
lldpLocPortId.21 = "1/0/21"
lldpLocPortId.22 = "1/0/22"
lldpLocPortId.23 = "1/0/23"
lldpLocPortId.24 = "1/0/24"
lldpLocPortId.25 = "1/0/25"
lldpLocPortId.26 = "1/0/26"
lldpLocPortId.27 = "1/0/27"
lldpLocPortId.28 = "1/0/28"
lldpLocPortDesc.1 = loc-UPS-CPD01
lldpLocPortDesc.2 = loc-UPS-CPD02
lldpLocPortDesc.3 = Router ISP 1 - Dinamica
lldpLocPortDesc.4 = loc-RT-GUEST Admin
lldpLocPortDesc.5 = loc-RTR-Guest WAN
lldpLocPortDesc.6 = loc-RTR-Guest LAN
lldpLocPortDesc.7 = loc-SWI-CORE MGMT 1
lldpLocPortDesc.8 = loc-SWI-CORE MGMT 2
lldpLocPortDesc.9 = Dinamica to VZ
lldpLocPortDesc.10 = 
lldpLocPortDesc.11 = QNAP
lldpLocPortDesc.12 = 
lldpLocPortDesc.13 = 
lldpLocPortDesc.14 = 
lldpLocPortDesc.15 = 
lldpLocPortDesc.16 = 
lldpLocPortDesc.17 = 
lldpLocPortDesc.18 = 
lldpLocPortDesc.19 = 
lldpLocPortDesc.20 = 
lldpLocPortDesc.21 = 
lldpLocPortDesc.22 = 
lldpLocPortDesc.23 = 
lldpLocPortDesc.24 = UPLILNK loc-SWI-CORE
lldpLocPortDesc.25 = 
lldpLocPortDesc.26 = 
lldpLocPortDesc.27 = 
lldpLocPortDesc.28 = 
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND (`ifName`= 'Router ISP 1 - Dinamica' OR `ifDescr` = 'Router ISP 1 - Dinamica' OR `port_label_short` = 'Router ISP 1 - Dinamica')]
SQL RUNTIME[0.00057411s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND `ifIndex` = '3' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00022101s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_ip` = '177.137.237.209' AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.03661823s]

SQL[SELECT `device_id` FROM `ports` WHERE `deleted` = '0' AND `ifPhysAddress` = '488f5a50f055' AND `device_id` != '797' LIMIT 1;]
SQL RUNTIME[0.02535009s]

SQL[SELECT  DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`)  WHERE 1  AND `ipv4_binary` = '±‰íÑ' AND (`ports`.`deleted` != "1" OR `ports`.`deleted` IS NULL) AND `device_id` != '797']
SQL RUNTIME[0.00207400s]

SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'mikrotik - rb750gr3 - ']
SQL RUNTIME[0.00012803s]

SQL[SELECT * FROM `devices` WHERE `sysName` = 'mikrotik - rb750gr3 - ' AND `disabled` = '0']
SQL RUNTIME[0.00018311s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_ip` = '177.137.237.209']
SQL RUNTIME[0.03629518s]
Autodiscovery for protocol LLDP (xdp) disabled.
Discover neighbour: proto[lldp], port_id[12292669], Array
(
    [remote_port_id] => 
    [remote_hostname] => MikroTik - RB750Gr3 - 
    [remote_port] => ether2 - Rede Cliente
    [remote_platform] => MikroTik RouterOS 6.47 (stable) RB750Gr3
    [remote_version] => 
    [remote_address] => 177.137.237.209
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_ip` = '177.137.237.209' AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.03653002s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292669' AND `protocol` = 'lldp' AND `remote_hostname` = 'MikroTik - RB750Gr3 - ' AND `remote_port` = 'ether2 - Rede Cliente']
SQL RUNTIME[0.00023890s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND (`ifName`= 'loc-SWI-CORE MGMT 1' OR `ifDescr` = 'loc-SWI-CORE MGMT 1' OR `port_label_short` = 'loc-SWI-CORE MGMT 1')]
SQL RUNTIME[0.00047612s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND `ifIndex` = '7' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00016999s]

SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-core' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018692s]

SQL[UPDATE `autodiscovery` set `last_checked` =CURRENT_TIMESTAMP() WHERE `autodiscovery_id` = '47380']
SQL RUNTIME[0.00063586s]

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = 'ManagementEthernet 1/1' OR `ifDescr` = 'ManagementEthernet 1/1' OR `port_label_short` = 'ManagementEthernet 1/1') AND `device_id` = '1702' AND `deleted` = '0']
SQL RUNTIME[0.00045204s]
Discover neighbour: proto[lldp], port_id[12292673], Array
(
    [remote_port_id] => 12326830
    [remote_hostname] => loc-SWI-CORE
    [remote_port] => ManagementEthernet 1/1
    [remote_platform] => Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017
    [remote_version] => 
    [remote_address] => 
)


SQL[SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'loc-swi-core' AND (`remote_ip` IS NULL OR `remote_ip` IN ('0.0.0.0', '::')) AND (`remote_device_id` IS NULL OR `remote_device_id` != '797')]
SQL RUNTIME[0.00018096s]

SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292673' AND `protocol` = 'lldp' AND `remote_hostname` = 'loc-SWI-CORE' AND `remote_port` = 'ManagementEthernet 1/1']
SQL RUNTIME[0.00014615s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND (`ifName`= 'UPLILNK loc-SWI-CORE' OR `ifDescr` = 'UPLILNK loc-SWI-CORE' OR `port_label_short` = 'UPLILNK loc-SWI-CORE')]
SQL RUNTIME[0.00042987s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '797' AND `deleted` = '0' AND `ifIndex` = '24' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00016904s]
AUTODISCOVERY DEVEL: remote_device_id from cache

SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = 'TenGigabitEthernet 1/22' OR `ifDescr` = 'TenGigabitEthernet 1/22' OR `port_label_short` = 'TenGigabitEthernet 1/22') AND `device_id` = '1702' AND `deleted` = '0']
SQL RUNTIME[0.00044012s]
Discover neighbour: proto[lldp], port_id[12292690], Array
(
    [remote_port_id] => 12326747
    [remote_hostname] => loc-SWI-CORE
    [remote_port] => TenGigabitEthernet 1/22
    [remote_platform] => Dell Real Time Operating System Software. Dell Operating System Version: 2.0. Dell Application Software Version: 9.11(2.0P0) Copyright (c) 1999-2017Dell Inc. All Rights Reserved.Build Time: Thu Apr 27 07:46:11 2017
    [remote_version] => 
    [remote_address] => 
)


SQL[SELECT `neighbours`.*, UNIX_TIMESTAMP(`last_change`) AS `last_change_unixtime` FROM `neighbours` WHERE `port_id` = '12292690' AND `protocol` = 'lldp' AND `remote_hostname` = 'loc-SWI-CORE' AND `remote_port` = 'TenGigabitEthernet 1/22']
SQL RUNTIME[0.00014496s]

 o CISCO-CDP-MIB        
CMD[/usr/bin/snmpbulkwalk -t '20' -v2c -c *** -Pud -Ih -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'loc-swi-core01.fqdn.net':'161' cdpCache]

CMD EXITCODE[0]
CMD RUNTIME[0.5368s]
STDOUT[
cdpCache = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]


SQL[SELECT * FROM `neighbours` WHERE `device_id` = '797']
SQL RUNTIME[0.00021315s]
12292673 -> loc-swi-core.fqdn.net () -> ManagementEthernet 1/1
12292690 -> loc-swi-core.fqdn.net () -> TenGigabitEthernet 1/22
12292673 -> loc-SWI-CORE () -> ManagementEthernet 1/1

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12292673']
SQL RUNTIME[0.00020504s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12292673']
SQL RUNTIME[0.00013709s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12326830']
SQL RUNTIME[0.00018096s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12326830']
SQL RUNTIME[0.00012922s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '1702']
SQL RUNTIME[0.00017619s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '1702']
SQL RUNTIME[0.00020218s]
12292690 -> loc-SWI-CORE () -> TenGigabitEthernet 1/22

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12292690']
SQL RUNTIME[0.00017595s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12292690']
SQL RUNTIME[0.00011706s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12326747']
SQL RUNTIME[0.00014710s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12326747']
SQL RUNTIME[0.00015283s]
12292669 -> MikroTik - RB750Gr3 -  (177.137.237.209) -> ether2 - Rede Cliente

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '12292669']
SQL RUNTIME[0.00016809s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '12292669']
SQL RUNTIME[0.00010800s]

+----------+--------+-----------------------------------------------+-------------------------+----------------------+---------+
| Protocol | ifName | Remote: hostname                              | port                    | platform             | version |
+----------+--------+-----------------------------------------------+-------------------------+----------------------+---------+
| LLDP     | 1/0/7  | loc-SWI-CORE                                  | ManagementEthernet 1/1  | Dell Real Time Op... | ...     |
| LLDP     | 1/0/24 | loc-SWI-CORE                                  | TenGigabitEthernet 1/22 | Dell Real Time Op... | ...     |
| LLDP     | 1/0/3  | MikroTik - RB750Gr3 -  (177.137.237.209) | ether2 - Rede Cliente   | MikroTik RouterOS... | ...     |
+----------+--------+-----------------------------------------------+-------------------------+----------------------+---------+



 > $valid[$module] /opt/observium/includes/discovery/neighbours.inc.php:61 
array(
  [12292667] => array(
                  [MikroTik - RB750Gr3 - ] => array(
                                                     [] => int(1)
                                                   )
                  [loc-RTR01.fqdn.net]         => array(
                                                     [] => int(1)
                                                   )
                  [loc-RTR02.fqdn.net]         => array(
                                                     [] => int(1)
                                                   )
                  [loc-SWI-ADM01]               => array(
                                                     [] => int(1)
                                                   )
                  [loc-SWI-DC-PROCESSO]         => array(
                                                     [] => int(1)
                                                   )
                  [loc-SWI-ECD-MANUTENCAO]      => array(
                                                     [] => int(1)
                                                   )
                  [loc-SWI-GO]                  => array(
                                                     [] => int(1)
                                                   )
                  [loc-SWI-SALA-CONTROLE]       => array(
                                                     [] => int(1)
                                                   )
                  [SEPA89D21484323]             => array(
                                                     [] => int(1)
                                                   )
                  [SEPE4C7226AD30D]             => array(
                                                     [] => int(1)
                                                   )
                  [loc-swi-dc-ta]               => array(
                                                     [] => int(1)
                                                   )
                  [loc-swi-expedicao]           => array(
                                                     [] => int(1)
                                                   )
                  [loc-swi-ligantes]            => array(
                                                     [] => int(1)
                                                   )
                  [loc-swi-manutencao]          => array(
                                                     [] => int(1)
                                                   )
                )
  [12292669] => array(
                  [MikroTik - RB750Gr3 - -177.137.237.209] => array(
                                                                     [ether2 - Rede Cliente] => int(1)
                                                                   )
                )
  [12292673] => array(
                  [loc-SWI-CORE] => array(
                                      [ManagementEthernet 1/1] => int(1)
                                    )
                )
  [12292690] => array(
                  [loc-SWI-CORE] => array(
                                      [TenGigabitEthernet 1/22] => int(1)
                                    )
                )
)


 o Changes              14 added, 3 unchanged
 o Duration             8.6119s

SQL[SELECT * FROM `devices` WHERE `devices`.`device_id` = '797']
SQL RUNTIME[0.00022006s]

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('797','797','device',NOW(),'6','Neighbours: 14 added, 3 unchanged.')]
SQL RUNTIME[0.00058794s]


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='8.6143',`force_discovery` ='0' WHERE `device_id` = '797']
SQL RUNTIME[0.00061893s]
#####  loc-swi-core01.fqdn.net [797] completed discovery modules at 2021-09-16 18:36:12  #####

 o Discovery time       8.6143 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '1416249' AND `process_name` = 'discovery.php' AND `device_id` = '797' AND `poller_id` = '0']
SQL RUNTIME[0.00059819s]
#####  Finished discovery run at 2021-09-16 18:36:12  #####

./discovery.php: loc-swi-core01.fqdn.net - 1 devices discovered in 8.974 secs

SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1631795763']
SQL RUNTIME[0.00019002s]
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
 o Devices Discovered   1
 o Discovery Time       8.974 secs
 o Memory usage         6MB (peak: 6MB)
 o MySQL Usage          Cell[23/0.031s] Row[70/0.125s] Rows[24/0.008s] Column[2/0.002s] Update[10/0.009s] Insert[16/0.004s] Delete[1/0.001s] 
 o RRDTool Usage