[arizzo@n4-wkf-obs-01 observium]$ ./discovery.php -d -h n4-wkf-apic-01-cimc
DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.0166s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 11801
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 11678
Last Changed Date: 2021-10-20 16:36:25 +0100 (Wed, 20 Oct 2021)

]
DEFINITIONS loaded by: 0.11703 ms

DEFINITIONS in memory: 13.5MB


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

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

CMD[date "+%:z"]

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

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

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

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

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

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

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0189s]
STDOUT[
Linux|3.10.0-1160.11.1.el7.x86_64|amd64|CentOS|7|vmware|
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0044s]
STDOUT[
Python 2.7.5
]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.007s]
STDOUT[
NET-SNMP version: 5.7.2
]

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

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

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

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

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

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

]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0312s]
STDOUT[
Apache/2.4.6
]

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

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

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

 o OS                   Linux 3.10.0-1160.11.1.el7.x86_64 [amd64] (CentOS 7)
 o Apache               2.4.6
 o PHP                  7.1.29 (OPcache: DISABLED)
 o Python               2.7.5
 o MariaDB              10.0.38-MariaDB (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.2
 o RRDtool              1.7.1
 o Fping                3.10 (IPv4 only)

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

 o PHP                  2GB

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

 o MariaDB

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

 o PHP                  UTF-8
 o MariaDB              utf8

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

 o Date                 Thursday, 09-Dec-21 21:45:38 UTC
 o PHP                  +00:00
 o MariaDB              +00:00


SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00022912s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00013995s]
#####  Starting discovery run at 2021-12-09 21:45:38  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'n4-wkf-apic-01-cimc' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00051308s]

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'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.2803s]
STDOUT[
.1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.9.1.2492
.1.3.6.1.2.1.1.3.0 = 55:12:30:29.19
]
SNMP STATUS[TRUE]

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

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

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('11400','discovery.php','27698','1002','php ./discovery.php -d -h n4-wkf-apic-01-cimc','1639086338','1009')]
SQL RUNTIME[0.00146222s]
#####  n4-wkf-apic-01-cimc [1009]  #####

 o OS Type              cisco-apic
 o SNMP Version         v3
 o Last discovery       2021-12-09 21:44:22
 o Last duration        4.56 seconds

#####  Module Start: os  #####


CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0383s]
STDOUT[
Cisco Integrated Management Controller(Cisco IMC) APIC-SERVER-L3, Firmware Version 4.1(3c), Copyright (c) 2008-2020, Cisco Systems, Inc.
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' sysObjectID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0386s]
STDOUT[
.1.3.6.1.4.1.9.1.2492
]
SNMP STATUS[TRUE]
+-------------+---------------------------------------------------------------------------------------------------------------------------------+
| OID         |                                                                                                                                 |
+-------------+---------------------------------------------------------------------------------------------------------------------------------+
| sysDescr    | Cisco Integrated Management Controller(Cisco IMC) APIC-SERVER-L3, Firmware Version 4.1(3c), Copyright (c) 2008-2020, Cisco Syst |
|             | ems, Inc.                                                                                                                       |
| sysObjectID | .1.3.6.1.4.1.9.1.2492                                                                                                           |
+-------------+---------------------------------------------------------------------------------------------------------------------------------+

 o Re-Detect OS matched (cisco-apic: Cisco APIC):
+-------------+--------------------+------------------------------------------------------------------------------------------------------------+
| OID         | Matched definition |                                                                                                            |
+-------------+--------------------+------------------------------------------------------------------------------------------------------------+
| sysObjectID | .1.3.6.1.4.1.9.1   | .1.3.6.1.4.1.9.1.2492                                                                                      |
| sysDescr    | /APIC/             | Cisco Integrated Management Controller(Cisco IMC) APIC-SERVER-L3, Firmware Version 4.1(3c), Copyright (c)  |
|             |                    | 2008-2020, Cisco Systems, Inc.                                                                             |
+-------------+--------------------+------------------------------------------------------------------------------------------------------------+


 o Duration             0.117s

#####  Module Start: mibs  #####


CMD[/usr/bin/snmptranslate -On -Pu -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID']

CMD EXITCODE[0]
CMD RUNTIME[0.0101s]
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 -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' .1.3.6.1.2.1.1.9.1.2]

CMD EXITCODE[0]
CMD RUNTIME[0.039s]
STDOUT[
.1.3.6.1.2.1.1.9.1.2.1 = .1.3.6.1.6.3.1
.1.3.6.1.2.1.1.9.1.2.2 = .1.3.6.1.6.3.10.3.1.1
.1.3.6.1.2.1.1.9.1.2.3 = .1.3.6.1.6.3.11.3.1.1
.1.3.6.1.2.1.1.9.1.2.4 = .1.3.6.1.6.3.15.2.1.1
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' sysORDescr]

CMD EXITCODE[0]
CMD RUNTIME[0.039s]
STDOUT[
sysORDescr.1 = The MIB module for SNMPv2 entities
sysORDescr.2 = The SNMP Management Architecture MIB.
sysORDescr.3 = The MIB for Message Processing and Dispatching.
sysORDescr.4 = The management information definitions for the SNMP User-based Security Model.
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m LLDP-EXT-MED-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' lldpXMedLocModelName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.048s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Store in cache OID: LLDP-EXT-MED-MIB::lldpXMedLocModelName.0
 o MIBs discovered      <empty>
SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00030398s]

+-----------------------+--------------------+---------+---------------------+
| Identity              | MIB                | Source  | Status              |
+-----------------------+--------------------+---------+---------------------+
| .1.3.6.1.6.3.1        | SNMPv2-MIB         | sysORID | MIB already defined |
| .1.3.6.1.6.3.10.3.1.1 | SNMP-FRAMEWORK-MIB | sysORID | MIB already defined |
| .1.3.6.1.6.3.11.3.1.1 | -                  | sysORID | Unknown Identity    |
| .1.3.6.1.6.3.15.2.1.1 | -                  | sysORID | Unknown Identity    |
+-----------------------+--------------------+---------+---------------------+


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00023103s]
JSON DECODE[Not string passed]
JSON RAW[


 > $str /opt/observium/includes/common.inc.php:5410
null

]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '1009' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00023007s]


  /opt/observium/includes/discovery/mibs.inc.php:313
array(
  [0]  => string(23) "CISCO-ENTITY-SENSOR-MIB"
  [1]  => string(17) "CISCO-PROCESS-MIB"
  [2]  => string(28) "CISCO-ENTITY-FRU-CONTROL-MIB"
  [3]  => string(10) "SNMPv2-MIB"
  [4]  => string(18) "SNMP-FRAMEWORK-MIB"
  [5]  => string(6) "IF-MIB"
  [6]  => string(13) "ADSL-LINE-MIB"
  [7]  => string(13) "EtherLike-MIB"
  [8]  => string(10) "ENTITY-MIB"
  [9]  => string(17) "ENTITY-SENSOR-MIB"
  [10] => string(8) "LLDP-MIB"
  [11] => string(13) "CISCO-CDP-MIB"
  [12] => string(10) "PW-STD-MIB"
  [13] => string(15) "DISMAN-PING-MIB"
  [14] => string(6) "IP-MIB"
  [15] => string(8) "IPV6-MIB"
)

 o Duration             0.1525s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_vrf']
SQL RUNTIME[0.00020289s]
#####  Module Start: vrf  #####


SQL[SELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '1009' AND 1]
SQL RUNTIME[0.00021195s]

SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '1009' AND `ifVrf` IS NOT NULL AND 1]
SQL RUNTIME[0.00022388s]

 o Duration             0.0024s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_ports']
SQL RUNTIME[0.00023985s]
#####  Module Start: ports  #####

 o Caching OIDs         ifDescr
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifDescr]

CMD EXITCODE[0]
CMD RUNTIME[0.0401s]
STDOUT[
ifDescr.1 = eth0
]
SNMP STATUS[TRUE]
ifAlias
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifAlias]

CMD EXITCODE[0]
CMD RUNTIME[0.0433s]
STDOUT[
ifAlias.1 =
]
SNMP STATUS[TRUE]
ifName
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifName]

CMD EXITCODE[0]
CMD RUNTIME[0.0409s]
STDOUT[
ifName.1 = eth0
]
SNMP STATUS[TRUE]
ifType
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifType]

CMD EXITCODE[0]
CMD RUNTIME[0.0405s]
STDOUT[
ifType.1 = ethernetCsmacd
]
SNMP STATUS[TRUE]
ifOperStatus
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifOperStatus]

CMD EXITCODE[0]
CMD RUNTIME[0.0421s]
STDOUT[
ifOperStatus.1 = up
]
SNMP STATUS[TRUE]



  /opt/observium/includes/discovery/ports.inc.php:44
array(
  [1] => array(
           [ifDescr]      => string(4) "eth0"
           [ifAlias]      => string(0) ""
           [ifName]       => string(4) "eth0"
           [ifType]       => string(14) "ethernetCsmacd"
           [ifOperStatus] => string(2) "up"
         )
)
 o Caching DB
SQL[SELECT * FROM `ports` WHERE `device_id` = '1009']
SQL RUNTIME[0.00041509s]
1 ports
 o Discovering ports    .
+---------+---------+--------+---------+----------------+-------------+---------+
| ifIndex | ifDescr | ifName | ifAlias | ifType         | Oper Status | Ignored |
+---------+---------+--------+---------+----------------+-------------+---------+
| 1       | eth0    | eth0   | ...     | ethernetCsmacd | up          | no      |
+---------+---------+--------+---------+----------------+-------------+---------+


 o Duration             0.2208s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_ports-stack']
SQL RUNTIME[0.00025105s]
#####  Module Start: ports-stack  #####


SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '1009']
SQL RUNTIME[0.00039101s]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ifStackStatus]

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


 o Duration             0.0488s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_vlans']
SQL RUNTIME[0.00029397s]
#####  Module Start: vlans  #####


SQL[SELECT * FROM `vlans` WHERE `device_id` = '1009';]
SQL RUNTIME[0.00023484s]

SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '1009';]
SQL RUNTIME[0.00016689s]


 o Duration             0.0023s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_oids']
SQL RUNTIME[0.00018287s]
#####  Module Start: oids  #####


SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '1009']
SQL RUNTIME[0.00062895s]

SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1']
SQL RUNTIME[0.00030899s]

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.13.2.1.1.12.1]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.13.2.1.1.12.2]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.3.1.1.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.12.1.1.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.11.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.12.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.13.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.14.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.3.1.2.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.20.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.3.1.3.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.7.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.12356.101.4.1.6.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' .1.3.6.1.4.1.2352.2.27.1.2.5.3.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.2636.3.1.15.1.8.7.1.0.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.2636.3.1.15.1.8.7.2.0.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.2636.3.1.15.1.8.7.3.0.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.2636.3.1.15.1.8.7.4.0.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.2636.3.39.1.12.1.1.1.6.0]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' .1.3.6.1.4.1.9.9.774.1.4.2.1.4.2.13]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' .1.3.6.1.4.1.9.9.774.1.4.2.1.5.2.13]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.9.9.774.1.4.2.1.3.2.13]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.9.9.774.1.4.2.1.4.1.13]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.9.9.774.1.4.2.1.5.1.13]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OUQnv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' 1.3.6.1.4.1.9.9.774.1.4.2.1.3.1.13]

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

 o Duration             1.3952s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_ip-addresses']
SQL RUNTIME[0.00028515s]
#####  Module Start: ip-addresses  #####


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00023603s]
JSON DECODE[Not string passed]
JSON RAW[


  /opt/observium/includes/common.inc.php:5410
null

]
 o IP-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipAdEntIfIndex]

CMD EXITCODE[0]
CMD RUNTIME[0.0497s]
STDOUT[
ipAdEntIfIndex.10.200.231.174 = 1
ipAdEntIfIndex.127.0.0.1 = 1
ipAdEntIfIndex.127.16.1.1 = 11
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipAdEntNetMask]

CMD EXITCODE[0]
CMD RUNTIME[0.0468s]
STDOUT[
ipAdEntNetMask.10.200.231.174 = 255.255.255.0
ipAdEntNetMask.127.0.0.1 = 255.255.0.0
ipAdEntNetMask.127.16.1.1 = 255.255.255.0
]
SNMP STATUS[TRUE]
Added 10.200.231.174
.Added 127.0.0.1
.Added 127.16.1.1
.
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipAddressIfIndex]

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

 o IPV6-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsb -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipv6AddrEntry]

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


SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '1009']
SQL RUNTIME[0.00048399s]

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

SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '274916']
SQL RUNTIME[0.00031590s]

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

SQL[SELECT * FROM `devices` WHERE `device_id` = '1009']
SQL RUNTIME[0.00024199s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '1009']
SQL RUNTIME[0.00018787s]

SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.200.231.0/24']
SQL RUNTIME[0.00161409s]

SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '127.0.0.0/16']
SQL RUNTIME[0.00203300s]

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

SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '127.16.1.0/24']
SQL RUNTIME[0.00159311s]

SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '1009']
SQL RUNTIME[0.00026011s]

SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '1009']
SQL RUNTIME[0.00022197s]
+---------+---------+-------------+-------------------+-----------------+----------+--------+
| ifIndex | ifDescr | IP: Version | Address           | Network         | Type     | Origin |
+---------+---------+-------------+-------------------+-----------------+----------+--------+
| 1       | eth0    | IPv4        | 10.200.231.174/24 | 10.200.231.0/24 | private  |        |
| 1       | eth0    | IPv4        | 127.0.0.1/16      | 127.0.0.0/16    | loopback |        |
| 11      | ...     | IPv4        | 127.16.1.1/24     | 127.16.1.0/24   | loopback |        |
+---------+---------+-------------+-------------------+-----------------+----------+--------+


 o Changes              3 unchanged
 o Duration             0.231s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_processors']
SQL RUNTIME[0.00039697s]
#####  Module Start: processors  #####

 o CISCO-PROCESS-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-PROCESS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cpmCPU]

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

CMD[/usr/bin/snmpget -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' .1.3.6.1.4.1.9.2.1.58.0]

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


SQL[SELECT * FROM `processors` WHERE `device_id` = '1009']
SQL RUNTIME[0.00034714s]

 o Duration             0.1337s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_mempools']
SQL RUNTIME[0.00031590s]
#####  Module Start: mempools  #####

 o CISCO-PROCESS-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-PROCESS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cpmCPUMemoryUsed]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-PROCESS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cpmCPUMemoryFree]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-PROCESS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cpmCPUTotalPhysicalIndex]

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


SQL[SELECT * FROM `mempools` WHERE `device_id` = '1009']
SQL RUNTIME[0.00026107s]

 o Duration             0.2132s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_inventory']
SQL RUNTIME[0.00020194s]
#####  Module Start: inventory  #####

 o ENTITY-MIB           ENTITY-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' entPhysicalEntry]

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


SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '1009']
SQL RUNTIME[0.00031018s]

 o Duration             0.475s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_printersupplies']
SQL RUNTIME[0.00022292s]
#####  Module Start: printersupplies  #####


SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '1009']
SQL RUNTIME[0.00020599s]


 o Duration             0.0013s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_sensors']
SQL RUNTIME[0.00019002s]
#####  Module Start: sensors  #####

 o CISCO-ENTITY-SENSOR-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' entSensorValueEntry]

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

 o CISCO-ENTITY-FRU-CONTROL-MIB
SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '1009' AND `status_type` = 'cisco-envmon-state' AND `status_deleted` = '0')]
SQL RUNTIME[0.00040483s]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-FRU-CONTROL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cefcFRUPowerStatusEntry]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-FRU-CONTROL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cefcFanTrayStatusEntry]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-FRU-CONTROL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cefcFanEntry]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-FRU-CONTROL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cefcModuleEntry]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-ENTITY-FRU-CONTROL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cefcFRUPowerSupplyGroupEntry]

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

 o ENTITY-SENSOR-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' entPhySensorValue]

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


SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00038815s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00032115s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028801s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024605s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024915s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00022197s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024796s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00022101s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00023103s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024915s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024009s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00020099s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018787s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00019097s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018907s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00020814s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018501s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018311s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018620s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00019097s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00019407s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018597s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024390s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00019884s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00021291s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00021315s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00018406s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00017881s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00019312s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00017691s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00017500s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '1009' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00024080s]

SQL[SELECT * FROM `status` WHERE `device_id` = '1009' AND `poller_type` = 'snmp' AND `status_deleted` = '0']
SQL RUNTIME[0.00018287s]

SQL[SELECT * FROM `counters` WHERE `device_id` = '1009' AND `poller_type` = 'snmp' AND `counter_deleted` = '0']
SQL RUNTIME[0.00019097s]


 o Duration             0.5176s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_storage']
SQL RUNTIME[0.00017190s]
#####  Module Start: storage  #####


SQL[SELECT * FROM `storage` WHERE `device_id` = '1009']
SQL RUNTIME[0.00018191s]

 o Duration             0.0014s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_neighbours']
SQL RUNTIME[0.00017405s]
#####  Module Start: neighbours  #####

 o LLDP-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' lldpRemChassisIdSubtype]

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

 o CISCO-CDP-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -Ih -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cdpCache]

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


SQL[SELECT * FROM `neighbours` WHERE `device_id` = '1009']
SQL RUNTIME[0.00033402s]



 o Duration             0.1306s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_arp-table']
SQL RUNTIME[0.00022006s]
#####  Module Start: arp-table  #####


SQL[SELECT `port_id`, `ifIndex` FROM `ports` WHERE `device_id` = '1009' GROUP BY `port_id`]
SQL RUNTIME[0.00026798s]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipNetToPhysicalPhysAddress]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OXqs -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipv6NetToMediaPhysAddress]

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

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' ipNetToMediaPhysAddress]

CMD EXITCODE[0]
CMD RUNTIME[0.0435s]
STDOUT[
ipNetToMediaPhysAddress[1][10.200.231.1] 0:0:5e:0:1:c8
ipNetToMediaPhysAddress[1][10.200.231.70] ac:f5:e6:1:fd:b9
ipNetToMediaPhysAddress[1][10.200.231.240] 10:e:7e:d9:63:a
ipNetToMediaPhysAddress[1][10.200.231.241] 10:e:7e:d6:e3:cb
ipNetToMediaPhysAddress[11][127.16.1.2] f8:a7:3a:24:83:82
]
SNMP STATUS[TRUE]
Used IP-MIB::ipNetToMediaPhysAddress

SQL[SELECT mac_id, mac_address, ip_address, ip_version, ifIndex FROM ip_mac AS M LEFT JOIN ports AS I ON M.port_id = I.port_id WHERE I.device_id = '1009']
SQL RUNTIME[0.00059390s]
....

 o Duration             0.1522s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_junose-atm-vp']
SQL RUNTIME[0.00022101s]
#####  Module Start: junose-atm-vp  #####


 o Duration             0.0003s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_bgp-peers']
SQL RUNTIME[0.00016999s]
#####  Module Start: bgp-peers  #####


 o Duration             0.0013s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_mac-accounting']
SQL RUNTIME[0.00016785s]
#####  Module Start: mac-accounting  #####


 o Duration             0.0002s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_sla']
SQL RUNTIME[0.00016689s]
#####  Module Start: sla  #####

 o DISMAN-PING-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' pingCtlEntry]

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


SQL[SELECT * FROM `slas` WHERE `device_id` = '1009']
SQL RUNTIME[0.00044584s]

 o Duration             0.0633s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_lsp']
SQL RUNTIME[0.00020504s]
Module [lsp] disabled globally by config in process [discovery].

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_pseudowires']
SQL RUNTIME[0.00028396s]
#####  Module Start: pseudowires  #####


SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '1009']
SQL RUNTIME[0.00026488s]
 o PW-STD-MIB
CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' pwID]

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


 o Duration             0.0466s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_virtual-machines']
SQL RUNTIME[0.00034213s]
#####  Module Start: virtual-machines  #####



 o Duration             0.0008s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_cisco-cbqos']
SQL RUNTIME[0.00023389s]
#####  Module Start: cisco-cbqos  #####


SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '1009']
SQL RUNTIME[0.00026298s]

CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'n4-wkf-apic-01-cimc':'161' cbQosIfType]

CMD EXITCODE[0]
CMD RUNTIME[0.0971s]
STDOUT[
cbQosIfType = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
QoS not configured.

 o Duration             0.1002s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_ucd-diskio']
SQL RUNTIME[0.00033712s]
#####  Module Start: ucd-diskio  #####


CMD[/usr/bin/snmpbulkwalk -t '40' -r '5' -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'n4-wkf-apic-01-cimc':'161' diskIOEntry]

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

SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '1009']
SQL RUNTIME[0.00036502s]


 o Duration             0.0466s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_wifi']
SQL RUNTIME[0.00021410s]
#####  Module Start: wifi  #####


SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '1009']
SQL RUNTIME[0.00019407s]

SQL[SELECT * FROM `wifi_wlans` WHERE `device_id` = '1009']
SQL RUNTIME[0.00017309s]

SQL[SELECT * FROM `wifi_aps` WHERE `device_id` = '1009']
SQL RUNTIME[0.00013208s]


 o Duration             0.0026s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_p2p-radios']
SQL RUNTIME[0.00017285s]
#####  Module Start: p2p-radios  #####


 o Duration             0.0001s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_graphs']
SQL RUNTIME[0.00015807s]
#####  Module Start: graphs  #####


 o Duration             0.0003s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1009' AND `attrib_type` = 'discover_raid']
SQL RUNTIME[0.00015688s]
Module [raid] disabled globally by config in process [discovery].
 o Modules Disabled     lsp, raid
 o Modules Enabled      os, mibs, vrf, ports, ports-stack, vlans, oids, ip-addresses, processors, mempools, inventory, printersupplies, sensors,
                        storage,neighbours, arp-table, junose-atm-vp, bgp-peers, mac-accounting, sla, pseudowires, virtual-machines,
                        cisco-cbqos,ucd-diskio, wifi, p2p-radios, graphs

SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '1009';]
SQL RUNTIME[0.00020504s]

SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='server',`last_discovered_timetaken` ='4.0914',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:28:{s:6:\"system\";d:0.2346;s:2:\"os\";d:0.001;s:7:\"sensors\";d:0.0007;s:6:\"status\";d:0.0004;s:7:\"counter\";d:0.0003;s:10:\"processors\";d:0.0006;s:8:\"mempools\";d:0.0006;s:7:\"storage\";d:0.0006;s:8:\"netstats\";d:0.7004;s:7:\"ucd-mib\";d:0.0004;s:13:\"ipSystemStats\";d:0.054;s:5:\"ports\";d:0.2067;s:9:\"bgp-peers\";d:0.0011;s:15:\"printersupplies\";d:0.0004;s:10:\"ucd-diskio\";d:0.0003;s:4:\"wifi\";d:0.0002;s:10:\"p2p-radios\";d:0.0005;s:4:\"ospf\";d:0.0004;s:3:\"sla\";d:0.0006;s:11:\"pseudowires\";d:0.0005;s:14:\"mac-accounting\";d:0.0006;s:12:\"loadbalancer\";d:0.0003;s:15:\"entity-physical\";d:0.0002;s:12:\"applications\";d:0.0004;s:9:\"fdb-table\";d:0.0011;s:6:\"graphs\";d:0.0004;s:4:\"oids\";d:0.0008;s:6:\"probes\";d:0.0004;}s:17:\"poller_ports_perf\";a:3:{s:6:\"IF-MIB\";d:0.09986495971679688;s:13:\"EtherLike-MIB\";d:0.050267934799194336;s:6:\"IP-MIB\";d:0.04714608192443848;}s:14:\"poller_history\";a:288:{i:1639086172;d:1.3248;i:1639085894;d:1.2731;i:1639085577;d:1.1093;i:1639085283;d:0.9752;i:1639084978;d:1.4392;i:1639084684;d:1.175;i:1639084380;d:1.3524;i:1639084098;d:1.3527;i:1639083776;d:1.1237;i:1639083475;d:1.1479;i:1639083194;d:1.5649;i:1639082879;d:1.4546;i:1639082574;d:1.1139;i:1639082297;d:1.3248;i:1639081986;d:1.0975;i:1639081685;d:1.0166;i:1639081402;d:1.4511;i:1639081080;d:1.1742;i:1639080789;d:1.6455;i:1639080516;d:1.5009;i:1639080191;d:1.0675;i:1639079886;d:1.5506;i:1639079584;d:0.8847;i:1639079280;d:1.3015;i:1639078990;d:1.0021;i:1639078693;d:0.98;i:1639078385;d:1.3301;i:1639078077;d:1.1067;i:1639077772;d:1.1167;i:1639077476;d:1.3271;i:1639077184;d:1.299;i:1639076883;d:1.0229;i:1639076582;d:1.0041;i:1639076265;d:1.0539;i:1639075984;d:0.9496;i:1639075689;d:1.2636;i:1639075396;d:1.016;i:1639075090;d:0.9112;i:1639074782;d:1.6952;i:1639074468;d:1.1393;i:1639074207;d:1.3478;i:1639073876;d:1.6179;i:1639073582;d:1.4225;i:1639073320;d:0.8762;i:1639072979;d:1.2949;i:1639072674;d:1.0082;i:1639072230;d:0.9224;i:1639072080;d:1.6178;i:1639071774;d:40.9772;i:1639071488;d:1.0787;i:1639071182;d:1.4661;i:1639070878;d:1.237;i:1639070580;d:1.4452;i:1639070280;d:1.2647;i:1639069976;d:1.3992;i:1639069698;d:1.0001;i:1639069390;d:1.2517;i:1639069074;d:1.2768;i:1639068783;d:0.9733;i:1639068479;d:1.0929;i:1639068180;d:1.0053;i:1639067876;d:1.3001;i:1639067603;d:1.2516;i:1639067280;d:1.9989;i:1639066984;d:1.5995;i:1639066678;d:1.4787;i:1639066398;d:1.5265;i:1639066120;d:0.9627;i:1639065811;d:1.1342;i:1639065480;d:1.2542;i:1639065182;d:1.5914;i:1639064884;d:1.0206;i:1639064568;d:0.9923;i:1639064307;d:1.0897;i:1639063973;d:1.2477;i:1639063677;d:1.2022;i:1639063383;d:1.122;i:1639063078;d:1.7457;i:1639062804;d:1.1764;i:1639062509;d:1.2721;i:1639062204;d:1.6175;i:1639061882;d:1.6997;i:1639061595;d:1.4836;i:1639061291;d:1.627;i:1639060994;d:1.5335;i:1639060701;d:1.3746;i:1639060396;d:1.3009;i:1639060090;d:1.4525;i:1639059797;d:1.5024;i:1639059492;d:1.0726;i:1639059193;d:1.4003;i:1639058910;d:1.637;i:1639058599;d:1.5433;i:1639058297;d:0.9305;i:1639057993;d:1.4238;i:1639057688;d:1.1388;i:1639057393;d:1.1325;i:1639057100;d:1.473;i:1639056788;d:1.4832;i:1639056491;d:0.94;i:1639056191;d:1.4399;i:1639055889;d:1.1863;i:1639055594;d:1.3512;i:1639055302;d:1.4273;i:1639054992;d:1.077;i:1639054687;d:1.6471;i:1639054395;d:1.1084;i:1639054107;d:0.9578;i:1639053806;d:0.9698;i:1639053505;d:1.3542;i:1639053193;d:1.3339;i:1639052895;d:1.6956;i:1639052642;d:1.1349;i:1639052327;d:1.5971;i:1639052003;d:1.3792;i:1639051697;d:1.4539;i:1639051411;d:1.2133;i:1639051100;d:1.1841;i:1639050804;d:0.9866;i:1639050494;d:1.0283;i:1639050207;d:1.0773;i:1639049891;d:1.1976;i:1639049598;d:1.4586;i:1639049286;d:1.4076;i:1639048999;d:0.9645;i:1639048697;d:0.9245;i:1639048412;d:0.9935;i:1639048105;d:0.9406;i:1639047809;d:1.5694;i:1639047489;d:1.123;i:1639047190;d:1.1511;i:1639046893;d:1.6268;i:1639046597;d:1.3681;i:1639046307;d:1.3647;i:1639045999;d:1.5132;i:1639045690;d:1.4012;i:1639045386;d:1.5228;i:1639045097;d:1.1235;i:1639044808;d:1.2243;i:1639044517;d:1.0031;i:1639044200;d:1.4601;i:1639043895;d:1.3614;i:1639043592;d:1.639;i:1639043280;d:1.2308;i:1639042988;d:1.3993;i:1639042692;d:1.0307;i:1639042393;d:1.3475;i:1639042092;d:1.1189;i:1639041800;d:0.9471;i:1639041489;d:1.2054;i:1639041206;d:1.0369;i:1639040898;d:1.6221;i:1639040598;d:1.0561;i:1639040299;d:1.5653;i:1639039993;d:0.9751;i:1639039685;d:1.107;i:1639039387;d:0.9838;i:1639039091;d:1.5836;i:1639038788;d:0.9286;i:1639038482;d:1.4817;i:1639038192;d:0.9858;i:1639037882;d:1.292;i:1639037584;d:1.4517;i:1639037313;d:1.1864;i:1639037000;d:0.9563;i:1639036699;d:1.2299;i:1639036387;d:1.0228;i:1639036079;d:1.0067;i:1639035778;d:1.0162;i:1639035482;d:0.9986;i:1639035180;d:1.5492;i:1639034877;d:1.205;i:1639034589;d:1.2146;i:1639034269;d:1.0924;i:1639033976;d:1.2529;i:1639033686;d:0.9743;i:1639033371;d:0.9277;i:1639033063;d:1.31;i:1639032779;d:1.0723;i:1639032482;d:1.1578;i:1639032188;d:1.1112;i:1639031889;d:1.0034;i:1639031565;d:1.3772;i:1639031262;d:1.4393;i:1639030986;d:1.4523;i:1639030671;d:1.5501;i:1639030385;d:0.9764;i:1639030088;d:1.027;i:1639029776;d:1.2643;i:1639029471;d:0.9161;i:1639029182;d:0.9357;i:1639028877;d:1.1742;i:1639028583;d:0.9179;i:1639028298;d:1.0173;i:1639027985;d:1.0002;i:1639027676;d:1.1338;i:1639027393;d:0.9432;i:1639027071;d:1.7897;i:1639026785;d:0.9138;i:1639026498;d:1.619;i:1639026175;d:0.9374;i:1639025871;d:1.3582;i:1639025585;d:0.9198;i:1639025271;d:1.0712;i:1639024981;d:0.9357;i:1639024679;d:1.235;i:1639024386;d:0.9741;i:1639024083;d:1.0316;i:1639023774;d:1.021;i:1639023483;d:0.8936;i:1639023173;d:0.874;i:1639022895;d:0.9704;i:1639022589;d:1.007;i:1639022272;d:0.9623;i:1639021969;d:1.0272;i:1639021669;d:0.9741;i:1639021376;d:1.4771;i:1639021073;d:1.4414;i:1639020782;d:1.3714;i:1639020483;d:0.915;i:1639020177;d:1.0063;i:1639019877;d:0.9327;i:1639019587;d:1.446;i:1639019299;d:1.4645;i:1639019006;d:1.2015;i:1639018682;d:1.2369;i:1639018389;d:0.9441;i:1639018087;d:1.0618;i:1639017778;d:1.1375;i:1639017495;d:1.0867;i:1639017197;d:1.0976;i:1639016880;d:1.457;i:1639016588;d:1.318;i:1639016292;d:1.21;i:1639016013;d:0.9334;i:1639015737;d:0.9882;i:1639015419;d:1.1246;i:1639015081;d:1.4158;i:1639014784;d:1.4851;i:1639014477;d:1.4641;i:1639014188;d:0.9361;i:1639013894;d:1.1872;i:1639013585;d:1.1299;i:1639013296;d:0.9074;i:1639012987;d:1.2934;i:1639012684;d:1.0299;i:1639012388;d:1.6315;i:1639012108;d:1.0255;i:1639011788;d:1.5237;i:1639011490;d:1.4744;i:1639011191;d:1.5506;i:1639010908;d:1.5049;i:1639010609;d:1.2053;i:1639010301;d:1.1705;i:1639009990;d:1.3191;i:1639009683;d:1.5936;i:1639009387;d:1.3455;i:1639009086;d:1.4427;i:1639008795;d:1.4608;i:1639008607;d:1.0993;i:1639008276;d:1.1123;i:1639007886;d:0.979;i:1639007597;d:1.3736;i:1639007280;d:1.0803;i:1639006988;d:1.3822;i:1639006694;d:1.4056;i:1639006387;d:1.3733;i:1639006078;d:1.5833;i:1639005785;d:0.9029;i:1639005482;d:0.9431;i:1639005186;d:0.9172;i:1639004890;d:1.0874;i:1639004584;d:1.012;i:1639004285;d:0.8949;i:1639003980;d:1.2649;i:1639003689;d:1.0602;i:1639003385;d:1.3551;i:1639003082;d:1.3273;i:1639002784;d:0.8845;i:1639002483;d:1.1019;i:1639002173;d:1.0147;i:1639001872;d:1.5339;i:1639001586;d:1.0752;i:1639001298;d:0.9625;i:1639000986;d:1.5084;i:1639000695;d:0.8951;i:1639000385;d:0.9981;i:1639000069;d:1.1343;}s:17:\"discovery_history\";a:100:{i:1639086338;d:4.0914;i:1639086258;d:4.5569;i:1639075489;d:4.3602;i:1639053351;d:4.8196;i:1639032104;d:4.2169;i:1639010226;d:4.754;i:1638988561;d:4.4747;i:1638966984;d:4.4439;i:1638945508;d:4.1936;i:1638923806;d:5.0894;i:1638902162;d:4.5656;i:1638880616;d:4.3282;i:1638858990;d:4.5359;i:1638837429;d:4.6414;i:1638815597;d:4.4361;i:1638794168;d:4.3891;i:1638772542;d:4.0917;i:1638750971;d:4.0319;i:1638729385;d:4.0657;i:1638707790;d:4.0868;i:1638686198;d:4.7138;i:1638664618;d:4.0976;i:1638642993;d:4.4481;i:1638621397;d:4.5799;i:1638599842;d:4.7047;i:1638578768;d:4.592;i:1638556648;d:9.0287;i:1638534983;d:4.7525;i:1638513337;d:4.0996;i:1638491762;d:4.0519;i:1638470123;d:4.1704;i:1638448565;d:4.2116;i:1638426941;d:4.0977;i:1638405364;d:4.0889;i:1638383736;d:4.0814;i:1638362139;d:4.3451;i:1638340542;d:3.906;i:1638318964;d:3.9459;i:1638297400;d:4.0696;i:1638275818;d:4.8969;i:1638254197;d:4.4674;i:1638232580;d:4.5534;i:1638210934;d:4.0217;i:1638189432;d:4.3585;i:1638167756;d:4.6665;i:1638146222;d:4.0935;i:1638124608;d:4.4877;i:1638103206;d:4.8182;i:1638081408;d:4.0862;i:1638059830;d:4.4751;i:1638038146;d:4.3962;i:1638016535;d:4.0819;i:1637994952;d:3.9381;i:1637973438;d:4.1018;i:1637951772;d:4.417;i:1637930425;d:4.6966;i:1637908603;d:4.1393;i:1637887006;d:4.557;i:1637865367;d:4.5213;i:1637843760;d:4.4872;i:1637822160;d:4.0517;i:1637800632;d:4.1531;i:1637778947;d:4.5585;i:1637757397;d:4.4513;i:1637735805;d:4.4118;i:1637714286;d:4.8443;i:1637692541;d:4.5233;i:1637670995;d:4.2105;i:1637649410;d:4.1255;i:1637627734;d:4.6453;i:1637606139;d:3.9804;i:1637584528;d:4.2291;i:1637562941;d:3.9456;i:1637541391;d:4.0169;i:1637519854;d:4.1097;i:1637498190;d:4.7831;i:1637476549;d:4.4867;i:1637454978;d:4.1673;i:1637433399;d:4.0543;i:1637411750;d:4.5544;i:1637390150;d:4.0093;i:1637368582;d:4.1075;i:1637346994;d:4.1404;i:1637325411;d:4.642;i:1637303791;d:4.5073;i:1637282140;d:4.4846;i:1637260539;d:4.0519;i:1637238930;d:4.1899;i:1637217384;d:3.919;i:1637195785;d:4.078;i:1637174124;d:4.0366;i:1637152528;d:4.2062;i:1637130944;d:3.918;i:1637109380;d:3.9836;i:1637087755;d:4.2842;i:1637066178;d:4.3516;i:1637044560;d:4.0408;i:1637022984;d:4.2607;i:1637001386;d:4.129;i:1636979836;d:4.2791;}s:18:\"discovery_mod_perf\";a:28:{s:2:\"os\";d:0.117;s:4:\"mibs\";d:0.1525;s:3:\"vrf\";d:0.0024;s:5:\"ports\";d:0.2208;s:11:\"ports-stack\";d:0.0488;s:5:\"vlans\";d:0.0023;s:11:\"ports_vlans\";N;s:4:\"oids\";d:1.3952;s:12:\"ip-addresses\";d:0.231;s:10:\"processors\";d:0.1337;s:8:\"mempools\";d:0.2132;s:9:\"inventory\";d:0.475;s:15:\"printersupplies\";d:0.0013;s:7:\"sensors\";d:0.5176;s:7:\"storage\";d:0.0014;s:10:\"neighbours\";d:0.1306;s:9:\"arp-table\";d:0.1522;s:13:\"junose-atm-vp\";d:0.0003;s:9:\"bgp-peers\";d:0.0013;s:14:\"mac-accounting\";d:0.0002;s:3:\"sla\";d:0.0633;s:11:\"pseudowires\";d:0.0466;s:16:\"virtual-machines\";d:0.0008;s:11:\"cisco-cbqos\";d:0.1002;s:10:\"ucd-diskio\";d:0.0466;s:4:\"wifi\";d:0.0026;s:10:\"p2p-radios\";d:0.0001;s:6:\"graphs\";d:0.0003;}}' WHERE `device_id` = '1009']
SQL RUNTIME[0.00180411s]
#####  n4-wkf-apic-01-cimc [1009] completed discovery modules at 2021-12-09 21:45:42  #####

 o Discovery time       4.0914 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '11400' AND `process_name` = 'discovery.php' AND `device_id` = '1009' AND `poller_id` = '0']
SQL RUNTIME[0.00175905s]
#####  Finished discovery run at 2021-12-09 21:45:42  #####


SQL[SELECT * FROM `groups` ORDER BY `entity_type`]
SQL RUNTIME[0.00077915s]

SQL[SELECT * FROM `groups_assoc`]
SQL RUNTIME[0.00028992s]
  String '10.8.8.41' transformed by action [ip-uncompress] to: '10.8.8.41'
  String '10.8.8.45' transformed by action [ip-uncompress] to: '10.8.8.45'

SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `bgpPeers`.`bgpPeerLocalAddr` = '10.8.8.41' OR `bgpPeers`.`bgpPeerLocalAddr` = '10.8.8.45')]
SQL RUNTIME[0.00145698s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '78']
SQL RUNTIME[0.00030398s]
Group         'Nottingham County Council - BGP Peers': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`location`, "") LIKE '%DC2%') OR( IFNULL(`devices`.`location`, "") LIKE '%dc2%') OR( IFNULL(`devices`.`location`, "") LIKE '%dc1%') OR( IFNULL(`devices`.`location`, "") LIKE '%DC1%') OR( IFNULL(`devices`.`location`, "") LIKE '%Derby%') OR( IFNULL(`devices`.`location`, "") LIKE '%DRY%'))]
SQL RUNTIME[0.00090885s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '7']
SQL RUNTIME[0.00024700s]
Group                               'Derby ': 26 existing, 26 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`location`, "") LIKE '%DC3%') OR( IFNULL(`devices`.`location`, "") LIKE '%WKF%') OR( IFNULL(`devices`.`location`, "") LIKE '%Wakefield%'))]
SQL RUNTIME[0.00069213s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '13']
SQL RUNTIME[0.00022602s]
Group                           'Wakefield ': 42 existing, 42 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`location`, "") LIKE '%DC4%') OR( IFNULL(`devices`.`location`, "") LIKE '%NHT%') OR( IFNULL(`devices`.`location`, "") LIKE '%Northampton%'))]
SQL RUNTIME[0.00067115s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '19']
SQL RUNTIME[0.00019884s]
Group                          'Northampton': 20 existing, 20 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`location`, "") LIKE '%THN%') OR( IFNULL(`devices`.`location`, "") LIKE '%TFM%') OR( IFNULL(`devices`.`location`, "") LIKE '%Telehouse%') OR( IFNULL(`devices`.`location`, "") LIKE '%TelehouseNorth%'))]
SQL RUNTIME[0.00067091s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '31']
SQL RUNTIME[0.00018811s]
Group                      'Telehouse North': 10 existing, 10 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`location`, "") LIKE '%MAN%') OR( IFNULL(`devices`.`location`, "") LIKE '%MA1%') OR( IFNULL(`devices`.`location`, "") LIKE '%Telecity%') OR( IFNULL(`devices`.`location`, "") LIKE '%3CD3%') OR( IFNULL(`devices`.`location`, "") LIKE '%3CD4%'))]
SQL RUNTIME[0.00073195s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '45']
SQL RUNTIME[0.00018191s]
Group               'Manchester Equinix MA1': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%480%')]
SQL RUNTIME[0.00034904s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '49']
SQL RUNTIME[0.00016379s]
Group                        'Juniper MX480': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%mx80%')]
SQL RUNTIME[0.00031900s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '51']
SQL RUNTIME[0.00015688s]
Group                         'Juniper MX80': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%MX104%')]
SQL RUNTIME[0.00035191s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '57']
SQL RUNTIME[0.00020194s]
Group                        'Juniper MX104': 11 existing, 11 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%MX240%')]
SQL RUNTIME[0.00037599s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '63']
SQL RUNTIME[0.00018787s]
Group                        'Juniper MX240': 1 existing, 1 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`hardware`, "") LIKE '%EX4200%') OR( IFNULL(`devices`.`hardware`, "") LIKE '%Virtual%'))]
SQL RUNTIME[0.00060701s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '67']
SQL RUNTIME[0.00022483s]
Group                       'Juniper EX4200': 50 existing, 50 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%mgmt%')]
SQL RUNTIME[0.00035405s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '70']
SQL RUNTIME[0.00022101s]
Group                                'MGMT ': 27 existing, 27 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%ld5%')]
SQL RUNTIME[0.00034714s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '73']
SQL RUNTIME[0.00018692s]
Group                   'LD5 Equinix Slough': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%WKF-LEAF%' OR IFNULL(`devices`.`hostname`, "") LIKE '%WKF-SPINE%' OR IFNULL(`devices`.`hostname`, "") LIKE '%WKF-UCS%' OR IFNULL(`devices`.`hostname`, "") LIKE '%WKF-APIC%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-h4-c-s%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-7k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-lf%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-3k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-n7k-admin%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-n3k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-nsx%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-compute%' OR IFNULL(`devices`.`hostname`, "") LIKE '%wkf-storage%')]
SQL RUNTIME[0.00165391s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '80']
SQL RUNTIME[0.00025392s]
Group                           'DC-3 Cloud': 34 existing, 34 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%NHT-LEAF%' OR IFNULL(`devices`.`hostname`, "") LIKE '%NHT-SPINE%' OR IFNULL(`devices`.`hostname`, "") LIKE '%NHT-UCS%' OR IFNULL(`devices`.`hostname`, "") LIKE '%NHT-APIC%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-h3-c-s%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-7k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-lf%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-n3k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%rk4425-secura-3k%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-n7k-admin%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-nsx%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-compute%' OR IFNULL(`devices`.`hostname`, "") LIKE '%nht-storage%')]
SQL RUNTIME[0.00168300s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '81']
SQL RUNTIME[0.00025487s]
Group                           'DC-4 Cloud': 42 existing, 42 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%pdu%')]
SQL RUNTIME[0.00033092s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '91']
SQL RUNTIME[0.00025296s]
Group                         'PDU Switches': 16 existing, 16 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-notts-%')]
SQL RUNTIME[0.00033808s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '106']
SQL RUNTIME[0.00020194s]
Group              'n4corp-sdwan-nottingham': 6 existing, 6 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%hscn%')]
SQL RUNTIME[0.00035596s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '116']
SQL RUNTIME[0.00020289s]
Group                         'HSCN Devices': 5 existing, 5 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` = '465' AND `devices`.`device_id` = '543')]
SQL RUNTIME[0.00018096s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '123']
SQL RUNTIME[0.00015306s]
Group                         'R3149_MAIINT': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-rdg%')]
SQL RUNTIME[0.00026894s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '128']
SQL RUNTIME[0.00023007s]
Group                 'n4corp-sdwan-reading': 7 existing, 7 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-%-edge%' OR IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-%-sw-%' OR IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-%-%-ap' OR IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-%-ap' OR `devices`.`device_id` IN ('894','895') OR `devices`.`device_id` IN ('982','872','884','893','889','885','887','888','890','891','867','886','874','875','938','939','940','941','942','943','944','892','988','869','985','984','987','990','989','986','992','991','993','878','879','978','979','980','981','983','871','996','997','882','883','973','870','995','994','881','880','976','977','868','946','950','951','947','945','948','949','877','876','952','953','954','955','956','999','998','894','895'))]
SQL RUNTIME[0.00058389s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '129']
SQL RUNTIME[0.00026703s]
Group                         'n4corp-sdwan': 73 existing, 73 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%SCC%')]
SQL RUNTIME[0.00040412s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '136']
SQL RUNTIME[0.00019908s]
Group                          'SCC Devices': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%geo-ha%')]
SQL RUNTIME[0.00037980s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '145']
SQL RUNTIME[0.00020504s]
Group                       'Geo-HA Devices': 6 existing, 6 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hardware`, "") LIKE '%EX3200-24T%')]
SQL RUNTIME[0.00061083s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '147']
SQL RUNTIME[0.00034213s]
Group                   'Juniper EX3200-24T': 20 existing, 20 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hardware`, "") LIKE '%EX4200-24T%')]
SQL RUNTIME[0.00066113s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '148']
SQL RUNTIME[0.00023508s]
Group                   'Juniper EX4200-24T': 18 existing, 18 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hardware`, "") LIKE '%SRX240%')]
SQL RUNTIME[0.00063396s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '149']
SQL RUNTIME[0.00020099s]
Group                       'Juniper SRX240': 13 existing, 13 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`vendor` = 'Cisco')]
SQL RUNTIME[0.00049996s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '150']
SQL RUNTIME[0.00030804s]
Group                        'Cisco Devices': 131 existing, 131 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4-dc1-h1-build%')]
SQL RUNTIME[0.00031090s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '151']
SQL RUNTIME[0.00029898s]
Group                 'DC1-H1 Build Network': 10 existing, 10 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%UC-ST%')]
SQL RUNTIME[0.00035810s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '156']
SQL RUNTIME[0.00018001s]
Group                      'Voice-UC-Stacks': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%DC4-H2-ST01%')]
SQL RUNTIME[0.00033808s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '158']
SQL RUNTIME[0.00020385s]
Group                         'DC4-H2-ST-01': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%HUB-ST%')]
SQL RUNTIME[0.00038600s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '160']
SQL RUNTIME[0.00019407s]
Group                           'Hub Stacks': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE (( IFNULL(`devices`.`hostname`, "") LIKE 'n4-dc1-h2-st-01' OR IFNULL(`devices`.`hostname`, "") LIKE 'n4-dry-dc2-h1-st-01' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-dc2-h2-st-0%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dc3-h1-st-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dc3-h3-st-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%transit-st%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dc4-h1-st%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dc4-h2-st%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dc4-h3-st%') AND( `devices`.`os` = 'junos'))]
SQL RUNTIME[0.00100589s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '161']
SQL RUNTIME[0.00025916s]
Group          'DC Internet Access Switches': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-dry%')]
SQL RUNTIME[0.00043201s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '166']
SQL RUNTIME[0.00028801s]
Group                   'n4corp-sdwan-derby': 20 existing, 20 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-wkf-%')]
SQL RUNTIME[0.00038099s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '167']
SQL RUNTIME[0.00019717s]
Group               'n4corp-sdwan-wakefield': 15 existing, 15 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-nht-%')]
SQL RUNTIME[0.00028992s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '168']
SQL RUNTIME[0.00018692s]
Group             'n4corp-sdwan-northampton': 18 existing, 18 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4corp-cardi-%')]
SQL RUNTIME[0.00031304s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '169']
SQL RUNTIME[0.00019288s]
Group                'n4corp-sdwan-cardinal': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('816','817','819','820','834','833','969','972','653','974','975','652'))]
SQL RUNTIME[0.00022101s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '170']
SQL RUNTIME[0.00029683s]
Group                      'n4corp-dc-infra': 12 existing, 12 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4-%-mx%')]
SQL RUNTIME[0.00038409s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '178']
SQL RUNTIME[0.00021100s]
Group                               'n4core': 30 existing, 30 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifName`, "") LIKE '%xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03936195s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '25']
SQL RUNTIME[0.00238299s]
Group                               '10Gbps': 2699 existing, 2699 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit: LINX London [20Gb]%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%Cogent Manchester [20Gb]%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%NTT [10Gb]%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit: LINX Manchester IXMAN%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit: GTT B:[20Gb] GTT Service id: GTT/00192487%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.08883905s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '37']
SQL RUNTIME[0.00029206s]
Group                 'N4-TRANSIT Aggregate': 5 existing, 5 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%20i%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04057312s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '71']
SQL RUNTIME[0.00026703s]
Group                            '20i Ports': 11 existing, 11 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: [20Gb]%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: C:Node4 B:[20Gb]%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000592%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000641%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000782%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%GTT Dark Fibre%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%CR:Gyron%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%e4/1 SM LC%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.11716819s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '72']
SQL RUNTIME[0.00031805s]
Group          'Core Network Ports Capacity': 34 existing, 34 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%dry%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000592%') OR( IFNULL(`devices`.`hostname`, "") LIKE '%dry%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000641%') OR( IFNULL(`devices`.`hostname`, "") LIKE '%dry%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000782%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.06218410s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '74']
SQL RUNTIME[0.00030804s]
Group                          'Derby 10GEs': 9 existing, 9 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%L3VPN_NOTTSCC_AZURE%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04181218s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '75']
SQL RUNTIME[0.00029016s]
Group         'Nottingham County Council - Ports': 9 existing, 9 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%servelec%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04224300s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '79']
SQL RUNTIME[0.00033593s]
Group                       'Servelec Ports': 75 existing, 75 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Cust: C:DBSYST B:1000Mb CIR:[500Mb] CT:ETH P:CIB%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04171109s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '82']
SQL RUNTIME[0.00032496s]
Group                'DB Systel 500Mbps CIB': 6 existing, 6 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%DBSYST%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04025006s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '83']
SQL RUNTIME[0.00035095s]
Group                       'DB Systel MPLS': 99 existing, 99 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-mx104-01-r3247%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%DBSYST%' AND IFNULL(`ports`.`ifName`, "") LIKE '%ae8%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04272699s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '84']
SQL RUNTIME[0.00030494s]
Group              'DB Systel MPLS WK-MX-01': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-mx104-02-r3149%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%DBSYST%' AND IFNULL(`ports`.`ifName`, "") LIKE '%ae8%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04256892s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '85']
SQL RUNTIME[0.00026703s]
Group                'DB Systel WKF-02 MPLS': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `ports`.`ifAlias` = '10GE to WKF-N7K-01 e4/5 MXGE001053' OR `ports`.`ifAlias` = 'Core: C:Node4 B:[40Gb] to WKF-MX04 ae2' OR `ports`.`ifAlias` = '10GE to WKF-N7K02 e4/5 MXGE001093') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03691792s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '86']
SQL RUNTIME[0.00030184s]
Group         'DWDM: NHT - WKF Direct Aggregate': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Redcentric%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%HSCN%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05252218s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '88']
SQL RUNTIME[0.00054193s]
Group                                 'HSCN': 209 existing, 209 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Cust: C:Virtual DCS (port1of2) B:1Gb CIR:[1000Mbps] CT:ETH P:CIB O:{ORD-17565-TQ1Z/ORD-23924-Z7H4}%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%Cust: C:Virtual DCS (port2of2) B:1Gb CIR:[1000Mbps]%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05482602s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '89']
SQL RUNTIME[0.00030804s]
Group                          'Virtual DCS': 5 existing, 5 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%NF01.S01/01%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04080892s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '90']
SQL RUNTIME[0.00033879s]
Group                                'Maint': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%NF01.S01/01%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04166913s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '97']
SQL RUNTIME[0.00035501s]
Group                         'Gyron fucked': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%hub%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04140687s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '98']
SQL RUNTIME[0.00034404s]
Group                        'Provider Hubs': 96 existing, 96 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit: Cogent%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04182506s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '99']
SQL RUNTIME[0.00024796s]
Group                       'Cogent Transit': 5 existing, 5 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE 'Transit: LINX%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03464699s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '100']
SQL RUNTIME[0.00042892s]
Group                       'LINX Aggregate': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`hostname` = 'n4-nht-leaf-01' AND IFNULL(`ports`.`ifName`, "") LIKE '%101/1/15%') OR( `devices`.`hostname` = 'n4-nht-leaf-02' AND IFNULL(`ports`.`ifName`, "") LIKE '%102/1/15%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.01127911s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '101']
SQL RUNTIME[0.00042915s]
Group                         'CSI JHC DDOS': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`hostname` = 'n4-wkf-7k-02' AND `ports`.`ifName` = 'Vlan283') OR( `devices`.`hostname` = 'n4-nht-dc4-h2-st02' AND IFNULL(`ports`.`ifName`, "") LIKE '%/0/17') OR( `devices`.`hostname` = 'n4-wkf-7k-01' AND `ports`.`ifName` = 'Vlan283')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00291014s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '102']
SQL RUNTIME[0.00033998s]
Group                      'Redeye Internet': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`hostname` = 'n4-nht-n3k-102' AND IFNULL(`ports`.`ifName`, "") LIKE '%Ethernet1/25%') OR( `devices`.`hostname` = 'n4-nht-n3k-101' AND IFNULL(`ports`.`ifName`, "") LIKE '%Ethernet1/25%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00083804s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '103']
SQL RUNTIME[0.00028706s]
Group         'CSI JHC (DDOS) CIB Ports on NHT LEAF': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%MPLS%' AND `ports`.`ifAdminStatus` = 'down') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.02137709s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '104']
SQL RUNTIME[0.00041795s]
Group                'MPLS-SW -- Free Ports': 67 existing, 67 new entries (+0/-0).

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` = '789' AND( IFNULL(`ports`.`ifAlias`, "") LIKE '%DRY-MX-02%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%DRY-MX-01%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%CAL0336016%')) OR( `devices`.`device_id` IN ('25','19') AND IFNULL(`ports`.`ifAlias`, "") LIKE '%N4-DC2-H1-HUB-ST-01%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00563312s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '105']
SQL RUNTIME[0.00032282s]
Group                      'Derby Hub Ports': 16 existing, 16 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%WBMC%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%TALKTALK L2TP Interconnect THN%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%TALKTALK DSL L2TP Interconnect MAN%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.07668686s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '107']
SQL RUNTIME[0.00034308s]
Group                         'DSL Capacity': 11 existing, 11 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%n4-thn-mx104-01-star-d5%' AND IFNULL(`ports`.`ifName`, "") LIKE '%ae3.554%') OR( IFNULL(`devices`.`hostname`, "") LIKE '%n4-man-mx80-02-ma1-3cd4%' AND IFNULL(`ports`.`ifName`, "") LIKE '%ge-1/3/6.554%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05379200s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '108']
SQL RUNTIME[0.00030613s]
Group                              'TTB DSL': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: C:Node4 B:[40Gb] to THN-MX05 ae2%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04244399s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '109']
SQL RUNTIME[0.00034094s]
Group         'DWDM: NHT - THN Direct Aggregate': 1 existing, 1 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: C:Node4 B:[20Gb] P:N4-DWDM to MAN-MX-02 ae2%' OR( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-pseudo-sw01-h2-p1-rb2%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%10GB DWDM FSPNOD4-WAK-0/1 Circuit #2 MXGE001097 to N4-MAN-PSUEDO-SW01 xe-0/1/0%') OR IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: C:Node4 CIR:[20Gb] to WKF-MX-03 ae2%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001096%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001921%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001922%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001097%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.10840106s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '110']
SQL RUNTIME[0.00035787s]
Group         'DWDM: WKF - MAN Direct Aggregate': 9 existing, 9 new entries (+0/-0).

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` = '697' AND IFNULL(`ports`.`ifName`, "") LIKE '%ssl%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00334382s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '111']
SQL RUNTIME[0.00044894s]
Group                          'WKF N4P SSL': 179 existing, 179 new entries (+0/-0).

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` = '698' AND IFNULL(`ports`.`ifName`, "") LIKE '%ssl%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00326014s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '112']
SQL RUNTIME[0.00057316s]
Group                        'NHT Forti SSL': 179 existing, 179 new entries (+0/-0).

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` = '698' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%ssl%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00295687s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '113']
SQL RUNTIME[0.00042892s]
Group                          'NHT N4P SSL': 174 existing, 174 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE000782%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04276705s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '117']
SQL RUNTIME[0.00038695s]
Group                   'KCOM 10GB DRY -NHT': 4 existing, 4 new entries (+0/-0).

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` = '698' AND `ports`.`ifType` = 'tunnel' AND IFNULL(`ports`.`ifName`, "") NOT LIKE 'ssl.%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00375414s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '118']
SQL RUNTIME[0.00071383s]
Group            'N4PROTECT_NHT_VPN_Tunnels': 477 existing, 477 new entries (+0/-0).

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` = '697' AND `ports`.`ifType` = 'tunnel' AND IFNULL(`ports`.`ifName`, "") NOT LIKE 'ssl.%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00464201s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '119']
SQL RUNTIME[0.00080609s]
Group            'N4PROTECT_WKF_VPN_Tunnels': 477 existing, 477 new entries (+0/-0).

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 ('698','697') AND `ports`.`ifType` = 'tunnel' AND IFNULL(`ports`.`ifName`, "") NOT LIKE 'ssl.%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00616503s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '120']
SQL RUNTIME[0.00104809s]
Group                'N4PROTECT_VPN_Tunnels': 954 existing, 954 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%DRY-MX%' AND IFNULL(`ports`.`ifName`, "") LIKE '%xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04603410s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '121']
SQL RUNTIME[0.00047898s]
Group                         'DRY-MX Ports': 57 existing, 57 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%SKYB%' AND( `ports`.`ifName` = 'lt-0/0/0.35' OR `ports`.`ifName` = 'lt-0/0/0.17')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04369521s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '122']
SQL RUNTIME[0.00035310s]
Group                             'Sky Bet ': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%tfm12-consl%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04188609s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '126']
SQL RUNTIME[0.00030708s]
Group                    'maitnance-console': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit: GTT%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04190397s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '130']
SQL RUNTIME[0.00034785s]
Group                    'GTT Transit Ports': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '10GE to N4-SCC-LYN-MX01 xe-0/0/1 KCOM Supplied:BT OSA BTWD201941 BTWC103762' OR IFNULL(`ports`.`ifAlias`, "") LIKE '10GE to N4-SCC-LYN-MX02 xe-0/0/1 KCOM Supplied:BT OSA BTWD201942 BTWC103760') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03565598s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '131']
SQL RUNTIME[0.00031304s]
Group                  'SCC CV-LP Aggregate': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%SAT-07-R251%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%SAT-08-R251%' OR( `devices`.`device_id` IN ('852','853') AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-100/2/0')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05924392s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '132']
SQL RUNTIME[0.00041699s]
Group                               'SAT-SW': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: C:N4CORP%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04368401s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '133']
SQL RUNTIME[0.00040412s]
Group                'corp-sdwan-core-ports': 17 existing, 17 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%geo-ha%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04208398s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '135']
SQL RUNTIME[0.00044489s]
Group                    'Port Maintenance ': 46 existing, 46 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`hostname` = 'N4-LON-MX240-01-GS1-C1' AND `ports`.`ifName` = 'xe-2/3/0') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00054407s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '137']
SQL RUNTIME[0.00041103s]
Group            'Global Switch to DRY DWDM': 1 existing, 1 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`hostname` = 'N4-DRY-MX104-05-R166' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-2/0/3') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00095415s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '138']
SQL RUNTIME[0.00023603s]
Group            'DRY to Global Switch DWDM': 1 existing, 1 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'N4-NHT-MX480-05-R4457' AND IFNULL(`ports`.`ifName`, "") LIKE 'ae2') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03308821s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '139']
SQL RUNTIME[0.00031304s]
Group                      'NHT DWDM to THN': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%ebuyer%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04225612s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '140']
SQL RUNTIME[0.00036502s]
Group                         'eBuyer Ports': 22 existing, 22 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001096%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04069591s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '141']
SQL RUNTIME[0.00028205s]
Group                         'Maintenance ': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001053%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001054%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001059%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001064%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001920%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001482%' OR IFNULL(`ports`.`ifAlias`, "") LIKE 'Core: C:Node4 B:[40Gb] to WKF-MX04 ae2' OR IFNULL(`ports`.`ifAlias`, "") LIKE 'Core: C:Node4 B:[40Gb] to NHT-MX06 ae2') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.09830594s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '142']
SQL RUNTIME[0.00030923s]
Group                'DWDM: NHT & WKF Ports': 15 existing, 15 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%CAL0313500%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04357696s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '143']
SQL RUNTIME[0.00033998s]
Group         'VMB MAN-LD5 Maint INC8001799 CAL0313500': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%NTT [10Gb]%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%NTT 10Gbs%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05220008s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '144']
SQL RUNTIME[0.00031996s]
Group                          'NTT Transit': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Minster Law%' AND IFNULL(`devices`.`hostname`, "") LIKE '%NHT%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04027820s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '146']
SQL RUNTIME[0.00030684s]
Group            'Minster Law DC3-DC4 POPIs': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%1062%' OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%1093%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%1096%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%1097%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%01343%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001921%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%0629%') OR( IFNULL(`ports`.`ifAlias`, "") LIKE '%MXGE001922%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.11647296s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '152']
SQL RUNTIME[0.00038600s]
Group                   'DWDM WKF-MA1 Ports': 18 existing, 18 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%po5%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04157186s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '153']
SQL RUNTIME[0.00032687s]
Group                           'ld5 ports ': 6 existing, 6 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `ports`.`ifAlias` = 'Core: 10GE to LINX' OR `ports`.`ifAlias` = 'Transit: LINX London [20Gb]' OR `ports`.`ifAlias` = 'Core: 10GE to LINX SFL-049883') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03823495s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '154']
SQL RUNTIME[0.00035810s]
Group                            'LINX-LON1': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%corp-fw%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%N4-CORP-WKF-FW-%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%N4-CORP-NHT-FW-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.06487894s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '155']
SQL RUNTIME[0.00039005s]
Group                        'corp-fw-ports': 31 existing, 31 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%UC-ST%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03964090s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '157']
SQL RUNTIME[0.00032711s]
Group                        'UC-Core-Ports': 12 existing, 12 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%R4209 Leaf 10%' OR IFNULL(`ports`.`ifAlias`, "") LIKE '%R4210 Leaf 10%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05464888s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '159']
SQL RUNTIME[0.00039887s]
Group                        'ACI Multisite': 4 existing, 4 new entries (+0/-0).

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 ('852','853') AND IFNULL(`ports`.`ifName`, "") LIKE 'ge-10%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%NOT-IN-USE%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00189614s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '162']
SQL RUNTIME[0.00050998s]
Group                 'Fusion ports - Derby': 310 existing, 310 new entries (+0/-0).

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 ('724','725') AND IFNULL(`ports`.`ifName`, "") LIKE 'ge-10%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%NOT-IN-USE%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00279117s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '163']
SQL RUNTIME[0.00047994s]
Group             'Fusion Ports - Wakefield': 264 existing, 264 new entries (+0/-0).

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 ('711','712') AND IFNULL(`ports`.`ifName`, "") LIKE 'ge-10%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%NOT-IN-USE%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00290084s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '164']
SQL RUNTIME[0.00046206s]
Group           'Fusion Ports - Northampton': 228 existing, 228 new entries (+0/-0).

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` = '103' AND IFNULL(`ports`.`ifName`, "") LIKE 'ge-10%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%NOT-IN-USE%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00157404s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '165']
SQL RUNTIME[0.00023413s]
Group            'Fusion Ports - Manchester': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%PC:CARDINAL%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04173112s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '171']
SQL RUNTIME[0.00036192s]
Group            'corp-sdwan-ports-cardinal': 3 existing, 3 new entries (+0/-0).

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 ('711','712') AND `ports`.`ifAdminStatus` = 'down' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00261688s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '172']
SQL RUNTIME[0.00028801s]
Group         'Capacity - MX480 10Gbps - NHT': 3 existing, 3 new entries (+0/-0).

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 ('724','725') AND `ports`.`ifAdminStatus` = 'down' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00226498s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '173']
SQL RUNTIME[0.00029206s]
Group         'Capacity - MX480 10Gbps - WKF': 4 existing, 4 new entries (+0/-0).

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 ('743','87') AND `ports`.`ifAdminStatus` = 'down' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00271416s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '174']
SQL RUNTIME[0.00031495s]
Group         'Capacity - MX480 10Gbps - THN': 4 existing, 4 new entries (+0/-0).

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` = '103' AND `ports`.`ifAdminStatus` = 'down' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00170994s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '175']
SQL RUNTIME[0.00032997s]
Group         'Capacity - MX480 10Gbps - MAN': 1 existing, 1 new entries (+0/-0).

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` = '692' AND IFNULL(`ports`.`ifName`, "") LIKE 'xe-%' AND `ports`.`ifAdminStatus` = 'down') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00061297s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '176']
SQL RUNTIME[0.00021410s]
Group         'Capacity - EX4550 10Gbps - DRY': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE 'n4%mx%' AND `ports`.`ifType` IN ('l2vlan','propVirtual') AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Cust: C:Stagecoach%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04388118s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '177']
SQL RUNTIME[0.00065017s]
Group                   'StagecoachCircuits': 323 existing, 323 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%BDJY1577%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04562497s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '179']
SQL RUNTIME[0.00029588s]
Group                            'L3 10Gbps': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Starcom NNI%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04086208s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '180']
SQL RUNTIME[0.00034618s]
Group                          'Starcom NNI': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `sla_id`, `devices`.`device_id` as `device_id` FROM `slas` LEFT JOIN `devices` ON (`slas`.`device_id` = `devices`.`device_id`) WHERE ( `slas`.`sla_owner` = 'L3VPN_NOTTSCC_AZURE') AND `slas`.`deleted` != '1']
SQL RUNTIME[0.00060916s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '77']
SQL RUNTIME[0.00031400s]
Group         'Nottingham County Council - RPM': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%ld5-mx-02%' AND `status`.`status_descr` = 'PEM 2') AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00225687s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '87']
SQL RUNTIME[0.00022602s]
Group                            'PSU Maint': 0 existing, 0 new entries (+0/-0).

SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00057006s]
Cached 88 alert rules.

SQL[SELECT * FROM `alert_assoc`]
SQL RUNTIME[0.00028992s]

SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1)))]
SQL RUNTIME[0.00331497s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '19']
SQL RUNTIME[0.01132798s]
Alert Checker 'BGP Peer Down (General)_PD-NET-WARN': 2909 existing, 2909 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'cust'))) AND `deleted` != '1']
SQL RUNTIME[0.06945515s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '25']
SQL RUNTIME[0.01236486s]
Alert Checker 'Customer Duplex Alert_PD-CUST-WARN': 3494 existing, 3494 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND IFNULL(`devices`.`hostname`, "") LIKE '%mx%') AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%PEM%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00291681s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '37']
SQL RUNTIME[0.00051594s]
Alert Checker 'Juniper PSU Check PEM1-2_PD-NET-CRITICAL': 77 existing, 77 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '67']
SQL RUNTIME[0.00035405s]

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`device_id` IN ('369','445','465','489','523','529','531','559','565','627','634','640','643','644','647','681','682','683','684','685','686','687','689','690','691','723','766','767','768','772','773','774','778','789','797','799','816','817','821','822','823','831','832','841','842','843','896','900','1016','1017')) AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%power supply%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00239015s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '43']
SQL RUNTIME[0.00073099s]
Alert Checker 'EX4200 PSU Alerter_PD-NET-CRITICAL': 140 existing, 140 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'cust'))) AND `deleted` != '1']
SQL RUNTIME[0.06339884s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '55']
SQL RUNTIME[0.01203418s]
Alert Checker 'Customer Port Down_PD-CUST-WARN': 3494 existing, 3494 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%routing engine%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00737906s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '69']
SQL RUNTIME[0.00085783s]
Alert Checker 'Routing Engine Failure_PD-NET-CRITICAL (NOT WORKING)': 182 existing, 182 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%fan%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00687885s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '79']
SQL RUNTIME[0.00348592s]
Alert Checker 'Fan Failure Alert_PD-NET-ERROR': 830 existing, 830 new entries (+0/-0).

SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `sensor_class` = 'temperature' AND IFNULL(`sensor_descr`, "") LIKE '%xe-%'))) AND `sensor_deleted` != '1']
SQL RUNTIME[0.01318502s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '93']
SQL RUNTIME[0.00178099s]
Alert Checker 'SFP High Temperature_PD-NET-ERROR': 363 existing, 363 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `port_descr_type` = 'cust'))) AND `deleted` != '1']
SQL RUNTIME[0.06488705s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '103']
SQL RUNTIME[0.01245904s]
Alert Checker 'Customer Port MTU Alert_PD-NET-WARN': 3494 existing, 3494 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`ifName`, "") LIKE '%xe-%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up' AND IFNULL(`ifName`, "") NOT LIKE '%32767%' AND `port_descr_type` = 'core'))) AND `deleted` != '1']
SQL RUNTIME[0.07805681s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '115']
SQL RUNTIME[0.00128889s]
Alert Checker 'Core Port MTU Alerter_PD-NET-INFO': 276 existing, 276 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`ifName`, "") LIKE '%ae%' AND IFNULL(`ifAlias`, "") LIKE '%MPLS-SW%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up'))) AND `deleted` != '1']
SQL RUNTIME[0.08059692s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '121']
SQL RUNTIME[0.00050497s]
Alert Checker 'MPLS Switch MTU Alerter_PD-NET-WARN': 46 existing, 46 new entries (+0/-0).

SQL[SELECT `storage_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `storage` LEFT JOIN `devices` ON (`storage`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1))) AND `storage_deleted` != '1']
SQL RUNTIME[0.00259995s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '123']
SQL RUNTIME[0.00302601s]
Alert Checker 'Low Storage Alert_PD-NET-WARN': 875 existing, 875 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `port_descr_type` = 'cust'))) AND `deleted` != '1']
SQL RUNTIME[0.06074691s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '127']
SQL RUNTIME[0.01355100s]
Alert Checker 'Customer Port Saturation_PD-NET-WARN': 3494 existing, 3494 new entries (+0/-0).

SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `bgpPeerRemoteAs` = '31727')) OR (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `bgpPeerRemoteAs` = '65001')))]
SQL RUNTIME[0.00398397s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '129']
SQL RUNTIME[0.00203395s]
Alert Checker 'Node4 iBGP Alert_PD-NET-CRITICAL': 506 existing, 506 new entries (+0/-0).

SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `bgpPeerRemoteAs` = '8714')))]
SQL RUNTIME[0.00174713s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '133']
SQL RUNTIME[0.00027514s]
Alert Checker 'LINX / MANIX Route Server Alert_PD-NET-ERROR': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `bgpPeerRemoteAs` = '174')))]
SQL RUNTIME[0.00165200s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '135']
SQL RUNTIME[0.00025821s]
Alert Checker 'Cogent BGP Alert_PD-NET-ERROR': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `bgpPeerRemoteAs` = '2914')))]
SQL RUNTIME[0.00124311s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '151']
SQL RUNTIME[0.00022697s]
Alert Checker   'NTT BGP Alert_PD-NET-ERROR': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`hardware` = 'N7K-C7004') AND ( 1 AND IFNULL(`ifName`, "") LIKE '%ethernet%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up'))) AND `deleted` != '1']
SQL RUNTIME[0.00324512s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '153']
SQL RUNTIME[0.00109506s]
Alert Checker 'Nexus 7K MTU Alert_PD-SDN-WARN': 233 existing, 233 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '67']
SQL RUNTIME[0.00040817s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '67']
SQL RUNTIME[0.00029612s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '67']
SQL RUNTIME[0.00033092s]

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`hardware` = 'EX3200-24T') AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%L2VPN%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`device_id` IN ('369','445','465','489','523','529','531','559','565','627','634','640','643','644','647','681','682','683','684','685','686','687','689','690','691','723','766','767','768','772','773','774','778','789','797','799','816','817','821','822','823','831','832','841','842','843','896','900','1016','1017')) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%L2VPN%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`hardware` = 'EX3200-24T') AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%POP%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`hardware` = 'EX3200-24T') AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%WKF-to-DRY%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`hardware` = 'EX3200-24T') AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%VLAN-CCC%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`device_id` IN ('369','445','465','489','523','529','531','559','565','627','634','640','643','644','647','681','682','683','684','685','686','687','689','690','691','723','766','767','768','772','773','774','778','789','797','799','816','817','821','822','823','831','832','841','842','843','896','900','1016','1017')) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%ETH-CCC%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`hardware` = 'EX3200-24T') AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%Interconnect%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up')) OR (( 1 AND `devices`.`device_id` IN ('369','445','465','489','523','529','531','559','565','627','634','640','643','644','647','681','682','683','684','685','686','687','689','690','691','723','766','767','768','772','773','774','778','789','797','799','816','817','821','822','823','831','832','841','842','843','896','900','1016','1017')) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%Interconnect%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up'))) AND `deleted` != '1']
SQL RUNTIME[0.03134608s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '157']
SQL RUNTIME[0.00046206s]
Alert Checker    'CCC MTU Alert_PD-NET-INFO': 35 existing, 35 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%alarm%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00721002s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '158']
SQL RUNTIME[0.00113893s]
Alert Checker 'Juniper Alarm Checker_PD-NET-WARN': 252 existing, 252 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `port_descr_type` = 'transit'))) AND `deleted` != '1']
SQL RUNTIME[0.06029010s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '159']
SQL RUNTIME[0.00053310s]
Alert Checker 'Transit Port Saturation_PD-NET-ERROR': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `port_descr_type` = 'core'))) AND `deleted` != '1']
SQL RUNTIME[0.06577897s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '160']
SQL RUNTIME[0.00315714s]
Alert Checker 'Core Port Down_PD-NET-CRITICAL': 776 existing, 776 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`ifName`, "") LIKE '%xe-%' AND `ifAdminStatus` = 'up' AND `ifOperStatus` = 'up' AND IFNULL(`ifName`, "") NOT LIKE '%32767%'))) AND `deleted` != '1']
SQL RUNTIME[0.08449697s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '165']
SQL RUNTIME[0.00900698s]
Alert Checker 'Xe 10Gb Port Down_PD-NET-ERROR': 2380 existing, 2380 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`os` = 'asa') AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%primary%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00102592s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '166']
SQL RUNTIME[0.00026894s]
Alert Checker 'Cisco ASA HA Failure_PD-NET-ERROR': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `oid_entry_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `oids` USING (`oid_id`) LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `oid_name` = 'fgHaStatsSyncStatus')))]
SQL RUNTIME[0.00056887s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '167']
SQL RUNTIME[0.00034094s]
Alert Checker 'Fortigate HA out of sync _PD-NET-CRITICAL': 30 existing, 30 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%#DDOS-PROTECTED%'))) AND `deleted` != '1']
SQL RUNTIME[0.07013178s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '168']
SQL RUNTIME[0.00050092s]
Alert Checker 'DDoS Protected Customer DDoS Event_PD-CUST-CRITICAL': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%DDOS:Y%'))) AND `deleted` != '1']
SQL RUNTIME[0.08272505s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '169']
SQL RUNTIME[0.00053191s]
Alert Checker 'DDoS Protected Customer_PD-CUST-CRITICAL': 62 existing, 62 new entries (+0/-0).

SQL[SELECT `status_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`os` = 'asa') AND ( 1 AND IFNULL(`status_descr`, "") LIKE '%primary%'))) AND `status_deleted` != '1']
SQL RUNTIME[0.00076199s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '171']
SQL RUNTIME[0.00026798s]
Alert Checker 'Cisco ASA HA Secondary Active_PD-NET-ERROR': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `oid_entry_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `oids` USING (`oid_id`) LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`hardware` = 'Virtual') AND ( 1 AND `oid_name` = 'jnxFruState')))]
SQL RUNTIME[0.00097990s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '174']
SQL RUNTIME[0.00020194s]
Alert Checker 'Juniper VC Switch Failure_PD-NET-CRITICAL': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`ifAlias`, "") LIKE '%DBSYSTEL%'))) AND `deleted` != '1']
SQL RUNTIME[0.07400703s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '175']
SQL RUNTIME[0.00035906s]
Alert Checker 'Cust DBSYSTEL 10GB DOWN_PD-CUST-CRITICAL': 31 existing, 31 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%fgt%') AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00151420s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '177']
SQL RUNTIME[0.00023413s]
Alert Checker 'N4Protect Resource Check_PD-NET-CRITICAL': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") LIKE '%office%' OR IFNULL(`devices`.`sysname`, "") LIKE '%lon-mpls%' OR IFNULL(`devices`.`sysname`, "") LIKE '%notts-mpls%' OR IFNULL(`devices`.`sysname`, "") LIKE '%rdg-mpls%' OR IFNULL(`devices`.`sysname`, "") LIKE '%dry-cardi-mpls%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-ftp-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-netprov-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-ftp-01%      ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-ipam-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-rad-02%  ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-netflow-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-rad-db-03%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-rad-db-04%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-ipam-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-ftp-01%        ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-ftp-02%      ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-rad-01%      ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-rad-db-01% ' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-rad-db-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%pdu%')]
SQL RUNTIME[0.00276995s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '178']
SQL RUNTIME[0.00039291s]
Alert Checker     'Device Down_PD-NET-ERROR': 24 existing, 24 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00038409s]

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-wkf-draas-vsrx-if-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%ftp%' AND IFNULL(`devices`.`hostname`, "") LIKE '%' AND `devices`.`device_id` NOT IN ('788','894'))]
SQL RUNTIME[0.00240898s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '179']
SQL RUNTIME[0.00345302s]
Alert Checker     'High CPU_PD-NET-CRITICAL': 960 existing, 960 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81','129')]
SQL RUNTIME[0.00048208s]

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`device_id` IN ('788','787') AND IFNULL(`mempools`.`mempool_descr`, "") NOT LIKE '%Physical Memory%') OR( `devices`.`device_id` NOT IN ('788','787','183') AND `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008','867','868','869','870','871','872','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','973','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1014') AND IFNULL(`mempools`.`mempool_descr`, "") NOT LIKE '%MEMPOOL%')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00298500s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '181']
SQL RUNTIME[0.00255203s]
Alert Checker 'High Memory _PD-NET-CRITICAL': 712 existing, 712 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%lon-mpls%' OR IFNULL(`devices`.`hostname`, "") LIKE '%notts-mpls%' OR IFNULL(`devices`.`hostname`, "") LIKE '%rdg-mpls%' OR IFNULL(`devices`.`hostname`, "") LIKE '%dry-cardi-mpls%' OR IFNULL(`devices`.`hostname`, "") LIKE '%mcast%' OR IFNULL(`devices`.`hostname`, "") LIKE '%office%')]
SQL RUNTIME[0.00096703s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '183']
SQL RUNTIME[0.00026512s]
Alert Checker 'Device Has Rebooted_PD-NET-ERROR': 0 existing, 0 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '68']
SQL RUNTIME[0.00025702s]

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `sensors`.`sensor_class` = 'temperature' AND( IFNULL(`sensors`.`sensor_descr`, "") NOT LIKE '%module-4%' AND IFNULL(`sensors`.`sensor_descr`, "") NOT LIKE '%Module-1, Carmel-5%' AND IFNULL(`sensors`.`sensor_descr`, "") NOT LIKE '%xe-%' AND IFNULL(`sensors`.`sensor_descr`, "") NOT LIKE '%Sugarbowl%' AND 1 AND IFNULL(`devices`.`hostname`, "") NOT LIKE 'n4-nht-geo-ha-st-ex4300-02-r4403')) AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.01409316s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '184']
SQL RUNTIME[0.00564218s]
Alert Checker 'High Temperature Alert_PD-NET-Critical': 1574 existing, 1574 new entries (+0/-0).
  String '155.231.241.1' transformed by action [ip-uncompress] to: '155.231.241.1'
  String '155.231.241.2' transformed by action [ip-uncompress] to: '155.231.241.2'

SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `bgpPeers`.`bgpPeerLocalAddr` = '155.231.241.1' OR `bgpPeers`.`bgpPeerLocalAddr` = '155.231.241.2')]
SQL RUNTIME[0.00138903s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '186']
SQL RUNTIME[0.00022483s]
Alert Checker         'HSCN_PD-NET-CRITICAL': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%fgt%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.02863407s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '187']
SQL RUNTIME[0.01004386s]
Alert Checker 'N4Protect Critical Interfaces_PD-NET-CRITICAL': 2628 existing, 2628 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") NOT LIKE 'n4-wkf-h4-c-s-rk-3539-lf-a')]
SQL RUNTIME[0.00052190s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '189']
SQL RUNTIME[0.00186992s]
Alert Checker            'High Latency ICMP': 423 existing, 423 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") NOT LIKE 'n4-nht-ucs-fi-b' AND IFNULL(`devices`.`hostname`, "") NOT LIKE 'n4-nht-ucs-fi-a')]
SQL RUNTIME[0.00064802s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '190']
SQL RUNTIME[0.00181985s]
Alert Checker            'High Latency SNMP': 422 existing, 422 new entries (+0/-0).

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 ('698','697') AND( `ports`.`ifIndex` = '31' OR `ports`.`ifIndex` = '38' OR `ports`.`ifIndex` = '37' OR `ports`.`ifIndex` = '32')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00049305s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '191']
SQL RUNTIME[0.00026917s]
Alert Checker 'N4P Port Errors_PD-NET-ERROR': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`mempools`.`mempool_descr`, "") LIKE '%SPC%') AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00090599s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '192']
SQL RUNTIME[0.00031805s]
Alert Checker 'SRX SPC High Usage Checker - PD-NET-ERROR': 27 existing, 27 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%srx%' AND `oids`.`oid_descr` = 'SRX SPU Current Flow Session')]
SQL RUNTIME[0.00041699s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '197']
SQL RUNTIME[0.00028896s]
Alert Checker 'SRX SPU Session Count - PD-NET-CRITICAL ': 22 existing, 22 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '129']
SQL RUNTIME[0.00030398s]

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`vendor` = 'Fortinet' AND IFNULL(`devices`.`hardware`, "") LIKE '%Fortigate%' AND `devices`.`device_id` NOT IN ('698','788','697','787') AND `devices`.`device_id` NOT IN ('867','868','869','870','871','872','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','973','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1014')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00144291s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '198']
SQL RUNTIME[0.00022221s]
Alert Checker 'Fortigatge Conserve Mode Warning - PD-NET-WARN': 6 existing, 6 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `devices`.`os` = 'nxos' AND IFNULL(`devices`.`hostname`, "") LIKE '%ADMIN%' AND `oids`.`oid_name` = 'ciscoVdcResUsed')]
SQL RUNTIME[0.00042391s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '199']
SQL RUNTIME[0.00023913s]
Alert Checker 'N7k-VDC-Res-Used-u4route-mem - PD-SDN-CRITICAL': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Core: [%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04287696s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '200']
SQL RUNTIME[0.00101709s]
Alert Checker 'Core port down - PD-NET-CRITICAL': 183 existing, 183 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '68']
SQL RUNTIME[0.00024080s]

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `sensors`.`sensor_class` = 'temperature' AND( 0)) AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00017691s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '202']
SQL RUNTIME[0.00020099s]
Alert Checker 'High Temperature Alert 65c Corp_PD-NET-Critical': 0 existing, 0 new entries (+0/-0).

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `sensors`.`sensor_class` = 'temperature' AND( IFNULL(`sensors`.`sensor_descr`, "") LIKE '%CPU1CORE%' OR IFNULL(`sensors`.`sensor_descr`, "") LIKE '%routing%') AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dry-cardi-mpls-srx-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%geo-ha%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dc4-h2-st-01-r4236%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dc3-h2-transit-st01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dc3-h1-st-01-r3149%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dc4-h1-st-01-r4019%') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.01183820s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '205']
SQL RUNTIME[0.00108600s]
Alert Checker 'Routing Engine High Temperature 55c_PD-NET-CRITICAL': 267 existing, 267 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-02%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/46')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03239489s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '209']
SQL RUNTIME[0.00028086s]
Alert Checker 'Core Port Down-7K-Orphan-PD-SDN-CRITICAL ': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ((( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-02%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/4' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/5')) OR(( IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-03%') AND( `ports`.`ifName` = 'Ethernet1/43' OR `ports`.`ifName` = 'Ethernet1/44')) OR(( IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-04%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/45' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/46'))) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05115485s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '210']
SQL RUNTIME[0.00037694s]
Alert Checker 'Core Port Down-7K-PD-SDN-CRITICAL ': 12 existing, 12 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-02%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/19')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03327203s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '212']
SQL RUNTIME[0.00025916s]
Alert Checker 'Core Port Down-N4P-PD-SDN-CRITICAL ': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ((( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-03%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-04%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/47' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/48' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/21' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/22')) OR(( IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-03%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-04%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/47' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/48' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/33' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/34'))) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05989194s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '213']
SQL RUNTIME[0.00081587s]
Alert Checker 'Core Port Down-POD-PD-SDN-CRITICAL ': 16 existing, 16 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-wkf-leaf-02%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-01%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-nht-leaf-02%') AND( IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/6' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/7' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/8' OR IFNULL(`ports`.`ifName`, "") LIKE 'Ethernet1/9')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04553509s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '215']
SQL RUNTIME[0.00036788s]
Alert Checker 'Core Port Down-UCS-PD-SDN-CRITICAL ': 16 existing, 16 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00036383s]

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008'))]
SQL RUNTIME[0.00040102s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '216']
SQL RUNTIME[0.00054407s]
Alert Checker  'Device Down_PD-SDN-CRITICAL': 76 existing, 76 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00037503s]

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00111604s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '217']
SQL RUNTIME[0.00067401s]
Alert Checker 'High Memory _PD-SDN-CRITICAL': 105 existing, 105 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00034595s]

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND `devices`.`hostname` != 'n4-wkf-leaf-01' AND `devices`.`hostname` != 'n4-wkf-leaf-02') AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00117588s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '218']
SQL RUNTIME[0.00069904s]
Alert Checker    'High Memory _PD-SDN-ERROR': 103 existing, 103 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00040197s]

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND `sensors`.`sensor_class` = 'temperature' AND IFNULL(`sensors`.`sensor_descr`, "") NOT LIKE '%module-4%') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00552201s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '219']
SQL RUNTIME[0.00372100s]
Alert Checker 'High Temperature Alert_PD-SDN-WARN': 939 existing, 939 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00037813s]

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008'))]
SQL RUNTIME[0.00094986s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '220']
SQL RUNTIME[0.00056696s]
Alert Checker        'High CPU_PD-SDN-ERROR': 105 existing, 105 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00027800s]

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008'))]
SQL RUNTIME[0.00086117s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '222']
SQL RUNTIME[0.00054002s]
Alert Checker     'High CPU_PD-SDN-CRITICAL': 105 existing, 105 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81','129')]
SQL RUNTIME[0.00040984s]

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`device_id` IN ('788','787') AND IFNULL(`mempools`.`mempool_descr`, "") NOT LIKE '%Physical Memory%') OR( `devices`.`device_id` NOT IN ('788','787') AND `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008','867','868','869','870','871','872','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','973','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1014') AND IFNULL(`mempools`.`mempool_descr`, "") NOT LIKE '%MEMPOOL%')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00313711s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '226']
SQL RUNTIME[0.00249100s]
Alert Checker     'High Memory _PD-NET-WARN': 716 existing, 716 new entries (+0/-0).

SQL[SELECT `cbgp_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers_cbgp` LEFT JOIN `devices` ON (`bgpPeers_cbgp`.`device_id` = `devices`.`device_id`) LEFT JOIN `bgpPeers` USING (`bgpPeer_id`) WHERE ( IFNULL(`bgpPeers`.`bgpPeerRemoteAddr`, "") LIKE '148.253.130.105' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAddr`, "") LIKE '148.253.130.107' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAddr`, "") LIKE '148.253.130.109' OR IFNULL(`bgpPeers`.`bgpPeerRemoteAddr`, "") LIKE '148.253.130.111')]
SQL RUNTIME[0.00686216s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '231']
SQL RUNTIME[0.00032711s]
Alert Checker 'Servelec Healthcare - Prefix Limit - PD-NET-WARN': 4 existing, 4 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00038099s]

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") NOT LIKE '%office%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%mcast%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%lon-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%notts-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%rdg-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%dry-cardi-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-ftp-02%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-netprov-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-ftp-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-ipam-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-rad-02%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-netflow-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-rad-db-03%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%wkf-rad-db-04%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-ipam-02%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-ftp-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-ftp-02%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-rad-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-rad-db-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%nht-rad-db-02%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%pdu%' AND `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dry-console-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-nht-h2-mpls-sw-04%')]
SQL RUNTIME[0.00346899s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '233']
SQL RUNTIME[0.00143099s]
Alert Checker  'Device Down_PD-NET-CRITICAL': 318 existing, 318 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81','129')]
SQL RUNTIME[0.00033903s]

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") NOT LIKE '%office%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%mcast%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%lon-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%notts-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%rdg-mpls%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%dry-cardi-mpls%' AND `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008','867','868','869','870','871','872','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','973','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1014') AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-ma1-ups-%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-dry-console-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-nht-mx104-02-r4020%')]
SQL RUNTIME[0.00196385s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '234']
SQL RUNTIME[0.00110888s]
Alert Checker 'Device Has Rebooted_PD-NET-CRITICAL': 272 existing, 272 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00029397s]

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008'))]
SQL RUNTIME[0.00040603s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '235']
SQL RUNTIME[0.00047898s]
Alert Checker 'Device Has Rebooted_PD-SDN-CRITICAL': 76 existing, 76 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00032687s]

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` NOT IN ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%n4-wkf-draas-vsrx-if-01%' AND IFNULL(`devices`.`hostname`, "") NOT LIKE '%ftp%' AND IFNULL(`devices`.`hostname`, "") LIKE '%' AND `devices`.`device_id` NOT IN ('788','894'))]
SQL RUNTIME[0.00219989s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '236']
SQL RUNTIME[0.00327611s]
Alert Checker        'High CPU_PD-NET-ERROR': 960 existing, 960 new entries (+0/-0).

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 ('635','638') AND( `ports`.`ifName` = 'port Ethernet 1/1' OR `ports`.`ifName` = 'port Ethernet 1/2' OR `ports`.`ifName` = 'port Ethernet 1/3' OR `ports`.`ifName` = 'port Ethernet 1/4')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00105095s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '237']
SQL RUNTIME[0.00028205s]
Alert Checker 'Core port down BRAS - PD-NET-CRITICAL': 8 existing, 8 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`port_descr_type` = 'cust') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.06416297s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '238']
SQL RUNTIME[0.01278806s]
Alert Checker 'Customer port high non-unicast pps - PD-NET-CRITICAL': 3541 existing, 3541 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `oids`.`oid_descr` = 'MX Routing Engine 1 State')]
SQL RUNTIME[0.00052094s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '242']
SQL RUNTIME[0.00042319s]
Alert Checker 'MX Routing Engine 1_PD-NET-CRITICAL': 20 existing, 20 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `oids`.`oid_descr` = 'MX Routing Engine 0 State')]
SQL RUNTIME[0.00052094s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '243']
SQL RUNTIME[0.00032711s]
Alert Checker 'MX Routing Engine 0_PD-NET-CRITICAL': 20 existing, 20 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `devices`.`device_id` IN ('846','847') AND IFNULL(`oids`.`oid_descr`, "") LIKE 'UPS - No. Alarms Present')]
SQL RUNTIME[0.00097203s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '245']
SQL RUNTIME[0.00024700s]
Alert Checker 'MA1 UPS Alarm - PD-NET-CRITICAL': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `devices`.`device_id` IN ('846','847') AND IFNULL(`oids`.`oid_descr`, "") LIKE 'UPS - Seconds on battery power')]
SQL RUNTIME[0.00067091s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '246']
SQL RUNTIME[0.00024390s]
Alert Checker 'MA1 UPS On Battery Power - PD-NET-CRITICAL': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`devices`.`hostname`, "") LIKE '%mx104%' OR IFNULL(`devices`.`hostname`, "") LIKE '%mx480%') AND IFNULL(`status`.`status_descr`, "") LIKE 'SD% %Power Supply%') AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00250101s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '247']
SQL RUNTIME[0.00043297s]
Alert Checker 'Juniper MX Fusion Switch PSU PD-NET-CRITICAL': 56 existing, 56 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%Transit:%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04348898s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '248']
SQL RUNTIME[0.00060892s]
Alert Checker 'Transit Port Down_PD-NET-CRITICAL': 14 existing, 14 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00033188s]

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 ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND IFNULL(`ports`.`ifAlias`, "") LIKE '%CoreSDN:%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.02877498s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '250']
SQL RUNTIME[0.00092101s]
Alert Checker 'CoreSDN Port Down_PD-SDN-CRITICAL': 137 existing, 137 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00036192s]
  String '10000000000' transformed by action [units] to: '10000000000'

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 ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND `ports`.`ifSpeed` = '10000000000') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03326702s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '252']
SQL RUNTIME[0.02794790s]
Alert Checker 'CoreSDN Port Saturation 10Gb_PD-NET-ERROR': 7768 existing, 7768 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('80','81')]
SQL RUNTIME[0.00042701s]
  String '1000000000' transformed by action [units] to: '1000000000'

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 ('129','135','139','145','277','285','289','295','297','393','397','577','583','731','732','757','758','764','765','769','770','791','792','844','845','905','906','1009','1010','1011','1018','1019','1020','1021','109','111','117','127','303','309','604','605','655','656','701','745','746','747','748','749','750','751','752','759','760','762','763','771','824','825','826','827','829','830','839','840','864','865','866','903','904','967','968','1006','1007','1008') AND `ports`.`ifSpeed` = '1000000000') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.02919483s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '253']
SQL RUNTIME[0.00561810s]
Alert Checker 'CoreSDN Port Saturation 1Gb_PD-NET-ERROR': 1532 existing, 1532 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('698','697')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00044608s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '255']
SQL RUNTIME[0.00021005s]
Alert Checker 'N4P Conserve Mode Warning - PD-NET-WARN': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE (( `devices`.`type` = 'network' AND `sensors`.`sensor_class` = 'temperature') AND( IFNULL(`sensors`.`sensor_descr`, "") LIKE '%CPU1CORE%' OR IFNULL(`sensors`.`sensor_descr`, "") LIKE '%routing%') AND( IFNULL(`devices`.`hostname`, "") LIKE '%geo-ha%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-dc3-h1-st-01-r3149%' OR IFNULL(`devices`.`hostname`, "") LIKE '%n4-dc4-h1-st-01-r4019%')) AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00123310s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '256']
SQL RUNTIME[0.00025916s]
Alert Checker 'Routing Engine High Temperature 70c_PD-NET-CRITICAL': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `cbgp_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers_cbgp` LEFT JOIN `devices` ON (`bgpPeers_cbgp`.`device_id` = `devices`.`device_id`) LEFT JOIN `bgpPeers` USING (`bgpPeer_id`) WHERE (( `bgpPeers_cbgp`.`safi` = 'unicast' AND( `bgpPeers`.`bgpPeerRemoteAddr` = '109.234.204.54' OR `bgpPeers`.`bgpPeerRemoteAddr` = '89.248.48.50')))]
SQL RUNTIME[0.00585103s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '259']
SQL RUNTIME[0.00022817s]
Alert Checker 'VIANET_AZURE_BGP_PEERS_PD-NET-ERROR': 2 existing, 2 new entries (+0/-0).

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_descr_type` = 'core' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%Core: Agg Eth ae2 to N4-LD5-N5K-%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.03570604s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '261']
SQL RUNTIME[0.00273514s]
Alert Checker 'Core Port Saturation_PD-NET-ERROR': 800 existing, 800 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") LIKE '%core%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04542613s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '263']
SQL RUNTIME[0.00379491s]
Alert Checker 'Core Port Errors Crit_PD-NET-CRITICAL': 1141 existing, 1141 new entries (+0/-0).

SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`os` = 'asa' AND IFNULL(`status`.`status_descr`, "") LIKE '%Secondary%') AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00061107s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '264']
SQL RUNTIME[0.00025105s]
Alert Checker 'Cisco ASA HA Secondary Failure PD-NET-ERROR': 8 existing, 8 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '129']
SQL RUNTIME[0.00036716s]

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('867','868','869','870','871','872','874','875','876','877','878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','973','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1014'))]
SQL RUNTIME[0.00045705s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '268']
SQL RUNTIME[0.00148797s]
Alert Checker     'n4corp-sdwan-device-down': 73 existing, 73 new entries (+0/-0).

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 ('852','853','103','711','712','743','87','724','725') AND IFNULL(`ports`.`ifName`, "") LIKE 'ge-10%/%/%' AND IFNULL(`ports`.`ifName`, "") NOT LIKE 'ge-10%/%/%.%') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00994587s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '270']
SQL RUNTIME[0.00423503s]
Alert Checker           'Fusion MTU Checker': 1183 existing, 1183 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`ports`.`ifName`, "") LIKE '%xe-%' AND IFNULL(`ports`.`ifName`, "") NOT LIKE '%32767%' AND `ports`.`ifAdminStatus` = 'up') AND( IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%ETBA12823466%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 xe-1/0/11%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 xe-0/0/11%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 ae%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.05418706s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '272']
SQL RUNTIME[0.00834799s]
Alert Checker 'Xe Error Checker_PD-NET-WARN': 2475 existing, 2475 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%-hub-%')]
SQL RUNTIME[0.00053120s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '273']
SQL RUNTIME[0.00032210s]
Alert Checker 'Nearing System MAC Address Limit': 3 existing, 3 new entries (+0/-0).

SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE (( IFNULL(`ports`.`ifAlias`, "") LIKE '%core%') AND( IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%ETBA12823466%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 xe-1/0/11%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 xe-0/0/11%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%N4-DRY-DC2-H1-EX4550-ST-01 ae%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%Core: [2Gb] Agg-Eth Uplink to N4-WKF-MX-02 ae10%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%Core: [1Gb] Agg-Eth (ae1) Uplink to N4-WKF-MX-02 ge-0/2/5 (ae10)%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%Core: [1Gb] Agg-Eth (ae1) Uplink to N4-WKF-MX-02 ge-0/3/1 (ae10)%')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.04866695s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '274']
SQL RUNTIME[0.00414801s]
Alert Checker 'Core Port Errors_PD-NET-WARN': 1134 existing, 1134 new entries (+0/-0).

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` = '726' AND( IFNULL(`ports`.`ifName`, "") LIKE '%1/0/3' OR IFNULL(`ports`.`ifName`, "") LIKE '%2/0/3')) OR( `devices`.`device_id` = '727' AND( IFNULL(`ports`.`ifName`, "") LIKE '%1/0/3' OR IFNULL(`ports`.`ifName`, "") LIKE '%2/0/3' OR IFNULL(`ports`.`ifName`, "") LIKE '%1/0/31' OR IFNULL(`ports`.`ifName`, "") LIKE '%2/0/31'))) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00099587s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '276']
SQL RUNTIME[0.00025511s]
Alert Checker   'N4engage SBC port high pps': 6 existing, 6 new entries (+0/-0).
./discovery.php: n4-wkf-apic-01-cimc - 1 devices discovered in 4.476 secs
Log file '/home/observium/logs/observium.log' is not writable, check file permissions.

SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1639071938']
SQL RUNTIME[0.00022817s]
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
 o Devices Discovered   1
 o Discovery Time       4.476 secs
 o Memory usage         58MB (peak: 60MB)
 o MySQL Usage          Cell[13/0.016s] Row[35/0.034s] Rows[493/5.239s] Column[136/0.137s] Update[1/0.003s] Insert[1/0.002s]
                        Delete[2/0.004s]
 o RRDTool Usage