LibreNMS Discovery SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.38ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.35ms] SQL[[1;33mselect version() [0;33m[][0m 0.22ms] =================================== Version info: Commit SHA: a71ea964b6498cda4e140551858d377301e6a670 Commit Date: 1650640185 DB Schema: 2022_04_08_085504_isis_adjacencies_table_add_index (236) PHP: 7.3.20 MySQL: 10.3.28-MariaDB RRDTool: 1.7.0 SNMP: 5.8 ==================================DEBUG! Updating os_def.cache SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND `device_id` = '257' ORDER BY device_id DESC [0;33m[][0m 0.59ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[257][0m 0.47ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[257][0m 0.62ms] snmp.meraki.com 257 cloud-controller [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '209.206.58.188' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 15.8/15.9/16.2 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-t' '5' 'udp:HOSTNAME:16100' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.29671.1 Modules status: Global+ OS Device #### Load disco module core #### Attempting to initialize OS: cloud-controller OS initialized as Generic SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' '-t' '5' 'udp:HOSTNAME:16100' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = .*.4.1.29671.1 .*.*.0 = Cisco Meraki Cloud Controller .*.*.0 = dashboard.meraki.com | Cisco Meraki Cloud Controller | .1.3.6.1.4.1.29671.1 | OS: Meraki Cloud Controller (cloud-controller) Attempting to initialize OS: cloud-controller OS initialized as Generic >> Runtime for discovery module 'core': 5.0640 seconds with -100440 bytes >> [0;36mSNMP[0m: [1/5.05s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS Device- Module [ os ] disabled on host. Modules status: Global+ OS Device- Module [ ports ] disabled on host. Modules status: Global+ OS Device- Module [ ports-stack ] disabled on host. Modules status: Global+ OS Device- Module [ entity-physical ] disabled on host. Modules status: Global+ OS Device- Module [ entity-state ] disabled on host. Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global+ OS Device- Module [ processors ] disabled on host. Modules status: Global+ OS Device- Module [ mempools ] disabled on host. Modules status: Global+ OS Device- Module [ cisco-vrf-lite ] disabled on host. Modules status: Global+ OS Device- Module [ cisco-mac-accounting ] disabled on host. Modules status: Global- OS Device Module [ cisco-pw ] disabled globally. Modules status: Global+ OS Device- Module [ vrf ] disabled on host. Modules status: Global+ OS Device- Module [ cisco-cef ] disabled on host. Modules status: Global+ OS Device- Module [ slas ] disabled on host. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global+ OS Device- Module [ ipv4-addresses ] disabled on host. Modules status: Global- OS Device Module [ ipv6-addresses ] disabled globally. Modules status: Global+ OS Device- Module [ route ] disabled on host. Modules status: Global+ OS Device #### Load disco module sensors #### Caching data: os sensors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OteQUs' '-Ih' '-m' 'MERAKI-CLOUD-CONTROLLER-MIB:SNMPv2-MIB:SNMPv2-SMI' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-t' '5' 'udp:HOSTNAME:16100' 'devName'[0m] devName.'8.y!..' = "MS-01" devName.'8.y"..' = "RBX88-SU50" devName.'8.y"..' = "MS-02" devName.'8.y#..' = "RBX88-SU-5-SS-3" devName.'8.y#,.' = "BAT88-SU-5-SS-1" devName.'8.y#0.' = "RBX88-SU51-2" devName.'8.y#=.' = "RBX88-SU51-1" devName.'8.y#V.' = "RBX75-SU35" devName.'8.y#c.' = "RBX88-SU52-2" devName.'8.y#..' = "BAT88-SU-5-SS-2" devName.'h:./..' = "SLF-IDF-G04-AP02" devName.'h:./..' = "SLF-IDF-F01-AP01" devName.'h:./..' = "SLF-IDF-G03-AP01" devName.'h:./..' = "SLF-IDF-G01-AP01" devName.'h:./..' = "SLF-RBX-BAT88-03-AP02" devName.'h:./..' = "SLF-IDF-C03-AP01" devName.'h:./..' = "SLF-IDF-F03-AP01" devName.'h:./..' = "SLF-IDF-F03-AP02" devName.'h:./..' = "SLF-IDF-G08-AP02" devName.'h:./..' = "SLF-IDF-B06-AP01" devName.'h:./..' = "SLF-IDF-G02-AP01" devName.'h:./..' = "SLF-IDF-B03-AP02" devName.'h:./..' = "SLF-IDF-B04-AP01" devName.'h:./..' = "SLF-STRA-01-AP01" devName.'h:./..' = "SLF-RBX-BAT75-04-AP02" devName.'h:./..' = "SLF-IDF-B04-AP02" devName.'h:./.!' = "SLF-IDF-F00-AP01" devName.'h:./.#' = "SLF-IDF-C01-AP04" devName.'h:./.%' = "SLF-RBX-BAT75-04-AP03" devName.'h:./..' = "SLF-IDF-C05-AP01" devName.'h:./.1' = "SLF-IDF-B00-AP05" devName.'h:./.3' = "DC2-ANZIN-PCI-AP01" devName.'h:./.4' = "SLF-IDF-G03-AP03" devName.'h:./.7' = "SLF-RBX-BAT75-04-AP01" devName.'h:./.L' = "SLF-RBX-AB-02-AP01" devName.'h:./.N' = "SLF-IDF-C02-AP04" devName.'h:./.P' = "SLF-LYO-06-AP02" devName.'h:./.R' = "SLF-RBX-BAT13-02-AP02" devName.'h:./.U' = "SLF-IDF-C04-AP01" devName.'h:./.W' = "SLF-IDF-B01-AP02" devName.'h:./.Y' = "SLF-RBX-BAT88-03-AP01" devName.'h:./.a' = "SLF-IDF-C05-AP02" devName.'h:./.e' = "SLF-IDF-C01-AP02" devName.'h:./.g' = "SLF-RBX-BAT13-RCH-AP02" devName.'h:./.i' = "SLF-IDF-G07-AP02" devName.'h:./..' = "SLF-RBX-AB-02-AP02" devName.'h:./..' = "SLF-LYO-06-AP01" devName.'h:./..' = "SLF-IDF-B06-AP02" devName.'h:./..' = "SLF-LYO-06-AP03" devName.'h:./..' = "SLF-IDF-B03-AP01" devName.'h:./..' = "SLF-RBX-BAT75-04-AP04" devName.'h:./..' = "SLF-STRA-01-AP02" devName.'h:./..' = "SLF-IDF-B02-AP01" devName.'h:./..' = "SLF-ANG-02-AP02" devName.'h:./.!' = "SLF-RBX-BAT88-05-AP01" devName.'h:./.#' = "SLF-IDF-G01-AP02" devName.'h:./.%' = "SLF-IDF-G02-AP02" devName.'h:./.+' = "SLF-IDF-G08-AP01" devName.'h:./.2' = "SLF-IDF-B02-AP02" devName.'h:./.6' = "SLF-IDF-F01-AP03" devName.'h:./.E' = "SLF-RBX-AB-01-AP01" devName.'h:./.F' = "SLF-IDF-C03-AP02" devName.'h:./.G' = "SLF-LYO-08-AP01" devName.'h:./.P' = "SLF-IDF-G07-AP01" devName.'h:./.j' = "SLF-IDF-B05-AP02" devName.'h:./.l' = "SLF-HAUSS-03-AP01" devName.'h:./.m' = "SLF-IDF-F07-AP02" devName.'h:./.n' = "SLF-IDF-C02-AP03" devName.'h:./.o' = "SLF-RBX-BAT88-05-AP02" devName.'h:./.q' = "SLF-RBX-BAT88-SS-AP02" devName.'h:./.s' = "SLF-IDF-G05-AP01" devName.'h:./.t' = "SLF-IDF-F05-AP02" devName.'h:./.u' = "SLF-IDF-C04-AP02" devName.'h:./.|' = "SLF-RBX-BAT88-03-AP03" devName.'h:./..' = "SLF-HAUSS-03-AP05" devName.'h:./..' = "SLF-IDF-F04-AP02" devName.'h:./..' = "SLF-ANG-02-AP04" devName.'h:./..' = "SLF-IDF-C06-AP01" devName.'h:./..' = "SLF-IDF-C02-AP02" devName.'h:./..' = "SLF-MAR-00-AP01" devName.'h:./..' = "SLF-IDF-C01-AP01" devName.'h:./..' = "SLF-IDF-F00-AP03" devName.'h:./..' = "SLF-LYO-08-AP03" devName.'h:./..' = "DC2-ANZIN-PCI-AP02" devName.'h:./..' = "SLF-IDF-C02-AP01" devName.'h:./..' = "SLF-IDF-C06-AP03" devName.'h:./..' = "SLF-IDF-G04-AP03" devName.'h:./..' = "SLF-IDF-F08-AP01" devName.'h:./..' = "SLF-IDF-B00-AP06" devName.'h:./..' = "SLF-IDF-G04-AP01" devName.'h:./..' = "SLF-IDF-G05-AP02" devName.'h:./..' = "SLF-IDF-F02-AP01" devName.'h:./..' = "SLF-IDF-F02-AP02" devName.'h:./..' = "SLF-RBX-BAT75-04-AP06" devName.'h:./..' = "SLF-IDF-F06-AP01" devName.'h:./..' = "SLF-IDF-F07-AP01" devName.'h:./..' = "SLF-RBX-BAT88-SS-AP01" devName.'h:./..' = "SLF-RBX-BAT13-01-AP02" devName.'h:./..' = "SLF-IDF-F00-AP02" devName.'h:./..' = "SLF-RBX-BAT13-SS-AP01" devName.'h:./..' = "SLF-IDF-F04-AP01" devName.'h:./..' = "SLF-IDF-G00-AP01" devName.'h:./..' = "SLF-IDF-F01-AP02" devName.'h:./..' = "SLF-IDF-B05-AP01" devName.'h:./..' = "SLF-IDF-C04-AP03" devName.'h:./..' = "SLF-IDF-G00-AP03" devName.'h:./..' = "SLF-MAR-00-AP02" devName.'h:./..' = "SLF-BOR00-AP01" devName.'h:./..' = "SLF-BOR-02-AP02" devName.'h:./..' = "SLF-HAUSS-03-AP02" devName.'h:./..' = "SLF-LYO-08-AP02" devName.'h:./..' = "SLF-ANG-02-AP03" devName.'h:./..' = "SLF-IDF-C00-AP01" devName.'h:./..' = "SLF-IDF-G03-AP02" devName.'h:./..' = "SLF-IDF-B00-AP03" devName.'h:./..' = "SLF-IDF-C06-AP02" devName.'h:./..' = "SLF-LYO-06-AP04" devName.'h:./..' = "SLF-IDF-F05-AP01" devName.'h:./..' = "SLF-RBX-BAT75-04-AP05" devName.'h:./..' = "SLF-IDF-G06-AP01" devName.'h:./..' = "SLF-ANG-02-AP01" devName.'h:./..' = "SLF-HAUSS-03-AP03" devName.'h:./..' = "SLF-IDF-B00-AP04" devName.'h:./..' = "SLF-IDF-B01-AP01" devName.'h:./..' = "SLF-IDF-G06-AP02" devName.'h:./..' = "SLF-IDF-G05-AP03" devName.'h:./..' = "SLF-IDF-G02-AP03" devName.'h:./..' = "SLF-RBX-BAT13-01-AP01" devName.'h:./..' = "SLF-RBX-BAT13-02-AP01" devName.'h:.T I' = "SLF-IDF-F06-AP02" devName.'h:.T J' = "SLF-IDF-B00-AP02" devName.'h:.T N' = "SLF-IDF-C01-AP03" devName.'h:.T h' = "SLF-IDF-G00-AP02" devName.'h:.T r' = "SLF-ANG-02-AP05" devName.'h:.T s' = "SLF-BOR-02-AP03" devName.'h:.T v' = "SLF-RBX-BAT13-RCH-AP01" devName.'h:.T .' = "SLF-STRA-00-AP01" devName.'h:.T .' = "SLF-MAR-00-AP03" devName.'h:.T .' = "SLF-IDF-C03-AP03" devName.'h:.T .' = "SLF-LYO-08-AP04" devName.'h:.T .' = "SLF-IDF-C05-AP03" devName.'h:.T .' = "SLF-HAUSS-03-AP04" devName.'h:.T .' = "SLF-IDF-B00-AP01" devName.'h:.T .' = "SLF-IDF-F08-AP02" devName.'h:....' = "DC2-PCI-SALLE 1" devName.'h:..'.' = "DC2-PCI-SALLE2" devName.'.....[' = "SLF-RBX-AB-RIE-AP02" devName.'......' = "SLF-RBX-BAT88-RCH-AP03" devName.'......' = "SLF-RBX-AB-02-AP04" devName.'.....2' = "SLF-RBX-AB-RIE-AP03" devName.'.....&' = "SLF-BOR-02-AP04" devName.'.....0' = "SLF-RBX-AB-01-AP02" devName.'.....2' = "SLF-RBX-BAT88-04-AP02" devName.'.....`' = "SLF-RBX-BAT88-02-AP02" devName.'.....o' = "SLF-RBX-BAT88-04-AP03" devName.'......' = "SLF-RBX-AB-RIE-AP01" devName.'......' = "SLF-RBX-AB-02-AP03" devName.'......' = "SLF-RBX-BAT88-SS-AP03" devName.'......' = "SLF-RBX-AB-01-AP06" devName.'.....4' = "SLF-RBX-BAT88-RCH-AP02" devName.'.....H' = "SLF-RBX-BAT88-01-AP02" devName.'.....U' = "SLF-RBX-BAT88-01-AP01" devName.'.....]' = "SLF-RBX-BAT88-01-AP03" devName.'.....^' = "SLF-RBX-BAT88-02-AP01" devName.'....._' = "SLF-RBX-BAT88-02-AP03" devName.'.....c' = "SLF-RBX-BAT88-RCH-AP01" devName.'.....e' = "SLF-RBX-AB-01-AP04" devName.'.....s' = "SLF-RBX-AB-01-AP03" devName.'.....t' = "SLF-RBX-BAT88-04-AP01" devName.'......' = "SLF-RBX-AB-01-AP05" SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OteQUs' '-Ih' '-m' 'MERAKI-CLOUD-CONTROLLER-MIB:SNMPv2-MIB:SNMPv2-SMI' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-t' '5' 'udp:HOSTNAME:16100' 'devLanIp'[0m] devLanIp = No Such Object available on this agent at this OID Invalid snmp_walk() data = devLanIp = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OteQUs' '-Ih' '-m' 'MERAKI-CLOUD-CONTROLLER-MIB:SNMPv2-MIB:SNMPv2-SMI' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-t' '5' 'udp:HOSTNAME:16100' 'devstatus'[0m] devStatus.'8.y!..' = 0 devStatus.'8.y"..' = 0 devStatus.'8.y"..' = 0 devStatus.'8.y#..' = 1 devStatus.'8.y#,.' = 1 devStatus.'8.y#0.' = 0 devStatus.'8.y#=.' = 0 devStatus.'8.y#V.' = 1 devStatus.'8.y#c.' = 0 devStatus.'8.y#..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./.!' = 1 devStatus.'h:./.#' = 1 devStatus.'h:./.%' = 1 devStatus.'h:./..' = 1 devStatus.'h:./.1' = 1 devStatus.'h:./.3' = 0 devStatus.'h:./.4' = 1 devStatus.'h:./.7' = 1 devStatus.'h:./.L' = 1 devStatus.'h:./.N' = 1 devStatus.'h:./.P' = 1 devStatus.'h:./.R' = 1 devStatus.'h:./.U' = 1 devStatus.'h:./.W' = 1 devStatus.'h:./.Y' = 1 devStatus.'h:./.a' = 1 devStatus.'h:./.e' = 1 devStatus.'h:./.g' = 1 devStatus.'h:./.i' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./.!' = 1 devStatus.'h:./.#' = 1 devStatus.'h:./.%' = 1 devStatus.'h:./.+' = 1 devStatus.'h:./.2' = 1 devStatus.'h:./.6' = 1 devStatus.'h:./.E' = 1 devStatus.'h:./.F' = 1 devStatus.'h:./.G' = 1 devStatus.'h:./.P' = 1 devStatus.'h:./.j' = 1 devStatus.'h:./.l' = 1 devStatus.'h:./.m' = 1 devStatus.'h:./.n' = 1 devStatus.'h:./.o' = 1 devStatus.'h:./.q' = 1 devStatus.'h:./.s' = 1 devStatus.'h:./.t' = 1 devStatus.'h:./.u' = 1 devStatus.'h:./.|' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 0 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:./..' = 1 devStatus.'h:.T I' = 1 devStatus.'h:.T J' = 1 devStatus.'h:.T N' = 1 devStatus.'h:.T h' = 1 devStatus.'h:.T r' = 1 devStatus.'h:.T s' = 1 devStatus.'h:.T v' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:.T .' = 1 devStatus.'h:....' = 0 devStatus.'h:..'.' = 0 devStatus.'.....[' = 1 devStatus.'......' = 1 devStatus.'......' = 1 devStatus.'.....2' = 1 devStatus.'.....&' = 1 devStatus.'.....0' = 1 devStatus.'.....2' = 1 devStatus.'.....`' = 1 devStatus.'.....o' = 1 devStatus.'......' = 1 devStatus.'......' = 1 devStatus.'......' = 1 devStatus.'......' = 1 devStatus.'.....4' = 1 devStatus.'.....H' = 1 devStatus.'.....U' = 1 devStatus.'.....]' = 1 devStatus.'.....^' = 1 devStatus.'....._' = 1 devStatus.'.....c' = 1 devStatus.'.....e' = 1 devStatus.'.....s' = 1 devStatus.'.....t' = 1 devStatus.'......' = 1 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OteQUs' '-Ih' '-m' 'MERAKI-CLOUD-CONTROLLER-MIB:SNMPv2-MIB:SNMPv2-SMI' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-t' '5' 'udp:HOSTNAME:16100' 'devClientCount'[0m] devClientCount.'8.y!..' = 0 devClientCount.'8.y"..' = 0 devClientCount.'8.y"..' = 0 devClientCount.'8.y#..' = 19 devClientCount.'8.y#,.' = 70 devClientCount.'8.y#0.' = 0 devClientCount.'8.y#=.' = 0 devClientCount.'8.y#V.' = 44 devClientCount.'8.y#c.' = 0 devClientCount.'8.y#..' = 12 devClientCount.'h:./..' = 4 devClientCount.'h:./..' = 5 devClientCount.'h:./..' = 5 devClientCount.'h:./..' = 6 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 10 devClientCount.'h:./..' = 4 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 6 devClientCount.'h:./.!' = 1 devClientCount.'h:./.#' = 0 devClientCount.'h:./.%' = 4 devClientCount.'h:./..' = 1 devClientCount.'h:./.1' = 0 devClientCount.'h:./.3' = 0 devClientCount.'h:./.4' = 5 devClientCount.'h:./.7' = 5 devClientCount.'h:./.L' = 1 devClientCount.'h:./.N' = 1 devClientCount.'h:./.P' = 0 devClientCount.'h:./.R' = 0 devClientCount.'h:./.U' = 0 devClientCount.'h:./.W' = 0 devClientCount.'h:./.Y' = 7 devClientCount.'h:./.a' = 8 devClientCount.'h:./.e' = 3 devClientCount.'h:./.g' = 3 devClientCount.'h:./.i' = 6 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./.!' = 0 devClientCount.'h:./.#' = 2 devClientCount.'h:./.%' = 0 devClientCount.'h:./.+' = 0 devClientCount.'h:./.2' = 0 devClientCount.'h:./.6' = 1 devClientCount.'h:./.E' = 2 devClientCount.'h:./.F' = 3 devClientCount.'h:./.G' = 1 devClientCount.'h:./.P' = 5 devClientCount.'h:./.j' = 8 devClientCount.'h:./.l' = 1 devClientCount.'h:./.m' = 4 devClientCount.'h:./.n' = 4 devClientCount.'h:./.o' = 9 devClientCount.'h:./.q' = 0 devClientCount.'h:./.s' = 5 devClientCount.'h:./.t' = 11 devClientCount.'h:./.u' = 7 devClientCount.'h:./.|' = 3 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 10 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 4 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 9 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 5 devClientCount.'h:./..' = 6 devClientCount.'h:./..' = 6 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 8 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 6 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 4 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 2 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 1 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 0 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 4 devClientCount.'h:./..' = 3 devClientCount.'h:./..' = 5 devClientCount.'h:./..' = 0 devClientCount.'h:.T I' = 0 devClientCount.'h:.T J' = 1 devClientCount.'h:.T N' = 0 devClientCount.'h:.T h' = 0 devClientCount.'h:.T r' = 1 devClientCount.'h:.T s' = 0 devClientCount.'h:.T v' = 11 devClientCount.'h:.T .' = 8 devClientCount.'h:.T .' = 6 devClientCount.'h:.T .' = 0 devClientCount.'h:.T .' = 0 devClientCount.'h:.T .' = 1 devClientCount.'h:.T .' = 0 devClientCount.'h:.T .' = 0 devClientCount.'h:.T .' = 2 devClientCount.'h:....' = 0 devClientCount.'h:..'.' = 0 devClientCount.'.....[' = 0 devClientCount.'......' = 4 devClientCount.'......' = 1 devClientCount.'.....2' = 0 devClientCount.'.....&' = 0 devClientCount.'.....0' = 4 devClientCount.'.....2' = 0 devClientCount.'.....`' = 1 devClientCount.'.....o' = 0 devClientCount.'......' = 0 devClientCount.'......' = 0 devClientCount.'......' = 0 devClientCount.'......' = 0 devClientCount.'.....4' = 22 devClientCount.'.....H' = 4 devClientCount.'.....U' = 10 devClientCount.'.....]' = 1 devClientCount.'.....^' = 1 devClientCount.'....._' = 0 devClientCount.'.....c' = 4 devClientCount.'.....e' = 0 devClientCount.'.....s' = 1 devClientCount.'.....t' = 6 devClientCount.'......' = 2 ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/meraki' '-t' '5' 'udp:HOSTNAME:16100' 'entPhysicalDescr'[0m] entPhysicalDescr = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhysicalDescr = No Such Object available on this agent at this OID SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",257,"ipmi"][0m 1.19ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",257,"ipmi"][0m 1.31ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",257,"ipmi"][0m 0.74ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",257,"ipmi"][0m 0.56ms] Airflow: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["airflow",257,"snmp"][0m 0.47ms] Current: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["current",257,"snmp"][0m 0.54ms] Charge: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["charge",257,"snmp"][0m 0.43ms] Dbm: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["dbm",257,"snmp"][0m 0.56ms] Fanspeed: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",257,"snmp"][0m 0.51ms] Frequency: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["frequency",257,"snmp"][0m 0.53ms] Humidity: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["humidity",257,"snmp"][0m 0.53ms] Load: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["load",257,"snmp"][0m 0.45ms] Loss: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["loss",257,"snmp"][0m 0.52ms] Power: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",257,"snmp"][0m 0.52ms] Power_consumed: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_consumed",257,"snmp"][0m 0.38ms] Power_factor: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_factor",257,"snmp"][0m 0.46ms] Runtime: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["runtime",257,"snmp"][0m 0.54ms] Signal: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["signal",257,"snmp"][0m 0.56ms] State: Dynamic Discovery (state): array ( 'data' => array ( 0 => array ( 'snmp_bulk' => false, 'oid' => 'devstatus', 'value' => 'devStatus', 'num_oid' => '.1.3.6.1.4.1.29671.1.1.4.1.3.{{ $index }}', 'descr' => '{{ $devName }}', 'index' => 'devstatus.{{ $index }}', 'state_name' => 'devStatus', 'group' => 'Meraki', 'states' => array ( 0 => array ( 'value' => 0, 'generic' => 2, 'graph' => 1, 'descr' => 'Offline', ), 1 => array ( 'value' => 1, 'generic' => 0, 'graph' => 1, 'descr' => 'Online', ), ), ), ), ) Data devstatus: array ( '\'8.y!..\'' => array ( 'devStatus' => '0', ), '\'8.y..\'' => array ( 'devStatus' => '0', ), '\'8.y#..\'' => array ( 'devStatus' => '1', ), '\'8.y#,.\'' => array ( 'devStatus' => '1', ), '\'8.y#0.\'' => array ( 'devStatus' => '0', ), '\'8.y#' => array ( 'devStatus' => '.\' = 0', ), '\'8.y#V.\'' => array ( 'devStatus' => '1', ), '\'8.y#c.\'' => array ( 'devStatus' => '0', ), '\'h:./..\'' => array ( 'devStatus' => '1', ), '\'h:./.!\'' => array ( 'devStatus' => '1', ), '\'h:./.#\'' => array ( 'devStatus' => '1', ), '\'h:./.%\'' => array ( 'devStatus' => '1', ), '\'h:./.1\'' => array ( 'devStatus' => '1', ), '\'h:./.3\'' => array ( 'devStatus' => '0', ), '\'h:./.4\'' => array ( 'devStatus' => '1', ), '\'h:./.7\'' => array ( 'devStatus' => '1', ), '\'h:./.L\'' => array ( 'devStatus' => '1', ), '\'h:./.N\'' => array ( 'devStatus' => '1', ), '\'h:./.P\'' => array ( 'devStatus' => '1', ), '\'h:./.R\'' => array ( 'devStatus' => '1', ), '\'h:./.U\'' => array ( 'devStatus' => '1', ), '\'h:./.W\'' => array ( 'devStatus' => '1', ), '\'h:./.Y\'' => array ( 'devStatus' => '1', ), '\'h:./.a\'' => array ( 'devStatus' => '1', ), '\'h:./.e\'' => array ( 'devStatus' => '1', ), '\'h:./.g\'' => array ( 'devStatus' => '1', ), '\'h:./.i\'' => array ( 'devStatus' => '1', ), '\'h:./.+\'' => array ( 'devStatus' => '1', ), '\'h:./.2\'' => array ( 'devStatus' => '1', ), '\'h:./.6\'' => array ( 'devStatus' => '1', ), '\'h:./.E\'' => array ( 'devStatus' => '1', ), '\'h:./.F\'' => array ( 'devStatus' => '1', ), '\'h:./.G\'' => array ( 'devStatus' => '1', ), '\'h:./.j\'' => array ( 'devStatus' => '1', ), '\'h:./.l\'' => array ( 'devStatus' => '1', ), '\'h:./.m\'' => array ( 'devStatus' => '1', ), '\'h:./.n\'' => array ( 'devStatus' => '1', ), '\'h:./.o\'' => array ( 'devStatus' => '1', ), '\'h:./.q\'' => array ( 'devStatus' => '1', ), '\'h:./.s\'' => array ( 'devStatus' => '1', ), '\'h:./.t\'' => array ( 'devStatus' => '1', ), '\'h:./.u\'' => array ( 'devStatus' => '1', ), '\'h:./.|\'' => array ( 'devStatus' => '1', ), '\'h:.T I\'' => array ( 'devStatus' => '1', ), '\'h:.T J\'' => array ( 'devStatus' => '1', ), '\'h:.T N\'' => array ( 'devStatus' => '1', ), '\'h:.T h\'' => array ( 'devStatus' => '1', ), '\'h:.T r\'' => array ( 'devStatus' => '1', ), '\'h:.T s\'' => array ( 'devStatus' => '1', ), '\'h:.T v\'' => array ( 'devStatus' => '1', ), '\'h:.T .\'' => array ( 'devStatus' => '1', ), '\'h:....\'' => array ( 'devStatus' => '0', ), '\'h:..\'.\'' => array ( 'devStatus' => '0', ), '\'.....[\'' => array ( 'devStatus' => '1', ), '\'......\'' => array ( 'devStatus' => '1', ), '\'.....2\'' => array ( 'devStatus' => '1', ), '\'.....&\'' => array ( 'devStatus' => '1', ), '\'.....0\'' => array ( 'devStatus' => '1', ), '\'.....`\'' => array ( 'devStatus' => '1', ), '\'.....o\'' => array ( 'devStatus' => '1', ), '\'.....4\'' => array ( 'devStatus' => '1', ), '\'.....H\'' => array ( 'devStatus' => '1', ), '\'.....U\'' => array ( 'devStatus' => '1', ), '\'.....]\'' => array ( 'devStatus' => '1', ), '\'.....^\'' => array ( 'devStatus' => '1', ), '\'....._\'' => array ( 'devStatus' => '1', ), '\'.....c\'' => array ( 'devStatus' => '1', ), '\'.....e\'' => array ( 'devStatus' => '1', ), '\'.....s\'' => array ( 'devStatus' => '1', ), '\'.....t\'' => array ( 'devStatus' => '1', ), ) Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.43ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y!..', devstatus.'8.y!..', devStatus, MS-01, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y!..'"][0m 0.63ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y!..'"][0m 0.67ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y!..'"][0m 0.49ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.23ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27128,"state_index_id":63}[0m 35.45ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.38ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y..', devstatus.'8.y..', devStatus, MS-02, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y..'"][0m 0.63ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y..'"][0m 0.75ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y..'"][0m 0.55ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27129,"state_index_id":63}[0m 125ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.37ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y#..', devstatus.'8.y#..', devStatus, BAT88-SU-5-SS-2, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y#..'"][0m 0.59ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#..'"][0m 0.63ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#..'"][0m 0.46ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27130,"state_index_id":63}[0m 279.8ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.37ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.25ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y#,.', devstatus.'8.y#,.', devStatus, BAT88-SU-5-SS-1, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y#,.'"][0m 0.61ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#,.'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#,.'"][0m 0.45ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.28ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27131,"state_index_id":63}[0m 35.91ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.35ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y#0.', devstatus.'8.y#0.', devStatus, RBX88-SU51-2, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y#0.'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#0.'"][0m 0.64ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#0.'"][0m 0.62ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.24ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27132,"state_index_id":63}[0m 79.06ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.35ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y#V.', devstatus.'8.y#V.', devStatus, RBX75-SU35, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y#V.'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#V.'"][0m 0.52ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#V.'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27133,"state_index_id":63}[0m 31.8ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.39ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'8.y#c.', devstatus.'8.y#c.', devStatus, RBX88-SU52-2, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'8.y#c.'"][0m 0.79ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#c.'"][0m 0.63ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'8.y#c.'"][0m 0.53ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27134,"state_index_id":63}[0m 9.37ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./..', devstatus.'h:./..', devStatus, SLF-RBX-BAT13-02-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/..'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/..'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/..'"][0m 0.46ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.15ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27135,"state_index_id":63}[0m 17.61ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.!', devstatus.'h:./.!', devStatus, SLF-RBX-BAT88-05-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.!'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.!'"][0m 0.5ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.!'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27136,"state_index_id":63}[0m 17.36ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.#', devstatus.'h:./.#', devStatus, SLF-IDF-G01-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.#'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.#'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.#'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27137,"state_index_id":63}[0m 2.6ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.19ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.%', devstatus.'h:./.%', devStatus, SLF-IDF-G02-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.%'"][0m 0.45ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.%'"][0m 0.51ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.%'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27138,"state_index_id":63}[0m 1.86ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.19ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.1', devstatus.'h:./.1', devStatus, SLF-IDF-B00-AP05, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.1'"][0m 0.43ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.1'"][0m 0.51ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.1'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27139,"state_index_id":63}[0m 2.23ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.19ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.3', devstatus.'h:./.3', devStatus, DC2-ANZIN-PCI-AP01, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.3'"][0m 0.45ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.3'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.3'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27140,"state_index_id":63}[0m 1.79ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.31ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.4', devstatus.'h:./.4', devStatus, SLF-IDF-G03-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.4'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.4'"][0m 0.51ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.4'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27141,"state_index_id":63}[0m 4.99ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.25ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.7', devstatus.'h:./.7', devStatus, SLF-RBX-BAT75-04-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.7'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.7'"][0m 0.52ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.7'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27142,"state_index_id":63}[0m 2.04ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.2ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.L', devstatus.'h:./.L', devStatus, SLF-RBX-AB-02-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.L'"][0m 0.72ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.L'"][0m 0.75ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.L'","SLF-RBX-AB-02-AP01",1,1,null,null,null,"Meraki",27143][0m 20.38ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27143,"sensor","2022-04-27 14:14:40",3,"Sensor Updated: state devStatus devstatus.'h:.\/.L' SLF-RBX-AB-02-AP01",""][0m 22.38ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.L'"][0m 0.75ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27143,"state_index_id":63}[0m 33.92ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.46ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.N', devstatus.'h:./.N', devStatus, SLF-IDF-C02-AP04, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.N'"][0m 0.67ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.N'"][0m 0.6ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.N'","SLF-IDF-C02-AP04",1,1,null,null,null,"Meraki",27144][0m 4.34ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27144,"sensor","2022-04-27 14:14:40",3,"Sensor Updated: state devStatus devstatus.'h:.\/.N' SLF-IDF-C02-AP04",""][0m 19.14ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.N'"][0m 0.66ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27144,"state_index_id":63}[0m 38.53ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.39ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.P', devstatus.'h:./.P', devStatus, SLF-IDF-G07-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.P'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.P'"][0m 0.52ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.P'"][0m 0.45ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27145,"state_index_id":63}[0m 16.63ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.37ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.59ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.R', devstatus.'h:./.R', devStatus, SLF-RBX-BAT13-02-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.R'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.R'"][0m 0.6ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.R'"][0m 0.75ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.22ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27146,"state_index_id":63}[0m 3.59ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.U', devstatus.'h:./.U', devStatus, SLF-IDF-C04-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.U'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.U'"][0m 0.54ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.U'","SLF-IDF-C04-AP01",1,1,null,null,null,"Meraki",27147][0m 42.35ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27147,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.U' SLF-IDF-C04-AP01",""][0m 15.26ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.U'"][0m 0.67ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27147,"state_index_id":63}[0m 16.25ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.32ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.25ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.W', devstatus.'h:./.W', devStatus, SLF-IDF-B01-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.W'"][0m 0.55ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.W'"][0m 0.85ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.W'"][0m 0.72ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27148,"state_index_id":63}[0m 3ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.Y', devstatus.'h:./.Y', devStatus, SLF-RBX-BAT88-03-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.Y'"][0m 0.75ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.Y'"][0m 0.81ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.Y'"][0m 0.69ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27149,"state_index_id":63}[0m 41.64ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.35ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.25ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.a', devstatus.'h:./.a', devStatus, SLF-IDF-C05-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.a'"][0m 0.54ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.a'"][0m 0.52ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.a'"][0m 0.44ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27150,"state_index_id":63}[0m 5.23ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.28ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.e', devstatus.'h:./.e', devStatus, SLF-IDF-C01-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.e'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.e'"][0m 0.52ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.e'","SLF-IDF-C01-AP02",1,1,null,null,null,"Meraki",27151][0m 33.38ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27151,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.e' SLF-IDF-C01-AP02",""][0m 56.53ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.e'"][0m 0.67ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27151,"state_index_id":63}[0m 4.84ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.g', devstatus.'h:./.g', devStatus, SLF-RBX-BAT13-RCH-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.g'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.g'"][0m 0.53ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.g'","SLF-RBX-BAT13-RCH-AP02",1,1,null,null,null,"Meraki",27152][0m 31.63ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27152,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.g' SLF-RBX-BAT13-RCH-AP02",""][0m 4.67ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.g'"][0m 0.65ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27152,"state_index_id":63}[0m 6.86ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.24ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.22ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.i', devstatus.'h:./.i', devStatus, SLF-IDF-G07-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.i'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.i'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.i'"][0m 0.57ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27153,"state_index_id":63}[0m 75.28ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.4ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.+', devstatus.'h:./.+', devStatus, SLF-IDF-G08-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.+'"][0m 0.66ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.+'"][0m 0.7ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.+'"][0m 0.61ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27154,"state_index_id":63}[0m 20.99ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.29ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.2', devstatus.'h:./.2', devStatus, SLF-IDF-B02-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.2'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.2'"][0m 0.64ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.2'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27155,"state_index_id":63}[0m 22.47ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.32ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.6', devstatus.'h:./.6', devStatus, SLF-IDF-F01-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.6'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.6'"][0m 0.55ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.6'"][0m 0.46ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27156,"state_index_id":63}[0m 64.04ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.76ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.4ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.E', devstatus.'h:./.E', devStatus, SLF-RBX-AB-01-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.E'"][0m 0.66ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.E'"][0m 0.62ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.E'","SLF-RBX-AB-01-AP01",1,1,null,null,null,"Meraki",27151][0m 2.28ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27151,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.E' SLF-RBX-AB-01-AP01",""][0m 1.77ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.E'"][0m 0.5ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27151,"state_index_id":63}[0m 2.35ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.2ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.F', devstatus.'h:./.F', devStatus, SLF-IDF-C03-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.F'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.F'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.F'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27157,"state_index_id":63}[0m 2.74ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.G', devstatus.'h:./.G', devStatus, SLF-LYO-08-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.G'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.G'"][0m 0.54ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.G'","SLF-LYO-08-AP01",1,1,null,null,null,"Meraki",27152][0m 33.65ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27152,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.G' SLF-LYO-08-AP01",""][0m 5.64ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.G'"][0m 0.69ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.22ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27152,"state_index_id":63}[0m 4.55ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.22ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.22ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.j', devstatus.'h:./.j', devStatus, SLF-IDF-B05-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.j'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.j'"][0m 0.67ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.j'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27158,"state_index_id":63}[0m 10.59ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.31ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.l', devstatus.'h:./.l', devStatus, SLF-HAUSS-03-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.l'"][0m 0.55ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.l'"][0m 0.52ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.l'","SLF-HAUSS-03-AP01",1,1,null,null,null,"Meraki",27143][0m 24.14ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27143,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.l' SLF-HAUSS-03-AP01",""][0m 91.3ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.l'"][0m 0.7ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.21ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27143,"state_index_id":63}[0m 17.1ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.28ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.22ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.m', devstatus.'h:./.m', devStatus, SLF-IDF-F07-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.m'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.m'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.m'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27159,"state_index_id":63}[0m 10.03ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.22ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.n', devstatus.'h:./.n', devStatus, SLF-IDF-C02-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.n'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.n'"][0m 0.51ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.n'","SLF-IDF-C02-AP03",1,1,null,null,null,"Meraki",27144][0m 11.27ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27144,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.n' SLF-IDF-C02-AP03",""][0m 67.81ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.n'"][0m 0.88ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.29ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27144,"state_index_id":63}[0m 2.07ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.27ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.3ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.o', devstatus.'h:./.o', devStatus, SLF-RBX-BAT88-05-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.o'"][0m 0.54ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.o'"][0m 0.61ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.o'"][0m 0.46ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27160,"state_index_id":63}[0m 16.4ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.34ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.q', devstatus.'h:./.q', devStatus, SLF-RBX-BAT88-SS-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.q'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.q'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.q'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27161,"state_index_id":63}[0m 35.93ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.44ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.34ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.s', devstatus.'h:./.s', devStatus, SLF-IDF-G05-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.s'"][0m 0.61ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.s'"][0m 0.56ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.s'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27162,"state_index_id":63}[0m 37.51ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.32ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.t', devstatus.'h:./.t', devStatus, SLF-IDF-F05-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.t'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.t'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.t'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27163,"state_index_id":63}[0m 13.26ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.32ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.u', devstatus.'h:./.u', devStatus, SLF-IDF-C04-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.u'"][0m 0.57ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.u'"][0m 0.67ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.3.'h:.\/.u'","SLF-IDF-C04-AP02",1,1,null,null,null,"Meraki",27147][0m 28.18ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,27147,"sensor","2022-04-27 14:14:41",3,"Sensor Updated: state devStatus devstatus.'h:.\/.u' SLF-IDF-C04-AP02",""][0m 2.24ms] ( 1 updated ) SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.u'"][0m 0.62ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27147,"state_index_id":63}[0m 5.95ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.25ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:./.|', devstatus.'h:./.|', devStatus, SLF-RBX-BAT88-03-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.\/.|'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.|'"][0m 0.52ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.\/.|'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27164,"state_index_id":63}[0m 18.68ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.3ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T I', devstatus.'h:.T I', devStatus, SLF-IDF-F06-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T I'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T I'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T I'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27165,"state_index_id":63}[0m 17.1ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.39ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T J', devstatus.'h:.T J', devStatus, SLF-IDF-B00-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T J'"][0m 0.66ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T J'"][0m 0.58ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T J'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27166,"state_index_id":63}[0m 8.66ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.22ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T N', devstatus.'h:.T N', devStatus, SLF-IDF-C01-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T N'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T N'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T N'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.15ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27167,"state_index_id":63}[0m 4.34ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.2ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T h', devstatus.'h:.T h', devStatus, SLF-IDF-G00-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T h'"][0m 0.44ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T h'"][0m 0.5ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T h'"][0m 0.4ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27168,"state_index_id":63}[0m 10.29ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.22ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.2ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T r', devstatus.'h:.T r', devStatus, SLF-ANG-02-AP05, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T r'"][0m 0.44ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T r'"][0m 0.5ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T r'"][0m 0.4ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27169,"state_index_id":63}[0m 2.12ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.19ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T s', devstatus.'h:.T s', devStatus, SLF-BOR-02-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T s'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T s'"][0m 0.5ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T s'"][0m 0.4ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27170,"state_index_id":63}[0m 22.43ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.23ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T v', devstatus.'h:.T v', devStatus, SLF-RBX-BAT13-RCH-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T v'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T v'"][0m 0.55ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T v'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27171,"state_index_id":63}[0m 4.79ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.2ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:.T .', devstatus.'h:.T .', devStatus, SLF-IDF-F08-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:.T .'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T .'"][0m 0.5ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:.T .'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.15ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27172,"state_index_id":63}[0m 2.07ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.19ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:....', devstatus.'h:....', devStatus, DC2-PCI-SALLE 1, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:....'"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:....'"][0m 0.49ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:....'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27173,"state_index_id":63}[0m 34.73ms] Sensor fetched value: 0 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.44ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.3ms] Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'h:..'.', devstatus.'h:..'.', devStatus, DC2-PCI-SALLE2, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'h:..'.'"][0m 0.55ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:..'.'"][0m 0.56ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'h:..'.'"][0m 0.47ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27174,"state_index_id":63}[0m 28.39ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.37ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.27ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....[', devstatus.'.....[', devStatus, SLF-RBX-AB-RIE-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....['"][0m 0.55ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....['"][0m 0.61ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....['"][0m 0.47ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27175,"state_index_id":63}[0m 6.27ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.24ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'......', devstatus.'......', devStatus, SLF-RBX-AB-01-AP05, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'......'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'......'"][0m 0.63ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'......'"][0m 0.52ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27176,"state_index_id":63}[0m 8.3ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....2', devstatus.'.....2', devStatus, SLF-RBX-BAT88-04-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....2'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....2'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....2'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27177,"state_index_id":63}[0m 44.54ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.35ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.25ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....&', devstatus.'.....&', devStatus, SLF-BOR-02-AP04, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....&'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....&'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....&'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27178,"state_index_id":63}[0m 50.36ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.39ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.24ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....0', devstatus.'.....0', devStatus, SLF-RBX-AB-01-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....0'"][0m 0.54ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....0'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....0'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.34ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27179,"state_index_id":63}[0m 121.98ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.38ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....`', devstatus.'.....`', devStatus, SLF-RBX-BAT88-02-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....`'"][0m 0.6ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....`'"][0m 0.68ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....`'"][0m 0.7ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.23ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27180,"state_index_id":63}[0m 38.54ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.32ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.3ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....o', devstatus.'.....o', devStatus, SLF-RBX-BAT88-04-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....o'"][0m 0.71ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....o'"][0m 0.6ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....o'"][0m 0.45ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27181,"state_index_id":63}[0m 2.66ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.23ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....4', devstatus.'.....4', devStatus, SLF-RBX-BAT88-RCH-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....4'"][0m 0.54ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....4'"][0m 0.73ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....4'"][0m 0.56ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27182,"state_index_id":63}[0m 13.97ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.33ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....H', devstatus.'.....H', devStatus, SLF-RBX-BAT88-01-AP02, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....H'"][0m 0.73ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....H'"][0m 0.76ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....H'"][0m 0.63ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27183,"state_index_id":63}[0m 12.74ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.31ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.22ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....U', devstatus.'.....U', devStatus, SLF-RBX-BAT88-01-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....U'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....U'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....U'"][0m 0.42ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.16ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27184,"state_index_id":63}[0m 2.39ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.3ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.28ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....]', devstatus.'.....]', devStatus, SLF-RBX-BAT88-01-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....]'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....]'"][0m 0.64ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....]'"][0m 0.44ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27185,"state_index_id":63}[0m 20.59ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.41ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.32ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....^', devstatus.'.....^', devStatus, SLF-RBX-BAT88-02-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....^'"][0m 0.55ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....^'"][0m 0.53ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....^'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.23ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27186,"state_index_id":63}[0m 71.82ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.36ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'....._', devstatus.'....._', devStatus, SLF-RBX-BAT88-02-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'....._'"][0m 0.59ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'....._'"][0m 0.57ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'....._'"][0m 0.48ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.2ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27187,"state_index_id":63}[0m 1.86ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.25ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....c', devstatus.'.....c', devStatus, SLF-RBX-BAT88-RCH-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....c'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....c'"][0m 0.51ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....c'"][0m 0.45ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27188,"state_index_id":63}[0m 13.39ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.23ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.27ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....e', devstatus.'.....e', devStatus, SLF-RBX-AB-01-AP04, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....e'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....e'"][0m 0.55ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....e'"][0m 0.5ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.17ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27189,"state_index_id":63}[0m 22.81ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.33ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.3ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....s', devstatus.'.....s', devStatus, SLF-RBX-AB-01-AP03, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....s'"][0m 0.52ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....s'"][0m 0.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....s'"][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27190,"state_index_id":63}[0m 13.71ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["devStatus"][0m 0.26ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[63][0m 0.21ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.3.'.....t', devstatus.'.....t', devStatus, SLF-RBX-BAT88-04-AP01, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",257,"devStatus","devstatus.'.....t'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....t'"][0m 0.51ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",257,"devStatus","devstatus.'.....t'"][0m 0.43ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["devStatus"][0m 0.15ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":27191,"state_index_id":63}[0m 2.52ms] array ( 'devStatus' => array ( 'devstatus.\'8.y!..\'' => 1, 'devstatus.\'8.y..\'' => 1, 'devstatus.\'8.y#..\'' => 1, 'devstatus.\'8.y#,.\'' => 1, 'devstatus.\'8.y#0.\'' => 1, 'devstatus.\'8.y#V.\'' => 1, 'devstatus.\'8.y#c.\'' => 1, 'devstatus.\'h:./..\'' => 1, 'devstatus.\'h:./.!\'' => 1, 'devstatus.\'h:./.#\'' => 1, 'devstatus.\'h:./.%\'' => 1, 'devstatus.\'h:./.1\'' => 1, 'devstatus.\'h:./.3\'' => 1, 'devstatus.\'h:./.4\'' => 1, 'devstatus.\'h:./.7\'' => 1, 'devstatus.\'h:./.L\'' => 1, 'devstatus.\'h:./.N\'' => 1, 'devstatus.\'h:./.P\'' => 1, 'devstatus.\'h:./.R\'' => 1, 'devstatus.\'h:./.U\'' => 1, 'devstatus.\'h:./.W\'' => 1, 'devstatus.\'h:./.Y\'' => 1, 'devstatus.\'h:./.a\'' => 1, 'devstatus.\'h:./.e\'' => 1, 'devstatus.\'h:./.g\'' => 1, 'devstatus.\'h:./.i\'' => 1, 'devstatus.\'h:./.+\'' => 1, 'devstatus.\'h:./.2\'' => 1, 'devstatus.\'h:./.6\'' => 1, 'devstatus.\'h:./.E\'' => 1, 'devstatus.\'h:./.F\'' => 1, 'devstatus.\'h:./.G\'' => 1, 'devstatus.\'h:./.j\'' => 1, 'devstatus.\'h:./.l\'' => 1, 'devstatus.\'h:./.m\'' => 1, 'devstatus.\'h:./.n\'' => 1, 'devstatus.\'h:./.o\'' => 1, 'devstatus.\'h:./.q\'' => 1, 'devstatus.\'h:./.s\'' => 1, 'devstatus.\'h:./.t\'' => 1, 'devstatus.\'h:./.u\'' => 1, 'devstatus.\'h:./.|\'' => 1, 'devstatus.\'h:.T I\'' => 1, 'devstatus.\'h:.T J\'' => 1, 'devstatus.\'h:.T N\'' => 1, 'devstatus.\'h:.T h\'' => 1, 'devstatus.\'h:.T r\'' => 1, 'devstatus.\'h:.T s\'' => 1, 'devstatus.\'h:.T v\'' => 1, 'devstatus.\'h:.T .\'' => 1, 'devstatus.\'h:....\'' => 1, 'devstatus.\'h:..\'.\'' => 1, 'devstatus.\'.....[\'' => 1, 'devstatus.\'......\'' => 1, 'devstatus.\'.....2\'' => 1, 'devstatus.\'.....&\'' => 1, 'devstatus.\'.....0\'' => 1, 'devstatus.\'.....`\'' => 1, 'devstatus.\'.....o\'' => 1, 'devstatus.\'.....4\'' => 1, 'devstatus.\'.....H\'' => 1, 'devstatus.\'.....U\'' => 1, 'devstatus.\'.....]\'' => 1, 'devstatus.\'.....^\'' => 1, 'devstatus.\'....._\'' => 1, 'devstatus.\'.....c\'' => 1, 'devstatus.\'.....e\'' => 1, 'devstatus.\'.....s\'' => 1, 'devstatus.\'.....t\'' => 1, ), ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["state",257,"snmp"][0m 1.78ms] devstatus.'8.y!..' -> devStatus devstatus.'8.y..' -> devStatus devstatus.'8.y#..' -> devStatus devstatus.'8.y#,.' -> devStatus devstatus.'8.y#0.' -> devStatus devstatus.'8.y#V.' -> devStatus devstatus.'8.y#c.' -> devStatus devstatus.'h:./..' -> devStatus devstatus.'h:./.!' -> devStatus devstatus.'h:./.#' -> devStatus devstatus.'h:./.%' -> devStatus devstatus.'h:./.1' -> devStatus devstatus.'h:./.3' -> devStatus devstatus.'h:./.4' -> devStatus devstatus.'h:./.7' -> devStatus devstatus.'h:./.L' -> devStatus devstatus.'h:./.N' -> devStatus devstatus.'h:./.P' -> devStatus devstatus.'h:./.R' -> devStatus devstatus.'h:./.U' -> devStatus devstatus.'h:./.W' -> devStatus devstatus.'h:./.Y' -> devStatus devstatus.'h:./.a' -> devStatus devstatus.'h:./.e' -> devStatus devstatus.'h:./.g' -> devStatus devstatus.'h:./.i' -> devStatus devstatus.'h:./.+' -> devStatus devstatus.'h:./.2' -> devStatus devstatus.'h:./.6' -> devStatus devstatus.'h:./.F' -> devStatus devstatus.'h:./.j' -> devStatus devstatus.'h:./.m' -> devStatus devstatus.'h:./.o' -> devStatus devstatus.'h:./.q' -> devStatus devstatus.'h:./.s' -> devStatus devstatus.'h:./.t' -> devStatus devstatus.'h:./.|' -> devStatus devstatus.'h:.T I' -> devStatus devstatus.'h:.T J' -> devStatus devstatus.'h:.T N' -> devStatus devstatus.'h:.T h' -> devStatus devstatus.'h:.T r' -> devStatus devstatus.'h:.T s' -> devStatus devstatus.'h:.T v' -> devStatus devstatus.'h:.T .' -> devStatus devstatus.'h:....' -> devStatus devstatus.'h:..'.' -> devStatus devstatus.'.....[' -> devStatus devstatus.'......' -> devStatus devstatus.'.....2' -> devStatus devstatus.'.....&' -> devStatus devstatus.'.....0' -> devStatus devstatus.'.....`' -> devStatus devstatus.'.....o' -> devStatus devstatus.'.....4' -> devStatus devstatus.'.....H' -> devStatus devstatus.'.....U' -> devStatus devstatus.'.....]' -> devStatus devstatus.'.....^' -> devStatus devstatus.'....._' -> devStatus devstatus.'.....c' -> devStatus devstatus.'.....e' -> devStatus devstatus.'.....s' -> devStatus devstatus.'.....t' -> devStatus Count: Dynamic Discovery (count): array ( 'data' => array ( 0 => array ( 'oid' => 'devClientCount', 'num_oid' => '.1.3.6.1.4.1.29671.1.1.4.1.5.{{ $index }}', 'index' => 'devClientCount.{{ $index }}', 'descr' => '{{ $devName }} - {{ $devClientCount }} user(s)', 'group' => 'Users Numbers', ), ), ) Data devClientCount: array ( '\'8.y!..\'' => array ( 'devClientCount' => '0', ), '\'8.y..\'' => array ( 'devClientCount' => '0', ), '\'8.y#..\'' => array ( 'devClientCount' => '12', ), '\'8.y#,.\'' => array ( 'devClientCount' => '70', ), '\'8.y#0.\'' => array ( 'devClientCount' => '0', ), '\'8.y#' => array ( 'devClientCount' => '.\' = 0', ), '\'8.y#V.\'' => array ( 'devClientCount' => '44', ), '\'8.y#c.\'' => array ( 'devClientCount' => '0', ), '\'h:./..\'' => array ( 'devClientCount' => '0', ), '\'h:./.!\'' => array ( 'devClientCount' => '0', ), '\'h:./.#\'' => array ( 'devClientCount' => '2', ), '\'h:./.%\'' => array ( 'devClientCount' => '0', ), '\'h:./.1\'' => array ( 'devClientCount' => '0', ), '\'h:./.3\'' => array ( 'devClientCount' => '0', ), '\'h:./.4\'' => array ( 'devClientCount' => '5', ), '\'h:./.7\'' => array ( 'devClientCount' => '5', ), '\'h:./.L\'' => array ( 'devClientCount' => '1', ), '\'h:./.N\'' => array ( 'devClientCount' => '1', ), '\'h:./.P\'' => array ( 'devClientCount' => '5', ), '\'h:./.R\'' => array ( 'devClientCount' => '0', ), '\'h:./.U\'' => array ( 'devClientCount' => '0', ), '\'h:./.W\'' => array ( 'devClientCount' => '0', ), '\'h:./.Y\'' => array ( 'devClientCount' => '7', ), '\'h:./.a\'' => array ( 'devClientCount' => '8', ), '\'h:./.e\'' => array ( 'devClientCount' => '3', ), '\'h:./.g\'' => array ( 'devClientCount' => '3', ), '\'h:./.i\'' => array ( 'devClientCount' => '6', ), '\'h:./.+\'' => array ( 'devClientCount' => '0', ), '\'h:./.2\'' => array ( 'devClientCount' => '0', ), '\'h:./.6\'' => array ( 'devClientCount' => '1', ), '\'h:./.E\'' => array ( 'devClientCount' => '2', ), '\'h:./.F\'' => array ( 'devClientCount' => '3', ), '\'h:./.G\'' => array ( 'devClientCount' => '1', ), '\'h:./.j\'' => array ( 'devClientCount' => '8', ), '\'h:./.l\'' => array ( 'devClientCount' => '1', ), '\'h:./.m\'' => array ( 'devClientCount' => '4', ), '\'h:./.n\'' => array ( 'devClientCount' => '4', ), '\'h:./.o\'' => array ( 'devClientCount' => '9', ), '\'h:./.q\'' => array ( 'devClientCount' => '0', ), '\'h:./.s\'' => array ( 'devClientCount' => '5', ), '\'h:./.t\'' => array ( 'devClientCount' => '11', ), '\'h:./.u\'' => array ( 'devClientCount' => '7', ), '\'h:./.|\'' => array ( 'devClientCount' => '3', ), '\'h:.T I\'' => array ( 'devClientCount' => '0', ), '\'h:.T J\'' => array ( 'devClientCount' => '1', ), '\'h:.T N\'' => array ( 'devClientCount' => '0', ), '\'h:.T h\'' => array ( 'devClientCount' => '0', ), '\'h:.T r\'' => array ( 'devClientCount' => '1', ), '\'h:.T s\'' => array ( 'devClientCount' => '0', ), '\'h:.T v\'' => array ( 'devClientCount' => '11', ), '\'h:.T .\'' => array ( 'devClientCount' => '2', ), '\'h:....\'' => array ( 'devClientCount' => '0', ), '\'h:..\'.\'' => array ( 'devClientCount' => '0', ), '\'.....[\'' => array ( 'devClientCount' => '0', ), '\'......\'' => array ( 'devClientCount' => '2', ), '\'.....2\'' => array ( 'devClientCount' => '0', ), '\'.....&\'' => array ( 'devClientCount' => '0', ), '\'.....0\'' => array ( 'devClientCount' => '4', ), '\'.....`\'' => array ( 'devClientCount' => '1', ), '\'.....o\'' => array ( 'devClientCount' => '0', ), '\'.....4\'' => array ( 'devClientCount' => '22', ), '\'.....H\'' => array ( 'devClientCount' => '4', ), '\'.....U\'' => array ( 'devClientCount' => '10', ), '\'.....]\'' => array ( 'devClientCount' => '1', ), '\'.....^\'' => array ( 'devClientCount' => '1', ), '\'....._\'' => array ( 'devClientCount' => '0', ), '\'.....c\'' => array ( 'devClientCount' => '4', ), '\'.....e\'' => array ( 'devClientCount' => '0', ), '\'.....s\'' => array ( 'devClientCount' => '1', ), '\'.....t\'' => array ( 'devClientCount' => '6', ), ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y!..', devClientCount.'8.y!..', cloud-controller, MS-01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y!..'"][0m 0.79ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y!..'"][0m 0.64ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y..', devClientCount.'8.y..', cloud-controller, MS-02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y..'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y..'"][0m 0.55ms] .Sensor fetched value: 12 Cur 12, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#..', devClientCount.'8.y#..', cloud-controller, BAT88-SU-5-SS-2 - 12 user(s), snmp, 1, 1, , 12, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y#..'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y#..'"][0m 0.52ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#..'","BAT88-SU-5-SS-2 - 12 user(s)",1,1,null,null,null,"Users Numbers",26809][0m 2.37ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26809,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'8.y#..' BAT88-SU-5-SS-2 - 12 user(s)",""][0m 2.48ms] ( 1 updated ) Sensor fetched value: 70 Cur 70, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#,.', devClientCount.'8.y#,.', cloud-controller, BAT88-SU-5-SS-1 - 70 user(s), snmp, 1, 1, , 70, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y#,.'"][0m 0.7ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y#,.'"][0m 0.68ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#,.'","BAT88-SU-5-SS-1 - 70 user(s)",1,1,null,null,null,"Users Numbers",26810][0m 13.79ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26810,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'8.y#,.' BAT88-SU-5-SS-1 - 70 user(s)",""][0m 12.43ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#0.', devClientCount.'8.y#0.', cloud-controller, RBX88-SU51-2 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y#0.'"][0m 0.69ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y#0.'"][0m 0.59ms] .Sensor fetched value: 44 Cur 44, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#V.', devClientCount.'8.y#V.', cloud-controller, RBX75-SU35 - 44 user(s), snmp, 1, 1, , 44, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y#V.'"][0m 0.57ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y#V.'"][0m 0.7ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#V.'","RBX75-SU35 - 44 user(s)",1,1,null,null,null,"Users Numbers",26812][0m 2.7ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26812,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'8.y#V.' RBX75-SU35 - 44 user(s)",""][0m 2.74ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'8.y#c.', devClientCount.'8.y#c.', cloud-controller, RBX88-SU52-2 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'8.y#c.'"][0m 0.56ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'8.y#c.'"][0m 0.75ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./..', devClientCount.'h:./..', cloud-controller, SLF-RBX-BAT13-02-AP01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/..'"][0m 0.66ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/..'"][0m 0.71ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.!', devClientCount.'h:./.!', cloud-controller, SLF-RBX-BAT88-05-AP01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.!'"][0m 0.63ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.!'"][0m 0.56ms] .Sensor fetched value: 2 Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.#', devClientCount.'h:./.#', cloud-controller, SLF-IDF-G01-AP02 - 2 user(s), snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.#'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.#'"][0m 0.52ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.%', devClientCount.'h:./.%', cloud-controller, SLF-IDF-G02-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.%'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.%'"][0m 0.5ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.1', devClientCount.'h:./.1', cloud-controller, SLF-IDF-B00-AP05 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.1'"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.1'"][0m 0.52ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.3', devClientCount.'h:./.3', cloud-controller, DC2-ANZIN-PCI-AP01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.3'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.3'"][0m 0.53ms] .Sensor fetched value: 5 Cur 5, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.4', devClientCount.'h:./.4', cloud-controller, SLF-IDF-G03-AP03 - 5 user(s), snmp, 1, 1, , 5, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.4'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.4'"][0m 0.56ms] .Sensor fetched value: 5 Cur 5, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.7', devClientCount.'h:./.7', cloud-controller, SLF-RBX-BAT75-04-AP01 - 5 user(s), snmp, 1, 1, , 5, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.7'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.7'"][0m 0.73ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.L', devClientCount.'h:./.L', cloud-controller, SLF-RBX-AB-02-AP01 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.L'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.L'"][0m 0.56ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.L'","SLF-RBX-AB-02-AP01 - 1 user(s)",1,1,null,null,null,"Users Numbers",26822][0m 19.57ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26822,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.L' SLF-RBX-AB-02-AP01 - 1 user(s)",""][0m 7.49ms] ( 1 updated ) Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.N', devClientCount.'h:./.N', cloud-controller, SLF-IDF-C02-AP04 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.N'"][0m 0.68ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.N'"][0m 0.61ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.N'","SLF-IDF-C02-AP04 - 1 user(s)",1,1,null,null,null,"Users Numbers",26823][0m 2.26ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26823,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.N' SLF-IDF-C02-AP04 - 1 user(s)",""][0m 42.02ms] ( 1 updated ) Sensor fetched value: 5 Cur 5, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.P', devClientCount.'h:./.P', cloud-controller, SLF-IDF-G07-AP01 - 5 user(s), snmp, 1, 1, , 5, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.P'"][0m 0.91ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.P'"][0m 0.62ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.R', devClientCount.'h:./.R', cloud-controller, SLF-RBX-BAT13-02-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.R'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.R'"][0m 0.62ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.U', devClientCount.'h:./.U', cloud-controller, SLF-IDF-C04-AP01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.U'"][0m 0.57ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.U'"][0m 0.78ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.U'","SLF-IDF-C04-AP01 - 0 user(s)",1,1,null,null,null,"Users Numbers",26826][0m 42.88ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26826,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.U' SLF-IDF-C04-AP01 - 0 user(s)",""][0m 2.94ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.W', devClientCount.'h:./.W', cloud-controller, SLF-IDF-B01-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.W'"][0m 0.72ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.W'"][0m 0.61ms] .Sensor fetched value: 7 Cur 7, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.Y', devClientCount.'h:./.Y', cloud-controller, SLF-RBX-BAT88-03-AP01 - 7 user(s), snmp, 1, 1, , 7, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.Y'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.Y'"][0m 0.53ms] .Sensor fetched value: 8 Cur 8, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.a', devClientCount.'h:./.a', cloud-controller, SLF-IDF-C05-AP02 - 8 user(s), snmp, 1, 1, , 8, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.a'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.a'"][0m 0.52ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.a'","SLF-IDF-C05-AP02 - 8 user(s)",1,1,null,null,null,"Users Numbers",26829][0m 11.96ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26829,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.a' SLF-IDF-C05-AP02 - 8 user(s)",""][0m 18.86ms] ( 1 updated ) Sensor fetched value: 3 Cur 3, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.e', devClientCount.'h:./.e', cloud-controller, SLF-IDF-C01-AP02 - 3 user(s), snmp, 1, 1, , 3, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.e'"][0m 0.99ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.e'"][0m 0.68ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.e'","SLF-IDF-C01-AP02 - 3 user(s)",1,1,null,null,null,"Users Numbers",26830][0m 25.11ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26830,"sensor","2022-04-27 14:14:42",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.e' SLF-IDF-C01-AP02 - 3 user(s)",""][0m 11.3ms] ( 1 updated ) Sensor fetched value: 3 Cur 3, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.g', devClientCount.'h:./.g', cloud-controller, SLF-RBX-BAT13-RCH-AP02 - 3 user(s), snmp, 1, 1, , 3, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.g'"][0m 0.8ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.g'"][0m 0.65ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.g'","SLF-RBX-BAT13-RCH-AP02 - 3 user(s)",1,1,null,null,null,"Users Numbers",26831][0m 67.89ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26831,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.g' SLF-RBX-BAT13-RCH-AP02 - 3 user(s)",""][0m 14.29ms] ( 1 updated ) Sensor fetched value: 6 Cur 6, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.i', devClientCount.'h:./.i', cloud-controller, SLF-IDF-G07-AP02 - 6 user(s), snmp, 1, 1, , 6, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.i'"][0m 1.03ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.i'"][0m 0.89ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.+', devClientCount.'h:./.+', cloud-controller, SLF-IDF-G08-AP01 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.+'"][0m 0.76ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.+'"][0m 0.79ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.2', devClientCount.'h:./.2', cloud-controller, SLF-IDF-B02-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.2'"][0m 0.71ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.2'"][0m 0.59ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.6', devClientCount.'h:./.6', cloud-controller, SLF-IDF-F01-AP03 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.6'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.6'"][0m 0.55ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.6'","SLF-IDF-F01-AP03 - 1 user(s)",1,1,null,null,null,"Users Numbers",26835][0m 79.5ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26835,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.6' SLF-IDF-F01-AP03 - 1 user(s)",""][0m 70.65ms] ( 1 updated ) Sensor fetched value: 2 Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.E', devClientCount.'h:./.E', cloud-controller, SLF-RBX-AB-01-AP01 - 2 user(s), snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.E'"][0m 0.85ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.E'"][0m 0.71ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.E'","SLF-RBX-AB-01-AP01 - 2 user(s)",1,1,null,null,null,"Users Numbers",26830][0m 107ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26830,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.E' SLF-RBX-AB-01-AP01 - 2 user(s)",""][0m 2.66ms] ( 1 updated ) Sensor fetched value: 3 Cur 3, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.F', devClientCount.'h:./.F', cloud-controller, SLF-IDF-C03-AP02 - 3 user(s), snmp, 1, 1, , 3, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.F'"][0m 0.81ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.F'"][0m 0.59ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.G', devClientCount.'h:./.G', cloud-controller, SLF-LYO-08-AP01 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.G'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.G'"][0m 0.55ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.G'","SLF-LYO-08-AP01 - 1 user(s)",1,1,null,null,null,"Users Numbers",26831][0m 18.4ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26831,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.G' SLF-LYO-08-AP01 - 1 user(s)",""][0m 14.73ms] ( 1 updated ) Sensor fetched value: 8 Cur 8, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.j', devClientCount.'h:./.j', cloud-controller, SLF-IDF-B05-AP02 - 8 user(s), snmp, 1, 1, , 8, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.j'"][0m 0.71ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.j'"][0m 0.6ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.j'","SLF-IDF-B05-AP02 - 8 user(s)",1,1,null,null,null,"Users Numbers",26837][0m 127.35ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26837,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.j' SLF-IDF-B05-AP02 - 8 user(s)",""][0m 26.19ms] ( 1 updated ) Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.l', devClientCount.'h:./.l', cloud-controller, SLF-HAUSS-03-AP01 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.l'"][0m 0.77ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.l'"][0m 0.66ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.l'","SLF-HAUSS-03-AP01 - 1 user(s)",1,1,null,null,null,"Users Numbers",26822][0m 47.83ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26822,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.l' SLF-HAUSS-03-AP01 - 1 user(s)",""][0m 33.97ms] ( 1 updated ) Sensor fetched value: 4 Cur 4, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.m', devClientCount.'h:./.m', cloud-controller, SLF-IDF-F07-AP02 - 4 user(s), snmp, 1, 1, , 4, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.m'"][0m 1.1ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.m'"][0m 0.89ms] .Sensor fetched value: 4 Cur 4, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.n', devClientCount.'h:./.n', cloud-controller, SLF-IDF-C02-AP03 - 4 user(s), snmp, 1, 1, , 4, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.n'"][0m 0.74ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.n'"][0m 0.84ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.n'","SLF-IDF-C02-AP03 - 4 user(s)",1,1,null,null,null,"Users Numbers",26823][0m 9.38ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26823,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.n' SLF-IDF-C02-AP03 - 4 user(s)",""][0m 3.46ms] ( 1 updated ) Sensor fetched value: 9 Cur 9, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.o', devClientCount.'h:./.o', cloud-controller, SLF-RBX-BAT88-05-AP02 - 9 user(s), snmp, 1, 1, , 9, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.o'"][0m 0.68ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.o'"][0m 0.59ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.o'","SLF-RBX-BAT88-05-AP02 - 9 user(s)",1,1,null,null,null,"Users Numbers",26839][0m 5.66ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26839,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.o' SLF-RBX-BAT88-05-AP02 - 9 user(s)",""][0m 3.29ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.q', devClientCount.'h:./.q', cloud-controller, SLF-RBX-BAT88-SS-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.q'"][0m 0.58ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.q'"][0m 0.59ms] .Sensor fetched value: 5 Cur 5, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.s', devClientCount.'h:./.s', cloud-controller, SLF-IDF-G05-AP01 - 5 user(s), snmp, 1, 1, , 5, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.s'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.s'"][0m 0.58ms] .Sensor fetched value: 11 Cur 11, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.t', devClientCount.'h:./.t', cloud-controller, SLF-IDF-F05-AP02 - 11 user(s), snmp, 1, 1, , 11, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.t'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.t'"][0m 0.54ms] .Sensor fetched value: 7 Cur 7, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.u', devClientCount.'h:./.u', cloud-controller, SLF-IDF-C04-AP02 - 7 user(s), snmp, 1, 1, , 7, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.u'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.u'"][0m 0.51ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.\/.u'","SLF-IDF-C04-AP02 - 7 user(s)",1,1,null,null,null,"Users Numbers",26826][0m 6.02ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26826,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.\/.u' SLF-IDF-C04-AP02 - 7 user(s)",""][0m 4.17ms] ( 1 updated ) Sensor fetched value: 3 Cur 3, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:./.|', devClientCount.'h:./.|', cloud-controller, SLF-RBX-BAT88-03-AP03 - 3 user(s), snmp, 1, 1, , 3, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.\/.|'"][0m 0.53ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.\/.|'"][0m 0.54ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T I', devClientCount.'h:.T I', cloud-controller, SLF-IDF-F06-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T I'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T I'"][0m 0.53ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T J', devClientCount.'h:.T J', cloud-controller, SLF-IDF-B00-AP02 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T J'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T J'"][0m 0.52ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T J'","SLF-IDF-B00-AP02 - 1 user(s)",1,1,null,null,null,"Users Numbers",26845][0m 89.22ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26845,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.T J' SLF-IDF-B00-AP02 - 1 user(s)",""][0m 8.94ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T N', devClientCount.'h:.T N', cloud-controller, SLF-IDF-C01-AP03 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T N'"][0m 0.77ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T N'"][0m 0.63ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T h', devClientCount.'h:.T h', cloud-controller, SLF-IDF-G00-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T h'"][0m 0.72ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T h'"][0m 0.62ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T r', devClientCount.'h:.T r', cloud-controller, SLF-ANG-02-AP05 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T r'"][0m 0.83ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T r'"][0m 0.59ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T s', devClientCount.'h:.T s', cloud-controller, SLF-BOR-02-AP03 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T s'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T s'"][0m 0.52ms] .Sensor fetched value: 11 Cur 11, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T v', devClientCount.'h:.T v', cloud-controller, SLF-RBX-BAT13-RCH-AP01 - 11 user(s), snmp, 1, 1, , 11, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T v'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T v'"][0m 0.57ms] .Sensor fetched value: 2 Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T .', devClientCount.'h:.T .', cloud-controller, SLF-IDF-F08-AP02 - 2 user(s), snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:.T .'"][0m 0.5ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:.T .'"][0m 0.55ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'h:.T .'","SLF-IDF-F08-AP02 - 2 user(s)",1,1,null,null,null,"Users Numbers",26851][0m 8.49ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26851,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'h:.T .' SLF-IDF-F08-AP02 - 2 user(s)",""][0m 3.12ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:....', devClientCount.'h:....', cloud-controller, DC2-PCI-SALLE 1 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:....'"][0m 0.57ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:....'"][0m 0.56ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'h:..'.', devClientCount.'h:..'.', cloud-controller, DC2-PCI-SALLE2 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'h:..'.'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'h:..'.'"][0m 0.51ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....[', devClientCount.'.....[', cloud-controller, SLF-RBX-AB-RIE-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....['"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....['"][0m 0.51ms] .Sensor fetched value: 2 Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'......', devClientCount.'......', cloud-controller, SLF-RBX-AB-01-AP05 - 2 user(s), snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'......'"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'......'"][0m 0.51ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'......'","SLF-RBX-AB-01-AP05 - 2 user(s)",1,1,null,null,null,"Users Numbers",26855][0m 15.21ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26855,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'......' SLF-RBX-AB-01-AP05 - 2 user(s)",""][0m 5.24ms] ( 1 updated ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....2', devClientCount.'.....2', cloud-controller, SLF-RBX-BAT88-04-AP02 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....2'"][0m 0.64ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....2'"][0m 0.57ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....&', devClientCount.'.....&', cloud-controller, SLF-BOR-02-AP04 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....&'"][0m 0.48ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....&'"][0m 0.52ms] .Sensor fetched value: 4 Cur 4, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....0', devClientCount.'.....0', cloud-controller, SLF-RBX-AB-01-AP02 - 4 user(s), snmp, 1, 1, , 4, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....0'"][0m 0.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....0'"][0m 0.52ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....`', devClientCount.'.....`', cloud-controller, SLF-RBX-BAT88-02-AP02 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....`'"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....`'"][0m 0.51ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....o', devClientCount.'.....o', cloud-controller, SLF-RBX-BAT88-04-AP03 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....o'"][0m 0.47ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....o'"][0m 0.53ms] .Sensor fetched value: 22 Cur 22, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....4', devClientCount.'.....4', cloud-controller, SLF-RBX-BAT88-RCH-AP02 - 22 user(s), snmp, 1, 1, , 22, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....4'"][0m 0.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....4'"][0m 0.51ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'.....4'","SLF-RBX-BAT88-RCH-AP02 - 22 user(s)",1,1,null,null,null,"Users Numbers",26861][0m 43.2ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26861,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'.....4' SLF-RBX-BAT88-RCH-AP02 - 22 user(s)",""][0m 3.09ms] ( 1 updated ) Sensor fetched value: 4 Cur 4, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....H', devClientCount.'.....H', cloud-controller, SLF-RBX-BAT88-01-AP02 - 4 user(s), snmp, 1, 1, , 4, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....H'"][0m 0.68ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....H'"][0m 0.62ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'.....H'","SLF-RBX-BAT88-01-AP02 - 4 user(s)",1,1,null,null,null,"Users Numbers",26862][0m 16.81ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26862,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'.....H' SLF-RBX-BAT88-01-AP02 - 4 user(s)",""][0m 2.68ms] ( 1 updated ) Sensor fetched value: 10 Cur 10, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....U', devClientCount.'.....U', cloud-controller, SLF-RBX-BAT88-01-AP01 - 10 user(s), snmp, 1, 1, , 10, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....U'"][0m 0.75ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....U'"][0m 0.85ms] SQL[[1;33mUPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=?,`group`=? WHERE `sensor_id` = ? [0;33m[".1.3.6.1.4.1.29671.1.1.4.1.5.'.....U'","SLF-RBX-BAT88-01-AP01 - 10 user(s)",1,1,null,null,null,"Users Numbers",26863][0m 3.37ms] USQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[257,26863,"sensor","2022-04-27 14:14:43",3,"Sensor Updated: count cloud-controller devClientCount.'.....U' SLF-RBX-BAT88-01-AP01 - 10 user(s)",""][0m 10.02ms] ( 1 updated ) Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....]', devClientCount.'.....]', cloud-controller, SLF-RBX-BAT88-01-AP03 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....]'"][0m 1.04ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....]'"][0m 0.93ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....^', devClientCount.'.....^', cloud-controller, SLF-RBX-BAT88-02-AP01 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....^'"][0m 0.78ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....^'"][0m 0.86ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'....._', devClientCount.'....._', cloud-controller, SLF-RBX-BAT88-02-AP03 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'....._'"][0m 0.74ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'....._'"][0m 0.8ms] .Sensor fetched value: 4 Cur 4, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....c', devClientCount.'.....c', cloud-controller, SLF-RBX-BAT88-RCH-AP01 - 4 user(s), snmp, 1, 1, , 4, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....c'"][0m 0.73ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....c'"][0m 0.8ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....e', devClientCount.'.....e', cloud-controller, SLF-RBX-AB-01-AP04 - 0 user(s), snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....e'"][0m 0.73ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....e'"][0m 0.79ms] .Sensor fetched value: 1 Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....s', devClientCount.'.....s', cloud-controller, SLF-RBX-AB-01-AP03 - 1 user(s), snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....s'"][0m 0.74ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....s'"][0m 0.62ms] .Sensor fetched value: 6 Cur 6, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.29671.1.1.4.1.5.'.....t', devClientCount.'.....t', cloud-controller, SLF-RBX-BAT88-04-AP01 - 6 user(s), snmp, 1, 1, , 6, (limits: LL: , LW: , W: , H: ) SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","count",257,"cloud-controller","devClientCount.'.....t'"][0m 0.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["count",257,"cloud-controller","devClientCount.'.....t'"][0m 0.56ms] .array ( 'cloud-controller' => array ( 'devClientCount.\'8.y!..\'' => 1, 'devClientCount.\'8.y..\'' => 1, 'devClientCount.\'8.y#..\'' => 1, 'devClientCount.\'8.y#,.\'' => 1, 'devClientCount.\'8.y#0.\'' => 1, 'devClientCount.\'8.y#V.\'' => 1, 'devClientCount.\'8.y#c.\'' => 1, 'devClientCount.\'h:./..\'' => 1, 'devClientCount.\'h:./.!\'' => 1, 'devClientCount.\'h:./.#\'' => 1, 'devClientCount.\'h:./.%\'' => 1, 'devClientCount.\'h:./.1\'' => 1, 'devClientCount.\'h:./.3\'' => 1, 'devClientCount.\'h:./.4\'' => 1, 'devClientCount.\'h:./.7\'' => 1, 'devClientCount.\'h:./.L\'' => 1, 'devClientCount.\'h:./.N\'' => 1, 'devClientCount.\'h:./.P\'' => 1, 'devClientCount.\'h:./.R\'' => 1, 'devClientCount.\'h:./.U\'' => 1, 'devClientCount.\'h:./.W\'' => 1, 'devClientCount.\'h:./.Y\'' => 1, 'devClientCount.\'h:./.a\'' => 1, 'devClientCount.\'h:./.e\'' => 1, 'devClientCount.\'h:./.g\'' => 1, 'devClientCount.\'h:./.i\'' => 1, 'devClientCount.\'h:./.+\'' => 1, 'devClientCount.\'h:./.2\'' => 1, 'devClientCount.\'h:./.6\'' => 1, 'devClientCount.\'h:./.E\'' => 1, 'devClientCount.\'h:./.F\'' => 1, 'devClientCount.\'h:./.G\'' => 1, 'devClientCount.\'h:./.j\'' => 1, 'devClientCount.\'h:./.l\'' => 1, 'devClientCount.\'h:./.m\'' => 1, 'devClientCount.\'h:./.n\'' => 1, 'devClientCount.\'h:./.o\'' => 1, 'devClientCount.\'h:./.q\'' => 1, 'devClientCount.\'h:./.s\'' => 1, 'devClientCount.\'h:./.t\'' => 1, 'devClientCount.\'h:./.u\'' => 1, 'devClientCount.\'h:./.|\'' => 1, 'devClientCount.\'h:.T I\'' => 1, 'devClientCount.\'h:.T J\'' => 1, 'devClientCount.\'h:.T N\'' => 1, 'devClientCount.\'h:.T h\'' => 1, 'devClientCount.\'h:.T r\'' => 1, 'devClientCount.\'h:.T s\'' => 1, 'devClientCount.\'h:.T v\'' => 1, 'devClientCount.\'h:.T .\'' => 1, 'devClientCount.\'h:....\'' => 1, 'devClientCount.\'h:..\'.\'' => 1, 'devClientCount.\'.....[\'' => 1, 'devClientCount.\'......\'' => 1, 'devClientCount.\'.....2\'' => 1, 'devClientCount.\'.....&\'' => 1, 'devClientCount.\'.....0\'' => 1, 'devClientCount.\'.....`\'' => 1, 'devClientCount.\'.....o\'' => 1, 'devClientCount.\'.....4\'' => 1, 'devClientCount.\'.....H\'' => 1, 'devClientCount.\'.....U\'' => 1, 'devClientCount.\'.....]\'' => 1, 'devClientCount.\'.....^\'' => 1, 'devClientCount.\'....._\'' => 1, 'devClientCount.\'.....c\'' => 1, 'devClientCount.\'.....e\'' => 1, 'devClientCount.\'.....s\'' => 1, 'devClientCount.\'.....t\'' => 1, ), ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["count",257,"snmp"][0m 1.68ms] devClientCount.'8.y!..' -> cloud-controller devClientCount.'8.y..' -> cloud-controller devClientCount.'8.y#..' -> cloud-controller devClientCount.'8.y#,.' -> cloud-controller devClientCount.'8.y#0.' -> cloud-controller devClientCount.'8.y#V.' -> cloud-controller devClientCount.'8.y#c.' -> cloud-controller devClientCount.'h:./..' -> cloud-controller devClientCount.'h:./.!' -> cloud-controller devClientCount.'h:./.#' -> cloud-controller devClientCount.'h:./.%' -> cloud-controller devClientCount.'h:./.1' -> cloud-controller devClientCount.'h:./.3' -> cloud-controller devClientCount.'h:./.4' -> cloud-controller devClientCount.'h:./.7' -> cloud-controller devClientCount.'h:./.L' -> cloud-controller devClientCount.'h:./.N' -> cloud-controller devClientCount.'h:./.P' -> cloud-controller devClientCount.'h:./.R' -> cloud-controller devClientCount.'h:./.U' -> cloud-controller devClientCount.'h:./.W' -> cloud-controller devClientCount.'h:./.Y' -> cloud-controller devClientCount.'h:./.a' -> cloud-controller devClientCount.'h:./.e' -> cloud-controller devClientCount.'h:./.g' -> cloud-controller devClientCount.'h:./.i' -> cloud-controller devClientCount.'h:./.+' -> cloud-controller devClientCount.'h:./.2' -> cloud-controller devClientCount.'h:./.6' -> cloud-controller devClientCount.'h:./.F' -> cloud-controller devClientCount.'h:./.j' -> cloud-controller devClientCount.'h:./.m' -> cloud-controller devClientCount.'h:./.o' -> cloud-controller devClientCount.'h:./.q' -> cloud-controller devClientCount.'h:./.s' -> cloud-controller devClientCount.'h:./.t' -> cloud-controller devClientCount.'h:./.|' -> cloud-controller devClientCount.'h:.T I' -> cloud-controller devClientCount.'h:.T J' -> cloud-controller devClientCount.'h:.T N' -> cloud-controller devClientCount.'h:.T h' -> cloud-controller devClientCount.'h:.T r' -> cloud-controller devClientCount.'h:.T s' -> cloud-controller devClientCount.'h:.T v' -> cloud-controller devClientCount.'h:.T .' -> cloud-controller devClientCount.'h:....' -> cloud-controller devClientCount.'h:..'.' -> cloud-controller devClientCount.'.....[' -> cloud-controller devClientCount.'......' -> cloud-controller devClientCount.'.....2' -> cloud-controller devClientCount.'.....&' -> cloud-controller devClientCount.'.....0' -> cloud-controller devClientCount.'.....`' -> cloud-controller devClientCount.'.....o' -> cloud-controller devClientCount.'.....4' -> cloud-controller devClientCount.'.....H' -> cloud-controller devClientCount.'.....U' -> cloud-controller devClientCount.'.....]' -> cloud-controller devClientCount.'.....^' -> cloud-controller devClientCount.'....._' -> cloud-controller devClientCount.'.....c' -> cloud-controller devClientCount.'.....e' -> cloud-controller devClientCount.'.....s' -> cloud-controller devClientCount.'.....t' -> cloud-controller Temperature: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",257,"snmp"][0m 1.26ms] Tv_signal: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["tv_signal",257,"snmp"][0m 0.55ms] Bitrate: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["bitrate",257,"snmp"][0m 0.4ms] Voltage: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",257,"snmp"][0m 0.48ms] Snr: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["snr",257,"snmp"][0m 0.37ms] Pressure: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["pressure",257,"snmp"][0m 0.5ms] Cooling: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["cooling",257,"snmp"][0m 0.44ms] Delay: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["delay",257,"snmp"][0m 0.46ms] Quality_factor: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["quality_factor",257,"snmp"][0m 0.4ms] Chromatic_dispersion: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["chromatic_dispersion",257,"snmp"][0m 0.46ms] Ber: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["ber",257,"snmp"][0m 0.45ms] Eer: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["eer",257,"snmp"][0m 0.43ms] Waterflow: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["waterflow",257,"snmp"][0m 0.41ms] Percent: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["percent",257,"snmp"][0m 0.48ms] >> Runtime for discovery module 'sensors': 99.8000 seconds with 573328 bytes >> [0;36mSNMP[0m: [5/96.03s] [1;33mMySQL[0m: [721/36.22s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS Device- Module [ storage ] disabled on host. Modules status: Global+ OS Device- Module [ hr-device ] disabled on host. Modules status: Global+ OS Device- Module [ discovery-protocols ] disabled on host. Modules status: Global+ OS Device- Module [ arp-table ] disabled on host. Modules status: Global+ OS Device- Module [ discovery-arp ] disabled on host. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global+ OS Device- Module [ bgp-peers ] disabled on host. Modules status: Global+ OS Device- Module [ vlans ] disabled on host. Modules status: Global- OS Device Module [ vmware-vminfo ] disabled globally. Modules status: Global- OS Device Module [ libvirt-vminfo ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device- Module [ ucd-diskio ] disabled on host. Modules status: Global+ OS Device- Module [ applications ] disabled on host. Modules status: Global+ OS Device- Module [ services ] disabled on host. Modules status: Global+ OS Device- Module [ stp ] disabled on host. Modules status: Global+ OS Device- Module [ ntp ] disabled on host. Modules status: Global+ OS Device- Module [ loadbalancers ] disabled on host. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device- Module [ wireless ] disabled on host. Modules status: Global+ OS Device- Module [ fdb-table ] disabled on host. Modules status: Global+ OS Device- Module [ mpls ] disabled on host. SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[106.094,257][0m 14.95ms] Discovered in 106.094 seconds ./discovery.php 257 2022-04-27 14:14:43 - 1 devices discovered in 106.3 secs [0;36mSNMP[0m [7/101.26s]: Snmpget[2/5.24s] Snmpwalk[5/96.03s] [1;33mSQL[0m [737/36.45s]: Select[598/2.78s] Delete[3/0.01s] Insert[102/23.54s] Update[34/10.13s] [0;32mRRD[0m [0/0.00s]: