- SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 2.36ms]
- SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 1.65ms]
- SQL[[1;33mselect version() [0;33m[][0m 0.9ms]
- ===========================================
- Component | Version
- --------- | -------
- LibreNMS | 25.3.0-42-gf4e45f488 (2025-03-24T21:20:22-04:00)
- DB Schema | 2025_03_22_134124_fix_ipv6_addresses_id_type (323)
- PHP | 8.3.14
- Python | 3.12.3
- Database | MariaDB 10.11.8-MariaDB-0ubuntu0.24.04.1
- RRDTool | 1.7.2
- SNMP | 5.9.4.pre2
- ===========================================
- LibreNMS config cache cleared and config reloaded.
- SQL[[1;33mselect `config_name`, `config_value` from `config` [0;33m[][0m 1.61ms]
- SQL[[1;33mselect * from `graph_types` [0;33m[][0m 1.16ms]
- SQL[[1;33mselect * from `config` where (`config_name` = ?) limit 1 [0;33m["traceroute"][0m 0.9ms]
- SQL[[1;33mdelete from `config` where `config_name` like ? [0;33m["traceroute.%"][0m 0.42ms]
- Starting polling run:
- SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["int-002-entree.gestion"][0m 0.99ms]
- SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[290][0m 1.11ms]
- Hostname: INT-002-ENTREE.gestion
- ID: 290
- OS: heliosip
- IP: 10.244.2.91
- Attempting to initialize OS: heliosip
- OS initialized as Generic (heliosip)
- SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[290][0m 1.04ms]
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'INT-002-ENTREE.gestion'
- response: INT-002-ENTREE.gestion : xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.89/1.34/1.81
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]
- SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.6530
- SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2025-03-25 09:12:40",1.34,290][0m 2.26ms]
- RRD[[0;32mlast INT-002-ENTREE.gestion/icmp-perf.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/icmp-perf.rrd N:1.34:3:3:0.89:1.81 --daemon 192.168.150.40:42217[0m]
- SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[290][0m 2ms]
- #### Load poller module core ####
- Module enabled: Global + | OS | Device | Manual
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]
- .*.*.0 = 404805100
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMP-FRAMEWORK-MIB::snmpEngineTime.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: HOST-RESOURCES-MIB::hrSystemUptime.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: SNMP-FRAMEWORK-MIB::snmpEngineTime.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: HOST-RESOURCES-MIB::hrSystemUptime.0
- Uptime seconds: 4048051
- RRD[[0;32mlast INT-002-ENTREE.gestion/uptime.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/uptime.rrd N:4048051 --daemon 192.168.150.40:42217[0m]
- Uptime: 1 month 2 weeks 4 days 20 hours
- SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[4048051,290][0m 1.16ms]
- >> [0;36mSNMP[0m: [3/0.11s] [1;33mMySQL[0m: [4/0.06s] [0;32mRRD[0m: [4/0.01s]
- >> Runtime for poller module 'core': 0.0913 seconds with 136664 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-core.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-core.rrd N:0.09126615524292 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module core ####
- #### Load poller module os ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[11][0m 1.06ms]
- Location: 002
- Hardware: 2N IP Force
- OS Version: 2.46.0.70.3
- OS Features:
- Serial: 54-1742-0231
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'os': 0.0081 seconds with 188624 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-os.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-os.rrd N:0.0080668926239014 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module os ####
- #### Load poller module availability ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[290,1742821960][0m 2.52ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[290,86400][0m 0.96ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[97.608,1325][0m 0.73ms]
- RRD[[0;32mlast INT-002-ENTREE.gestion/availability-86400.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/availability-86400.rrd N:97.608 --daemon 192.168.150.40:42217[0m]
- 1 day : 97.608%
- SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[290,1742303560][0m 1.89ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[290,604800][0m 0.69ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[98.571,1326][0m 0.49ms]
- RRD[[0;32mlast INT-002-ENTREE.gestion/availability-604800.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/availability-604800.rrd N:98.571 --daemon 192.168.150.40:42217[0m]
- 1 week : 98.571%
- SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[290,1740316360][0m 1.75ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[290,2592000][0m 0.67ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[99.663,1327][0m 0.6ms]
- RRD[[0;32mlast INT-002-ENTREE.gestion/availability-2592000.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/availability-2592000.rrd N:99.663 --daemon 192.168.150.40:42217[0m]
- 1 month : 99.663%
- SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[290,1711372360][0m 2.68ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[290,31536000][0m 0.88ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[99.971,1328][0m 0.49ms]
- RRD[[0;32mlast INT-002-ENTREE.gestion/availability-31536000.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/availability-31536000.rrd N:99.971 --daemon 192.168.150.40:42217[0m]
- 1 year : 99.971%
- SQL[[1;33mdelete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [0;33m[290,1325,1326,1327,1328][0m 0.43ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [13/0.15s] [0;32mRRD[0m: [10/0.00s]
- >> Runtime for poller module 'availability': 0.0336 seconds with 75152 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-availability.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-availability.rrd N:0.033560037612915 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module availability ####
- #### Load poller module ipmi ####
- Module enabled: Global + | OS | Device | Manual
- Reporting disabled by user setting
- SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[290][0m 1.42ms]
- array (
- )
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ipmi': 0.0042 seconds with 89832 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ipmi.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ipmi.rrd N:0.0041718482971191 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ipmi ####
- #### Load poller module sensors ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[290][0m 0.79ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'sensors': 0.0016 seconds with 3040 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-sensors.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-sensors.rrd N:0.0015950202941895 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module sensors ####
- #### Load poller module processors ####
- Module enabled: Global + | OS | Device | Manual
- Attempting to initialize OS: heliosip
- OS initialized as Generic (heliosip)
- SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[290][0m 1.09ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'processors': 0.0058 seconds with 62024 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-processors.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-processors.rrd N:0.0057928562164307 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module processors ####
- #### Load poller module mempools ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[290][0m 0.98ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'mempools': 0.0031 seconds with 28192 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-mempools.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-mempools.rrd N:0.0031378269195557 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module mempools ####
- #### Load poller module storage ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `storage` where `storage`.`device_id` = ? and `storage`.`device_id` is not null [0;33m[290][0m 0.82ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'storage': 0.0040 seconds with 58328 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-storage.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-storage.rrd N:0.0040009021759033 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module storage ####
- #### Load poller module netstats ####
- Module enabled: Global + | OS | Device | Manual
- icmp
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInMsgs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutMsgs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInEchos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutEchos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInEchoReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutEchoReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInDestUnreachs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutDestUnreachs.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInMsgs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutMsgs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInEchos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutEchos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInEchoReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutEchoReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInDestUnreachs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutDestUnreachs.0
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInParmProbs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimeExcds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInSrcQuenchs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInRedirects.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimestamps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimestampReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInAddrMasks.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInAddrMaskReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimeExcds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutParmProbs.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInParmProbs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimeExcds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInSrcQuenchs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInRedirects.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimestamps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInTimestampReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInAddrMasks.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpInAddrMaskReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimeExcds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutParmProbs.0
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutSrcQuenchs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutRedirects.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimestamps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimestampReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutAddrMasks.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutAddrMaskReps.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutSrcQuenchs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutRedirects.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimestamps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutTimestampReps.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutAddrMasks.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::icmpOutAddrMaskReps.0
- ip
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipForwDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInDelivers.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInReceives.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutRequests.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInDiscards.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutDiscards.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutNoRoutes.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmReqds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmOKs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmFails.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipForwDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInDelivers.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInReceives.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutRequests.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInDiscards.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutDiscards.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipOutNoRoutes.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmReqds.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmOKs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipReasmFails.0
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragOKs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragFails.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragCreates.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInUnknownProtos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInHdrErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInAddrErrors.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragOKs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragFails.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipFragCreates.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInUnknownProtos.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInHdrErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-MIB::ipInAddrErrors.0
- ip_forward
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: IP-FORWARD-MIB::ipCidrRouteNumber.0
- snmp
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0'[0m]
- SNMPv2-MIB::snmpInPkts.0 = 1426095
- SNMPv2-MIB::snmpOutPkts.0 = 1426095
- SNMPv2-MIB::snmpInBadVersions.0 = 34
- SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
- SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
- SNMPv2-MIB::snmpInASNParseErrs.0 = 0
- SNMPv2-MIB::snmpInTooBigs.0 = 0
- SNMPv2-MIB::snmpInNoSuchNames.0 = 959814
- SNMPv2-MIB::snmpInBadValues.0 = 0
- SNMPv2-MIB::snmpInReadOnlys.0 = 0
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0'[0m]
- SNMPv2-MIB::snmpInGenErrs.0 = 52
- SNMPv2-MIB::snmpInTotalReqVars.0 = 813767
- SNMPv2-MIB::snmpInTotalSetVars.0 = 0
- SNMPv2-MIB::snmpInGetRequests.0 = 1027447
- SNMPv2-MIB::snmpInGetNexts.0 = 398597
- SNMPv2-MIB::snmpInSetRequests.0 = 0
- SNMPv2-MIB::snmpInGetResponses.0 = 1426095
- SNMPv2-MIB::snmpInTraps.0 = 0
- SNMPv2-MIB::snmpOutTooBigs.0 = 0
- SNMPv2-MIB::snmpOutNoSuchNames.0 = 959814
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m]
- SNMPv2-MIB::snmpOutBadValues.0 = 0
- SNMPv2-MIB::snmpOutGenErrs.0 = 52
- SNMPv2-MIB::snmpOutGetRequests.0 = 67828
- SNMPv2-MIB::snmpOutGetNexts.0 = 398402
- SNMPv2-MIB::snmpOutSetRequests.0 = 0
- SNMPv2-MIB::snmpOutGetResponses.0 = 1426096
- SNMPv2-MIB::snmpOutTraps.0 = 1
- SNMPv2-MIB::snmpSilentDrops.0 = 1
- SNMPv2-MIB::snmpProxyDrops.0 = 0
- RRD[[0;32mlast INT-002-ENTREE.gestion/netstats-snmp.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/netstats-snmp.rrd N:1426095:1426095:34:0:0:0:0:959814:0:0:52:813767:0:1027447:398597:0:1426095:0:0:959814:0:52:67828:398402:0:1426096:1:1:0 --daemon 192.168.150.40:42217[0m]
- udp
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpInDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpOutDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpInErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpNoPorts.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpInDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpOutDatagrams.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpInErrors.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: UDP-MIB::udpNoPorts.0
- tcp
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m]
- Exitcode: 2 ["Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpActiveOpens.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpPassiveOpens.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpAttemptFails.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpEstabResets.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpCurrEstab.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpInSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpOutSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpRetransSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpInErrs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpOutRsts.0
- "]
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpActiveOpens.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpPassiveOpens.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpAttemptFails.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpEstabResets.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpCurrEstab.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpInSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpOutSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpRetransSegs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpInErrs.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: TCP-MIB::tcpOutRsts.0
- >> [0;36mSNMP[0m: [11/0.53s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [4/0.00s]
- >> Runtime for poller module 'netstats': 0.5368 seconds with 51240 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-netstats.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-netstats.rrd N:0.53682994842529 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module netstats ####
- #### Load poller module hr-mib ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
- Exitcode: 2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemMaxProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemNumUsers.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemMaxProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemProcesses.0
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: hrSystemNumUsers.0
- >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'hr-mib': 0.0477 seconds with 4120 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-hr-mib.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-hr-mib.rrd N:0.047734022140503 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module hr-mib ####
- #### Load poller module ucd-mib ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'systemStats'[0m]
- SNMP['/usr/bin/snmpget' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
- Exitcode: 2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.1
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.3
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.1
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.2
- Error in packet
- Reason: (noSuchName) There is no such variable name in this MIB.
- Failed object: laLoadInt.3
- >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ucd-mib': 0.0631 seconds with 9224 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ucd-mib.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ucd-mib.rrd N:0.063085079193115 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ucd-mib ####
- #### Load poller module ipSystemStats ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
- >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ipSystemStats': 0.0410 seconds with 3592 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ipSystemStats.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ipSystemStats.rrd N:0.041042804718018 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ipSystemStats ####
- #### Load poller module ports ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[290][0m 2.22ms]
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'ifEntry'[0m]
- ifIndex.1 = 1
- ifDescr.1 = Internet Adapter
- ifType.1 = ethernetCsmacd
- ifMtu.1 = 1500
- ifSpeed.1 = 100000000
- ifPhysAddress.1 = 37:43:2d:31:45:2d:42:33:2d:30:33:2d:32:39:2d:39:41
- ifAdminStatus.1 = up
- ifOperStatus.1 = up
- ifLastChange.1 = 0
- ifInOctets.1 = 0
- ifInUcastPkts.1 = 0
- ifInNUcastPkts.1 = 0
- ifInDiscards.1 = 0
- ifInErrors.1 = 0
- ifInUnknownProtos.1 = 0
- ifOutOctets.1 = 0
- ifOutUcastPkts.1 = 0
- ifOutNUcastPkts.1 = 0
- ifOutDiscards.1 = 0
- ifOutErrors.1 = 0
- ifOutQLen.1 = 0
- ifSpecific.1 = 0
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
- SNMP['/usr/bin/snmpwalk' '-v1' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
- Fetched data (Full ports polling): dot3StatsDuplexStatus
- array (
- 1 =>
- array (
- 'ifIndex' => '1',
- 'ifDescr' => 'Internet Adapter',
- 'ifType' => 'ethernetCsmacd',
- 'ifMtu' => '1500',
- 'ifSpeed' => '100000000',
- 'ifPhysAddress' => '37:43:2d:31:45:2d:42:33:2d:30:33:2d:32:39:2d:39:41',
- 'ifAdminStatus' => 'up',
- 'ifOperStatus' => 'up',
- 'ifLastChange' => '0',
- 'ifInOctets' => '0',
- 'ifInUcastPkts' => '0',
- 'ifInNUcastPkts' => '0',
- 'ifInDiscards' => '0',
- 'ifInErrors' => '0',
- 'ifInUnknownProtos' => '0',
- 'ifOutOctets' => '0',
- 'ifOutUcastPkts' => '0',
- 'ifOutNUcastPkts' => '0',
- 'ifOutDiscards' => '0',
- 'ifOutErrors' => '0',
- 'ifOutQLen' => '0',
- 'ifSpecific' => '0',
- ),
- )
- valid
- ifInOctets
- ifOutOctets
- ifInUcastPkts
- ifOutUcastPkts
- ifInBroadcastPkts
- ifOutBroadcastPkts
- ifInMulticastPkts
- ifOutMulticastPkts
- ifSpeed (100000000)
- Using ifDescr as ifAlias
- Using ifDescr as ifName
- Internet Adapter
- ifInOctets (0 B) 0 Bps 279 secs
- ifOutOctets (0 B) 0 Bps 279 secs
- ifInErrors (0 B) 0 Bps 279 secs
- ifOutErrors (0 B) 0 Bps 279 secs
- ifInUcastPkts (0 B) 0 Bps 279 secs
- ifOutUcastPkts (0 B) 0 Bps 279 secs
- ifInNUcastPkts (0 B) 0 Bps 279 secs
- ifOutNUcastPkts (0 B) 0 Bps 279 secs
- ifInDiscards (0 B) 0 Bps 279 secs
- ifOutDiscards (0 B) 0 Bps 279 secs
- ifInUnknownProtos (0 B) 0 Bps 279 secs
- ifInBroadcastPkts (0 B) 0 Bps 279 secs
- ifOutBroadcastPkts (0 B) 0 Bps 279 secs
- ifInMulticastPkts (0 B) 0 Bps 279 secs
- ifOutMulticastPkts (0 B) 0 Bps 279 secs
- RRD warning: unused data sent ifInUcastPkts_rate
- RRD warning: unused data sent ifOutUcastPkts_rate
- RRD warning: unused data sent ifInErrors_rate
- RRD warning: unused data sent ifOutErrors_rate
- RRD warning: unused data sent ifInOctets_rate
- RRD warning: unused data sent ifOutOctets_rate
- RRD warning: unused data sent ifInBits_rate
- RRD warning: unused data sent ifOutBits_rate
- RRD[[0;32mlast INT-002-ENTREE.gestion/port-id15264.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/port-id15264.rrd N:0:0:0:0:0:0:0:0:0:0:0:U:U:U:U --daemon 192.168.150.40:42217[0m]
- SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1742908361,1742908082,279,15264][0m 1.53ms]
- SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15264][0m 0.84ms]
- 1 updated
- Port Internet Adapter: Internet Adapter (1 / #15264) VLAN = ? bps(0 bps/0 bps) bytes(0 B/0 B) pkts(0 pps/0 pps)
- SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1742908361,1742908082,null][0m 0.81ms]
- 0 updated
- >> [0;36mSNMP[0m: [4/0.14s] [1;33mMySQL[0m: [4/0.05s] [0;32mRRD[0m: [4/0.00s]
- >> Runtime for poller module 'ports': 0.1615 seconds with 72320 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ports.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ports.rrd N:0.16146802902222 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ports ####
- #### Load poller module customoid ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[290][0m 0.95ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'customoid': 0.0024 seconds with 3032 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-customoid.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-customoid.rrd N:0.0023980140686035 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module customoid ####
- #### Load poller module bgp-peers ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[290][0m 1.09ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'bgp-peers': 0.0046 seconds with 14168 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-bgp-peers.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-bgp-peers.rrd N:0.0046188831329346 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module bgp-peers ####
- #### Load poller module ucd-diskio ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[290][0m 0.69ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 2656 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ucd-diskio.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ucd-diskio.rrd N:0.0014200210571289 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ucd-diskio ####
- #### Load poller module wireless ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `wireless_sensors` where `wireless_sensors`.`device_id` = ? and `wireless_sensors`.`device_id` is not null [0;33m[290][0m 0.87ms]
- SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161'[0m]
- Exitcode: 1 ["Missing object name
- USAGE: snmpget [OPTIONS] AGENT OID [OID]...
- Version: 5.9.4.pre2
- Web: http://www.net-snmp.org/
- Email: net-snmp-coders@lists.sourceforge.net
- OPTIONS:
- -h, --help\t\tdisplay this help message
- -H\t\t\tdisplay configuration file directives understood
- -v 1|2c|3\t\tspecifies SNMP version to use
- -V, --version\t\tdisplay package version number
- SNMP Version 1 or 2c specific
- -c COMMUNITY\t\tset the community string
- SNMP Version 3 specific
- -a PROTOCOL\t\tset authentication protocol (MD5|SHA|SHA-224|SHA-256|SHA-384|SHA-512)
- -A PASSPHRASE\t\tset authentication protocol pass phrase
- -e ENGINE-ID\t\tset security engine ID (e.g. 800000020109840301)
- -E ENGINE-ID\t\tset context engine ID (e.g. 800000020109840301)
- -l LEVEL\t\tset security level (noAuthNoPriv|authNoPriv|authPriv)
- -n CONTEXT\t\tset context name (e.g. bridge1)
- -u USER-NAME\t\tset security name (e.g. bert)
- -x PROTOCOL\t\tset privacy protocol (DES|AES|AES-192|AES-256)
- -X PASSPHRASE\t\tset privacy protocol pass phrase
- -Z BOOTS,TIME\t\tset destination engine boots/time
- General communication options
- -r RETRIES\t\tset the number of retries
- -t TIMEOUT\t\tset the request timeout (in seconds)
- Debugging
- -d\t\t\tdump input/output packets in hexadecimal
- -D[TOKEN[,...]]\tturn on debugging output for the specified TOKENs
- \t\t\t (ALL gives extremely verbose debugging output)
- General options
- -m MIB[:...]\t\tload given list of MIBs (ALL loads everything)
- -M DIR[:...]\t\tlook in given list of directories for MIBs
- (default: /opt/librenms/mibs:/opt/librenms/mibs/2n)
- -P MIBOPTS\t\tToggle various defaults controlling MIB parsing:
- \t\t\t u: disallow the use of underlines in MIB symbols
- \t\t\t c: disallow the use of \"--\" to terminate comments
- \t\t\t d: save the DESCRIPTIONs of the MIB objects
- \t\t\t e: disable errors when MIB symbols conflict
- \t\t\t w: enable warnings when MIB symbols conflict
- \t\t\t W: enable detailed warnings when MIB symbols conflict
- \t\t\t R: replace MIB symbols from latest module
- -O OUTOPTS\t\tToggle various defaults controlling output display:
- \t\t\t 0: print leading 0 for single-digit hex characters
- \t\t\t a: print all strings in ascii format
- \t\t\t b: do not break OID indexes down
- \t\t\t e: print enums numerically
- \t\t\t E: escape quotes in string indices
- \t\t\t f: print full OIDs on output
- \t\t\t n: print OIDs numerically
- \t\t\t p PRECISION: display floating point values with specified PRECISION (printf format string)
- \t\t\t q: quick print for easier parsing
- \t\t\t Q: quick print with equal-signs
- \t\t\t s: print only last symbolic element of OID
- \t\t\t S: print MIB module-id plus last element
- \t\t\t t: print timeticks unparsed as numeric integers
- \t\t\t T: print human-readable text along with hex strings
- \t\t\t u: print OIDs using UCD-style prefix suppression
- \t\t\t U: don't print units
- \t\t\t v: print values only (not OID = value)
- \t\t\t x: print all strings in hex format
- \t\t\t X: extended index format
- -I INOPTS\t\tToggle various defaults controlling input parsing:
- \t\t\t b: do best/regex matching to find a MIB node
- \t\t\t h: don't apply DISPLAY-HINTs
- \t\t\t r: do not check values for range/type legality
- \t\t\t R: do random access to OID labels
- \t\t\t u: top-level OIDs must have '.' prefix (UCD-style)
- \t\t\t s SUFFIX: Append all textual OIDs with SUFFIX before parsing
- \t\t\t S PREFIX: Prepend all textual OIDs with PREFIX before parsing
- -L LOGOPTS\t\tToggle various defaults controlling logging:
- \t\t\t e: log to standard error
- \t\t\t o: log to standard output
- \t\t\t n: don't log at all
- \t\t\t f file: log to the specified file
- \t\t\t s facility: log to syslog (via the specified facility)
- \t\t\t (variants)
- \t\t\t [EON] pri: log to standard error, output or /dev/null for level 'pri' and above
- \t\t\t [EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
- \t\t\t [FS] pri token: log to file/syslog for level 'pri' and above
- \t\t\t [FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
- -C APPOPTS\t\tSet various application specific behaviours:
- \t\t\t f: do not fix errors and retry the request
- "]
- Missing object name
- USAGE: snmpget [OPTIONS] AGENT OID [OID]...
- Version: 5.9.4.pre2
- Web: http://www.net-snmp.org/
- Email: net-snmp-coders@lists.sourceforge.net
- OPTIONS:
- -h, --help display this help message
- -H display configuration file directives understood
- -v 1|2c|3 specifies SNMP version to use
- -V, --version display package version number
- SNMP Version 1 or 2c specific
- -c COMMUNITY set the community string
- SNMP Version 3 specific
- -a PROTOCOL set authentication protocol (MD5|SHA|SHA-224|SHA-256|SHA-384|SHA-512)
- -A PASSPHRASE set authentication protocol pass phrase
- -e ENGINE-ID set security engine ID (e.g. 800000020109840301)
- -E ENGINE-ID set context engine ID (e.g. 800000020109840301)
- -l LEVEL set security level (noAuthNoPriv|authNoPriv|authPriv)
- -n CONTEXT set context name (e.g. bridge1)
- -u USER-NAME set security name (e.g. bert)
- -x PROTOCOL set privacy protocol (DES|AES|AES-192|AES-256)
- -X PASSPHRASE set privacy protocol pass phrase
- -Z BOOTS,TIME set destination engine boots/time
- General communication options
- -r RETRIES set the number of retries
- -t TIMEOUT set the request timeout (in seconds)
- Debugging
- -d dump input/output packets in hexadecimal
- -D[TOKEN[,...]] turn on debugging output for the specified TOKENs
- (ALL gives extremely verbose debugging output)
- General options
- -m MIB[:...] load given list of MIBs (ALL loads everything)
- -M DIR[:...] look in given list of directories for MIBs
- (default: /opt/librenms/mibs:/opt/librenms/mibs/2n)
- -P MIBOPTS Toggle various defaults controlling MIB parsing:
- u: disallow the use of underlines in MIB symbols
- c: disallow the use of "--" to terminate comments
- d: save the DESCRIPTIONs of the MIB objects
- e: disable errors when MIB symbols conflict
- w: enable warnings when MIB symbols conflict
- W: enable detailed warnings when MIB symbols conflict
- R: replace MIB symbols from latest module
- -O OUTOPTS Toggle various defaults controlling output display:
- 0: print leading 0 for single-digit hex characters
- a: print all strings in ascii format
- b: do not break OID indexes down
- e: print enums numerically
- E: escape quotes in string indices
- f: print full OIDs on output
- n: print OIDs numerically
- p PRECISION: display floating point values with specified PRECISION (printf format string)
- q: quick print for easier parsing
- Q: quick print with equal-signs
- s: print only last symbolic element of OID
- S: print MIB module-id plus last element
- t: print timeticks unparsed as numeric integers
- T: print human-readable text along with hex strings
- u: print OIDs using UCD-style prefix suppression
- U: don't print units
- v: print values only (not OID = value)
- x: print all strings in hex format
- X: extended index format
- -I INOPTS Toggle various defaults controlling input parsing:
- b: do best/regex matching to find a MIB node
- h: don't apply DISPLAY-HINTs
- r: do not check values for range/type legality
- R: do random access to OID labels
- u: top-level OIDs must have '.' prefix (UCD-style)
- s SUFFIX: Append all textual OIDs with SUFFIX before parsing
- S PREFIX: Prepend all textual OIDs with PREFIX before parsing
- -L LOGOPTS Toggle various defaults controlling logging:
- e: log to standard error
- o: log to standard output
- n: don't log at all
- f file: log to the specified file
- s facility: log to syslog (via the specified facility)
- (variants)
- [EON] pri: log to standard error, output or /dev/null for level 'pri' and above
- [EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
- [FS] pri token: log to file/syslog for level 'pri' and above
- [FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
- -C APPOPTS Set various application specific behaviours:
- f: do not fix errors and retry the request
- >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'wireless': 0.0292 seconds with 118080 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-wireless.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-wireless.rrd N:0.029212951660156 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module wireless ####
- #### Load poller module ospf ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[290][0m 1.17ms]
- Processes:
- SNMP[[0;36m'/usr/bin/snmpwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUt' '-Pu' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
- SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[290,""][0m 0.59ms]
- Total processes: 0
- >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ospf': 0.0415 seconds with 103752 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ospf.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ospf.rrd N:0.041486024856567 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ospf ####
- #### Load poller module ospfv3 ####
- Module enabled: Global + | OS | Device | Manual
- Processes:
- SNMP[[0;36m'/usr/bin/snmpwalk' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/2n' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v1' '-c' 'COMMUNITY' '-OQXUt' '-Pu' '-Os' 'udp:HOSTNAME:161' 'OSPFV3-MIB::ospfv3GeneralGroup'[0m]
- SQL[[1;33mdelete from `ospfv3_instances` where `ospfv3_instances`.`device_id` = ? and `ospfv3_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[290,""][0m 1.03ms]
- Total processes: 0
- >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ospfv3': 0.0567 seconds with 70416 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ospfv3.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ospfv3.rrd N:0.05665397644043 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ospfv3 ####
- #### Load poller module aruba-controller ####
- Module enabled: Global + | OS | Device | Manual
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'aruba-controller': 0.0008 seconds with 4152 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-aruba-controller.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-aruba-controller.rrd N:0.00076699256896973 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module aruba-controller ####
- #### Load poller module entity-physical ####
- Module enabled: Global + | OS | Device | Manual
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'entity-physical': 0.0005 seconds with 8136 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-entity-physical.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-entity-physical.rrd N:0.00047492980957031 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module entity-physical ####
- #### Load poller module applications ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null and `applications`.`deleted_at` is null [0;33m[290][0m 0.89ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'applications': 0.0027 seconds with 65400 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-applications.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-applications.rrd N:0.002716064453125 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module applications ####
- #### Load poller module stp ####
- Module enabled: Global + | OS | Device | Manual
- Instances:
- SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[290][0m 0.87ms]
- Ports:
- SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[290][0m 1.09ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'stp': 0.0053 seconds with 76896 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-stp.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-stp.rrd N:0.0052890777587891 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module stp ####
- #### Load poller module ntp ####
- Module enabled: Global + | OS | Device | Manual
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'ntp': 0.0015 seconds with 2008 bytes
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf-ntp.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf-ntp.rrd N:0.0014569759368896 --daemon 192.168.150.40:42217[0m]
- #### Unload poller module ntp ####
- RRD[[0;32mlast INT-002-ENTREE.gestion/poller-perf.rrd --daemon 192.168.150.40:42217[0m]
- RRD[[0;32mupdate INT-002-ENTREE.gestion/poller-perf.rrd N:2.2704999446869 --daemon 192.168.150.40:42217[0m]
- SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[290][0m 1.28ms]
- Enabled graphs (7): poller_perf availability ping_perf poller_modules_perf uptime netstat_snmp netstat_snmp_pkt
- SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2025-03-25 09:12:41",2.2704999446868896,290][0m 2.04ms]
- >>> Polled INT-002-ENTREE.gestion (290) in 2.270 seconds <<<
- #### Start Alerts ####
- SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[290][0m 1.13ms]
- SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time(`end`) and time(`start`) <= ? and time(`end`) > ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (46, 172)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2025-03-25T13:12:41.701920Z","2025-03-25T13:12:41.701920Z",0,1,"13:12:41","13:12:41","13:12:41","13:12:41","[42m%","device",290,"device_group","location",11][0m 2.13ms]
- SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[290][0m 1.01ms]
- SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
- LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
- LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
- LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
- LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
- LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
- WHERE a.disabled = 0 AND (
- (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
- OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
- OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL))
- ) [0;33m[290,290,290,290,290,290,290,290,290,290,290][0m 3.28ms]
- Rule [0;35m#5 (Loop - Secteur Beauharnois):[0m
- SQL[[1;33mSELECT * FROM devices,syslog WHERE (devices.device_id = ? AND devices.device_id = syslog.device_id) AND syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) AND syslog.msg REGEXP ".*BPDU received on protected port.*" [0;33m[290][0m 20.93ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,290][0m 1ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#8 (Équipements up/down - Secteur Beauharnois):[0m
- SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[290][0m 1.28ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,290][0m 0.78ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#11 (Jumbo a configurer):[0m
- SQL[[1;33mSELECT * FROM devices,syslog WHERE (devices.device_id = ? AND devices.device_id = syslog.device_id) AND syslog.timestamp >= (DATE_SUB(NOW(),INTERVAL 5 MINUTE)) AND syslog.msg REGEXP ".*Excessive undersized*giant packets.*" [0;33m[290][0m 3.28ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,290][0m 0.56ms]
- Status: [0;34mNOCHG[0m
- #### End Alerts (0.0508s) ####
- ### Start Device Groups ###
- SQL[[1;33mselect * from `device_groups` [0;33m[][0m 1.17ms]
- SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181) [0;33m[][0m 5.28ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-001-01%",290][0m 0.89ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-002-01%",290][0m 0.67ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-003-01%",290][0m 0.59ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-004-01%",290][0m 0.63ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-005-01%",290][0m 0.38ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-006-01%",290][0m 0.36ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-007-01%",290][0m 0.46ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-008-01%",290][0m 0.46ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-009-01%",290][0m 0.68ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-010-01%",290][0m 0.47ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-011-01%",290][0m 0.44ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-012-01%",290][0m 0.82ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-013-01%",290][0m 0.66ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-014-01%",290][0m 0.8ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-015-01%",290][0m 0.87ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-016-01%",290][0m 0.74ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-017-01%",290][0m 0.43ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-018-01%",290][0m 0.37ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-019-01%",290][0m 0.39ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-020-01%",290][0m 0.42ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-021-01%",290][0m 0.41ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-022-01%",290][0m 0.49ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-023-01%",290][0m 0.51ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-024-01%",290][0m 0.39ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-025-01%",290][0m 0.38ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-026-01%",290][0m 0.44ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-027-01%",290][0m 0.82ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-028-01%",290][0m 0.61ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-034-01%",290][0m 0.81ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-035-01%",290][0m 0.69ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-036-01%",290][0m 0.67ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-037-01%",290][0m 0.61ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-039-01%",290][0m 0.59ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-040-01%",290][0m 0.67ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-041-01%",290][0m 0.59ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-042-01%",290][0m 0.54ms]
- SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`devices`.`hostname` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-043-01%","10.245.143.%","sbc%",290][0m 0.78ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-044-01%","s%-044-1-01%",290][0m 0.49ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-045-01%",290][0m 0.46ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-047-01%",290][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-049-01%",290][0m 0.46ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["s%-868-01%",290][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-001-%","s%-001-01%","UPS-%",290][0m 0.49ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-002-%","s%-002-01%","UPS-%",290][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-003-%","s%-003-01%","UPS-%",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-004-%","s%-004-01%","UPS-%",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-005-%","s%-005-01%","UPS-%",290][0m 0.37ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-006-%","s%-006-01%","UPS-%",290][0m 0.38ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-007-%","s%-007-01%","UPS-%",290][0m 0.35ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-008-%","s%-008-01%","UPS-%",290][0m 0.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-009-%","s%-009-01%","UPS-%",290][0m 0.37ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-010-%","s%-010-01%","UPS-%",290][0m 0.86ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-011-%","s%-011-01%","UPS-%",290][0m 0.74ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-012-%","s%-012-01%","UPS-%",290][0m 0.96ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-013-%","s%-013-01%","UPS-%",290][0m 0.76ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-014-%","s%-014-01%","UPS-%",290][0m 0.99ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-015-%","s%-015-01%","UPS-%",290][0m 0.88ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-016-%","s%-016-01%","UPS-%",290][0m 1.07ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-017-%","s%-017-01%","UPS-%",290][0m 1.19ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-018-%","s%-018-01%","UPS-%",290][0m 1.39ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-019-%","s%-019-01%","UPS-%",290][0m 1.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-020-%","s%-020-01%","UPS-%",290][0m 0.93ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-021-%","s%-021-01%","UPS-%",290][0m 0.68ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-022-%","s%-022-01%","UPS-%",290][0m 0.58ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-023-%","s%-023-01%","UPS-%",290][0m 0.53ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-024-%","s%-024-01%","UPS-%",290][0m 0.59ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-025-%","s%-025-01%","UPS-%",290][0m 0.7ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-026-%","s%-026-01%","UPS-%",290][0m 0.57ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-027-%","s%-027-01%","UPS-%",290][0m 0.54ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-028-%","s%-028-01%","UPS-%",290][0m 0.73ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-034-%","s%-034-01%","UPS-%",290][0m 0.63ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-035-%","s%-035-01%","UPS-%",290][0m 0.43ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-036-%","s%-036-01%","UPS-%",290][0m 0.41ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-037-%","s%-037-01%","UPS-%",290][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-039-%","s%-039-01%","UPS-%",290][0m 0.41ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-040-%","s%-040-01%","UPS-%",290][0m 0.36ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-041-%","s%-041-01%","UPS-%",290][0m 0.35ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-042-%","s%-042-01%","UPS-%",290][0m 0.3ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-043-%","s%-043-01%","UPS-%",290][0m 0.3ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-044-%","s%-044-01%","UPS-%",290][0m 0.31ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-045-%","s%-045-01%","UPS-%",290][0m 0.3ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-047-%","s%-047-01%","UPS-%",290][0m 0.66ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-049-%","s%-049-01%","UPS-%",290][0m 0.57ms]
- SQL[[1;33mselect exists(select * from `devices` where ((`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ? AND `devices`.`hostname` NOT LIKE ?) OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["%-868-%","s%-868-01%","UPS-%","%-100-%","UPS-%",290][0m 0.68ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-001-%","001-%","%-UPS.gestion",290][0m 0.7ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-002-%","002-%","%-UPS.gestion",290][0m 0.73ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-003-%","003-%","%-UPS.gestion",290][0m 0.76ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-004-%","004-%","%-UPS.gestion",290][0m 0.76ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-005-%","005-%","%-UPS.gestion",290][0m 0.91ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-006-%","006-%","%-UPS.gestion",290][0m 0.74ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-007-%","007-%","%-UPS.gestion",290][0m 0.68ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-008-%","008-%","%-UPS.gestion",290][0m 0.56ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-009-%","009-%","%-UPS.gestion",290][0m 0.47ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-010-%","010-%","%-UPS.gestion",290][0m 0.51ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-011-%","011-%","%-UPS.gestion",290][0m 0.53ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-012-%","012-%","%-UPS.gestion",290][0m 0.47ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-013-%","013-%","%-UPS.gestion",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-014-%","014-%","%-UPS.gestion",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-015-%","015-%","%-UPS.gestion",290][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-016-%","016-%","%-UPS.gestion",290][0m 0.47ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-017-%","017-%","%-UPS.gestion",290][0m 0.46ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-018-%","018-%","%-UPS.gestion",290][0m 0.6ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-019-%","019-%","%-UPS.gestion",290][0m 0.35ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-020-%","020-%","%-UPS.gestion",290][0m 0.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-021-%","021-%","%-UPS.gestion",290][0m 0.33ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-022-%","022-%","%-UPS.gestion",290][0m 0.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-023-%","023-%","%-UPS.gestion",290][0m 0.33ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-024-%","024-%","%-UPS.gestion",290][0m 0.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-025-%","025-%","%-UPS.gestion",290][0m 0.36ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-026-%","026-%","%-UPS.gestion",290][0m 0.35ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-027-%","027-%","%-UPS.gestion",290][0m 0.37ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-028-%","028-%","%-UPS.gestion",290][0m 0.35ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-034-%","034-%","%-UPS.gestion",290][0m 0.34ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-035-%","035-%","%-UPS.gestion",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-036-%","036-%","%-UPS.gestion",290][0m 0.45ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-037-%","037-%","%-UPS.gestion",290][0m 0.92ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-039-%","039-%","%-UPS.gestion",290][0m 0.64ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-040-%","040-%","%-UPS.gestion",290][0m 0.67ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-041-%","041-%","%-UPS.gestion",290][0m 0.6ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-042-%","042-%","%-UPS.gestion",290][0m 0.82ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-043-%","043-%","%-UPS.gestion",290][0m 1.06ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-044-%","044-%","%-UPS.gestion",290][0m 0.74ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-045-%","045-%","%-UPS.gestion",290][0m 0.7ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-047-%","047-%","%-UPS.gestion",290][0m 0.61ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-049-%","049-%","%-UPS.gestion",290][0m 0.62ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR (`devices`.`hostname` LIKE ? AND `devices`.`hostname` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-868-%","868-%","%-UPS.gestion",290][0m 0.62ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["SC-%","SD-%",290][0m 0.63ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["Critique-%","%-BH",290][0m 0.89ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["\u00c9quipements-%","%-BH",290][0m 1ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["Critique-%","%-HN",290][0m 0.89ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["\u00c9quipements-%","%-HN",290][0m 0.84ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["Critique-%","%-VF",290][0m 0.84ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["\u00c9quipements-%","%-VF",290][0m 0.94ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS%","%-BH",290][0m 0.88ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-%","%-HN",290][0m 0.93ms]
- SQL[[1;33mselect exists(select * from `devices` left join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` left join `device_groups` on `device_group_device`.`device_group_id` = `device_groups`.`id` where (`device_groups`.`name` LIKE ? AND `device_groups`.`name` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["UPS-%","%-VF",290][0m 0.91ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["DOM-%",290][0m 0.64ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;37mindows%",290][0m 0.67ms]
- SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[290][0m 0.62ms]
- Groups Added: Removed:
- ### End Device Groups (0.1887s) ###
- [0;36mSNMP[0m [25/1.05s]: Snmpget[17/0.75s] Snmpwalk[8/0.30s]
- [1;33mSQL[0m [200/1.85s]: Select[186/1.71s] Delete[4/0.02s] Update[10/0.11s]
- [0;32mRRD[0m [66/0.04s]: Other[33/0.03s] Update[33/0.01s]