DEBUG! CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0041s] CMD EXITDELAY[5ms] 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: 15526 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 15526 Last Changed Date: 2026-11-16 16:22:14 +0100 (Mon, 16 Nov 2026) ] CMD[/usr/bin/svn auth svn.observium.org | awk '/Username:/ {print $2}'] CMD EXITCODE[0] CMD RUNTIME[0.0043s] STDOUT[ cominnoc-35416468 ] DEFINITIONS Time : 0.096549 ms DEFINITIONS Memory: 3.63MB SQL[SELECT * FROM `observium_attribs` WHERE `attrib_type` != 'ldap_session_secret'] SQL RUNTIME[0.00028586s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[6.986E-5s] SQL[SET SESSION `sql_mode` = 'NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[5.007E-5s] DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO SQL[SELECT * FROM `config`] SQL RUNTIME[8.297E-5s] SQL[SELECT @@SESSION.time_zone;] SQL RUNTIME[4.411E-5s] SQL[SELECT @@SYSTEM_TIME_ZONE;] SQL RUNTIME[4.101E-5s] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[6.199E-5s] SQL[SELECT CONVERT_TZ('2000-01-01 00:00:00', '+00:00', 'UTC')] SQL RUNTIME[8.702E-5s] DB timezone different from php timezone. Syncing.. SQL[SELECT version();] SQL RUNTIME[3.791E-5s] SQL[SET SESSION time_zone='+00:00';] SQL RUNTIME[3.505E-5s] CMD[date "+%z"] CMD EXITCODE[0] CMD RUNTIME[0.0009s] STDOUT[ +0100 ] SQL[SELECT @@SESSION.time_zone;] SQL RUNTIME[0.00027394s] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00015807s] SQL[SELECT CONVERT_TZ('2000-01-01 00:00:00', '+00:00', 'UTC')] SQL RUNTIME[0.00017405s] SQL[SELECT EXISTS (SELECT 1 FROM `pollers` WHERE `poller_id` = '0')] SQL RUNTIME[0.00020695s] SQL[SELECT EXISTS (SELECT 1 FROM `pollers` WHERE `poller_id` != '0')] SQL RUNTIME[0.0001719s] SQL[SELECT *, UNIX_TIMESTAMP(`timestamp`) AS `unixtime` FROM `pollers` WHERE `poller_id` = '0'] SQL RUNTIME[0.00015306s] Observium Attributes already cached. ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 26.11.15526 https://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0095s] STDOUT[ Linux|6.8.0-149-generic|amd64|Ubuntu|24.04.5|kvm| ] CMD[/usr/bin/env python3 --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0009s] STDOUT[ Python 3.12.3 ] SQL[SELECT version();] SQL RUNTIME[0.00012302s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.001s] STDOUT[ NET-SNMP version: 5.9.4.pre2 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0048s] STDOUT[ RRDtool 1.7.2 Copyright by Tobias Oetiker ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0006s] STDOUT[ /usr/bin/fping: Version 5.1 ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.0129s] STDOUT[ Apache/2.4.58 ] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.000211s] SQL[SHOW VARIABLES LIKE 'log_bin'] SQL RUNTIME[0.0009861s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00040507s] ##### Observium ##### o Version 26.11.15526 o Train rolling o Released 16th November 2026 o Subscription User cominnoc-35416468 ##### Software versions ##### o OS Linux 6.8.0-149-generic [amd64] (Ubuntu 24.04.5) o VM KVM Virtual Machine o Apache 2.4.58 o PHP 8.3.6 o Python 3.12.3 o MySQL 8.0.46-0ubuntu0.24.04.5 (client: MySQLnd 8.3.6) o SNMP NET-SNMP 5.9.4.pre2 o RRDtool 1.7.2 o Fping 5.1 (IPv4 and IPv6) o Fetch cURL 8.5.0 (OpenSSL/3.0.13, LibZ 1.3, LibIDN 2.3.7) ##### PHP info ##### o OPcache ENABLED o Memory Limit Unlimited o Math BCMATH ##### DB info ##### o DB schema 573 o MySQL binlog OFF o MySQL mode NO_ENGINE_SUBSTITUTION ##### Charset info ##### o PHP UTF-8 o MySQL utf8mb3 ##### Timezones info ##### o Date Wednesday, 18-Nov-26 09:09:53 UTC o PHP +00:00 (UTC) o MySQL +00:00 (+00:00) ##### Starting discovery run at 2026-11-18 09:09:53 ##### SQL[SELECT * FROM `devices` WHERE `device_id` = 636 AND `disabled` = 0 AND `status` = 1 AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00027919s] SQL[SELECT *, TIMESTAMPDIFF(SECOND, `updated`, NOW()) AS `age` FROM `device_snmp_get_limits` WHERE `device_id` = '636'] SQL RUNTIME[0.00016499s] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'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.013s] STDOUT[ .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.11863.5.158 .1.3.6.1.2.1.1.3.0 = 369:3:50:32.41 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636'] SQL RUNTIME[0.00027299s] SQL[SELECT *, TIMESTAMPDIFF(SECOND, `updated`, NOW()) AS `age` FROM `device_snmp_get_limits` WHERE `device_id` = '636'] SQL RUNTIME[0.00011587s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '636' AND `poller_id` = '0'] SQL RUNTIME[7.2E-5s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('1725403','discovery.php','1613384','0','php ./discovery.php -d -h 636','1794992992','636')] SQL RUNTIME[0.00161314s] ##### [636] ##### o OS Type tplink-jetstream o SNMP Version v2c o Last discovery 2026-11-18 06:19:01 o Last duration 8.92 seconds JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '636' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[8.202E-5s] o MIB Helpers etherlike-mib.inc.php ip-mib.inc.php lldp-mib.inc.php ##### Module Start: snmp ##### including: includes/discovery/snmp.inc.php SQL[SELECT `snmp_maxrep_learned`, `snmp_maxget_learned`, `snmp_maxreply_learned` FROM `devices` WHERE `device_id` = '636'] SQL RUNTIME[7.987E-5s] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -d -r 0 -m SNMPv2-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.1.0] CMD EXITCODE[2] CMD RUNTIME[0.016s] CMD EXITDELAY[5ms] STDOUT[ ] STDERR[ Sending 414 bytes to UDP: []:161->[0.0.0.0]:51513 0000: 30 82 01 9A 02 01 01 04 07 52 30 21 35 6E 6D 50 0........ 0016: A0 82 01 8A 02 04 5A 85 87 80 02 01 00 02 01 00 ......Z......... 0032: 30 82 01 7A 30 0C 06 08 2B 06 01 02 01 01 01 00 0..z0...+....... 0048: 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 ..0...+......... 0064: 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 0...+.........0. 0080: 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 ..+.........0... 0096: 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 +.........0...+. 0112: 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 ........0...+... 0128: 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 ......0...+..... 0144: 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 ....0...+....... 0160: 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 ..0...+......... 0176: 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 0...+.........0. 0192: 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 ..+.........0... 0208: 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 +.........0...+. 0224: 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 ........0...+... 0240: 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 ......0...+..... 0256: 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 ....0...+....... 0272: 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 ..0...+......... 0288: 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 0...+.........0. 0304: 06 08 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 ..+.........0... 0320: 2B 06 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 +.........0...+. 0336: 01 02 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 ........0...+... 0352: 01 01 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 ......0...+..... 0368: 01 00 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 ....0...+....... 0384: 05 00 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 ..0...+......... 0400: 30 0C 06 08 2B 06 01 02 01 01 01 00 05 00 0...+......... Received 30 byte packet from UDP: []:161->[0.0.0.0]:51513 0000: 30 1C 02 01 01 04 07 52 30 21 35 6E 6D 50 A2 0E 0........ 0016: 02 04 5A 85 87 80 02 01 01 02 01 00 30 00 ..Z.........0. Error in packet Reason: (tooBig) Response message would have been too large. ] Device-specific maxrep 120. CMD[/usr/bin/snmpbulkget -Cr'120' -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -d -r 0 -Cn0 -m SNMPv2-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.2.2.1] CMD EXITCODE[0] CMD RUNTIME[0.6181s] STDOUT[ .1.3.6.1.2.1.2.2.1.1.841 = 841 .1.3.6.1.2.1.2.2.1.1.49153 = 49153 .1.3.6.1.2.1.2.2.1.1.49154 = 49154 .1.3.6.1.2.1.2.2.1.1.49155 = 49155 .1.3.6.1.2.1.2.2.1.1.49156 = 49156 .1.3.6.1.2.1.2.2.1.1.49157 = 49157 .1.3.6.1.2.1.2.2.1.1.49158 = 49158 .1.3.6.1.2.1.2.2.1.1.49159 = 49159 .1.3.6.1.2.1.2.2.1.1.49160 = 49160 .1.3.6.1.2.1.2.2.1.1.49161 = 49161 .1.3.6.1.2.1.2.2.1.1.49162 = 49162 .1.3.6.1.2.1.2.2.1.2.841 = Vlan-interface841 .1.3.6.1.2.1.2.2.1.2.49153 = gigabitEthernet 1/0/1 .1.3.6.1.2.1.2.2.1.2.49154 = gigabitEthernet 1/0/2 .1.3.6.1.2.1.2.2.1.2.49155 = gigabitEthernet 1/0/3 .1.3.6.1.2.1.2.2.1.2.49156 = gigabitEthernet 1/0/4 .1.3.6.1.2.1.2.2.1.2.49157 = gigabitEthernet 1/0/5 .1.3.6.1.2.1.2.2.1.2.49158 = gigabitEthernet 1/0/6 .1.3.6.1.2.1.2.2.1.2.49159 = gigabitEthernet 1/0/7 .1.3.6.1.2.1.2.2.1.2.49160 = gigabitEthernet 1/0/8 .1.3.6.1.2.1.2.2.1.2.49161 = gigabitEthernet 1/0/9 .1.3.6.1.2.1.2.2.1.2.49162 = gigabitEthernet 1/0/10 .1.3.6.1.2.1.2.2.1.3.841 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49153 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49154 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49155 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49156 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49157 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49158 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49159 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49160 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49161 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.3.49162 = ethernetCsmacd .1.3.6.1.2.1.2.2.1.4.841 = 1500 .1.3.6.1.2.1.2.2.1.4.49153 = 1518 .1.3.6.1.2.1.2.2.1.4.49154 = 1518 .1.3.6.1.2.1.2.2.1.4.49155 = 1518 .1.3.6.1.2.1.2.2.1.4.49156 = 1518 .1.3.6.1.2.1.2.2.1.4.49157 = 1518 .1.3.6.1.2.1.2.2.1.4.49158 = 1518 .1.3.6.1.2.1.2.2.1.4.49159 = 1518 .1.3.6.1.2.1.2.2.1.4.49160 = 1518 .1.3.6.1.2.1.2.2.1.4.49161 = 1518 .1.3.6.1.2.1.2.2.1.4.49162 = 1518 .1.3.6.1.2.1.2.2.1.5.841 = 1000000000 .1.3.6.1.2.1.2.2.1.5.49153 = 0 .1.3.6.1.2.1.2.2.1.5.49154 = 100000000 .1.3.6.1.2.1.2.2.1.5.49155 = 100000000 .1.3.6.1.2.1.2.2.1.5.49156 = 100000000 .1.3.6.1.2.1.2.2.1.5.49157 = 0 .1.3.6.1.2.1.2.2.1.5.49158 = 0 .1.3.6.1.2.1.2.2.1.5.49159 = 0 .1.3.6.1.2.1.2.2.1.5.49160 = 100000000 .1.3.6.1.2.1.2.2.1.5.49161 = 1000000000 .1.3.6.1.2.1.2.2.1.5.49162 = 0 .1.3.6.1.2.1.2.2.1.6.841 = 28:87:ba:f3:c3:9e .1.3.6.1.2.1.2.2.1.6.49153 = 28:87:ba:f3:c3:9e .1.3.6.1.2.1.2.2.1.6.49154 = 28:87:ba:f3:c3:9e .1.3.6.1.2.1.2.2.1.6.49155 = 28:87:ba:f3:c3:9e .1.3.6.1.2.1.2.2.1.6.49156 = 28:87:ba:f3:c3:9e ] o Large replies not sent, the agent stops at 1462 bytes o Max-rep 50 (learned) o Collection preference Default (default) SQL[SELECT DISTINCT `ifIndex` FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0 ORDER BY `ifIndex` DESC LIMIT 6] SQL RUNTIME[0.00032902s] SQL[SELECT `ifIndex`, `ifInOctets`, `ifOutOctets` FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0 AND `port_64bit` = 1 ORDER BY GREATEST(`ifInOctets`, `ifOutOctets`) DESC, `ifIndex` DESC LIMIT 64] SQL RUNTIME[0.00052905s] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.1.1.0 .1.3.6.1.2.1.1.2.0 .1.3.6.1.2.1.1.3.0 .1.3.6.1.2.1.1.4.0 .1.3.6.1.2.1.1.5.0 .1.3.6.1.2.1.1.6.0 .1.3.6.1.2.1.1.7.0 .1.3.6.1.2.1.11.1.0 .1.3.6.1.2.1.11.3.0 .1.3.6.1.2.1.11.4.0 .1.3.6.1.2.1.11.5.0 .1.3.6.1.2.1.11.6.0 .1.3.6.1.2.1.11.30.0 .1.3.6.1.2.1.11.31.0 .1.3.6.1.2.1.11.32.0 .1.3.6.1.2.1.2.2.1.1.841 .1.3.6.1.2.1.2.2.1.2.841 .1.3.6.1.2.1.2.2.1.3.841 .1.3.6.1.2.1.2.2.1.4.841 .1.3.6.1.2.1.2.2.1.5.841 .1.3.6.1.2.1.2.2.1.6.841 .1.3.6.1.2.1.2.2.1.7.841 .1.3.6.1.2.1.2.2.1.8.841 .1.3.6.1.2.1.2.2.1.9.841 .1.3.6.1.2.1.2.2.1.10.841 .1.3.6.1.2.1.2.2.1.11.841 .1.3.6.1.2.1.2.2.1.12.841 .1.3.6.1.2.1.2.2.1.13.841 .1.3.6.1.2.1.2.2.1.14.841 .1.3.6.1.2.1.2.2.1.15.841 .1.3.6.1.2.1.2.2.1.16.841 .1.3.6.1.2.1.2.2.1.17.841 .1.3.6.1.2.1.2.2.1.18.841 .1.3.6.1.2.1.2.2.1.19.841 .1.3.6.1.2.1.2.2.1.20.841 .1.3.6.1.2.1.2.2.1.21.841 .1.3.6.1.2.1.2.2.1.22.841 .1.3.6.1.2.1.2.2.1.1.49162 .1.3.6.1.2.1.2.2.1.2.49162 .1.3.6.1.2.1.2.2.1.3.49162 .1.3.6.1.2.1.2.2.1.4.49162 .1.3.6.1.2.1.2.2.1.5.49162 .1.3.6.1.2.1.2.2.1.6.49162 .1.3.6.1.2.1.2.2.1.7.49162 .1.3.6.1.2.1.2.2.1.8.49162 .1.3.6.1.2.1.2.2.1.9.49162 .1.3.6.1.2.1.2.2.1.10.49162 .1.3.6.1.2.1.2.2.1.11.49162] CMD EXITCODE[0] CMD RUNTIME[0.0579s] STDOUT[ .1.3.6.1.2.1.1.1.0 = JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+ .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.11863.5.158 .1.3.6.1.2.1.1.3.0 = 369:3:50:33.08 .1.3.6.1.2.1.1.4.0 = noc@com-in.net .1.3.6.1.2.1.1.5.0 = TP2210-POP25 .1.3.6.1.2.1.1.6.0 = Schroeplerstrasse IN .1.3.6.1.2.1.1.7.0 = 3 .1.3.6.1.2.1.11.1.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.3.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.4.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.5.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.6.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.30.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.31.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.11.32.0 = No Such Object available on this agent at this OID .1.3.6.1.2.1.2.2.1.1.841 = 841 .1.3.6.1.2.1.2.2.1.2.841 = "Vlan-interface841" .1.3.6.1.2.1.2.2.1.3.841 = 6 .1.3.6.1.2.1.2.2.1.4.841 = 1500 .1.3.6.1.2.1.2.2.1.5.841 = 1000000000 .1.3.6.1.2.1.2.2.1.6.841 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.841 = 1 .1.3.6.1.2.1.2.2.1.8.841 = 1 .1.3.6.1.2.1.2.2.1.9.841 = 0:0:01:02.04 .1.3.6.1.2.1.2.2.1.10.841 = 2785281868 .1.3.6.1.2.1.2.2.1.11.841 = 0 .1.3.6.1.2.1.2.2.1.12.841 = 0 .1.3.6.1.2.1.2.2.1.13.841 = 0 .1.3.6.1.2.1.2.2.1.14.841 = 0 .1.3.6.1.2.1.2.2.1.15.841 = 0 .1.3.6.1.2.1.2.2.1.16.841 = 1770908662 .1.3.6.1.2.1.2.2.1.17.841 = 0 .1.3.6.1.2.1.2.2.1.18.841 = 0 .1.3.6.1.2.1.2.2.1.19.841 = 0 .1.3.6.1.2.1.2.2.1.20.841 = 0 .1.3.6.1.2.1.2.2.1.21.841 = 0 .1.3.6.1.2.1.2.2.1.22.841 = .0.0 .1.3.6.1.2.1.2.2.1.1.49162 = 49162 .1.3.6.1.2.1.2.2.1.2.49162 = "gigabitEthernet 1/0/10" .1.3.6.1.2.1.2.2.1.3.49162 = 6 .1.3.6.1.2.1.2.2.1.4.49162 = 1518 .1.3.6.1.2.1.2.2.1.5.49162 = 0 .1.3.6.1.2.1.2.2.1.6.49162 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49162 = 1 .1.3.6.1.2.1.2.2.1.8.49162 = 2 .1.3.6.1.2.1.2.2.1.9.49162 = 0:0:00:00.00 .1.3.6.1.2.1.2.2.1.10.49162 = 0 .1.3.6.1.2.1.2.2.1.11.49162 = 0 ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.2.2.1.19.841 .1.3.6.1.2.1.2.2.1.20.841 .1.3.6.1.2.1.2.2.1.21.841 .1.3.6.1.2.1.2.2.1.22.841 .1.3.6.1.2.1.2.2.1.1.49162 .1.3.6.1.2.1.2.2.1.2.49162 .1.3.6.1.2.1.2.2.1.3.49162 .1.3.6.1.2.1.2.2.1.4.49162 .1.3.6.1.2.1.2.2.1.5.49162 .1.3.6.1.2.1.2.2.1.6.49162 .1.3.6.1.2.1.2.2.1.7.49162 .1.3.6.1.2.1.2.2.1.8.49162 .1.3.6.1.2.1.2.2.1.9.49162 .1.3.6.1.2.1.2.2.1.10.49162 .1.3.6.1.2.1.2.2.1.11.49162 .1.3.6.1.2.1.2.2.1.12.49162 .1.3.6.1.2.1.2.2.1.13.49162 .1.3.6.1.2.1.2.2.1.14.49162 .1.3.6.1.2.1.2.2.1.15.49162 .1.3.6.1.2.1.2.2.1.16.49162 .1.3.6.1.2.1.2.2.1.17.49162 .1.3.6.1.2.1.2.2.1.18.49162 .1.3.6.1.2.1.2.2.1.19.49162 .1.3.6.1.2.1.2.2.1.20.49162 .1.3.6.1.2.1.2.2.1.21.49162 .1.3.6.1.2.1.2.2.1.22.49162 .1.3.6.1.2.1.2.2.1.1.49161 .1.3.6.1.2.1.2.2.1.2.49161 .1.3.6.1.2.1.2.2.1.3.49161 .1.3.6.1.2.1.2.2.1.4.49161 .1.3.6.1.2.1.2.2.1.5.49161 .1.3.6.1.2.1.2.2.1.6.49161 .1.3.6.1.2.1.2.2.1.7.49161 .1.3.6.1.2.1.2.2.1.8.49161 .1.3.6.1.2.1.2.2.1.9.49161 .1.3.6.1.2.1.2.2.1.10.49161 .1.3.6.1.2.1.2.2.1.11.49161 .1.3.6.1.2.1.2.2.1.12.49161 .1.3.6.1.2.1.2.2.1.13.49161 .1.3.6.1.2.1.2.2.1.14.49161 .1.3.6.1.2.1.2.2.1.15.49161 .1.3.6.1.2.1.2.2.1.16.49161 .1.3.6.1.2.1.2.2.1.17.49161 .1.3.6.1.2.1.2.2.1.18.49161 .1.3.6.1.2.1.2.2.1.19.49161 .1.3.6.1.2.1.2.2.1.20.49161 .1.3.6.1.2.1.2.2.1.21.49161 .1.3.6.1.2.1.2.2.1.22.49161] CMD EXITCODE[0] CMD RUNTIME[0.0529s] STDOUT[ .1.3.6.1.2.1.2.2.1.19.841 = 0 .1.3.6.1.2.1.2.2.1.20.841 = 0 .1.3.6.1.2.1.2.2.1.21.841 = 0 .1.3.6.1.2.1.2.2.1.22.841 = .0.0 .1.3.6.1.2.1.2.2.1.1.49162 = 49162 .1.3.6.1.2.1.2.2.1.2.49162 = "gigabitEthernet 1/0/10" .1.3.6.1.2.1.2.2.1.3.49162 = 6 .1.3.6.1.2.1.2.2.1.4.49162 = 1518 .1.3.6.1.2.1.2.2.1.5.49162 = 0 .1.3.6.1.2.1.2.2.1.6.49162 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49162 = 1 .1.3.6.1.2.1.2.2.1.8.49162 = 2 .1.3.6.1.2.1.2.2.1.9.49162 = 0:0:00:00.00 .1.3.6.1.2.1.2.2.1.10.49162 = 0 .1.3.6.1.2.1.2.2.1.11.49162 = 0 .1.3.6.1.2.1.2.2.1.12.49162 = 0 .1.3.6.1.2.1.2.2.1.13.49162 = 0 .1.3.6.1.2.1.2.2.1.14.49162 = 0 .1.3.6.1.2.1.2.2.1.15.49162 = 0 .1.3.6.1.2.1.2.2.1.16.49162 = 0 .1.3.6.1.2.1.2.2.1.17.49162 = 0 .1.3.6.1.2.1.2.2.1.18.49162 = 0 .1.3.6.1.2.1.2.2.1.19.49162 = 0 .1.3.6.1.2.1.2.2.1.20.49162 = 0 .1.3.6.1.2.1.2.2.1.21.49162 = 0 .1.3.6.1.2.1.2.2.1.22.49162 = .0.0 .1.3.6.1.2.1.2.2.1.1.49161 = 49161 .1.3.6.1.2.1.2.2.1.2.49161 = "gigabitEthernet 1/0/9" .1.3.6.1.2.1.2.2.1.3.49161 = 6 .1.3.6.1.2.1.2.2.1.4.49161 = 1518 .1.3.6.1.2.1.2.2.1.5.49161 = 1000000000 .1.3.6.1.2.1.2.2.1.6.49161 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49161 = 1 .1.3.6.1.2.1.2.2.1.8.49161 = 1 .1.3.6.1.2.1.2.2.1.9.49161 = 4:23:25:18.15 .1.3.6.1.2.1.2.2.1.10.49161 = 1312147228 .1.3.6.1.2.1.2.2.1.11.49161 = 4274084686 .1.3.6.1.2.1.2.2.1.12.49161 = 363132936 .1.3.6.1.2.1.2.2.1.13.49161 = 0 .1.3.6.1.2.1.2.2.1.14.49161 = 0 .1.3.6.1.2.1.2.2.1.15.49161 = 0 .1.3.6.1.2.1.2.2.1.16.49161 = 4036660652 .1.3.6.1.2.1.2.2.1.17.49161 = 566096799 .1.3.6.1.2.1.2.2.1.18.49161 = 761319 .1.3.6.1.2.1.2.2.1.19.49161 = 0 .1.3.6.1.2.1.2.2.1.20.49161 = 0 .1.3.6.1.2.1.2.2.1.21.49161 = 0 .1.3.6.1.2.1.2.2.1.22.49161 = .0.0 ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.2.2.1.8.49161 .1.3.6.1.2.1.2.2.1.9.49161 .1.3.6.1.2.1.2.2.1.10.49161 .1.3.6.1.2.1.2.2.1.11.49161 .1.3.6.1.2.1.2.2.1.12.49161 .1.3.6.1.2.1.2.2.1.13.49161 .1.3.6.1.2.1.2.2.1.14.49161 .1.3.6.1.2.1.2.2.1.15.49161 .1.3.6.1.2.1.2.2.1.16.49161 .1.3.6.1.2.1.2.2.1.17.49161 .1.3.6.1.2.1.2.2.1.18.49161 .1.3.6.1.2.1.2.2.1.19.49161 .1.3.6.1.2.1.2.2.1.20.49161 .1.3.6.1.2.1.2.2.1.21.49161 .1.3.6.1.2.1.2.2.1.22.49161 .1.3.6.1.2.1.2.2.1.1.49160 .1.3.6.1.2.1.2.2.1.2.49160 .1.3.6.1.2.1.2.2.1.3.49160 .1.3.6.1.2.1.2.2.1.4.49160 .1.3.6.1.2.1.2.2.1.5.49160 .1.3.6.1.2.1.2.2.1.6.49160 .1.3.6.1.2.1.2.2.1.7.49160 .1.3.6.1.2.1.2.2.1.8.49160 .1.3.6.1.2.1.2.2.1.9.49160 .1.3.6.1.2.1.2.2.1.10.49160 .1.3.6.1.2.1.2.2.1.11.49160 .1.3.6.1.2.1.2.2.1.12.49160 .1.3.6.1.2.1.2.2.1.13.49160 .1.3.6.1.2.1.2.2.1.14.49160 .1.3.6.1.2.1.2.2.1.15.49160 .1.3.6.1.2.1.2.2.1.16.49160 .1.3.6.1.2.1.2.2.1.17.49160 .1.3.6.1.2.1.2.2.1.18.49160 .1.3.6.1.2.1.2.2.1.19.49160 .1.3.6.1.2.1.2.2.1.20.49160 .1.3.6.1.2.1.2.2.1.21.49160 .1.3.6.1.2.1.2.2.1.22.49160 .1.3.6.1.2.1.2.2.1.1.49159 .1.3.6.1.2.1.2.2.1.2.49159 .1.3.6.1.2.1.2.2.1.3.49159 .1.3.6.1.2.1.2.2.1.4.49159 .1.3.6.1.2.1.2.2.1.5.49159 .1.3.6.1.2.1.2.2.1.6.49159 .1.3.6.1.2.1.2.2.1.7.49159 .1.3.6.1.2.1.2.2.1.8.49159 .1.3.6.1.2.1.2.2.1.9.49159 .1.3.6.1.2.1.2.2.1.10.49159 .1.3.6.1.2.1.2.2.1.11.49159] CMD EXITCODE[0] CMD RUNTIME[0.0252s] STDOUT[ .1.3.6.1.2.1.2.2.1.8.49161 = 1 .1.3.6.1.2.1.2.2.1.9.49161 = 4:23:25:18.15 .1.3.6.1.2.1.2.2.1.10.49161 = 1312148178 .1.3.6.1.2.1.2.2.1.11.49161 = 4274084687 .1.3.6.1.2.1.2.2.1.12.49161 = 363132936 .1.3.6.1.2.1.2.2.1.13.49161 = 0 .1.3.6.1.2.1.2.2.1.14.49161 = 0 .1.3.6.1.2.1.2.2.1.15.49161 = 0 .1.3.6.1.2.1.2.2.1.16.49161 = 4036661728 .1.3.6.1.2.1.2.2.1.17.49161 = 566096800 .1.3.6.1.2.1.2.2.1.18.49161 = 761319 .1.3.6.1.2.1.2.2.1.19.49161 = 0 .1.3.6.1.2.1.2.2.1.20.49161 = 0 .1.3.6.1.2.1.2.2.1.21.49161 = 0 .1.3.6.1.2.1.2.2.1.22.49161 = .0.0 .1.3.6.1.2.1.2.2.1.1.49160 = 49160 .1.3.6.1.2.1.2.2.1.2.49160 = "gigabitEthernet 1/0/8" .1.3.6.1.2.1.2.2.1.3.49160 = 6 .1.3.6.1.2.1.2.2.1.4.49160 = 1518 .1.3.6.1.2.1.2.2.1.5.49160 = 100000000 .1.3.6.1.2.1.2.2.1.6.49160 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49160 = 1 .1.3.6.1.2.1.2.2.1.8.49160 = 1 .1.3.6.1.2.1.2.2.1.9.49160 = 262:4:03:44.72 .1.3.6.1.2.1.2.2.1.10.49160 = 121617639 .1.3.6.1.2.1.2.2.1.11.49160 = 537222457 .1.3.6.1.2.1.2.2.1.12.49160 = 2545 .1.3.6.1.2.1.2.2.1.13.49160 = 0 .1.3.6.1.2.1.2.2.1.14.49160 = 0 .1.3.6.1.2.1.2.2.1.15.49160 = 0 .1.3.6.1.2.1.2.2.1.16.49160 = 4014913995 .1.3.6.1.2.1.2.2.1.17.49160 = 4212840703 .1.3.6.1.2.1.2.2.1.18.49160 = 43901420 .1.3.6.1.2.1.2.2.1.19.49160 = 0 .1.3.6.1.2.1.2.2.1.20.49160 = 0 .1.3.6.1.2.1.2.2.1.21.49160 = 0 .1.3.6.1.2.1.2.2.1.22.49160 = .0.0 .1.3.6.1.2.1.2.2.1.1.49159 = 49159 .1.3.6.1.2.1.2.2.1.2.49159 = "gigabitEthernet 1/0/7" .1.3.6.1.2.1.2.2.1.3.49159 = 6 .1.3.6.1.2.1.2.2.1.4.49159 = 1518 .1.3.6.1.2.1.2.2.1.5.49159 = 0 .1.3.6.1.2.1.2.2.1.6.49159 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49159 = 2 .1.3.6.1.2.1.2.2.1.8.49159 = 2 .1.3.6.1.2.1.2.2.1.9.49159 = 0:0:00:00.00 .1.3.6.1.2.1.2.2.1.10.49159 = 0 .1.3.6.1.2.1.2.2.1.11.49159 = 0 ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.2.2.1.19.49160 .1.3.6.1.2.1.2.2.1.20.49160 .1.3.6.1.2.1.2.2.1.21.49160 .1.3.6.1.2.1.2.2.1.22.49160 .1.3.6.1.2.1.2.2.1.1.49159 .1.3.6.1.2.1.2.2.1.2.49159 .1.3.6.1.2.1.2.2.1.3.49159 .1.3.6.1.2.1.2.2.1.4.49159 .1.3.6.1.2.1.2.2.1.5.49159 .1.3.6.1.2.1.2.2.1.6.49159 .1.3.6.1.2.1.2.2.1.7.49159 .1.3.6.1.2.1.2.2.1.8.49159 .1.3.6.1.2.1.2.2.1.9.49159 .1.3.6.1.2.1.2.2.1.10.49159 .1.3.6.1.2.1.2.2.1.11.49159 .1.3.6.1.2.1.2.2.1.12.49159 .1.3.6.1.2.1.2.2.1.13.49159 .1.3.6.1.2.1.2.2.1.14.49159 .1.3.6.1.2.1.2.2.1.15.49159 .1.3.6.1.2.1.2.2.1.16.49159 .1.3.6.1.2.1.2.2.1.17.49159 .1.3.6.1.2.1.2.2.1.18.49159 .1.3.6.1.2.1.2.2.1.19.49159 .1.3.6.1.2.1.2.2.1.20.49159 .1.3.6.1.2.1.2.2.1.21.49159 .1.3.6.1.2.1.2.2.1.22.49159 .1.3.6.1.2.1.2.2.1.1.49158 .1.3.6.1.2.1.2.2.1.2.49158 .1.3.6.1.2.1.2.2.1.3.49158 .1.3.6.1.2.1.2.2.1.4.49158 .1.3.6.1.2.1.2.2.1.5.49158 .1.3.6.1.2.1.2.2.1.6.49158 .1.3.6.1.2.1.2.2.1.7.49158 .1.3.6.1.2.1.2.2.1.8.49158 .1.3.6.1.2.1.2.2.1.9.49158 .1.3.6.1.2.1.2.2.1.10.49158 .1.3.6.1.2.1.2.2.1.11.49158 .1.3.6.1.2.1.2.2.1.12.49158 .1.3.6.1.2.1.2.2.1.13.49158 .1.3.6.1.2.1.2.2.1.14.49158 .1.3.6.1.2.1.2.2.1.15.49158 .1.3.6.1.2.1.2.2.1.16.49158 .1.3.6.1.2.1.2.2.1.17.49158 .1.3.6.1.2.1.2.2.1.18.49158 .1.3.6.1.2.1.2.2.1.19.49158 .1.3.6.1.2.1.2.2.1.20.49158 .1.3.6.1.2.1.2.2.1.21.49158 .1.3.6.1.2.1.2.2.1.22.49158] CMD EXITCODE[0] CMD RUNTIME[0.0332s] STDOUT[ .1.3.6.1.2.1.2.2.1.19.49160 = 0 .1.3.6.1.2.1.2.2.1.20.49160 = 0 .1.3.6.1.2.1.2.2.1.21.49160 = 0 .1.3.6.1.2.1.2.2.1.22.49160 = .0.0 .1.3.6.1.2.1.2.2.1.1.49159 = 49159 .1.3.6.1.2.1.2.2.1.2.49159 = "gigabitEthernet 1/0/7" .1.3.6.1.2.1.2.2.1.3.49159 = 6 .1.3.6.1.2.1.2.2.1.4.49159 = 1518 .1.3.6.1.2.1.2.2.1.5.49159 = 0 .1.3.6.1.2.1.2.2.1.6.49159 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49159 = 2 .1.3.6.1.2.1.2.2.1.8.49159 = 2 .1.3.6.1.2.1.2.2.1.9.49159 = 0:0:00:00.00 .1.3.6.1.2.1.2.2.1.10.49159 = 0 .1.3.6.1.2.1.2.2.1.11.49159 = 0 .1.3.6.1.2.1.2.2.1.12.49159 = 0 .1.3.6.1.2.1.2.2.1.13.49159 = 0 .1.3.6.1.2.1.2.2.1.14.49159 = 0 .1.3.6.1.2.1.2.2.1.15.49159 = 0 .1.3.6.1.2.1.2.2.1.16.49159 = 0 .1.3.6.1.2.1.2.2.1.17.49159 = 0 .1.3.6.1.2.1.2.2.1.18.49159 = 0 .1.3.6.1.2.1.2.2.1.19.49159 = 0 .1.3.6.1.2.1.2.2.1.20.49159 = 0 .1.3.6.1.2.1.2.2.1.21.49159 = 0 .1.3.6.1.2.1.2.2.1.22.49159 = .0.0 .1.3.6.1.2.1.2.2.1.1.49158 = 49158 .1.3.6.1.2.1.2.2.1.2.49158 = "gigabitEthernet 1/0/6" .1.3.6.1.2.1.2.2.1.3.49158 = 6 .1.3.6.1.2.1.2.2.1.4.49158 = 1518 .1.3.6.1.2.1.2.2.1.5.49158 = 0 .1.3.6.1.2.1.2.2.1.6.49158 = "28 87 BA F3 C3 9E " .1.3.6.1.2.1.2.2.1.7.49158 = 2 .1.3.6.1.2.1.2.2.1.8.49158 = 2 .1.3.6.1.2.1.2.2.1.9.49158 = 0:0:00:00.00 .1.3.6.1.2.1.2.2.1.10.49158 = 0 .1.3.6.1.2.1.2.2.1.11.49158 = 0 .1.3.6.1.2.1.2.2.1.12.49158 = 0 .1.3.6.1.2.1.2.2.1.13.49158 = 0 .1.3.6.1.2.1.2.2.1.14.49158 = 0 .1.3.6.1.2.1.2.2.1.15.49158 = 0 .1.3.6.1.2.1.2.2.1.16.49158 = 0 .1.3.6.1.2.1.2.2.1.17.49158 = 0 .1.3.6.1.2.1.2.2.1.18.49158 = 0 .1.3.6.1.2.1.2.2.1.19.49158 = 0 .1.3.6.1.2.1.2.2.1.20.49158 = 0 .1.3.6.1.2.1.2.2.1.21.49158 = 0 .1.3.6.1.2.1.2.2.1.22.49158 = .0.0 ] JSON DECODE[Not string passed] JSON RAW[ ] o Max-get 48 (learned) JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `scope`, `max_get` FROM `device_snmp_get_limits` WHERE `device_id` = '636' AND `max_get` < '48' AND `updated` < NOW() - INTERVAL 7 DAY] SQL RUNTIME[0.00042486s] SQL[SELECT *, TIMESTAMPDIFF(SECOND, `updated`, NOW()) AS `age` FROM `device_snmp_get_limits` WHERE `device_id` = '636'] SQL RUNTIME[8.917E-5s] JSON DECODE[Not string passed] JSON RAW[ ] o Duration 0.8224s ##### Module Start: os ##### including: includes/discovery/os.inc.php CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0138s] STDOUT[ JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+ ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysObjectID.0] CMD EXITCODE[0] CMD RUNTIME[0.0167s] STDOUT[ .1.3.6.1.4.1.11863.5.158 ] SNMP STATUS[TRUE] +-------------+---------------------------------------------------------+ | OID | | +-------------+---------------------------------------------------------+ | sysDescr | JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+ | | sysObjectID | .1.3.6.1.4.1.11863.5.158 | +-------------+---------------------------------------------------------+ o Detect OS matched (tplink-jetstream: TP-Link JetStream): +-------------+----------------------+--------------------------+ | OID | Matched definition | | +-------------+----------------------+--------------------------+ | sysObjectID | .1.3.6.1.4.1.11863.5 | .1.3.6.1.4.1.11863.5.158 | +-------------+----------------------+--------------------------+ o Duration 0.0451s ##### Module Start: mibs ##### including: includes/discovery/mibs.inc.php CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID'] CMD EXITCODE[0] CMD RUNTIME[0.0039s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 ] SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2' CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.1.9.1.2] CMD EXITCODE[0] CMD RUNTIME[0.5098s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' sysORDescr] CMD EXITCODE[0] CMD RUNTIME[0.5361s] STDOUT[ sysORDescr = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT EXISTS (SELECT 1 FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0)] SQL RUNTIME[0.00041509s] SQL[SELECT DISTINCT `ifType` FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0] SQL RUNTIME[0.00052905s] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'ospfAdminStat.0'] CMD EXITCODE[0] CMD RUNTIME[0.0113s] STDOUT[ OSPF-MIB::ospfAdminStat.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'ospfv3AdminStatus.0'] CMD EXITCODE[0] CMD RUNTIME[0.0102s] CMD EXITDELAY[5ms] STDOUT[ OSPFV3-MIB::ospfv3AdminStatus.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'mplsL3VpnConfiguredVrfs.0'] CMD EXITCODE[0] CMD RUNTIME[0.0096s] STDOUT[ MPLS-L3VPN-STD-MIB::mplsL3VpnConfiguredVrfs.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m MPLS-VPN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'mplsVpnConfiguredVrfs.0'] CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ MPLS-VPN-MIB::mplsVpnConfiguredVrfs.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m NTPv4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'ntpEntSoftwareName.0'] CMD EXITCODE[0] CMD RUNTIME[0.0079s] STDOUT[ NTPv4-MIB::ntpEntSoftwareName.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m LLDP-V2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'lldpV2LocChassisId.0'] CMD EXITCODE[0] CMD RUNTIME[0.0115s] STDOUT[ LLDP-V2-MIB::lldpV2LocChassisId.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m LLDP-V2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'lldpV2StatsRemTablesLastChangeTime.0'] CMD EXITCODE[0] CMD RUNTIME[0.011s] STDOUT[ LLDP-V2-MIB::lldpV2StatsRemTablesLastChangeTime.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m LLDP-EXT-MED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'lldpXMedLocModelName.0'] CMD EXITCODE[0] CMD RUNTIME[0.0147s] STDOUT[ LLDP-EXT-MED-MIB::lldpXMedLocModelName.0 = ] CMD[/usr/bin/snmpgetnext -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -m IEEE8023-LAG-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' dot3adAggPortAttachedAggID] CMD EXITCODE[0] CMD RUNTIME[0.018s] STDOUT[ sysDescr.0 = JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+ ] SNMPGETNEXT returned different Oid (sysDescr) instead requested (IEEE8023-LAG-MIB::dot3adAggPortAttachedAggID). SNMP STATUS[FALSE] CMD[/usr/bin/snmpgetnext -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -m ISIS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' isisCircIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.019s] STDOUT[ enterprises.11863.6.1.1.1.0 = "JetStream 10-Port Gigabit Smart Switch with 8-Port PoE+" ] SNMPGETNEXT returned different Oid (enterprises) instead requested (ISIS-MIB::isisCircIfIndex). SNMP STATUS[FALSE] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m BFD-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'bfdAdminStatus.0'] CMD EXITCODE[0] CMD RUNTIME[0.0099s] STDOUT[ BFD-STD-MIB::bfdAdminStatus.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmpgetnext -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -m DOCS-IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' docsIfSigQSignalNoise] CMD EXITCODE[0] CMD RUNTIME[0.014s] STDOUT[ mib-2.17.1.1.0 = "28 87 BA F3 C3 9E " ] SNMPGETNEXT returned different Oid (mib-2) instead requested (DOCS-IF-MIB::docsIfSigQSignalNoise). SNMP STATUS[FALSE] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' '.1.3.6.1.4.1.54849.1.1.5.0'] CMD EXITCODE[0] CMD RUNTIME[0.007s] STDOUT[ iso.3.6.1.4.1.54849.1.1.5.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmptranslate -OS -Pud -Ir -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp '.1.3.6.1.4.1.54849.1.1.5.0'] CMD EXITCODE[0] CMD RUNTIME[0.0041s] STDOUT[ iso.3.6.1.4.1.54849.1.1.5.0 ] SNMP TRANSLATE (CMD): '.1.3.6.1.4.1.54849.1.1.5.0' -> 'iso.3.6.1.4.1.54849.1.1.5.0' CMD[/usr/bin/snmptranslate -OS -IR -Pud -Ir -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'iso.3.6.1.4.1.54849.1.1.5.0'] CMD EXITCODE[0] CMD RUNTIME[0.004s] STDOUT[ iso.3.6.1.4.1.54849.1.1.5.0 ] SNMP TRANSLATE (CMD): 'iso.3.6.1.4.1.54849.1.1.5.0' -> 'iso.3.6.1.4.1.54849.1.1.5.0' SNMP ERROR[#2 - Request not completed] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' '.1.3.6.1.4.1.54849.1.2.1.0'] CMD EXITCODE[0] CMD RUNTIME[0.007s] STDOUT[ iso.3.6.1.4.1.54849.1.2.1.0 = No Such Object available on this agent at this OID ] CMD[/usr/bin/snmptranslate -OS -Pud -Ir -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp '.1.3.6.1.4.1.54849.1.2.1.0'] CMD EXITCODE[0] CMD RUNTIME[0.004s] STDOUT[ iso.3.6.1.4.1.54849.1.2.1.0 ] SNMP TRANSLATE (CMD): '.1.3.6.1.4.1.54849.1.2.1.0' -> 'iso.3.6.1.4.1.54849.1.2.1.0' CMD[/usr/bin/snmptranslate -OS -IR -Pud -Ir -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'iso.3.6.1.4.1.54849.1.2.1.0'] CMD EXITCODE[0] CMD RUNTIME[0.0041s] STDOUT[ iso.3.6.1.4.1.54849.1.2.1.0 ] SNMP TRANSLATE (CMD): 'iso.3.6.1.4.1.54849.1.2.1.0' -> 'iso.3.6.1.4.1.54849.1.2.1.0' SNMP ERROR[#2 - Request not completed] Skip sysObjectID definition match, because it is empty. o MIBs discovered SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00036788s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00023699s] JSON DECODE[Not string passed] JSON RAW[ ] Array ( [0] => TPLINK-SYSINFO-MIB [1] => TPLINK-SYSMONITOR-MIB [2] => TPLINK-DOT1Q-VLAN-MIB [3] => TPLINK-L2BRIDGE-MIB [4] => TPLINK-IPV6ADDR-MIB [5] => TPLINK-LLDPINFO-MIB [6] => TPLINK-DDMSTATUS-MIB [7] => SNMPv2-MIB [8] => IF-MIB [9] => EtherLike-MIB [10] => IP-MIB [11] => LLDP-MIB [12] => PW-STD-MIB [13] => DISMAN-PING-MIB [14] => BGP4-MIB ) o Duration 1.2513s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_vrf'] SQL RUNTIME[8.702E-5s] ##### Module Start: vrf ##### including: includes/discovery/vrf.inc.php VRF cleanup skipped because collection was incomplete. VRF port cleanup skipped because membership collection was incomplete. o Duration 0.0006s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_ports'] SQL RUNTIME[8.297E-5s] ##### Module Start: ports ##### including: includes/discovery/ports.inc.php o Caching OIDs SQL[SELECT `ifIndex` FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0 AND (`port_source` IS NULL OR `port_source` = 'IF-MIB')] SQL RUNTIME[0.00014687s] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ifOperStatus] CMD EXITCODE[0] CMD RUNTIME[0.5102s] STDOUT[ ifOperStatus.841 = up ifOperStatus.49153 = down ifOperStatus.49154 = up ifOperStatus.49155 = up ifOperStatus.49156 = up ifOperStatus.49157 = down ifOperStatus.49158 = down ifOperStatus.49159 = down ifOperStatus.49160 = up ifOperStatus.49161 = up ifOperStatus.49162 = down ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'ifDescr.841' 'ifType.841' 'ifName.841' 'ifDescr.49153' 'ifType.49153' 'ifName.49153' 'ifDescr.49154' 'ifType.49154' 'ifName.49154' 'ifDescr.49155' 'ifType.49155' 'ifName.49155' 'ifDescr.49156' 'ifType.49156' 'ifName.49156' 'ifDescr.49157' 'ifType.49157' 'ifName.49157' 'ifDescr.49158' 'ifType.49158' 'ifName.49158' 'ifDescr.49159' 'ifType.49159' 'ifName.49159' 'ifDescr.49160' 'ifType.49160' 'ifName.49160' 'ifDescr.49161' 'ifType.49161' 'ifName.49161' 'ifDescr.49162' 'ifType.49162' 'ifName.49162'] CMD EXITCODE[0] CMD RUNTIME[0.2302s] STDOUT[ IF-MIB::ifDescr.841 = Vlan-interface841 IF-MIB::ifType.841 = ethernetCsmacd IF-MIB::ifName.841 = Vlan-interface841 IF-MIB::ifDescr.49153 = gigabitEthernet 1/0/1 IF-MIB::ifType.49153 = ethernetCsmacd IF-MIB::ifName.49153 = gigabitEthernet 1/0/1 IF-MIB::ifDescr.49154 = gigabitEthernet 1/0/2 IF-MIB::ifType.49154 = ethernetCsmacd IF-MIB::ifName.49154 = gigabitEthernet 1/0/2 IF-MIB::ifDescr.49155 = gigabitEthernet 1/0/3 IF-MIB::ifType.49155 = ethernetCsmacd IF-MIB::ifName.49155 = gigabitEthernet 1/0/3 IF-MIB::ifDescr.49156 = gigabitEthernet 1/0/4 IF-MIB::ifType.49156 = ethernetCsmacd IF-MIB::ifName.49156 = gigabitEthernet 1/0/4 IF-MIB::ifDescr.49157 = gigabitEthernet 1/0/5 IF-MIB::ifType.49157 = ethernetCsmacd IF-MIB::ifName.49157 = gigabitEthernet 1/0/5 IF-MIB::ifDescr.49158 = gigabitEthernet 1/0/6 IF-MIB::ifType.49158 = ethernetCsmacd IF-MIB::ifName.49158 = gigabitEthernet 1/0/6 IF-MIB::ifDescr.49159 = gigabitEthernet 1/0/7 IF-MIB::ifType.49159 = ethernetCsmacd IF-MIB::ifName.49159 = gigabitEthernet 1/0/7 IF-MIB::ifDescr.49160 = gigabitEthernet 1/0/8 IF-MIB::ifType.49160 = ethernetCsmacd IF-MIB::ifName.49160 = gigabitEthernet 1/0/8 IF-MIB::ifDescr.49161 = gigabitEthernet 1/0/9 IF-MIB::ifType.49161 = ethernetCsmacd IF-MIB::ifName.49161 = gigabitEthernet 1/0/9 IF-MIB::ifDescr.49162 = gigabitEthernet 1/0/10 IF-MIB::ifType.49162 = ethernetCsmacd IF-MIB::ifName.49162 = gigabitEthernet 1/0/10 ] Get Array ( [841] => Array ( [ifOperStatus] => up [ifDescr] => Vlan-interface841 [ifType] => ethernetCsmacd [ifName] => Vlan-interface841 ) [49153] => Array ( [ifOperStatus] => down [ifDescr] => gigabitEthernet 1/0/1 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/1 ) [49154] => Array ( [ifOperStatus] => up [ifDescr] => gigabitEthernet 1/0/2 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/2 ) [49155] => Array ( [ifOperStatus] => up [ifDescr] => gigabitEthernet 1/0/3 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/3 ) [49156] => Array ( [ifOperStatus] => up [ifDescr] => gigabitEthernet 1/0/4 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/4 ) [49157] => Array ( [ifOperStatus] => down [ifDescr] => gigabitEthernet 1/0/5 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/5 ) [49158] => Array ( [ifOperStatus] => down [ifDescr] => gigabitEthernet 1/0/6 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/6 ) [49159] => Array ( [ifOperStatus] => down [ifDescr] => gigabitEthernet 1/0/7 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/7 ) [49160] => Array ( [ifOperStatus] => up [ifDescr] => gigabitEthernet 1/0/8 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/8 ) [49161] => Array ( [ifOperStatus] => up [ifDescr] => gigabitEthernet 1/0/9 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/9 ) [49162] => Array ( [ifOperStatus] => down [ifDescr] => gigabitEthernet 1/0/10 [ifType] => ethernetCsmacd [ifName] => gigabitEthernet 1/0/10 ) ) o Caching DB SQL[SELECT * FROM `ports` WHERE `device_id` = '636'] SQL RUNTIME[0.00055385s] 11 ports ifIndex 841 (ifAdminStatus = , ifOperStatus = up). ifIndex 49153 (ifAdminStatus = , ifOperStatus = down). ifIndex 49154 (ifAdminStatus = , ifOperStatus = up). ifIndex 49155 (ifAdminStatus = , ifOperStatus = up). ifIndex 49156 (ifAdminStatus = , ifOperStatus = up). ifIndex 49157 (ifAdminStatus = , ifOperStatus = down). ifIndex 49158 (ifAdminStatus = , ifOperStatus = down). ifIndex 49159 (ifAdminStatus = , ifOperStatus = down). ifIndex 49160 (ifAdminStatus = , ifOperStatus = up). ifIndex 49161 (ifAdminStatus = , ifOperStatus = up). ifIndex 49162 (ifAdminStatus = , ifOperStatus = down). CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUs -OS -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' 'ifAlias.841' 'ifAlias.49153' 'ifAlias.49154' 'ifAlias.49155' 'ifAlias.49156' 'ifAlias.49157' 'ifAlias.49158' 'ifAlias.49159' 'ifAlias.49160' 'ifAlias.49161' 'ifAlias.49162'] CMD EXITCODE[0] CMD RUNTIME[0.1548s] STDOUT[ IF-MIB::ifAlias.841 = MGMT IF-MIB::ifAlias.49153 = IF-MIB::ifAlias.49154 = IF-MIB::ifAlias.49155 = IF-MIB::ifAlias.49156 = IF-MIB::ifAlias.49157 = IF-MIB::ifAlias.49158 = IF-MIB::ifAlias.49159 = IF-MIB::ifAlias.49160 = SCHLIESS856 IF-MIB::ifAlias.49161 = POP25DL2et-0/0/4 IF-MIB::ifAlias.49162 = ] o Discovering ports ifIndex 841 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49153 (ifAdminStatus = , ifOperStatus = down). . ifIndex 49154 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49155 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49156 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49157 (ifAdminStatus = , ifOperStatus = down). . ifIndex 49158 (ifAdminStatus = , ifOperStatus = down). . ifIndex 49159 (ifAdminStatus = , ifOperStatus = down). . ifIndex 49160 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49161 (ifAdminStatus = , ifOperStatus = up). . ifIndex 49162 (ifAdminStatus = , ifOperStatus = down). . SQL[SELECT GET_LOCK('ports-filtered-636', 0)] SQL RUNTIME[0.00012898s] SQL[SELECT attrib_id, attrib_value FROM entity_attribs WHERE entity_type = 'device' AND entity_id = '636' AND attrib_type = 'snmp_filtered_indexes_ports'] SQL RUNTIME[0.00035214s] SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_filtered_indexes_ports'] SQL RUNTIME[0.00204802s] SQL[SELECT EXISTS (SELECT 1 FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_filtered_indexes_ports')] SQL RUNTIME[9.894E-5s] SQL[INSERT INTO `entity_attribs` (`device_id`,`entity_type`,`entity_id`,`attrib_type`,`attrib_value`) VALUES ('636','device','636','snmp_filtered_indexes_ports','[]')] SQL RUNTIME[0.00157523s] SQL[SELECT RELEASE_LOCK('ports-filtered-636')] SQL RUNTIME[6.104E-5s] +---------+------------------------+------------------------+------------------+----------------+-------------+---------+ | ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored | +---------+------------------------+------------------------+------------------+----------------+-------------+---------+ | 841 | Vlan-interface841 | Vlan-interface841 | MGMT | ethernetCsmacd | up | no | | 49153 | gigabitEthernet 1/0/1 | gigabitEthernet 1/0/1 | ... | ethernetCsmacd | down | no | | 49154 | gigabitEthernet 1/0/2 | gigabitEthernet 1/0/2 | ... | ethernetCsmacd | up | no | | 49155 | gigabitEthernet 1/0/3 | gigabitEthernet 1/0/3 | ... | ethernetCsmacd | up | no | | 49156 | gigabitEthernet 1/0/4 | gigabitEthernet 1/0/4 | ... | ethernetCsmacd | up | no | | 49157 | gigabitEthernet 1/0/5 | gigabitEthernet 1/0/5 | ... | ethernetCsmacd | down | no | | 49158 | gigabitEthernet 1/0/6 | gigabitEthernet 1/0/6 | ... | ethernetCsmacd | down | no | | 49159 | gigabitEthernet 1/0/7 | gigabitEthernet 1/0/7 | ... | ethernetCsmacd | down | no | | 49160 | gigabitEthernet 1/0/8 | gigabitEthernet 1/0/8 | SCHLIESS856 | ethernetCsmacd | up | no | | 49161 | gigabitEthernet 1/0/9 | gigabitEthernet 1/0/9 | POP25DL2et-0/0/4 | ethernetCsmacd | up | no | | 49162 | gigabitEthernet 1/0/10 | gigabitEthernet 1/0/10 | ... | ethernetCsmacd | down | no | +---------+------------------------+------------------------+------------------+----------------+-------------+---------+ o Duration 0.9195s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_ports-stack'] SQL RUNTIME[8.893E-5s] ##### Module Start: ports-stack ##### including: includes/discovery/ports-stack.inc.php SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '636'] SQL RUNTIME[0.00012207s] SQL[SELECT `ifIndex`, `port_id` FROM ports WHERE `device_id` = '636'] SQL RUNTIME[9.394E-5s] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ifStackStatus] CMD EXITCODE[0] CMD RUNTIME[0.3834s] STDOUT[ ifStackStatus = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'ports_stack_empty_since'] SQL RUNTIME[0.00042391s] o Duration 0.3887s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_vlans'] SQL RUNTIME[0.0001061s] ##### Module Start: vlans ##### including: includes/discovery/vlans.inc.php SQL[SELECT * FROM `vlans` WHERE `device_id` = '636'] SQL RUNTIME[0.00013804s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '636'] SQL RUNTIME[0.000108s] o TPLINK-DOT1Q-VLAN-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m TPLINK-DOT1Q-VLAN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' vlanConfigTable] CMD EXITCODE[0] CMD RUNTIME[0.3399s] STDOUT[ dot1qVlanId.1 = 1 dot1qVlanId.770 = 770 dot1qVlanId.841 = 841 dot1qVlanId.856 = 856 dot1qVlanDescription.1 = "System-VLAN" dot1qVlanDescription.770 = "LORAWAN" dot1qVlanDescription.841 = "MGMT.841" dot1qVlanDescription.856 = "SCHLIESS856" vlanTagPortMemberAdd.1 = "" vlanTagPortMemberAdd.770 = "1/0/9" vlanTagPortMemberAdd.841 = "1/0/9" vlanTagPortMemberAdd.856 = "1/0/9" vlanUntagPortMemberAdd.1 = "1/0/9" vlanUntagPortMemberAdd.770 = "" vlanUntagPortMemberAdd.841 = "1/0/1-7,1/0/10" vlanUntagPortMemberAdd.856 = "1/0/8" vlanPortMemberRemove.1 = "" vlanPortMemberRemove.770 = "" vlanPortMemberRemove.841 = "" vlanPortMemberRemove.856 = "" dot1qVlanStatus.1 = active dot1qVlanStatus.770 = active dot1qVlanStatus.841 = active dot1qVlanStatus.856 = active ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m TPLINK-DOT1Q-VLAN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' vlanPortNumber] CMD EXITCODE[0] CMD RUNTIME[0.2883s] STDOUT[ vlanPortNumber.49153 = "1/0/1" vlanPortNumber.49154 = "1/0/2" vlanPortNumber.49155 = "1/0/3" vlanPortNumber.49156 = "1/0/4" vlanPortNumber.49157 = "1/0/5" vlanPortNumber.49158 = "1/0/6" vlanPortNumber.49159 = "1/0/7" vlanPortNumber.49160 = "1/0/8" vlanPortNumber.49161 = "1/0/9" vlanPortNumber.49162 = "1/0/10" ] SNMP STATUS[TRUE] Unknown port name for untagged Vlans: 1/0/1-7 Array ( [1] => Array ( [1] => Array ( [ifIndex] => 1 [vlan_domain] => 1 [vlan_vlan] => 1 [vlan_name] => System-VLAN [vlan_type] => ethernet [vlan_status] => operational ) [770] => Array ( [ifIndex] => 770 [vlan_domain] => 1 [vlan_vlan] => 770 [vlan_name] => LORAWAN [vlan_type] => ethernet [vlan_status] => operational ) [841] => Array ( [ifIndex] => 841 [vlan_domain] => 1 [vlan_vlan] => 841 [vlan_name] => MGMT.841 [vlan_type] => ethernet [vlan_status] => operational ) [856] => Array ( [ifIndex] => 856 [vlan_domain] => 1 [vlan_vlan] => 856 [vlan_name] => SCHLIESS856 [vlan_type] => ethernet [vlan_status] => operational ) ) ) Array ( [49161] => Array ( [1] => Array ( [vlan] => 1 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) [770] => Array ( [vlan] => 770 [vlan_egress] => tagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) [841] => Array ( [vlan] => 841 [vlan_egress] => tagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) [856] => Array ( [vlan] => 856 [vlan_egress] => tagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49153] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49154] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49155] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49156] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49157] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49158] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49159] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49162] => Array ( [841] => Array ( [vlan] => 841 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) [49160] => Array ( [856] => Array ( [vlan] => 856 [vlan_egress] => untagged [vlan_egress_source] => TPLINK-DOT1Q-VLAN-MIB ) ) ) SQL[SELECT `port_id`, `ifIndex`, `ifName`, `ifDescr` FROM `ports` WHERE `device_id` = '636' AND `deleted` = 0 AND `ifType` IN ('l2vlan', 'l3ipvlan')] SQL RUNTIME[0.00042987s] 1 770 841 856+--------+----------+-------------+----------+-------------+ | Domain | Vlan: ID | Name | Type | Status | +--------+----------+-------------+----------+-------------+ | 1 | 1 | System-VLAN | ethernet | operational | | 1 | 770 | LORAWAN | ethernet | operational | | 1 | 841 | MGMT.841 | ethernet | operational | | 1 | 856 | SCHLIESS856 | ethernet | operational | +--------+----------+-------------+----------+-------------+ SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49161' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00012398s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11752'] SQL RUNTIME[0.00013685s] SQL[SELECT DISTINCT `entity_type` FROM `entity_attribs` WHERE `device_id` = '636'] SQL RUNTIME[0.00014901s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49153' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[7.892E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11744'] SQL RUNTIME[7.892E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49154' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[5.102E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11745'] SQL RUNTIME[6.819E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49155' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[4.816E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11746'] SQL RUNTIME[7.51E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49156' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[4.697E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11747'] SQL RUNTIME[7.486E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49157' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[4.411E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11748'] SQL RUNTIME[6.294E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49158' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[4.792E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11749'] SQL RUNTIME[6.199E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49159' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[5.317E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11750'] SQL RUNTIME[7.415E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49162' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[4.506E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11753'] SQL RUNTIME[6.89E-5s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '49160' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[5.198E-5s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11751'] SQL RUNTIME[6.914E-5s] +---------+-----------+------+--------+ | ifIndex | ifDescr | Vlan | Egress | +---------+-----------+------+--------+ | 49161 | Gi 1/0/9 | 1 | U | | 49161 | Gi 1/0/9 | 770 | T | | 49161 | Gi 1/0/9 | 841 | T | | 49161 | Gi 1/0/9 | 856 | T | | 49153 | Gi 1/0/1 | 841 | U | | 49154 | Gi 1/0/2 | 841 | U | | 49155 | Gi 1/0/3 | 841 | U | | 49156 | Gi 1/0/4 | 841 | U | | 49157 | Gi 1/0/5 | 841 | U | | 49158 | Gi 1/0/6 | 841 | U | | 49159 | Gi 1/0/7 | 841 | U | | 49162 | Gi 1/0/10 | 841 | U | | 49160 | Gi 1/0/8 | 856 | U | +---------+-----------+------+--------+ SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'poll_stp'] SQL RUNTIME[7.606E-5s] Module [ vlans ] stats: 1[V.P.] 770[V.P.] 841[V.P.] 856[V.P.] o Changes 4 unchanged o Duration 0.6653s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_oids'] SQL RUNTIME[5.388E-5s] ##### Module Start: oids ##### including: includes/discovery/oids.inc.php SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '636'] SQL RUNTIME[0.00011683s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[5.698E-5s] o Duration 0.0027s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_ip-addresses'] SQL RUNTIME[5.603E-5s] ##### Module Start: ip-addresses ##### including: includes/discovery/ip-addresses.inc.php SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[7.296E-5s] JSON DECODE[Not string passed] JSON RAW[ ] o IP-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ipAdEntIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.1508s] STDOUT[ ipAdEntIfIndex.172.16.5.154 = 841 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ipAdEntNetMask] CMD EXITCODE[0] CMD RUNTIME[0.1592s] STDOUT[ ipAdEntNetMask.172.16.5.154 = 255.255.240.0 ] SNMP STATUS[TRUE] Added . CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUsb -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ipAddressIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0899s] STDOUT[ ipAddressIfIndex = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] o LLDP-MIB o TPLINK-IPV6ADDR-MIB [ CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Irh -OQUsb -m TPLINK-IPV6ADDR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' ipv6ParaConfigAddress] CMD EXITCODE[0] CMD RUNTIME[0.4565s] CMD EXITDELAY[5ms] STDOUT[ ipv6ParaConfigAddress.841.2.4.254.128.0.0.0.0.0.0.42.135.186.255.254.243.195.158 = "FE 80 00 00 00 00 00 00 2A 87 BA FF FE F3 C3 9E " ] SNMP STATUS[TRUE] Store in cache Table OID: TPLINK-IPV6ADDR-MIB::ipv6ParaConfigAddress CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Irh -OQUsb -m TPLINK-IPV6ADDR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' ipv6ParaConfigPrefixLength] CMD EXITCODE[0] CMD RUNTIME[0.4964s] STDOUT[ ipv6ParaConfigPrefixLength.841.2.4.254.128.0.0.0.0.0.0.42.135.186.255.254.243.195.158 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: TPLINK-IPV6ADDR-MIB::ipv6ParaConfigPrefixLength Address fe80:0000:0000:0000:2a87:baff:fef3:c39e/128 marked as invalid by type [link-local]. Address 'fe80:0000:0000:0000:2a87:baff:fef3:c39e/128' skipped as invalid. ] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '636'] SQL RUNTIME[0.00055885s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '636' AND `ifIndex` = '841' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00016117s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '11743'] SQL RUNTIME[0.00013304s] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '172.16.0.0/20'] SQL RUNTIME[0.00011802s] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '636'] SQL RUNTIME[6.795E-5s] SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '636'] SQL RUNTIME[7.2E-5s] +---------+-------------------+-------------+-----------------+---------------+---------+--------+ | ifIndex | ifDescr | IP: Version | Address | Network | Type | Origin | +---------+-------------------+-------------+-----------------+---------------+---------+--------+ | 841 | Vlan-interface841 | IPv4 | /20 | 172.16.0.0/20 | private | | +---------+-------------------+-------------+-----------------+---------------+---------+--------+ o Changes 1 unchanged o Duration 1.3771s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_processors'] SQL RUNTIME[0.00015903s] ##### Module Start: processors ##### including: includes/discovery/processors.inc.php o TPLINK-SYSMONITOR-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Irh -OQUsb -m TPLINK-SYSMONITOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' tpSysMonitorCpuTable] CMD EXITCODE[0] CMD RUNTIME[1.0936s] STDOUT[ tpSysMonitorCpuUnitNumber.1 = 1 tpSysMonitorCpu5Seconds.1 = 82 tpSysMonitorCpu1Minute.1 = 7 tpSysMonitorCpu5Minutes.1 = 2 ] SNMP STATUS[TRUE] Store in cache Table OID: TPLINK-SYSMONITOR-MIB::tpSysMonitorCpuTable 636 -> .1.3.6.1.4.1.11863.6.4.1.1.1.1.4.1, 1, TPLINK-SYSMONITOR-MIB-tpSysMonitorCpuTable, Processor Unit 1, 1, 2 SQL[SELECT * FROM `processors` WHERE `device_id` = '636' AND `processor_index` = '1' AND `processor_type` = 'TPLINK-SYSMONITOR-MIB-tpSysMonitorCpuTable'] SQL RUNTIME[0.00048113s] SQL[SELECT * FROM `processors` WHERE `device_id` = '636'] SQL RUNTIME[0.00045085s] 1 -> TPLINK-SYSMONITOR-MIB-tpSysMonitorCpuTable Array ( [TPLINK-SYSMONITOR-MIB-tpSysMonitorCpuTable] => Array ( [1] => 1 ) ) o Changes 1 unchanged o Duration 1.0985s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_mempools'] SQL RUNTIME[0.00014591s] ##### Module Start: mempools ##### including: includes/discovery/mempools.inc.php o TPLINK-SYSMONITOR-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Irh -OQUsb -m TPLINK-SYSMONITOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' tpSysMonitorMemoryTable] CMD EXITCODE[0] CMD RUNTIME[1.0996s] STDOUT[ tpSysMonitorMemoryUnitNumber.1 = 1 tpSysMonitorMemoryUtilization.1 = 33 ] SNMP STATUS[TRUE] Store in cache Table OID: TPLINK-SYSMONITOR-MIB::tpSysMonitorMemoryTable Array ( [used] => 33 [total] => 100 [free] => 67 [perc] => 33 [units] => 1 [scale] => 1 ) 636 -> 1, TPLINK-SYSMONITOR-MIB::tpSysMonitorMemoryTable, Memory Unit 1, 1, 100, 33 SQL[SELECT * FROM `mempools` WHERE `device_id` = '636' AND `mempool_index` = '1' AND `mempool_mib` = 'TPLINK-SYSMONITOR-MIB' AND `mempool_object` = 'tpSysMonitorMemoryTable'] SQL RUNTIME[0.0004921s] SQL[SELECT * FROM `mempools` WHERE `device_id` = '636'] SQL RUNTIME[0.000108s] 1 -> TPLINK-SYSMONITOR-MIB Array ( [TPLINK-SYSMONITOR-MIB] => Array ( [1] => 1 ) ) o Changes 1 unchanged o Duration 1.1043s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_inventory'] SQL RUNTIME[9.894E-5s] ##### Module Start: inventory ##### including: includes/discovery/inventory.inc.php SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[6.39E-5s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '636'] SQL RUNTIME[0.00010705s] o Duration 0.0026s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_printersupplies'] SQL RUNTIME[5.507E-5s] ##### Module Start: printersupplies ##### including: includes/discovery/printersupplies.inc.php SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '636'] SQL RUNTIME[6.7E-5s] SQL[SELECT * FROM `counters` WHERE `device_id` = '636' AND `counter_class` = 'printersupply' AND `counter_deleted` = '0'] SQL RUNTIME[0.0001359s] SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '636'] SQL RUNTIME[5.198E-5s] o Duration 0.0037s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_printertrays'] SQL RUNTIME[5.412E-5s] ##### Module Start: printertrays ##### including: includes/discovery/printertrays.inc.php SQL[SELECT * FROM `printertrays` WHERE `device_id` = '636' AND `tray_deleted` = '0'] SQL RUNTIME[8.202E-5s] o Duration 0.0016s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_sensors'] SQL RUNTIME[5.388E-5s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_transceivers'] SQL RUNTIME[4.816E-5s] ##### Module Start: transceivers ##### including: includes/discovery/transceivers.inc.php SQL[SELECT `transceiver_id`, `transceiver_uid`, `transceiver_mib`, `deleted` FROM `transceivers` WHERE `device_id` = '636'] SQL RUNTIME[9.203E-5s] o Duration 0.0013s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_storage'] SQL RUNTIME[5.102E-5s] ##### Module Start: storage ##### including: includes/discovery/storage.inc.php SQL[SELECT * FROM `storage` WHERE `device_id` = '636'] SQL RUNTIME[8.202E-5s] o Duration 0.0013s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_neighbours'] SQL RUNTIME[5.221E-5s] ##### Module Start: neighbours ##### including: includes/discovery/neighbours.inc.php SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[5.317E-5s] JSON DECODE[Not string passed] JSON RAW[ ] o LLDP-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' lldpRemChassisIdSubtype] CMD EXITCODE[0] CMD RUNTIME[0.3445s] CMD EXITDELAY[5ms] STDOUT[ lldpRemChassisIdSubtype = No Such Instance currently exists at this OID ] SNMP STATUS[FALSE] o TPLINK-LLDPINFO-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m TPLINK-LLDPINFO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/tplink 'udp':'':'161' lldpNeighborInfoTable] CMD EXITCODE[0] CMD RUNTIME[0.4674s] STDOUT[ lldpNeighborInfoTable = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SQL[SELECT * FROM `neighbours` WHERE `device_id` = '636'] SQL RUNTIME[0.00501299s] o Duration 0.8274s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_arp-table'] SQL RUNTIME[0.00028491s] ##### Module Start: arp-table ##### including: includes/discovery/arp-table.inc.php SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00018191s] JSON DECODE[Not string passed] JSON RAW[ ] o IP-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ipNetToPhysicalPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.0987s] STDOUT[ ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' ipNetToMediaPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.1267s] STDOUT[ ipNetToMediaPhysAddress[841][172.16.15.250] = 0:c:29:e3:44:7d ipNetToMediaPhysAddress[841][172.16.15.254] = 0:10:db:ff:10:1 ipNetToMediaPhysAddress[841][172.16.15.252] = 0:c:29:ec:f8:2e ] SNMP STATUS[TRUE] Used IP-MIB::ipNetToMediaPhysAddress SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '636'] SQL RUNTIME[0.00037289s] +---------+-------------------+-----+-------------+-----------------+ | ifIndex | ifDescr | VRF | IP: Version | Addresses Count | +---------+-------------------+-----+-------------+-----------------+ | 841 | Vlan-interface841 | | IPv4 | 3 | +---------+-------------------+-----+-------------+-----------------+ o Changes 3 unchanged o Duration 0.2331s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_junose-atm-vp'] SQL RUNTIME[0.00147295s] ##### Module Start: junose-atm-vp ##### including: includes/discovery/junose-atm-vp.inc.php o Duration 0.0003s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_bgp-peers'] SQL RUNTIME[0.00029206s] ##### Module Start: bgp-peers ##### including: includes/discovery/bgp-peers.inc.php SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'bgp_localas'] SQL RUNTIME[0.00019097s] CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUv -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' bgpLocalAs.0] CMD EXITCODE[0] CMD RUNTIME[0.0117s] STDOUT[ No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] No BGP on host SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '636'] SQL RUNTIME[0.00036097s] o Duration 0.0182s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_mac-accounting'] SQL RUNTIME[0.00026202s] ##### Module Start: mac-accounting ##### including: includes/discovery/mac-accounting.inc.php o Duration 0.0003s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_sla'] SQL RUNTIME[0.00016403s] ##### Module Start: sla ##### including: includes/discovery/sla.inc.php o DISMAN-PING-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' pingCtlEntry] CMD EXITCODE[1] CMD RUNTIME[6.0115s] CMD EXITDELAY[5ms] STDOUT[ ] STDERR[ Timeout: No Response from udp::161 ] SNMP STATUS[FALSE] SNMP ERROR[#1004 - Bulk Request timeout] Retry walk at max-rep 10 after error 1004 at 50. CMD[/usr/bin/snmpbulkwalk -Cr'10' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' pingCtlEntry] CMD EXITCODE[1] CMD RUNTIME[6.0113s] STDOUT[ ] STDERR[ Timeout: No Response from udp::161 ] SNMP STATUS[FALSE] SNMP ERROR[#1004 - Bulk Request timeout] SQL[SELECT * FROM `slas` WHERE `device_id` = '636'] SQL RUNTIME[0.00037384s] o Duration 12.0333s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_lsp'] SQL RUNTIME[0.00016594s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_pseudowires'] SQL RUNTIME[5.412E-5s] ##### Module Start: pseudowires ##### including: includes/discovery/pseudowires.inc.php SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '636'] SQL RUNTIME[0.0001018s] o PW-STD-MIB CMD[/usr/bin/snmpbulkwalk -Cr'50' -Cc -t '2' -r '2' -v2c -c '' -Pud -Ir -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' pwID] CMD EXITCODE[1] CMD RUNTIME[6.0102s] STDOUT[ ] STDERR[ Timeout: No Response from udp::161 ] SNMP STATUS[FALSE] SNMP ERROR[#1004 - Bulk Request timeout] Retry walk at max-rep 10 after error 1004 at 50. CMD[/usr/bin/snmpget -t '3' -r '1' -v2c -c *** -Pud -Ir -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'':'161' .1.3.6.1.2.1.1.3.0] CMD EXITCODE[1] CMD RUNTIME[6.0119s] STDOUT[ ] STDERR[ Timeout: No Response from udp::161. ] SNMP agent stopped answering, remaining requests skipped for this run. SNMP STATUS[FALSE] SNMP local incomplete: agent_silent o Duration 12.0253s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_virtual-machines'] SQL RUNTIME[0.00033402s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_cisco-cbqos'] SQL RUNTIME[0.00022006s] ##### Module Start: cisco-cbqos ##### including: includes/discovery/cisco-cbqos.inc.php SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '636'] SQL RUNTIME[0.000144s] SNMP STATUS[FALSE] SNMP local incomplete: agent_silent QoS not configured. o Duration 0.0017s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_ucd-diskio'] SQL RUNTIME[9.799E-5s] ##### Module Start: ucd-diskio ##### including: includes/discovery/ucd-diskio.inc.php SNMP STATUS[FALSE] SNMP local incomplete: agent_silent SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '636'] SQL RUNTIME[8.202E-5s] o Duration 0.0015s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_wifi'] SQL RUNTIME[5.293E-5s] ##### Module Start: wifi ##### including: includes/discovery/wifi.inc.php SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '636'] SQL RUNTIME[7.2E-5s] SQL[SELECT * FROM `wifi_wlans` WHERE `device_id` = '636'] SQL RUNTIME[5.889E-5s] SQL[SELECT * FROM `wifi_aps` WHERE `device_id` = '636'] SQL RUNTIME[5.007E-5s] o Duration 0.0035s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_p2p-radios'] SQL RUNTIME[4.101E-5s] Discovery module 'p2p-radios' not really exists! SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_graphs'] SQL RUNTIME[3.91E-5s] ##### Module Start: graphs ##### including: includes/discovery/graphs.inc.php o Duration 0.0001s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_stp'] SQL RUNTIME[5.388E-5s] ##### Module Start: stp ##### including: includes/discovery/stp.inc.php o Duration 0.0001s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'discover_raid'] SQL RUNTIME[4.888E-5s] o Modules Disabled sensors, lsp, virtual-machines, raid o Modules Enabled snmp, os, mibs, vrf, ports, ports-stack, vlans, oids, ip-addresses, processors, mempools, inventory, printersupplies, printertrays,transceivers, storage, neighbours, arp-table, junose-atm-vp, bgp-peers, mac-accounting, sla, pseudowires, cisco-cbqos,ucd-diskio, wifi, p2p-radios, graphs, stp SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '636';] SQL RUNTIME[8.297E-5s] SQL[INSERT INTO `discovery_perf_history` (`device_id`,`module`,`time_taken`,`discovery_time`) VALUES ('636','snmp','0.822','2026-11-18 09:10:26'),('636','os','0.045','2026-11-18 09:10:26'),('636','mibs','1.251','2026-11-18 09:10:26'),('636','vrf','0.001','2026-11-18 09:10:26'),('636','ports','0.92','2026-11-18 09:10:26'),('636','ports-stack','0.389','2026-11-18 09:10:26'),('636','vlans','0.665','2026-11-18 09:10:26'),('636','oids','0.003','2026-11-18 09:10:26'),('636','ip-addresses','1.377','2026-11-18 09:10:26'),('636','processors','1.099','2026-11-18 09:10:26'),('636','mempools','1.104','2026-11-18 09:10:26'),('636','inventory','0.003','2026-11-18 09:10:26'),('636','printersupplies','0.004','2026-11-18 09:10:26'),('636','printertrays','0.002','2026-11-18 09:10:26'),('636','transceivers','0.001','2026-11-18 09:10:26'),('636','storage','0.001','2026-11-18 09:10:26'),('636','neighbours','0.827','2026-11-18 09:10:26'),('636','arp-table','0.233','2026-11-18 09:10:26'),('636','junose-atm-vp','0','2026-11-18 09:10:26'),('636','bgp-peers','0.018','2026-11-18 09:10:26'),('636','mac-accounting','0','2026-11-18 09:10:26'),('636','sla','12.033','2026-11-18 09:10:26'),('636','pseudowires','12.025','2026-11-18 09:10:26'),('636','cisco-cbqos','0.002','2026-11-18 09:10:26'),('636','ucd-diskio','0.002','2026-11-18 09:10:26'),('636','wifi','0.004','2026-11-18 09:10:26'),('636','graphs','0','2026-11-18 09:10:26'),('636','stp','0','2026-11-18 09:10:26')] SQL RUNTIME[0.00288105s] Logged discovery performance for 28 modules o Discovery CPU time 0.54 seconds SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='32.8793',`force_discovery` ='0',`device_state` ='a:4:{s:15:\"poller_mod_perf\";a:33:{s:6:\"system\";d:0.0649;s:2:\"os\";d:0.0705;s:7:\"sensors\";d:0.0026;s:6:\"status\";d:0.0015;s:7:\"counter\";d:0.0018;s:10:\"processors\";d:0.0273;s:8:\"mempools\";d:0.0223;s:7:\"storage\";d:0.0031;s:8:\"netstats\";d:0.1174;s:7:\"ucd-mib\";d:0.0005;s:13:\"ipSystemStats\";d:0.0966;s:5:\"ports\";d:1.839;s:9:\"bgp-peers\";d:0.0021;s:3:\"vrf\";d:0.0003;s:15:\"printersupplies\";d:0.0015;s:12:\"printertrays\";d:0.002;s:13:\"printeralerts\";d:0.0002;s:10:\"ucd-diskio\";d:0.0017;s:4:\"wifi\";d:0.0116;s:10:\"p2p-radios\";d:0.0016;s:4:\"ospf\";d:0.0047;s:4:\"isis\";d:0.0019;s:3:\"sla\";d:0.0016;s:11:\"pseudowires\";d:0.0018;s:3:\"bfd\";d:0.0011;s:14:\"mac-accounting\";d:0.0015;s:13:\"ipsec-tunnels\";d:0.0001;s:12:\"loadbalancer\";d:0.0001;s:15:\"entity-physical\";d:0.0002;s:9:\"fdb-table\";d:0.3271;s:6:\"graphs\";d:0.0002;s:4:\"oids\";d:0.0017;s:6:\"probes\";d:0.0017;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:0.5243091583251953;s:21:\"TPLINK-DOT1Q-VLAN-MIB\";d:0.9200379848480225;s:13:\"EtherLike-MIB\";d:0.26804089546203613;s:6:\"IP-MIB\";d:0.10103106498718262;}s:14:\"poller_history\";a:288:{i:1794992950;d:2.6995;i:1794992945;d:2.676;i:1794992646;d:2.6731;i:1794992338;d:2.7302;i:1794992050;d:2.7582;i:1794991750;d:2.7233;i:1794991443;d:2.6474;i:1794991150;d:2.5805;i:1794990841;d:2.654;i:1794990545;d:2.6733;i:1794990239;d:2.6078;i:1794989941;d:2.7045;i:1794989647;d:2.6622;i:1794989343;d:2.5916;i:1794989047;d:2.6829;i:1794988749;d:2.7389;i:1794988449;d:2.6202;i:1794988146;d:2.6283;i:1794987842;d:2.6675;i:1794987546;d:2.6428;i:1794987238;d:2.6954;i:1794986943;d:2.6743;i:1794986644;d:2.6161;i:1794986338;d:2.6429;i:1794986045;d:2.6717;i:1794985744;d:2.6934;i:1794985445;d:2.8733;i:1794985141;d:2.7737;i:1794984842;d:2.8174;i:1794984538;d:2.6586;i:1794984241;d:2.6724;i:1794983935;d:2.7991;i:1794983637;d:2.6765;i:1794983338;d:2.7895;i:1794983046;d:2.7435;i:1794982759;d:2.8096;i:1794982449;d:2.6086;i:1794982147;d:2.6583;i:1794981848;d:2.6815;i:1794981544;d:2.6679;i:1794981244;d:2.768;i:1794980937;d:2.6414;i:1794980635;d:2.6754;i:1794980345;d:2.8131;i:1794980045;d:2.6815;i:1794979746;d:2.6577;i:1794979443;d:2.651;i:1794979145;d:2.6234;i:1794978843;d:2.6664;i:1794978538;d:2.6628;i:1794978235;d:2.7172;i:1794977938;d:2.7039;i:1794977636;d:2.7075;i:1794977333;d:2.7126;i:1794977042;d:2.6794;i:1794976740;d:2.6181;i:1794976445;d:2.6614;i:1794976145;d:2.6951;i:1794975849;d:2.6556;i:1794975539;d:2.6558;i:1794975238;d:2.6407;i:1794974938;d:2.7059;i:1794974637;d:2.6287;i:1794974337;d:2.6607;i:1794974045;d:2.6964;i:1794973745;d:2.641;i:1794973440;d:2.6196;i:1794973141;d:2.6747;i:1794972844;d:2.6391;i:1794972538;d:2.6642;i:1794972238;d:2.6894;i:1794971932;d:2.6572;i:1794971640;d:2.6603;i:1794971340;d:2.6421;i:1794971050;d:2.5815;i:1794970743;d:2.6972;i:1794970440;d:2.6298;i:1794970136;d:2.7525;i:1794969840;d:2.6647;i:1794969542;d:2.6149;i:1794969238;d:2.6548;i:1794968936;d:2.6792;i:1794968632;d:2.6207;i:1794968343;d:2.631;i:1794968040;d:2.6064;i:1794967739;d:2.6298;i:1794967446;d:2.7085;i:1794967140;d:2.6424;i:1794966840;d:2.6931;i:1794966529;d:2.776;i:1794966235;d:2.6808;i:1794965935;d:2.6569;i:1794965642;d:2.6884;i:1794965340;d:2.6747;i:1794965040;d:2.6679;i:1794964740;d:2.6083;i:1794964434;d:2.6134;i:1794964132;d:2.6281;i:1794963842;d:2.7259;i:1794963533;d:2.6441;i:1794963235;d:2.7406;i:1794962937;d:2.6026;i:1794962636;d:2.6801;i:1794962339;d:2.6086;i:1794962047;d:2.6067;i:1794961746;d:2.7127;i:1794961448;d:2.6352;i:1794961144;d:2.604;i:1794960846;d:2.6532;i:1794960536;d:2.6474;i:1794960247;d:2.7863;i:1794959937;d:2.6054;i:1794959636;d:2.6583;i:1794959336;d:2.6642;i:1794959049;d:2.704;i:1794958748;d:2.6439;i:1794958450;d:2.6912;i:1794958145;d:2.6363;i:1794957838;d:2.5873;i:1794957540;d:2.7668;i:1794957236;d:2.6343;i:1794956940;d:2.6678;i:1794956645;d:2.6462;i:1794956341;d:2.6029;i:1794956044;d:2.6199;i:1794955742;d:2.6939;i:1794955503;d:2.6675;i:1794955147;d:2.6146;i:1794954848;d:2.6143;i:1794954539;d:2.6408;i:1794954239;d:2.6766;i:1794953941;d:2.6799;i:1794953643;d:2.6428;i:1794953340;d:2.637;i:1794953046;d:2.6539;i:1794952734;d:2.6149;i:1794952441;d:2.7447;i:1794952139;d:2.7777;i:1794951842;d:2.7233;i:1794951547;d:2.6454;i:1794951239;d:2.6619;i:1794950938;d:2.6236;i:1794950647;d:2.6207;i:1794950350;d:2.611;i:1794950045;d:2.6242;i:1794949747;d:2.6617;i:1794949450;d:2.7131;i:1794949134;d:2.6512;i:1794948850;d:2.7193;i:1794948540;d:2.5699;i:1794948244;d:2.5643;i:1794947940;d:2.6254;i:1794947643;d:2.7311;i:1794947342;d:2.8608;i:1794947044;d:2.6487;i:1794946739;d:2.7744;i:1794946439;d:2.6476;i:1794946147;d:2.6831;i:1794945849;d:2.6476;i:1794945543;d:2.6454;i:1794945244;d:2.6304;i:1794944948;d:2.6762;i:1794944646;d:2.6117;i:1794944347;d:2.6204;i:1794944039;d:2.6371;i:1794943745;d:2.627;i:1794943448;d:2.6894;i:1794943148;d:2.7775;i:1794942837;d:2.659;i:1794942542;d:2.6158;i:1794942249;d:2.6157;i:1794941949;d:2.5931;i:1794941646;d:2.6255;i:1794941340;d:2.6382;i:1794941040;d:2.6271;i:1794940741;d:2.6835;i:1794940446;d:2.6136;i:1794940159;d:2.6337;i:1794939852;d:2.6185;i:1794939539;d:2.611;i:1794939245;d:2.6504;i:1794938939;d:2.6651;i:1794938648;d:2.709;i:1794938346;d:2.686;i:1794938043;d:2.6954;i:1794937745;d:2.7379;i:1794937446;d:2.8202;i:1794937159;d:2.6014;i:1794936846;d:2.6168;i:1794936544;d:2.5918;i:1794936241;d:2.7485;i:1794935939;d:2.7519;i:1794935639;d:2.6923;i:1794935347;d:2.7134;i:1794935045;d:2.676;i:1794934743;d:2.644;i:1794934442;d:2.6681;i:1794934153;d:2.6192;i:1794933845;d:2.6137;i:1794933542;d:2.6634;i:1794933241;d:2.6673;i:1794932940;d:2.6174;i:1794932646;d:2.6816;i:1794932342;d:2.6407;i:1794932049;d:2.6432;i:1794931738;d:2.6158;i:1794931449;d:2.6628;i:1794931151;d:2.5886;i:1794930844;d:2.6276;i:1794930538;d:2.7638;i:1794930235;d:2.6743;i:1794929940;d:2.737;i:1794929634;d:2.6691;i:1794929339;d:2.6118;i:1794929037;d:2.608;i:1794928741;d:2.6739;i:1794928441;d:2.6519;i:1794928149;d:2.6876;i:1794927836;d:2.5957;i:1794927539;d:2.7542;i:1794927247;d:2.7058;i:1794926946;d:2.6195;i:1794926641;d:2.6254;i:1794926343;d:2.6216;i:1794926050;d:2.6568;i:1794925753;d:2.6328;i:1794925450;d:2.5835;i:1794925147;d:2.6404;i:1794924840;d:2.6589;i:1794924543;d:2.6413;i:1794924239;d:2.6396;i:1794923940;d:2.741;i:1794923643;d:2.7179;i:1794923338;d:2.5817;i:1794923041;d:2.6513;i:1794922742;d:2.6192;i:1794922442;d:2.6441;i:1794922149;d:2.6389;i:1794921842;d:2.6387;i:1794921540;d:2.7021;i:1794921237;d:2.6313;i:1794920944;d:2.6973;i:1794920638;d:2.6187;i:1794920343;d:2.6691;i:1794920051;d:2.6579;i:1794919749;d:2.6283;i:1794919444;d:2.6354;i:1794919152;d:2.6996;i:1794918846;d:2.6049;i:1794918540;d:2.6746;i:1794918248;d:2.7525;i:1794917947;d:2.6261;i:1794917643;d:2.5825;i:1794917345;d:2.6453;i:1794917064;d:2.6742;i:1794916741;d:2.576;i:1794916451;d:2.7325;i:1794916143;d:2.6876;i:1794915843;d:2.6408;i:1794915556;d:2.6158;i:1794915236;d:2.6234;i:1794914943;d:2.7334;i:1794914645;d:2.5937;i:1794914347;d:2.6637;i:1794914043;d:2.6833;i:1794913745;d:2.6803;i:1794913445;d:2.6547;i:1794913150;d:2.7121;i:1794912843;d:2.6151;i:1794912544;d:2.6487;i:1794912325;d:2.6676;i:1794912025;d:3.1963;i:1794911648;d:2.6191;i:1794911346;d:2.6119;i:1794911045;d:2.649;i:1794910746;d:2.6965;i:1794910450;d:2.6203;i:1794910154;d:2.6223;i:1794909853;d:2.6624;i:1794909547;d:2.6407;i:1794909244;d:2.6862;i:1794908948;d:2.6967;i:1794908646;d:2.6419;i:1794908341;d:2.6402;i:1794908043;d:2.6882;i:1794907748;d:2.6143;i:1794907444;d:2.6614;i:1794907152;d:2.7058;}s:17:\"discovery_history\";a:100:{i:1794992993;d:32.8793;i:1794982732;d:8.92;i:1794961165;d:9.4662;i:1794939619;d:9.0093;i:1794918093;d:8.9066;i:1794896481;d:8.8558;i:1794874856;d:8.8871;i:1794859750;d:8.6265;i:1794853313;d:7.8805;i:1794831760;d:7.8981;i:1794810149;d:7.914;i:1794788512;d:8.2148;i:1794766854;d:8.3966;i:1794745295;d:8.2462;i:1794723693;d:8.2529;i:1794702086;d:8.2782;i:1794680478;d:8.3318;i:1794658889;d:8.2645;i:1794637367;d:8.3075;i:1794615769;d:8.2553;i:1794602039;d:8.3979;i:1794600535;d:42.4346;i:1794592378;d:42.4054;i:1794570792;d:42.3787;i:1794549256;d:42.3237;i:1794527641;d:42.504;i:1794506108;d:42.2177;i:1794484436;d:41.7572;i:1794462841;d:41.895;i:1794441231;d:41.7589;i:1794419640;d:41.669;i:1794398065;d:41.6747;i:1794376164;d:41.74;i:1794354537;d:41.8019;i:1794333228;d:43.9273;i:1794311649;d:41.8615;i:1794290116;d:41.5882;i:1794268352;d:41.4835;i:1794246749;d:41.5219;i:1794225237;d:41.4354;i:1794203706;d:41.4664;i:1794181909;d:41.5117;i:1794160363;d:41.7535;i:1794138731;d:41.6348;i:1794117249;d:41.6622;i:1794095431;d:41.364;i:1794073960;d:41.7022;i:1794052359;d:41.6605;i:1794030804;d:41.5464;i:1794009183;d:41.8171;i:1793987636;d:41.6654;i:1793966072;d:41.5962;i:1793944491;d:41.5495;i:1793922922;d:41.4851;i:1793900779;d:41.5098;i:1793879022;d:47.3769;i:1793857225;d:41.6132;i:1793837191;d:42.2085;i:1793815159;d:6.3142;i:1793793523;d:5.9878;i:1793771926;d:6.1263;i:1793750272;d:5.9171;i:1793728682;d:5.9867;i:1793707092;d:5.9047;i:1793685518;d:6.0834;i:1793663940;d:6.1233;i:1793642323;d:5.9576;i:1793620713;d:6.0622;i:1793599120;d:5.9166;i:1793577537;d:6.0856;i:1793555953;d:6.1335;i:1793534336;d:5.8717;i:1793512714;d:5.9473;i:1793491131;d:5.9725;i:1793469532;d:5.9283;i:1793447932;d:5.917;i:1793426342;d:6.0302;i:1793404730;d:5.9893;i:1793383119;d:6.0086;i:1793361550;d:6.1426;i:1793339937;d:5.9255;i:1793318315;d:5.9086;i:1793296694;d:5.9278;i:1793275131;d:5.9091;i:1793253365;d:5.8789;i:1793231922;d:5.9694;i:1793210305;d:5.8851;i:1793188729;d:6.0172;i:1793167139;d:6.0474;i:1793145437;d:6.0566;i:1793123817;d:5.9625;i:1793102304;d:5.9289;i:1793080721;d:6.0332;i:1793059116;d:6.0502;i:1793037570;d:5.9009;i:1793015906;d:5.8928;i:1792994356;d:6.0866;i:1792972712;d:5.9096;i:1792951134;d:6.0751;i:1792929527;d:5.904;}}',`last_discovered_cputime` ='0.54' WHERE `device_id` = '636'] SQL RUNTIME[0.00145411s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'collection_condition'] SQL RUNTIME[9.298E-5s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT * FROM `devices` WHERE `devices`.`device_id` = '636'] SQL RUNTIME[0.00012302s] SQL[SHOW COLUMNS FROM `eventlog`] SQL RUNTIME[0.00072813s] SQL[SELECT `event_id`, `message`, `details`, UNIX_TIMESTAMP(`timestamp`) AS `unixtime` FROM `eventlog` WHERE `entity_type` = 'device' AND `device_id` = '636' AND `kind` = 'collection.condition' AND `entity_id` = '636' ORDER BY `event_id` DESC LIMIT 1] SQL RUNTIME[0.00032902s] SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`,`kind`,`category`,`details`) VALUES ('636','636','device',NOW(),'4','Collection problem (discovery): ERROR! snmpbulkwalk exit by timeout. If the device responds to other SNMP requests, try to decrease SNMP Max Repetitions on the device properties page or set to 0 to not use bulk snmp commands.','collection.condition','observium','{\"state\":\"start\",\"process\":\"discovery\",\"problem\":\"bulk_request_timeout\",\"count\":3,\"oids\":[\"DISMAN-PING-MIB::pingCtlEntry\",\"PW-STD-MIB::pwID\"]}')] SQL RUNTIME[0.00135589s] SQL[SELECT EXISTS (SELECT 1 FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'collection_condition')] SQL RUNTIME[8.297E-5s] SQL[INSERT INTO `entity_attribs` (`device_id`,`entity_type`,`entity_id`,`attrib_type`,`attrib_value`) VALUES ('636','device','636','collection_condition','{\"discovery\":{\"bulk_request_timeout\":{\"since\":1794993026,\"clean\":0,\"message\":\"ERROR! snmpbulkwalk exit by timeout. If the device responds to other SNMP requests, try to decrease SNMP Max Repetitions on the device properties page or set to 0 to not use bulk snmp commands.\"}}}')] SQL RUNTIME[0.00114298s] SQL[SELECT * FROM `device_collection_problems` WHERE `device_id` = '636'] SQL RUNTIME[0.000103s] SQL[INSERT INTO `device_collection_problems` (`device_id`,`process`,`scope_key`,`module`,`mib`,`collection`,`first_seen`,`last_seen`,`last_run`,`affected_runs`,`details`) VALUES ('636', 'discovery', '3882b379b24deb8baf5eda4463b22940e1999ba88af540544618097a7e06d05c', 'mibs', '', 'snmpget', '1794993026', '1794993026', '1794992993.3194', 1, '{\"kind\":\"command\",\"unresolved\":null,\"recovered\":null,\"objects\":[],\"contexts\":[],\"contexts_truncated\":false,\"error_codes\":[2],\"operations\":[]}') ON DUPLICATE KEY UPDATE `affected_runs` = IF(VALUES(`last_run`) > `last_run`, `affected_runs` + 1, `affected_runs`), `last_seen` = IF(VALUES(`last_run`) > `last_run`, VALUES(`last_seen`), `last_seen`), `details` = IF(VALUES(`last_run`) > `last_run`, VALUES(`details`), `details`), `cleared` = IF(VALUES(`last_run`) > `last_run`, NULL, `cleared`), `collection` = IF(VALUES(`last_run`) > `last_run`, VALUES(`collection`), `collection`), `last_run` = GREATEST(`last_run`, VALUES(`last_run`))] SQL RUNTIME[0.00196195s] SQL[INSERT INTO `device_collection_problems` (`device_id`,`process`,`scope_key`,`module`,`mib`,`collection`,`first_seen`,`last_seen`,`last_run`,`affected_runs`,`details`) VALUES ('636', 'discovery', 'd03ad42793a48574747e0a98d1686fc8f0cadcec1c58c8e75cce66c2a33de26b', 'sla', 'DISMAN-PING-MIB', 'snmpwalk', '1794993026', '1794993026', '1794992993.3194', 1, '{\"kind\":\"command\",\"unresolved\":null,\"recovered\":null,\"objects\":[\"pingCtlEntry\"],\"contexts\":[],\"contexts_truncated\":false,\"error_codes\":[1004],\"operations\":[]}') ON DUPLICATE KEY UPDATE `affected_runs` = IF(VALUES(`last_run`) > `last_run`, `affected_runs` + 1, `affected_runs`), `last_seen` = IF(VALUES(`last_run`) > `last_run`, VALUES(`last_seen`), `last_seen`), `details` = IF(VALUES(`last_run`) > `last_run`, VALUES(`details`), `details`), `cleared` = IF(VALUES(`last_run`) > `last_run`, NULL, `cleared`), `collection` = IF(VALUES(`last_run`) > `last_run`, VALUES(`collection`), `collection`), `last_run` = GREATEST(`last_run`, VALUES(`last_run`))] SQL RUNTIME[0.00155401s] SQL[INSERT INTO `device_collection_problems` (`device_id`,`process`,`scope_key`,`module`,`mib`,`collection`,`first_seen`,`last_seen`,`last_run`,`affected_runs`,`details`) VALUES ('636', 'discovery', '710def490a3cf259d7559d718296f438fd516fd7d51754c74fb5710d7795b822', 'pseudowires', 'PW-STD-MIB', 'snmpwalk', '1794993026', '1794993026', '1794992993.3194', 1, '{\"kind\":\"command\",\"unresolved\":null,\"recovered\":null,\"objects\":[\"pwID\"],\"contexts\":[],\"contexts_truncated\":false,\"error_codes\":[1004],\"operations\":[]}') ON DUPLICATE KEY UPDATE `affected_runs` = IF(VALUES(`last_run`) > `last_run`, `affected_runs` + 1, `affected_runs`), `last_seen` = IF(VALUES(`last_run`) > `last_run`, VALUES(`last_seen`), `last_seen`), `details` = IF(VALUES(`last_run`) > `last_run`, VALUES(`details`), `details`), `cleared` = IF(VALUES(`last_run`) > `last_run`, NULL, `cleared`), `collection` = IF(VALUES(`last_run`) > `last_run`, VALUES(`collection`), `collection`), `last_run` = GREATEST(`last_run`, VALUES(`last_run`))] SQL RUNTIME[0.00176311s] ##### [636] completed discovery modules at 2026-11-18 09:10:26 ##### o Discovery time 32.8793 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '1725403' AND `process_name` = 'discovery.php' AND `device_id` = '636' AND `poller_id` = '0'] SQL RUNTIME[0.00140214s] SQL[SELECT * FROM `observium_attribs` WHERE `attrib_type` != 'ldap_session_secret'] SQL RUNTIME[0.00011897s] SQL[SELECT `devices`.*, `locations`.`location` AS `location_canonical`, `locations`.`location_lat`, `locations`.`location_lon`, `locations`.`location_country`, `locations`.`location_state`, `locations`.`location_county`, `locations`.`location_city`, `locations`.`location_geoapi`, `locations`.`location_status`, `locations`.`location_manual`, `locations`.`location_updated`, UNIX_TIMESTAMP(`devices`.`last_polled`) AS `last_polled_unixtime`, UNIX_TIMESTAMP(`devices`.`ignore_until`) AS `ignore_until_unixtime` FROM `devices` LEFT JOIN `locations` USING (`location_id`) WHERE `device_id` = '636'] SQL RUNTIME[0.00019097s] SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '636'] SQL RUNTIME[0.00016189s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_maxrep_basis'] SQL RUNTIME[7.391E-5s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_maxrep_pending'] SQL RUNTIME[4.792E-5s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_maxrep_strikes'] SQL RUNTIME[4.005E-5s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_maxrep_retry'] SQL RUNTIME[3.91E-5s] SQL[SELECT EXISTS (SELECT 1 FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '636' AND `attrib_type` = 'snmp_maxrep_strikes')] SQL RUNTIME[4.983E-5s] SQL[INSERT INTO `entity_attribs` (`device_id`,`entity_type`,`entity_id`,`attrib_type`,`attrib_value`) VALUES ('636','device','636','snmp_maxrep_strikes','1')] SQL RUNTIME[0.00144315s] ##### Finished discovery run at 2026-11-18 09:10:26 ##### SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00014901s] SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[6.294E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Waystream')] SQL RUNTIME[0.00080299s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 17] SQL RUNTIME[0.0001092s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Mikrotik')] SQL RUNTIME[0.00109696s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 43] SQL RUNTIME[0.00017095s] SQL[INSERT INTO `group_table` (`group_id`,`entity_id`,`device_id`,`entity_type`) VALUES ('43','2174','2174','device')] SQL RUNTIME[0.00208807s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'mg2200%' OR IFNULL(`devices`.`hostname`, "") LIKE 'mg2310%' OR IFNULL(`devices`.`hostname`, "") LIKE 'mg2510%')] SQL RUNTIME[0.00043893s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 42] SQL RUNTIME[0.00020814s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'mg2052%' OR IFNULL(`devices`.`hostname`, "") LIKE 'v2508w%' OR IFNULL(`devices`.`hostname`, "") LIKE 'mg2042%' OR IFNULL(`devices`.`hostname`, "") LIKE 'mg2012%' OR IFNULL(`devices`.`hostname`, "") LIKE 'mg2011%')] SQL RUNTIME[0.00045896s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 41] SQL RUNTIME[0.00088477s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`syscontact`, "") REGEXP '^.*comingolstadt.net$')] SQL RUNTIME[0.00183511s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 31] SQL RUNTIME[0.00015807s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (41,42,17)] SQL RUNTIME[0.00044203s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (9,711,712,713,714,715,716,717,718,2168,733,735,874,875,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1022,1024,1025,1027,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1158,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1338,1339,1340,1341,1342,1343,1344,1345,1347,1348,1349,1350,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1494,1495,1496,1497,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1552,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1650,1651,1652,1654,1655,1656,1657,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1913,1914,1915,1916,1917,2107,2110,2124,2125,2126,2160,2164,2171,2172,3,1919,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1934,1935,1936,1937,1938,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1958,1959,1961,1962,1963,1980,1993,1994,1995,1997,1998,1999,2000,2001,2003,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2023,2024,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2103,2109,2128,2129,2141,2148,2157,2162))] SQL RUNTIME[0.00213695s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 28] SQL RUNTIME[0.00089097s] SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`hardware`, "") LIKE 'MX104' OR IFNULL(`devices`.`hardware`, "") LIKE 'ACX7024' OR IFNULL(`devices`.`hardware`, "") LIKE 'MX480' OR IFNULL(`devices`.`hardware`, "") LIKE 'MX204') AND( IFNULL(`devices`.`sysname`, "") NOT LIKE '%GW-%'))] SQL RUNTIME[0.00114202s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 24] SQL RUNTIME[0.00012016s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 12] SQL RUNTIME[6.89E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[5.603E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[5.007E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[5.722E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 24] SQL RUNTIME[6.294E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (20,619,2163,2165) OR `devices`.`device_id` IN (866,867) OR `devices`.`device_id` IN (25,32,33,545) OR `devices`.`device_id` IN (31,531,737,2158,2159,2161) OR `devices`.`device_id` IN (27,28,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130))] SQL RUNTIME[0.00032091s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 20] SQL RUNTIME[0.00018287s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 11] SQL RUNTIME[6.08E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 8] SQL RUNTIME[7.606E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[5.388E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00014997s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 15] SQL RUNTIME[6.008E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 16] SQL RUNTIME[5.984E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 9] SQL RUNTIME[5.507E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 43] SQL RUNTIME[5.198E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (18,528,529,540,541,542,543,544,779,780) OR `devices`.`device_id` IN (532,533,534,535,536,537,538,539,545,546,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,729,777,782,783,784,785,786,787,788,790,792,793,794,795,2143,2144) OR `devices`.`device_id` IN (5,548,549,550,551,555,556,557,559,560,561,562,563,565,566,781,797) OR `devices`.`device_id` IN (12,15,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,530,720,721,722,723,724,728,731,732,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2134,2135,2136,2137,2138,2139,2140,2142,2145,2146,2147,2154,2155,2158,2159) OR `devices`.`device_id` IN (6,19,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595) OR `devices`.`device_id` IN (7,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776) OR `devices`.`device_id` IN (8,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,2131) OR `devices`.`device_id` IN (2081,2152,2153,2173,2174))] SQL RUNTIME[0.00190806s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 19] SQL RUNTIME[0.00056386s] SQL[INSERT INTO `group_table` (`group_id`,`entity_id`,`device_id`,`entity_type`) VALUES ('19','2174','2174','device')] SQL RUNTIME[0.00216484s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 10] SQL RUNTIME[8.988E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 14] SQL RUNTIME[5.722E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 13] SQL RUNTIME[6.294E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (17,24,568,569,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,719,1957,1990,2167) OR 0 OR `devices`.`device_id` IN (11,21,655,656,872,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1977,1978,1981,1982,1986,1987,2048,2075,2076,2078,2079,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2132,2150,2151) OR IFNULL(`devices`.`vendor`, '') = 'E-T-A')] SQL RUNTIME[0.00071502s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 18] SQL RUNTIME[0.00013804s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") LIKE 'SRX4100%' OR IFNULL(`devices`.`sysname`, "") LIKE 'SRX1500%' OR IFNULL(`devices`.`os`, '') = 'panos')] SQL RUNTIME[0.00073504s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[6.008E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Microsens')] SQL RUNTIME[0.000525s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 16] SQL RUNTIME[7.796E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'D-Link')] SQL RUNTIME[0.00051904s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[6.413E-5s] SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`hardware`, "") LIKE 'SRX%' OR IFNULL(`devices`.`hardware`, "") LIKE 'EX%' OR IFNULL(`devices`.`hardware`, "") LIKE 'QFX%') AND( IFNULL(`devices`.`hostname`, "") NOT LIKE 'SRX4100%'))] SQL RUNTIME[0.00108409s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00041008s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hardware`, "") LIKE 'acx7509')] SQL RUNTIME[0.00080299s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[5.317E-5s] SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE `ipv4_binary` = 0xac1024f7 AND (`ports`.`deleted` IS NULL OR `ports`.`deleted` != "1")] SQL RUNTIME[0.00067902s] SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE `ipv4_binary` = 0xac1024f6 AND (`ports`.`deleted` IS NULL OR `ports`.`deleted` != "1")] SQL RUNTIME[0.00057483s] SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE `ipv4_binary` = 0xac1024f5 AND (`ports`.`deleted` IS NULL OR `ports`.`deleted` != "1")] SQL RUNTIME[0.00053191s] SQL[SELECT `device_id` FROM `devices` WHERE ( 0 OR IFNULL(`devices`.`device_id`, '') = 32 OR IFNULL(`devices`.`device_id`, '') = 25 OR( IFNULL(`devices`.`hostname`, "") LIKE '%-gw-%'))] SQL RUNTIME[0.00061488s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[6.7E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") LIKE 'kti%')] SQL RUNTIME[0.00025201s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 15] SQL RUNTIME[7.2E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Cisco')] SQL RUNTIME[0.00053s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 8] SQL RUNTIME[0.00010586s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'TP-Link')] SQL RUNTIME[0.00057387s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 9] SQL RUNTIME[0.00010109s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') IN ('Digi','Kentix'))] SQL RUNTIME[0.00054598s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 10] SQL RUNTIME[8.821E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Accedian')] SQL RUNTIME[0.00053692s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 11] SQL RUNTIME[6.39E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'SmartOptics')] SQL RUNTIME[0.00051212s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 12] SQL RUNTIME[7.105E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") LIKE 'usv%' OR IFNULL(`devices`.`hostname`, "") LIKE 'usv%')] SQL RUNTIME[0.00062299s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 13] SQL RUNTIME[9.084E-5s] SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE `ipv4_binary` = 0xac100501 AND (`ports`.`deleted` IS NULL OR `ports`.`deleted` != "1")] SQL RUNTIME[0.00054312s] SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE `ipv4_binary` = 0xac100f02 AND (`ports`.`deleted` IS NULL OR `ports`.`deleted` != "1")] SQL RUNTIME[0.00053096s] SQL[SELECT `device_id` FROM `devices` WHERE ( 0 OR 0)] SQL RUNTIME[4.792E-5s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 14] SQL RUNTIME[5.198E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 23 AND( IFNULL(`probes`.`probe_descr`, "") LIKE '%Public%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%hetzner%'))] SQL RUNTIME[0.00019002s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 35] SQL RUNTIME[7.296E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 23 AND( IFNULL(`probes`.`probe_descr`, "") LIKE '%USV%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%HOA%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%IPG%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%KENTIX%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%Energie%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%KLIMA%'))] SQL RUNTIME[0.00015593s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 36] SQL RUNTIME[8.416E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 39] SQL RUNTIME[6.604E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 23 AND( IFNULL(`probes`.`probe_descr`, "") LIKE '%Public%' OR `probes`.`probe_id` IN (14,22,30,35,36,37,38,39,44,45,49,51,67,68) OR IFNULL(`probes`.`probe_descr`, "") LIKE '%ns1.com-in.net%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '\"ns2.com-in.net\"'))] SQL RUNTIME[0.00021911s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 38] SQL RUNTIME[9.513E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 23 AND( IFNULL(`probes`.`probe_descr`, "") LIKE 'Internal%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%PDU%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%pa1410%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%LORAWAN%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%purtel%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%patton%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%fxp0%'))] SQL RUNTIME[0.00018382s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 39] SQL RUNTIME[7.2E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 23 AND( IFNULL(`probes`.`probe_descr`, "") LIKE '%com-in.local%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%com-in.net%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%linux%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%pfsense%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%pa1410%' OR IFNULL(`probes`.`probe_descr`, "") LIKE '%FAX%'))] SQL RUNTIME[0.00015712s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 40] SQL RUNTIME[5.007E-5s] SQL[SELECT * FROM `alert_tests`] SQL RUNTIME[0.00022197s] Cached 19 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[6.199E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 20] SQL RUNTIME[9.394E-5s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (20,25,27,28,31,32,33,531,545,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2158,2159,2161,2163,2165)) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00132084s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 4] SQL RUNTIME[0.00334191s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 19] SQL RUNTIME[0.00023699s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (5,6,7,8,12,15,18,19,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,548,549,550,551,555,556,557,559,560,561,562,563,565,566,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,720,721,722,723,724,728,729,731,732,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,779,780,781,782,783,784,785,786,787,788,790,792,793,794,795,797,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2081,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2131,2134,2135,2136,2137,2138,2139,2140,2142,2143,2144,2145,2146,2147,2152,2153,2154,2155,2158,2159,2173,2174))] SQL RUNTIME[0.00128198s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 7] SQL RUNTIME[0.00089502s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('2174','device','2174','7')] SQL RUNTIME[0.00208712s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `ports`.`port_label_base` = 'vcp-') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00529695s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 12] SQL RUNTIME[0.00013399s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 20] SQL RUNTIME[9.704E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (20,25,27,28,31,32,33,531,545,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2158,2159,2161,2163,2165))] SQL RUNTIME[0.00026989s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 13] SQL RUNTIME[0.00022411s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[6.604E-5s] String '51402' transformed by action [asdot] to: '51402' String '3209' transformed by action [asdot] to: '3209' String '47228' transformed by action [asdot] to: '47228' String '13237' transformed by action [asdot] to: '13237' String '12331' transformed by action [asdot] to: '12331' String '33891' transformed by action [asdot] to: '33891' String '6695' transformed by action [asdot] to: '6695' String '41110' transformed by action [asdot] to: '41110' String '1299' transformed by action [asdot] to: '1299' String '51378' transformed by action [asdot] to: '51378' String '212181' transformed by action [asdot] to: '212181' String '65100' transformed by action [asdot] to: '65100' SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (25,32,33,545) AND( IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '51402' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '3209' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '47228' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '13237' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '12331' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '33891' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '6695' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '41110' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '1299' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '51378' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '212181' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") LIKE '65100'))] SQL RUNTIME[0.00021315s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 14] SQL RUNTIME[0.00012589s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`probes`.`probe_type`, '') IN ('check_http','check_ping') AND IFNULL(`probes`.`probe_descr`, "") REGEXP '(FritzBox|patton|mg.[0-9].[0-9])')] SQL RUNTIME[0.00025415s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 15] SQL RUNTIME[0.0001328s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (20,19)] SQL RUNTIME[0.00026894s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (5,6,7,8,12,15,18,19,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,548,549,550,551,555,556,557,559,560,561,562,563,565,566,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,720,721,722,723,724,728,729,731,732,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,779,780,781,782,783,784,785,786,787,788,790,792,793,794,795,797,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2081,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2131,2134,2135,2136,2137,2138,2139,2140,2142,2143,2144,2145,2146,2147,2152,2153,2154,2155,2158,2159,2173,2174,20,25,27,28,31,32,33,531,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2161,2163,2165) AND( IFNULL(`status`.`entPhysicalClass`, "") LIKE '%power%')) AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00354314s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 17] SQL RUNTIME[0.00112605s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (20,19)] SQL RUNTIME[0.000314s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (5,6,7,8,12,15,18,19,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,548,549,550,551,555,556,557,559,560,561,562,563,565,566,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,720,721,722,723,724,728,729,731,732,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,779,780,781,782,783,784,785,786,787,788,790,792,793,794,795,797,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2081,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2131,2134,2135,2136,2137,2138,2139,2140,2142,2143,2144,2145,2146,2147,2152,2153,2154,2155,2158,2159,2173,2174,20,25,27,28,31,32,33,531,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2161,2163,2165) AND IFNULL(`status`.`status_type`, '') = 'juniper-yellow-state') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.0076611s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 21] SQL RUNTIME[0.00104284s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (20,19)] SQL RUNTIME[0.00040412s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (5,6,7,8,12,15,18,19,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,548,549,550,551,555,556,557,559,560,561,562,563,565,566,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,720,721,722,723,724,728,729,731,732,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,779,780,781,782,783,784,785,786,787,788,790,792,793,794,795,797,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2081,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2131,2134,2135,2136,2137,2138,2139,2140,2142,2143,2144,2145,2146,2147,2152,2153,2154,2155,2158,2159,2173,2174,20,25,27,28,31,32,33,531,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2161,2163,2165) AND IFNULL(`status`.`status_type`, '') = 'juniper-alarm-state') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00756502s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 22] SQL RUNTIME[0.00099397s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 20] SQL RUNTIME[0.00015593s] SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (20,25,27,28,31,32,33,531,545,619,737,739,740,741,742,743,744,745,806,807,808,809,810,812,813,815,816,817,818,819,820,821,822,823,824,825,826,827,829,830,831,833,835,836,837,838,839,840,843,844,845,846,847,848,850,851,852,853,854,856,857,858,859,860,861,862,863,864,865,866,867,868,1910,1942,1964,1976,1979,1984,1985,2002,2104,2108,2130,2158,2159,2161,2163,2165) AND IFNULL(`status`.`status_descr`, "") LIKE 'Routing Engine%' AND IFNULL(`status`.`status_descr`, "") NOT LIKE '%jnx%') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.002666s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 23] SQL RUNTIME[0.00037098s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 28] SQL RUNTIME[0.00050783s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 41] SQL RUNTIME[0.00065804s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (3,9,711,712,713,714,715,716,717,718,733,735,874,875,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1022,1024,1025,1027,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1158,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1338,1339,1340,1341,1342,1343,1344,1345,1347,1348,1349,1350,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1494,1495,1496,1497,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1552,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1650,1651,1652,1654,1655,1656,1657,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1913,1914,1915,1916,1917,1919,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1934,1935,1936,1937,1938,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1958,1959,1961,1962,1963,1980,1993,1994,1995,1997,1998,1999,2000,2001,2003,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2023,2024,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2103,2107,2109,2110,2124,2125,2126,2128,2129,2141,2148,2157,2160,2162,2164,2168,2171,2172) AND `devices`.`device_id` NOT IN (733,735,874,875,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1022,1024,1025,1027,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1158,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1338,1339,1340,1341,1342,1343,1344,1345,1347,1348,1349,1350,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1494,1495,1496,1497,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1552,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1650,1651,1652,1654,1655,1656,1657,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1913,1914,1915,1916,1917,2107,2110,2124,2125,2126,2160,2164,2171,2172))] SQL RUNTIME[0.00243807s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 24] SQL RUNTIME[0.00029016s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 36] SQL RUNTIME[0.00017595s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( `probes`.`probe_id` IN (3,4,5,6,7,8,9,10,11,12,13,193,200,201,202,204,205,207,208,209,210,211,212,213,214,215,216,220,221,222,226,228,229,230,231,232,233,234))] SQL RUNTIME[0.000175s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 26] SQL RUNTIME[0.00017905s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 35] SQL RUNTIME[0.00015283s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 39] SQL RUNTIME[5.889E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( `probes`.`probe_id` IN (18,23,27,28,29,43,48,64,70) OR `probes`.`probe_id` IN (14,22,30,35,36,37,38,39,44,45,49,51,67,68))] SQL RUNTIME[0.00013208s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 28] SQL RUNTIME[0.00011396s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 40] SQL RUNTIME[8.202E-5s] SQL[SELECT `probe_id`, `devices`.`device_id` as `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( `probes`.`probe_id` = 49)] SQL RUNTIME[0.00012898s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 29] SQL RUNTIME[8.392E-5s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') = 43)] SQL RUNTIME[0.0002439s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 30] SQL RUNTIME[5.102E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 19] SQL RUNTIME[0.00021601s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (5,6,7,8,12,15,18,19,29,30,35,36,38,44,45,48,49,50,51,52,53,55,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,77,78,79,80,81,82,83,84,85,86,87,88,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,155,156,157,158,159,160,161,162,163,164,165,167,168,169,170,171,172,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,229,232,234,235,237,238,239,242,243,244,245,246,247,248,249,251,252,254,255,257,258,259,260,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,333,334,335,336,337,338,339,341,342,343,344,345,346,347,348,349,350,351,352,353,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,384,385,386,387,388,389,390,391,392,393,394,395,397,398,399,400,402,403,404,405,406,407,408,410,411,412,413,414,415,416,417,418,419,420,421,423,424,425,426,427,428,429,430,431,432,433,434,435,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,495,498,500,501,502,503,504,505,507,508,509,510,512,514,515,516,517,518,519,520,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,548,549,550,551,555,556,557,559,560,561,562,563,565,566,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,684,687,688,689,690,691,692,693,694,698,699,700,701,702,703,704,705,707,708,709,710,720,721,722,723,724,728,729,731,732,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,779,780,781,782,783,784,785,786,787,788,790,792,793,794,795,797,798,799,800,803,804,805,876,877,1911,1920,1939,1940,1941,1992,2026,2027,2077,2080,2081,2082,2099,2100,2101,2102,2105,2106,2112,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2127,2131,2134,2135,2136,2137,2138,2139,2140,2142,2143,2144,2145,2146,2147,2152,2153,2154,2155,2158,2159,2173,2174)) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00352812s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 31] SQL RUNTIME[0.00858021s] SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`) VALUES ('2174','port','119014','31'),('2174','port','119015','31'),('2174','port','119016','31'),('2174','port','119017','31'),('2174','port','119018','31'),('2174','port','119019','31'),('2174','port','119020','31'),('2174','port','119021','31'),('2174','port','119022','31'),('2174','port','119023','31'),('2174','port','119024','31'),('2174','port','119025','31'),('2174','port','119026','31'),('2174','port','119027','31'),('2174','port','119028','31'),('2174','port','119029','31'),('2174','port','119030','31'),('2174','port','119031','31'),('2174','port','119032','31'),('2174','port','119033','31'),('2174','port','119034','31')] SQL RUNTIME[0.00142694s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 41] SQL RUNTIME[0.0003531s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (733,735,874,875,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1022,1024,1025,1027,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1158,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1338,1339,1340,1341,1342,1343,1344,1345,1347,1348,1349,1350,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1494,1495,1496,1497,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1552,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1650,1651,1652,1654,1655,1656,1657,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1913,1914,1915,1916,1917,2107,2110,2124,2125,2126,2160,2164,2171,2172))] SQL RUNTIME[0.00180507s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 33] SQL RUNTIME[0.00106001s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[8.893E-5s] String '51402' transformed by action [asdot] to: '51402' String '1299' transformed by action [asdot] to: '1299' String '3209' transformed by action [asdot] to: '3209' String '47228' transformed by action [asdot] to: '47228' String '12331' transformed by action [asdot] to: '12331' String '13237' transformed by action [asdot] to: '13237' String '33891' transformed by action [asdot] to: '33891' String '41110' transformed by action [asdot] to: '41110' String '51378' transformed by action [asdot] to: '51378' String '65100' transformed by action [asdot] to: '65100' String '212181' transformed by action [asdot] to: '212181' SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (25,32,33,545) AND( IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '51402' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '1299' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '3209' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '47228' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '12331' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '13237' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '33891' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '41110' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '51378' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '65100' AND IFNULL(`bgpPeers`.`bgpPeerRemoteAs`, "") NOT LIKE '212181'))] SQL RUNTIME[0.00023079s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 34] SQL RUNTIME[9.394E-5s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[7.606E-5s] SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (866,867))] SQL RUNTIME[0.00015306s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 35] SQL RUNTIME[0.00021815s] ##### Update Alert Tests Table ##### +-------------------------------------+-------------------+-------+---------+ | Alert Test | Entries: existing | found | changes | +-------------------------------------+-------------------+-------+---------+ | RuT BB Port down | 3087 | 3087 | +0/-0 | | RuT Device down | 700 | 701 | +1/-0 | | RuT VC Port down | 19 | 19 | +0/-0 | | RuT BB-Router down | 88 | 88 | +0/-0 | | BGP NeighborStateChange | 39 | 39 | +0/-0 | | 2nd Level FritzBox POP Fail | 40 | 40 | +0/-0 | | Netzteil ausgefallen | 851 | 851 | +0/-0 | | Juniper Yellow Alarm | 577 | 577 | +0/-0 | | Juniper Red Alarm | 577 | 577 | +0/-0 | | Routing Engine ausgefallen | 158 | 158 | +0/-0 | | 2nd Level Device down | 128 | 128 | +0/-0 | | Infrastruktur Ping Fail | 38 | 38 | +0/-0 | | RuT Ping Fail | 23 | 23 | +0/-0 | | IT Ping Fail | 1 | 1 | +0/-0 | | Zabbix offline | 1 | 1 | +0/-0 | | RuT CPE Port down | 9154 | 9175 | +21/-0 | | 2nd Level DSLAM down | 1012 | 1012 | +0/-0 | | Kein Ticket BGP NeighborStateChange | 36 | 36 | +0/-0 | | BB BGP NeighborStateChange | 148 | 148 | +0/-0 | +-------------------------------------+-------------------+-------+---------+ ./discovery.php: - 1 devices discovered in 32.9835 secs SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1794978626'] SQL RUNTIME[0.00011611s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output. o Devices Discovered (Total) 1 (1) o Discovery Time 32.9835 secs o Definitions 0.096549034118652 secs o Memory usage 20MB (peak: 20MB) o MySQL Usage Cell[32/0.04s] Row[62/0.079s] Rows[145/0.298s] Column[46/0.058s] Update[1/0.003s] Insert[10/0.03s] Delete[3/0.007s] o RRDTool Usage