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

CMD EXITCODE[0]
CMD RUNTIME[0.0089s]
CMD EXITDELAY[5ms]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: https://svn.observium.org/svn/observium/branches/stable
Relative URL: ^/observium/branches/stable
Repository Root: https://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 12944
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 12912
Last Changed Date: 2023-08-02 15:24:07 +0200 (Wed, 02 Aug 2023)

]
DEFINITIONS Time  : 0.104248 ms

DEFINITIONS Memory: 15.2MB


SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00049496s]

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

SQL[SET SESSION `sql_mode` = 'NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00008488s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO

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

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

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0029s]
STDOUT[
obs.workgroup
]

SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)]
SQL RUNTIME[0.00021291s]

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0144s]
STDOUT[
Linux|5.15.0-79-generi
c|amd64|Ubuntu|22.04|vmware|
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.003s]
STDOUT[
Python 3.10.12
]

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

CMD[/usr/bin/snmpget --version 2>&1]
--More--(2%)


CMD EXITCODE[0]
CMD RUNTIME[0.0072s]
STDOUT[
NET-SNMP version: 5.9.1
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0099s]
STDOUT[
RRDtool 1.7.2  Copyright by Tobias Oetiker 
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0024s]
CMD EXITDELAY[5ms]
STDOUT[
/usr/bin/fping: Version 5.1
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.019s]
STDOUT[
Apache/2.4.52
]

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

SQL[SHOW VARIABLES LIKE 'log_bin']

SQL RUNTIME[0.00194597s]

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

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

 o OS                   Linux 5.15.0-79-generic [amd64] (Ubuntu 22.04)
 o Apache               2.4.52
 o PHP                  8.1.2-1ubuntu2.14 (OPcache: DISABLED)
 o Python               3.10.12
 o MySQL                8.0.34-0ubuntu0.22.04.1 (extension: mysqli 8.1.2-1ubuntu2.14)
 o SNMP                 NET-SNMP 5.9.1
 o RRDtool              1.7.2
 o Fping                5.1 (IPv4 and IPv6)
 o Fetch                cURL 7.81.0 (OpenSSL/3.0.2, LibZ 1.2.11, LibIDN 2.3.2)

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

 o PHP                  Unlimited

#####  DB info  #####

 o DB schema            485
 o MySQL binlog         ON
 o MySQL mode           NO_ENGINE_SUBSTITUTION

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

 o PHP                  UTF-8
 o MySQL                utf8mb3

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

 o Date                 Tuesday, 29-Aug-23 14:50:08 CEST
 o PHP                  +02:00
 o MySQL                +02:00

#####  Starting discovery run at 2023-08-29 14:50:08  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname`
 LIKE 'fgm.placeholder.nl' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00047088s]
Not found device [10] model 'fortinet' association for .1.3.6.1.4.1.12356.103.1.64

CMD[/usr/bin/snmpget -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':'fgm.placeholder.nl':'161' .1.3.6.1.2.1.1.2.0 .1.3.6.1.2.1.1.3.0]

--More--(5%)
CMD EXITCODE[0]
CMD RUNTIME[0.0435s]
STDOUT[
.1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.12356.103.1.64
.1.3.6.1.2.1.1.3.0 = 0:2:03:48.31
]
SNMP STATUS[TRUE]


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

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

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('1151846','discovery.php','531571','0','php ./discovery.php -d -h fgm.placeholder.nl','1693313408'
,'10')]
SQL RUNTIME[0.00229311s]
#####  fgm.placeholder.nl [10]  #####

 o OS Type              forti-os
 o OS Group             fortinet
 o SNMP Version         v3
 o Last discovery       2023-08-29 13:59:18
 o Last duration        3.19 seconds

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

Device-specific no-bulk option.

CMD[/usr/bin/snmpget -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':'fgm.placeholder.nl':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0506s]
STDOUT[
Fortimanager
]
SNMP STATUS[TRUE]
Store in cache OID: SNMPv2-MIB::sysDescr.0
Device-s


pecific no-bulk option.

CMD[/usr/bin/snmpget -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':'fgm.placeholder.nl':'161' sysObjectID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0447s]
STDOUT[
.1.3.6.1.4.1.12356.103.1.64
]
SNMP STATUS[TRUE]
+-------------+-----------------------------+
| OID         |                             |
+-------------+-----------------------------+
| sysDescr    | Fortimanager                |
| sysObjectID | .1.3.6.1.4.1.12356.103.1.64 |
+-------------+-----------------------------+

 o Detect OS matched (forti-os: Fortinet OS): 
+-------------+------------------------+-----------------------------+
| OID         | Matched definition     |                             |
+-------------+------------------------+-----------------------------+
| sysObjectID | .1.3.6.1.4.1.12356.103 | .1.3.6.1.4.1.12356.103.1.64 |
+-------------+------------------------+-----------------------------+


 o Duration             0.1258s

#####  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.0192s]
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 -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':'fgm.placeholder.nl':'161' .1.3.6.1.2.1.1.9.1.2]

CMD EXITCODE[0]
CMD RUNTIME[0.0433s]
STDOUT[
.1.3.6.1.2.1.1.9.1.2 = No
 Such Instance currently exists at this OID


]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' sysORDescr]

CMD EXITCODE[0]
CMD RUNTIME[0.0438s]
STDOUT[
sysORDescr = No Such Instance currently exists at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ospfAdminStat.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0401s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]

SNMP ERROR[#1000 - Failed response]
Store in cache OID: OSPF-MIB::ospfAdminStat.0

CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ospfv3AdminStatus.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0443s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Store in cache OID: OSPFV3-MIB::ospfv3AdminStatus.0

CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m LLDP-V2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' lldpV2LocChassisId.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0445s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Store in cache OID: LLDP-V2-MIB::lldpV2LocChassisId.0

CMD[/usr/bin/snmpget -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':'fgm.placeholder.nl':'161' lldpXMedLocModelName.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0455s]
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` = '10' AND `attrib_type` = 

'sysORID']
SQL RUNTIME[0.00032997s]

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


]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '10' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00017095s]
Array
(
    [0] => FORTINET-FORTIMAIL-MIB
    [1] => FORTINET-CORE-MIB
    [2] => SNMPv2-MIB
    [3] => SNMP-FRAMEWORK-MIB
    [4] => IF-MIB
    [5] => ADSL-LINE-MIB
    [6] => EtherLike-MIB
    [7] => ENTITY-MIB
    [8] => ENTITY-SENSOR-MIB
    [9] => UCD-SNMP-MIB
--More--(13%)
    [10] => HOST-RESOURCES-MIB
    [11] => Q-BRIDGE-MIB
    [12] => IP-MIB
    [13] => IPV6-MIB
    [14] => LLDP-MIB
    [15] => CISCO-CDP-MIB
    [16] => PW-STD-MIB
    [17] => DISMAN-PING-MIB
    [18] => BGP4-MIB
)


 o Duration             0.2965s




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


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

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

 o Duration             0.0021s


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

 o Caching OIDs         ifDescr 
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ifDescr]

CMD EXITCODE[0]
CMD RUNTIME[0.0484s]
STDOUT[
ifDescr.1 = port1
ifDescr.2 = port2
ifDescr.3 = port3
ifDescr.4 = port4
ifDescr.5 = port5
ifDescr.6 = port6
ifDescr.7 = port7
ifDescr.8 = port8
ifDescr.9 = port9
ifDescr.10 = port10
ifDescr.11 = port11
ifDescr.12 = port12
]
SNMP STATUS[

TRUE]
ifAlias 
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ifAlias]

CMD EXITCODE[0]
CMD RUNTIME[0.0476s]
STDOUT[
ifAlias.1 = 
ifAlias.2 = 
ifAlias.3 = 
ifAlias.4 = 
ifAlias.5 = 
ifAlias.6 = 
ifAlias.7 = 
ifAlias.8 = 
ifAlias.9 = 
ifAlias.10 = 
ifAlias.11 = 
ifAlias.12 = 
]
SNMP STATUS[TRUE]
ifName 
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ifName]

CMD EXITCODE[0]
CMD RUNTIME[0.0473s]
STDOUT[
ifName.1 = port1
ifName.2 = port2
ifName.3 = port3
ifName.4 = port4
--More--(16%)

ifName.5 = port5
ifName.6 = port6
ifName.7 = port7
ifName.8 = port8
ifName.9 = port9
ifName.10 = port10
ifName.11 = port11
ifName.12 = port12
]
SNMP STATUS[TRUE]
ifType 



CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ifType]

CMD EXITCODE[0]
CMD RUNTIME[0.0491s]
STDOUT[
ifType.1 = ethernetCsmacd
ifType.2 = ethernetCsmacd
ifType.3 = ethernetCsmacd
ifType.4 = ethernetCsmacd
ifType.5 = ethernetCsmacd
ifType.6 = ethernetCsmacd
ifType.7 = ethernetCsmacd
ifType.8 = ethernetCsmacd
ifType.9 = ethernetCsmacd
ifType.10 = ethernetCsmacd
ifType.11 = ethernetCsmacd
ifType.12 = ethernetCsmacd
]
SNMP STATUS[TRUE]
ifOperStatus 
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ifOperStatus]

CMD EXITCODE[0]
CMD RUNTIME[0.0481s]
STDOUT[
ifOperStatus.1 = up
ifOperStatus.2 = down
ifOperStatus.3 = down
ifOperStatus.4 = down
ifOperStatus.5 = down
ifOperStatus.6 = down
ifOperStatus.7 = down
ifOperStatus.8 = down
ifOperStatus.9 = down
ifOperStatus.10 = down
ifOperStatus.11 = down
ifOperStatus.12 = down
]
SNMP STATUS[TRUE]

Array
(
    [1] => Array
        (
            [ifDescr] => port1
            [ifAlias] => 
            [ifName] => port1
            [ifType] => ethernetCsmacd
            [ifOperStatus] => up
        )

    [2] => Array
        (
            [ifDescr] => port2
            [ifAlias] => 
            [ifName] => port2
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [3] => Array
        (
            [ifDescr] => port3
            [ifAlias] => 
            [ifName] => port3
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [4] => Array
        (
            [ifDescr] => port4
--More--(18%)


            [ifAlias] => 
            [ifName] => port4
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [5] => Array
        (
            [ifDescr] => port5
            [ifAlias] => 
            [ifName] => port5
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [6] => Array
        (
            [ifDescr] => port6
            [ifAlias] => 
            [ifName] => port6
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [7] => Array
        (
            [ifDescr] => port7
            [ifAlias] => 
            [ifName] => port7
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [8] => Array
        (
            [ifDescr] => port8
            [ifAlias] => 
            [ifName] => port8
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [9] => Array
        (
            [ifDescr] => port9
            [ifAlias] => 
            [ifName] => port9
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [10] => Array
        (

            [ifDescr] => port10
            [ifAlias] => 
            [ifName] => port10
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [11] => Array
        (
            [ifDescr] => port11
            [ifAlias] => 
            [ifName] => port11
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

    [12] => Array
        (
            [ifDescr] => port12
            [ifAlias] => 
            [ifName] => port12
            [ifType] => ethernetCsmacd
            [ifOperStatus] => down
        )

)

 o Caching DB           
SQL[SELECT * FROM `ports` WHERE `device_id` = '10']
SQL RUNTIME[0.00066710s]
--More--(20%)
12 ports
 o Discovering ports    ............
+---------+---------+--------+---------+----------------+-------------+---------+
| ifIndex | ifDescr | ifName | ifAlias | ifType         | Oper Status | Ignored |
+---------+---------+--------+---------+----------------+-------------+---------+

| 1       | port1   | port1  | ...     | ethernetCsmacd | up          | no      |
| 2       | port2   | port2  | ...     | ethernetCsmacd | down        | no      |
| 3       | port3   | port3  | ...     | ethernetCsmacd | down        | no      |
| 4       | port4   | port4  | ...     | ethernetCsmacd | down        | no      |
| 5       | port5   | port5  | ...     | ethernetCsmacd | down        | no      |
| 6       | port6   | port6  | ...     | ethernetCsmacd | down        | no      |
| 7       | port7   | port7  | ...     | ethernetCsmacd | down        | no      |
| 8       | port8   | port8  | ...     | ethernetCsmacd | down        | no      |
| 9       | port9   | port9  | ...     | ethernetCsmacd | down        | no      |
| 10      | port10  | port10 | ...     | ethernetCsmacd | down        | no      |
| 11      | port11  | port11 | ...     | ethernetCsmacd | down        | no      |
| 12      | port12  | port12 | ...     | ethernetCsmacd | down        | no      |
+---------+---------+--------+---------+----------------+-------------+---------+


 o Duration             0.2693s


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


SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '10']
SQL RUNTIME[0.00019884s]

CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m IF-MIB -M /opt/observium/mibs/rf

c:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ifStackStatus]

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


 o Duration             0.1151s


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


SQL[SELECT * FROM `vlans` WHERE `device_id` = '10';]
SQL RUNTIME[0.00024796s]

SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '10';]
SQL RUNTIME[0.00015712s]
 o Q-BRIDGE-MIB         
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' dot1qVlanStaticName]

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



 o Duration             0.0546s


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


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

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

 o Duration             0.0018s
--More--(25%)



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


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


]
 o IP-MIB               
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ipAdEntIfIndex]



CMD EXITCODE[0]
CMD RUNTIME[0.0906s]
STDOUT[
ipAdEntIfIndex.10.31.240.100 = 1
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ipAdEntNetMask]

CMD EXITCODE[0]
CMD RUNTIME[0.0779s]
STDOUT[
ipAdEntNetMask.10.31.240.100 = 255.255.252.0
]
SNMP STATUS[TRUE]
Added 10.31.240.100
.
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ipAddressIfIndex]

CMD EXITCODE[0]
CMD RUNTIME[0.099s]
STDOUT[
ipAddressIfIndex = No Such Instance currently exists at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

 o IPV6-MIB             
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' ipv6AddrEntry]

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

 o LLDP-MIB             

SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '10']
SQL RUNTIME[0.00044489s]

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

SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '125']
SQL RUNTIME[0.00029397s]

SQL[SELECT DISTINCT `entity_type` FROM `entity_attribs` WHERE `device_id` = '10']
SQL RUNTIME[0.00029182s]

SQL[SELECT * FROM `devices` LEFT JOIN `devices_locations` USING (`device_id`) WHERE `device_id` = '10']
SQL RUNTIME[0.00033522s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '10']
SQL RUNTIME[0.00023007s]

SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.31.240.0/22']
SQL RUNTIME[0.00020695s]

SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '10']
SQL RUNTIME[0.00019407s]

SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '10']
SQL RUNTIME[0.00020599s]
--More--(30%)

+---------+---------+-------------+------------------+----------------+---------+--------+
| ifIndex | ifDescr | IP: Version | Address          | Network        | Type    | Origin |
+---------+---------+-------------+------------------+----------------+---------+--------+
| 1       | port1   | IPv4        | 10.31.240.100/22 | 10.31.240.0/22 | private |        |
+---------+---------+-------------+------------------+----------------+---------+--------+


 o Changes              1 unchanged
 o Duration             0.4001s


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

 o UCD-SNMP-MIB         
SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '10' AND `processor_type` != 'ucd-old')]


SQL RUNTIME[0.00024390s]

 o HOST-RESOURCES-MIB   
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrProcessorLoad]

CMD EXITCODE[0]
CMD RUNTIME[0.0425s]
STDOUT[
hrProcessorLoad.1 = 5
hrProcessorLoad.2 = 1
hrProcessorLoad.3 = 0
hrProcessorLoad.4 = 4
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrDevice]

CMD EXITCODE[0]
CMD RUNTIME[0.0456s]
STDOUT[
hrDeviceIndex.1 = 1
hrDeviceIndex.2 = 2
hrDeviceIndex.3 = 3
hrDeviceIndex.4 = 4
hrDeviceType.1 = hrDeviceProcessor
hrDeviceType.2 = hrDeviceProcessor
hrDeviceType.3 = hrDeviceProcessor
hrDeviceType.4 = hrDeviceProcessor
hrDeviceDescr.1 = CPU Processor
hrDeviceDescr.2 = CPU Processor
hrDeviceDescr.3 = CPU Processor
hrDeviceDescr.4 = CPU Processor
hrDeviceID.1 = zeroDotZero.0
hrDeviceID.2 = zeroDotZero.0
hrDeviceID.3 = zeroDotZero.0
hrDeviceID.4 = zeroDotZero.0
hrDeviceStatus.1 = running
hrDeviceStatus.2 = running
hrDeviceStatus.3 = running
hrDeviceStatus.4 = running
hrDeviceErrors.1 = 0
hrDeviceErrors.2 = 0
hrDeviceErrors.3 = 0
hrDeviceErrors.4 = 0
hrProcessorFrwID.1 = zeroDotZero.0
hrProcessorFrwID.2 = zeroDotZero.0
hrProcessorFrwID.3 = zeroDotZero.0
hrProcessorFrwID.4 = zeroDotZero.0
hrProcessorLoad.1 = 5
hrProcessorLoad.2 = 1
hrProcessorLoad.3 = 0
hrProcessorLoad.4 = 4
]
SNMP STATUS[TRUE]
10 -> .1.3.6.1.2.1.25.3.3.1.2.1, 1, hr, Processor, 1, 5, , 1

SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '1' AND `processor_type` = 'hr']
SQL RUNTIME[0.00055122s]
10 -> .1.3.6.1.2.1.25.3.3.1.2.2, 2, hr, Processor, 1, 1, , 2

SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '2' AND `processor_type` = 'hr']
SQL RUNTIME[0.00030398s]
10 -> .1.3.6.1.2.1.25.3.3.1.2.3, 3, hr, Processor, 1, 0, , 3

SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '3' AND `processor_type` = 'hr']
SQL RUNTIME[0.00022793s]
--More--(34%)
10 -> .1.3.6.1.2.1.25.3.3.1.2.4, 4, hr, Processor, 1, 4, , 4

SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '4' AND `processor_type` = 'hr']
SQL RUNTIME[0.00022697s]
10 -> 1, 1, hr-average, Average, 1, 2.5, , 


SQL[SELECT * FROM `processors` WHERE `device_id` = '10' AND `processor_index` = '1' AND `processor_type` = 'hr-average']
SQL RUNTIME[0.00020409s]

SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '10' AND `processor_type` = 'ucd-old')]
SQL RUNTIME[0.00020099s]

 o FORTINET-FORTIMAIL-MIB 
CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m FORTINET-FORTIMAIL-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/fortinet 'udp':'fgm.placeholder.nl':'161' fmlSysCpuUsage.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0426s]
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` = '10']
SQL RUNTIME[0.00044894s]
1 -> hr
2 -> hr
3 -> hr
4 -> hr
1 -> hr-average
Array
(
    [hr] => Array
        (
            [1] => 1


            [2] => 1
            [3] => 1
            [4] => 1
        )

    [hr-average] => Array
        (
            [1] => 1
        )

)


 o Changes              5 unchanged
 o Duration             0.1461s


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

 o UCD-SNMP-MIB         
CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0]

CMD EXITCODE[0]
CMD RUNTIME[0.038s]
STDOUT[
memTotalReal.0 = No Such Object available on this agent at this OID
memAvailReal.0 = No Such Object available on this agent at this OID
memBuffer.0 = No Such Object available on this agent at this OID
memCached.0 = No Such Object available on this agent at this OID
]
SNMP ERROR[#1000 - Failed response]
SNMP STATUS[FALSE]

 o HOST-RESOURCES-MIB   
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrStorageEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.0398s]
STDOUT[
hrStorageIndex.1 = 1
hrStorageIndex.2 = 2
hrStorageIndex.3 = 3
hrStorageIndex.4 = 4
hrStorageType.1 = hrStorageRam
hrS
torageType.2 = hrStorageVirtualMemory
--More--(38%)
hrStorageType.3 = hrStorageFixedDisk
hrStorageType.4 = hrStorageFixedDisk
hrStorageDescr.1 = Physical Memory
hrStorageDescr.2 = Swap Memory
hrStorageDescr.3 = Compact Flash Disk
hrStorageDescr.4 = Internal Hard Disk
hrStorageAllocationUnits.1 = 1024
hrStorageAllocationUnits.2 = 1024


hrStorageAllocationUnits.3 = 4096
hrStorageAllocationUnits.4 = 4096
hrStorageSize.1 = 8166936
hrStorageSize.2 = 2097148
hrStorageSize.3 = 251878
hrStorageSize.4 = 20608614
hrStorageUsed.1 = 6227940
hrStorageUsed.2 = 0
hrStorageUsed.3 = 61865
hrStorageUsed.4 = 13569229
hrStorageAllocationFailures.1 = 0
hrStorageAllocationFailures.2 = 0
hrStorageAllocationFailures.3 = 0
hrStorageAllocationFailures.4 = 0
]
SNMP STATUS[TRUE]
Store in cache Table OID: HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES::hrStorageEntry
10 -> 1, HOST-RESOURCES-MIB::, Physical Memory, 1024, 8166936, 6227940

SQL[SELECT * FROM `mempools` WHERE `device_id` = '10' AND `mempool_index` = '1' AND `mempool_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00044322s]
10 -> 2, HOST-RESOURCES-MIB::, Swap Memory, 1024, 2097148, 0

SQL[SELECT * FROM `mempools` WHERE `device_id` = '10' AND `mempool_index` = '2' AND `mempool_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00023508s]


SQL[SELECT * FROM `mempools` WHERE `device_id` = '10']
SQL RUNTIME[0.00019097s]
1 -> HOST-RESOURCES-MIB
2 -> HOST-RESOURCES-MIB
Array
(
    [HOST-RESOURCES-MIB] => Array
        (
            [1] => 1
            [2] => 1
        )

)



 o Changes              2 unchanged
 o Duration             0.0858s


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

 o ENTITY-MIB           ENTITY-MIB 
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m ENTITY-MIB:FORTINET-CORE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/fortinet 'udp':'fgm.placeholder.nl':'161' entPhysicalEntry]

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

 o HOST-RESOURCES-MIB   
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrDeviceEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.0444s]
STDOUT[
hrDeviceIndex.1 = 1
hrDeviceIndex.2 = 2
hrDeviceIndex.3 = 3
hrDeviceIndex.4 = 4
hrDeviceType.1 = hrDeviceProcessor
hrDeviceType.2 = hrDeviceProcessor
hrDeviceType.3 = hrDeviceProcessor
hrDeviceType.4 = hrDeviceProcessor
--More--(41%)

hrDeviceDescr.1 = CPU Processor
hrDeviceDescr.2 = CPU Processor
hrDeviceDescr.3 = CPU Processor
hrDeviceDescr.4 = CPU Processor
hrDeviceID.1 = zeroDotZero.0
hrDeviceID.2 = zeroDotZero.0
hrDeviceID.3 = zeroDotZero.0
hrDeviceID.4 = zeroDotZero.0
hrDeviceStatus.1 = running
hrDeviceStatus.2 = running
hrDeviceStatus.3 = running
hrDeviceStatus.4 = running
hrDeviceErrors.1 = 0
hrDeviceErrors.2 = 0
hrDeviceErrors.3 = 0
hrDeviceErrors.4 = 0
]
SNMP STATUS[TRUE]


CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' hrProcessorEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.0398s]
STDOUT[
hrProcessorFrwID.1 = zeroDotZero.0
hrProcessorFrwID.2 = zeroDotZero.0
hrProcessorFrwID.3 = zeroDotZero.0
hrProcessorFrwID.4 = zeroDotZero.0
hrProcessorLoad.1 = 5
hrProcessorLoad.2 = 1
hrProcessorLoad.3 = 0
hrProcessorLoad.4 = 4
]
SNMP STATUS[TRUE]

SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '1')]
SQL RUNTIME[0.00041413s]

SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='5' WHERE device_id = '10' AND hrDeviceIndex = '1']
SQL RUNTIME[0.00253797s]
.
SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '2')]
SQL RUNTIME[0.00029707s]

SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='1' WHERE device_id = '10' AND hrDeviceIndex = '2']
SQL RUNTIME[0.00227499s]
.
SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '3')]
SQL RUNTIME[0.00023484s]

SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='0' WHERE device_id = '10' AND hrDeviceIndex = '3']

SQL RUNTIME[0.00189281s]
.
SQL[SELECT EXISTS (SELECT 1 FROM `hrDevice` WHERE `device_id` = '10' AND `hrDeviceIndex` = '4')]
SQL RUNTIME[0.00018001s]

SQL[UPDATE `hrDevice` set `hrDeviceType` ='hrDeviceProcessor',`hrDeviceDescr` ='CPU Processor',`hrDeviceStatus` ='running',`hrDeviceErrors` ='0',`hrProcessorLoad` ='4' WHERE device_id = '10' AND hrDeviceIndex = '4']
SQL RUNTIME[0.00203204s]
.
SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '10']
SQL RUNTIME[0.00016904s]


SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '10']
SQL RUNTIME[0.00016403s]

 o Duration             0.2189s


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


SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '10']
SQL RUNTIME[0.00019717s]


 o Duration             0.0011s


SQL[SELECT `attrib_value` FROM `entity_attribs` 
WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_sensors']
SQL RUNTIME[0.00018001s]
--More--(47%)

#####  Module Start: sensors  #####

 o ENTITY-SENSOR-MIB    
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' entPhySensorValue]

CMD EXITCODE[0]
CMD RUNTIME[0.1164s]
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` = '10' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00047803s]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--More--(55%)
SQL[SELECT * FROM `sensors` WHERE `device_id` = '10' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00017595s]

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

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

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

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

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

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

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


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

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

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


 o Duration             0.1424s


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

 o UCD-SNMP-MIB         
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' dskEntry]

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

 o HOST-RESOURCES-MIB  

 Get cached Table OID: HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES::hrStorageEntry
skip(memory)
skip(memory)
10 -> 3, hrStorageFixedDisk, HOST-RESOURCES-MIB, Compact Flash Disk, 4096, 1031692288, 253399040, 0

SQL[SELECT * FROM `storage` WHERE `device_id` = '10' AND `storage_index` = '3' AND `storage_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00074887s]
10 -> 4, hrStorageFixedDisk, HOST-RESOURCES-MIB, Internal Hard Disk, 4096, 84412882944, 55579561984, 0

SQL[SELECT * FROM `storage` WHERE `device_id` = '10' AND `storage_index` = '4' AND `storage_mib` = 'HOST-RESOURCES-MIB']
SQL RUNTIME[0.00036216s]


SQL[SELECT * FROM `storage` WHERE `device_id` = '10']
SQL RUNTIME[0.00040698s]
3 -> HOST-RESOURCES-MIB
4 -> HOST-RESOURCES-MIB
Array
(
    [HOST-RESOURCES-MIB] => Array
        (
            [3] => Compact Flash Disk
            [4] => Internal Hard Disk
        )

)


 o Changes              2 unchanged
 o Duration             0.1258s

--More--(61%)


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


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


]
 o LLDP-MIB             
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' lldpRemChassisIdSubtype]

CMD EXITCODE[0]


CMD RUNTIME[0.0446s]
STDOUT[
lldpRemChassisIdSubtype = No more variables left in this MIB View (It is past the end of the MIB tree)
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

 o CISCO-CDP-MIB        
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' cdpCache]

CMD EXITCODE[0]
CMD RUNTIME[0.1476s]
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` = '10']
SQL RUNTIME[0.00039196s]



 o Duration             0.1987s


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


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


]
 o IP-MIB               
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u **

* -Pud -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipNetToPhysicalPhysAddress]

CMD EXITCODE[0]
CMD RUNTIME[0.1125s]
STDOUT[
ipNetToPhysicalPhysAddress = No Such Instance currently exists at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipNetToMediaPhysAddress]

CMD EXITCODE[0]
CMD RUNTIME[0.0432s]
STDOUT[
ipNetToMediaPhysAddress[1][10.31.240.1] = 0:0:11:11:22:22
ipNetToMediaPhysAddress[1][10.31.240.10] = 0:50:56:a3:5d:c5
ipNetToMediaPhysAddress[1][10.31.243.254] = 0:9:f:9:8:5
]
SNMP STATUS[TRUE]
Used IP-MIB::ipNetToMediaPhysAddress

 o IPV6-MIB             
CMD[/usr/bin/snmpbulkwalk -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUsX -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' ipv6NetToMediaPhysAddress]

CMD EXITCODE[0]
--More--(66%)


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


SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '10']
SQL RUNTIME[0.00055599s]

+---------+---------+-----+-------------+-----------------+
| ifIndex | ifDescr | VRF | IP: Version | Addresses Count |
+---------+---------+-----+-------------+-----------------+
| 1       | port1   |     | IPv4        | 3               |
+---------+---------+-----+-------------+-----------------+


 o Changes              3 unchanged
 o Duration             0.2762s


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


 o Duration             0.0008s


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


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` =

 '10' AND `attrib_type` = 'bgp_localas']
SQL RUNTIME[0.00021315s]

CMD[/usr/bin/snmpget -v3 -l 'authPriv' -n '' -x *** -X *** -a *** -A *** -u *** -Pud -OQUv -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'fgm.placeholder.nl':'161' bgpLocalAs.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0372s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
No BGP on host
SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '10']
SQL RUNTIME[0.00045300s]

 o Duration             0.0412s


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


 o Duration             0.0002s


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

 o DISMAN-PING-MIB      
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':
'161' pingCtlEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.1214s]
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` = '10']
SQL RUNTIME[0.00037599s]

 o Duration             0.1246s

--More--(70%)


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_lsp']
SQL RUNTIME[0.00025487s]

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


SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '10']
SQL RUNTIME[0.00020218s]
 o PW-STD-MIB           
CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' pwID]

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


 o Duration             0.0435s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_virtual-machines']
SQL RUNTIME[0.00038218s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` =

 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_cisco-cbqos']
SQL RUNTIME[0.00054288s]
#####  Module Start: cisco-cbqos  #####


SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '10']
SQL RUNTIME[0.00026488s]

CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' cbQosIfType]

CMD EXITCODE[0]
CMD RUNTIME[0.1718s]
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.1747s


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


CMD[/usr/bin/snmpbulkwalk -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':'fgm.placeholder.nl':'161' diskIOEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.1208s]
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` = '10']
SQL RUNTIME[0.00039387s]
-
SQL[DELETE FROM `ucd_diskio` WHERE `diskio_id` = '']
SQL RUNTIME[0.00018787s]


 o Duration             0.1249s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_wifi']
SQL RUNTIME[0.00022697s]

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

--More--(75%)


 o Duration             0.0001s


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


 o Duration             0.0004s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '10' AND `attrib_type` = 'discover_raid']
SQL RUNTIME[0.00019598s]
 o Modules Disabled     lsp, virtual-machines, wifi, 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, cisco-cbqos, ucd-diskio, 
                        p2p-radios,graphs 

SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '10';]
SQL RUNTIME[0.00017118s]

SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='security',`last_discovered_timetaken` ='3.0008',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:26:{s:6:\"system\";d:0.513;s:2:\"os\";d:0.2412;s:7:\"sensors\";d:0.0009;s:6:\"status\";d:0.0004;s:7:\"counter\";d
:0.0005;s:10:\"pro
cessors\";d:0.3228;s:8:\"mempools\";d:0.0826;s:7:\"storage\";d:0.0069;s:8:\"netstats\";d:0.5795;s:7:\"ucd-mib\";d:0.1263;s:13:\"ipSystemStats\";d:0.1151;s:5:\"ports\";d:0.7621;s:9:\"bgp-peers\";d:0.0013;s:15:\"printersupplies\";d:0.0006;s:10:\"ucd-diskio\";d:0.0006;s:10:\"p2p-radios\";d:0.0005;s:4:\"ospf\";d:0.0001;s:3:\"sla\";d:0.0005;s:11:\"pseudowires\";d:0.0006;s:14:\"mac-accounting\";d:0.0008;s:12:\"loadbalancer\";d:0.0002;s:15:\"entity-physical\";d:0.0002;s:9:\"fdb-table\";d:0.0708;s:6:\"graphs\";d:0.1085;s:4:\"oids\";d:0.0445;s:6:\"probes\";d:0.0012;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:0.32122111320495605;s:13:\"EtherLike-MIB\";d:0.05432295799255371;s:12:\"Q-BRIDGE-MIB\";d:0.1885969638824463;s:6:\"IP-MIB\";d:0.12035989761352539;}s:14:\"poller_history\";a:25:{i:1693313402;d:3.1536;i:1693313102;d:3.2064;i:1693312802;d:3.2337;i:1693312502;d:3.4188;i:1693312202;d:3.4495;i:1693311901;d:3.2916;i:1693311602;d:3.2621;i:1693311301;d:3.4216;i:1693311001;d:3.0182;i:1693310702;d:3.1586;i:1693310401;d:2.9539;i:1693310102;d:3.1878;i:1693309801;d:3.0893;i:1693309502;d:3.9898;i:1693309202;d:3.2208;i:1693308902;d:3.0107;i:1693308602;d:3.1337;i:1693308302;d:2.9999;i:1693308002;d:2.9587;i:1693307702;d:3.2777;i:1693307402;d:3.1143;i:1693307102;d:3.2791;i:1693306802;d:3.1023;i:1693306502;d:3.527;i:1693306202;d:5.1759;}s:17:\"discovery_history\";a:3:{i:1693313408;d:3.0008;i:1693310355;d:3.1893;i:1693306201;d:3.4966;}s:18:\"discovery_mod_perf\";a:26:{s:2:\"os\";d:0.1258;s:4:\"mibs\";d:0.2965;s:3:\"vrf\";d:0.0021;s:5:\"ports\";d:0.2693;s:11:\"ports-stack\";d:0.1151;s:5:\"vlans\";d:0.0546;s:11:\"ports_vlans\";N;s:4:\"oids\";d:0.0018;s:12:\"ip-addresses\";d:0.4001;s:10:\"processors\";d:0.1461;s:8:\"mempools\";d:0.0858;s:9:\"inventory\";d:0.2189;s:15:\"printersupplies\";d:0.0011;s:7:\"sensors\";d:0.1424;s:7:\"storage\";d:0.1258;s:10:\"neighbours\";d:0.1987;s:9:\"arp-table\";d:0.2762;s:13:\"junose-atm-vp\";d:0.0008;s:9:\"bgp-peers\";d:0.0412;s:14:\"m
ac-accounting\";d:0.0002;s:3:\"sla\";d:0.1246;s:11:\"pseudowires\";d:0.0435;s:11:\"cisco-cbqos\";d:0.1747;s:10:\"ucd-diskio\";d:0.1249;s:10:\"p2p-radios\";d:0.0001;s:6:\"graphs\";d:0.0004;}}' WHERE `device_id` = '10']
SQL RUNTIME[0.00504494s]
#####  fgm.placeholder.nl [10] completed discovery modules at 2023-08-29 14:50:11  #####

 o Discovery time       3.0008 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '1151846' AND `process_name` = 'discovery.php' AND `device_id` = '10' AND `poller_id` = '0']
SQL RUNTIME[0.00227404s]
#####  Finished discovery run at 2023-08-29 14:50:11  #####


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

SQL[SELECT * FROM `groups_assoc`]
SQL RUNTIME[0.00019789s]

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_24x7')]
SQL RUNTIME[0.00021386s]

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

Group                           'infra_24x7': 4 existing, 4 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_10x5')]
SQL RUNTIME[0.00026202s]

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

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`syscontact` = 'infra_be')]
SQL RUNTIME[0.00020599s]

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

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

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

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00017905s]

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 ('3','5','9','10',
'8','4')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00032306s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '1']
SQL RUNTIME[0.00024104s]
--More--(83%)
Alert Checker            'fw-memory-warning': 8 existing, 8 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00027394s]

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 ('3','5','9','10',
'8','4')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00031590s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '2']
SQL RUNTIME[0.00022697s]
Alert Checker           'fw-memory-critical': 8 existing, 8 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00020099s]

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 ('3','5','9','10',
'8','4'))]
SQL RUNTIME[0.00024295s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '3']
SQL RUNTIME[0.00025988s]
Alert Checker              'fw-cpu-cr
itical': 33 existing, 33 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00019217s]

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 ('3','5','9','10',
'8','4'))]
SQL RUNTIME[0.00026512s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '4']
SQL RUNTIME[0.00027609s]
Alert Checker               'fw-cpu-warning': 33 existing, 33 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00021315s]

SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8
','4') AND IFNULL(`status`.`status_type`, '') = 'FgHaMode') AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00061679s]

SQL[SELECT * FROM `alert_table` WHERE `aler
t_test_id` = '5']
SQL RUNTIME[0.00032306s]
Alert Checker                 'fw_ha_status': 4 existing, 4 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00032592s]

SQL[SELECT `bgpPeer_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10',
'8','4'))]
SQL RUNTIME[0.00046706s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '6']
SQL RUNTIME[0.00050402s]
Alert Checker                    'fw_bgp_up': 5 existing, 5 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00032187s]

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 ('3','5'

,'9','10',
'8','4') AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00061393s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '7']
SQL RUNTIME[0.00028801s]
Alert Checker      'fw-temperature-critical': 8 existing, 8 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00051188s]

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 ('3','5','9','10',
'8','4') AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00066304s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '8']
SQL RUNTIME[0.00021005s]
Alert Checker       'fw-temperature-warning': 8 existing, 8 new entries (+0/-0).

SQL[SELECT DISTINCT `
entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00020003s]

SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN ('3','5','9','10','8','4'))]
--More--(92%)
SQL RUNTIME[0.00014710s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '9']
SQL RUNTIME[0.00018287s]
Alert Checker       'fw-reacahable-critical': 6 existing, 6 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00016093s]

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 ('3','5','9','10','8'

,'4') AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00050402s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '10']
SQL RUNTIME[0.00041890s]
Alert Checker        'fw-port-error-warning': 61 existing, 61 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00022221s]

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 ('3','5','9','10','8'
,'4') AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00053191s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '11']
SQL RUNTIME[0.00034904s]
Alert Checker       'fw-port-error-critical': 61 existing, 61 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 A
ND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00018597s]

SQL[SELECT `status_id`, `devices`.`device_id` as `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('3','5','9','10','8
','4') AND IFNULL(`status`.`status_type`, '') = 'FgHaStatsSyncStatusType') AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00031686s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '12']
SQL RUNTIME[0.00023007s]
Alert Checker                   'fw_ha_sync': 7 existing, 7 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00018001s]

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 ('3','5','9','10','8'
,'4'
) AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1']
SQL RUNTIME[0.00049901s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '13']
SQL RUNTIME[0.00033784s]
Alert Checker               'fw-port-status': 61 existing, 61 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` IN ('2','1','3')]
SQL RUNTIME[0.00017786s]

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 ('3','5','9','10','8'
,'4') AND IFNULL(`ports`.`ifType`, '') = 'tunnel' AND IFNULL(`ports`.`ifName`, "") NOT LIKE '%.root%' AND IFNULL(`ports`.`ifName`, "") NOT LIKE '%.Guest%') AND `ports`.`deleted` != 
'1']
SQL RUNTIME[0.00050592s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '14']
SQL RUNTI
ME[0.00019217s]
Alert Checker                  'fw-port-vpn': 4 existing, 4 new entries (+0/-0).
./discovery.php: fgm.placeholder.nl - 1 devices discovered in 3.143 secs

SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1693299008']
SQL RUNTIME[0.00014520s]
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       3.143 secs
 o Definitions          0.104248046875 secs
 o Memory usage         24MB (peak: 24MB)
 o MySQL Usage          Cell[16/0.014s] Row[43/0.037s] Rows[119/0.095s] Column[19/0.013s] Update[5/0.017s] Insert[1/0.003s] Delete[3/0.004s] 
 o RRDTool Usage        
root@obs:/opt/observium#