From librenms, 10 Months ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.41ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.31ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.32ms]
  7.  
  8. ===========================================
  9. Component | Version
  10. --------- | -------
  11. LibreNMS  | 23.5.0 (2023-05-19T11:32:19-04:00)
  12. DB Schema | 2023_05_12_071412_devices_expand_timetaken_doubles (251)
  13. PHP       | 8.1.11
  14. Python    | 3.9.10
  15. Database  | MariaDB 10.5.16-MariaDB
  16. RRDTool   | 1.7.2
  17. SNMP      | 5.9.1
  18. ===========================================
  19. DEBUG!
  20. Updating os_def.cache  
  21. Starting polling run:
  22.  
  23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.1.250.132' ORDER BY `device_id` ASC [0;33m[][0m 0.69ms]
  24.  
  25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[661][0m 0.37ms]
  26.  
  27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[661][0m 0.32ms]
  28.  
  29. Attempting to initialize OS: linux  
  30. Attempting to initialize Group OS: unix  
  31. OS initialized: LibreNMS\OS\Shared\Unix  
  32. Hostname:    10.1.250.132
  33. Device ID:   661
  34. OS:          linux
  35.  (unix)
  36.  
  37. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.1.250.132'
  38.  
  39. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.185/0.195/0.209  
  40. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  41. SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
  42.  
  43.  
  44. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.185,0.209,0.195,3,3,0,"{\"poller_name\":\"librenms.indypl.org\"}",661,"2023-06-22 07:41:47"][0m 0.31ms]
  45.  
  46. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.195,661][0m 0.25ms]
  47.  
  48. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[661][0m 0.34ms]
  49.  
  50. Modules status: Global+  
  51. OS  
  52. Device  
  53.  
  54. #### Load poller module core ####
  55. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]  
  56. .*.*.0 = 167563
  57.  
  58.  
  59. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  60. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1676
  61. HOST-RESOURCES-MIB::hrSystemUptime.0 = 518002
  62.  
  63.  
  64. Uptime seconds: 5180
  65.  
  66. Uptime: 1 hour 26 minutes 20 seconds
  67. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[5180,661][0m 0.26ms]
  68.  
  69.  
  70. >> Runtime for poller module 'core': 0.0593 seconds with 119328 bytes
  71. >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [1/0.00s]  
  72. #### Unload poller module core ####
  73.  
  74. Modules status: Global-  
  75. OS  
  76. Device  
  77. Module [ unix-agent ] disabled globally.
  78.  
  79. Modules status: Global+  
  80. OS  
  81. Device  
  82.  
  83. #### Load poller module os ####
  84. Generic :(
  85. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[46][0m 0.26ms]
  86.  
  87. Location: Unknown
  88. Hardware: Generic x86 64-bit
  89. OS Version: 6.1.34
  90. OS Features:
  91. Serial:
  92.  
  93. >> Runtime for poller module 'os': 0.0027 seconds with 122288 bytes
  94. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  95. #### Unload poller module os ####
  96.  
  97. Modules status: Global+  
  98. OS  
  99. Device  
  100.  
  101. #### Load poller module availability ####
  102. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[661][0m 0.24ms]
  103.  
  104. Availability:
  105. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[661][0m 0.21ms]
  106.  
  107. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1687347707][0m 0.24ms]
  108.  
  109. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.66,2613][0m 0.15ms]
  110.  
  111. 1 day : 99.66%
  112. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1686829307][0m 0.23ms]
  113.  
  114. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.951,2614][0m 0.15ms]
  115.  
  116. 1 week : 99.951%
  117. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1684842107][0m 0.22ms]
  118.  
  119. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.989,2615][0m 0.16ms]
  120.  
  121. 1 month : 99.989%
  122. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1655898107][0m 0.22ms]
  123.  
  124. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.999,2616][0m 0.14ms]
  125.  
  126. 1 year : 99.999%
  127.  
  128. >> Runtime for poller module 'availability': 0.0050 seconds with 25480 bytes
  129. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s]  
  130. #### Unload poller module availability ####
  131.  
  132. Modules status: Global+  
  133. OS  
  134. Device  
  135.  
  136. #### Load poller module ipmi ####
  137. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[661][0m 0.27ms]
  138.  
  139. array (
  140. )  
  141.  
  142. >> Runtime for poller module 'ipmi': 0.0007 seconds with 2528 bytes
  143. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  144. #### Unload poller module ipmi ####
  145.  
  146. Modules status: Global+  
  147. OS  
  148. Device  
  149.  
  150. #### Load poller module sensors ####
  151. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[661][0m 0.27ms]
  152.  
  153.  
  154. >> Runtime for poller module 'sensors': 0.0005 seconds with 280 bytes
  155. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  156. #### Unload poller module sensors ####
  157.  
  158. Modules status: Global+  
  159. OS  
  160. Device  
  161.  
  162. #### Load poller module processors ####
  163. Attempting to initialize OS: linux  
  164. Attempting to initialize Group OS: unix  
  165. OS initialized: LibreNMS\OS\Shared\Unix  
  166. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[661][0m 0.25ms]
  167.  
  168. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608'[0m]
  169. .*.*.*608 = 1  
  170.  
  171. array (
  172.   '.1.3.6.1.2.1.25.3.3.1.2.196608' => '1',
  173. )  
  174. Intel Xeon Gold 6140 @ 2.30GHz: 1%
  175.  
  176. >> Runtime for poller module 'processors': 0.0282 seconds with 60456 bytes
  177. >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [1/0.00s]  
  178. #### Unload poller module processors ####
  179.  
  180. Modules status: Global+  
  181. OS  
  182. Device  
  183.  
  184. #### Load poller module mempools ####
  185. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[661][0m 0.42ms]
  186.  
  187. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1' '.1.3.6.1.2.1.25.2.3.1.6.3' '.1.3.6.1.2.1.25.2.3.1.6.6' '.1.3.6.1.2.1.25.2.3.1.6.7' '.1.3.6.1.2.1.25.2.3.1.6.8'[0m]
  188. .*.*.* = 932188
  189. .*.*.* = 932188
  190. .*.*.* = 153768
  191. .*.*.* = 616880
  192. .*.*.* = 4636  
  193.  
  194. Free memory adjusted by availability calculation: 14.75 GiB -> 15.48 GiB
  195.  
  196. hrstorage [system]: Physical memory: 17.75 MiB / 15.63 GiB
  197. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[165416960,16621936640,787][0m 0.29ms]
  198.  
  199. hrstorage [virtual]: Virtual memory: 6�0.34 MiB / 15.63 GiB
  200. hrstorage [buffers]: Memory buffers: 10.16 MiB / 15.63 GiB
  201. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[157458432,16629895168,789][0m 0.18ms]
  202.  
  203. hrstorage [cached]: Cached memory: 4`2.42 MiB / 15.63 GiB
  204. hrstorage [shared]: Shared memory: 0%  4.53 MiB / 15.63 GiB
  205.  
  206. >> Runtime for poller module 'mempools': 0.0324 seconds with 169536 bytes
  207. >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [3/0.01s]  
  208. #### Unload poller module mempools ####
  209.  
  210. Modules status: Global+  
  211. OS  
  212. Device  
  213.  
  214. #### Load poller module storage ####
  215. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[661][0m 0.35ms]
  216.  
  217. Storage /dev/shm: hrstorage
  218.  
  219.  
  220.  
  221. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
  222. hrStorageIndex.1 = 1
  223. hrStorageIndex.3 = 3
  224. hrStorageIndex.6 = 6
  225. hrStorageIndex.7 = 7
  226. hrStorageIndex.8 = 8
  227. hrStorageIndex.10 = 10
  228. hrStorageIndex.11 = 11
  229. hrStorageIndex.33 = 33
  230. hrStorageIndex.35 = 35
  231. hrStorageIndex.37 = 37
  232. hrStorageIndex.39 = 39
  233. hrStorageIndex.40 = 40
  234. hrStorageIndex.52 = 52
  235. hrStorageIndex.55 = 55
  236. hrStorageType.1 = hrStorageRam
  237. hrStorageType.3 = hrStorageVirtualMemory
  238. hrStorageType.6 = hrStorageOther
  239. hrStorageType.7 = hrStorageOther
  240. hrStorageType.8 = hrStorageOther
  241. hrStorageType.10 = hrStorageVirtualMemory
  242. hrStorageType.11 = hrStorageOther
  243. hrStorageType.33 = hrStorageFixedDisk
  244. hrStorageType.35 = hrStorageFixedDisk
  245. hrStorageType.37 = hrStorageFixedDisk
  246. hrStorageType.39 = hrStorageFixedDisk
  247. hrStorageType.40 = hrStorageFixedDisk
  248. hrStorageType.52 = hrStorageFixedDisk
  249. hrStorageType.55 = hrStorageFixedDisk
  250. hrStorageDescr.1 = Physical memory
  251. hrStorageDescr.3 = Virtual memory
  252. hrStorageDescr.6 = Memory buffers
  253. hrStorageDescr.7 = Cached memory
  254. hrStorageDescr.8 = Shared memory
  255. hrStorageDescr.10 = Swap space
  256. hrStorageDescr.11 = Available memory
  257. hrStorageDescr.33 = /dev/shm
  258. hrStorageDescr.35 = /run
  259. hrStorageDescr.37 = /run/wrappers
  260. hrStorageDescr.39 = /
  261. hrStorageDescr.40 = /nix/store
  262. hrStorageDescr.52 = /boot
  263. hrStorageDescr.55 = /run/user/1000
  264. hrStorageAllocationUnits.1 = 1024
  265. hrStorageAllocationUnits.3 = 1024
  266. hrStorageAllocationUnits.6 = 1024
  267. hrStorageAllocationUnits.7 = 1024
  268. hrStorageAllocationUnits.8 = 1024
  269. hrStorageAllocationUnits.10 = 1024
  270. hrStorageAllocationUnits.11 = 1024
  271. hrStorageAllocationUnits.33 = 4096
  272. hrStorageAllocationUnits.35 = 4096
  273. hrStorageAllocationUnits.37 = 4096
  274. hrStorageAllocationUnits.39 = 4096
  275. hrStorageAllocationUnits.40 = 4096
  276. hrStorageAllocationUnits.52 = 4096
  277. hrStorageAllocationUnits.55 = 4096
  278. hrStorageSize.1 = 16393900
  279. hrStorageSize.3 = 16393900
  280. hrStorageSize.6 = 16393900
  281. hrStorageSize.7 = 616880
  282. hrStorageSize.8 = 4636
  283. hrStorageSize.10 = 0
  284. hrStorageSize.11 = 15923672
  285. hrStorageSize.33 = 2049238
  286. hrStorageSize.35 = 1024619
  287. hrStorageSize.37 = 2049238
  288. hrStorageSize.39 = 12692951
  289. hrStorageSize.40 = 12692951
  290. hrStorageSize.52 = 130812
  291. hrStorageSize.55 = 409847
  292. hrStorageUsed.1 = 932188
  293. hrStorageUsed.3 = 932188
  294. hrStorageUsed.6 = 153768
  295. hrStorageUsed.7 = 616880
  296. hrStorageUsed.8 = 4636
  297. hrStorageUsed.10 = 0
  298. hrStorageUsed.11 = 0
  299. hrStorageUsed.33 = 0
  300. hrStorageUsed.35 = 1051
  301. hrStorageUsed.37 = 108
  302. hrStorageUsed.39 = 626824
  303. hrStorageUsed.40 = 626824
  304. hrStorageUsed.52 = 8177
  305. hrStorageUsed.55 = 0  
  306.  
  307. array (
  308.   'hrstorage' =>
  309.   array (
  310.     1 =>
  311.     array (
  312.       'hrStorageIndex' => '1',
  313.       'hrStorageType' => 'hrStorageRam',
  314.       'hrStorageDescr' => 'Physical memory',
  315.       'hrStorageAllocationUnits' => '1024',
  316.       'hrStorageSize' => '16393900',
  317.       'hrStorageUsed' => '932188',
  318.     ),
  319.     3 =>
  320.     array (
  321.       'hrStorageIndex' => '3',
  322.       'hrStorageType' => 'hrStorageVirtualMemory',
  323.       'hrStorageDescr' => 'Virtual memory',
  324.       'hrStorageAllocationUnits' => '1024',
  325.       'hrStorageSize' => '16393900',
  326.       'hrStorageUsed' => '932188',
  327.     ),
  328.     6 =>
  329.     array (
  330.       'hrStorageIndex' => '6',
  331.       'hrStorageType' => 'hrStorageOther',
  332.       'hrStorageDescr' => 'Memory buffers',
  333.       'hrStorageAllocationUnits' => '1024',
  334.       'hrStorageSize' => '16393900',
  335.       'hrStorageUsed' => '153768',
  336.     ),
  337.     7 =>
  338.     array (
  339.       'hrStorageIndex' => '7',
  340.       'hrStorageType' => 'hrStorageOther',
  341.       'hrStorageDescr' => 'Cached memory',
  342.       'hrStorageAllocationUnits' => '1024',
  343.       'hrStorageSize' => '616880',
  344.       'hrStorageUsed' => '616880',
  345.     ),
  346.     8 =>
  347.     array (
  348.       'hrStorageIndex' => '8',
  349.       'hrStorageType' => 'hrStorageOther',
  350.       'hrStorageDescr' => 'Shared memory',
  351.       'hrStorageAllocationUnits' => '1024',
  352.       'hrStorageSize' => '4636',
  353.       'hrStorageUsed' => '4636',
  354.     ),
  355.     10 =>
  356.     array (
  357.       'hrStorageIndex' => '10',
  358.       'hrStorageType' => 'hrStorageVirtualMemory',
  359.       'hrStorageDescr' => 'Swap space',
  360.       'hrStorageAllocationUnits' => '1024',
  361.       'hrStorageSize' => '0',
  362.       'hrStorageUsed' => '0',
  363.     ),
  364.     11 =>
  365.     array (
  366.       'hrStorageIndex' => '11',
  367.       'hrStorageType' => 'hrStorageOther',
  368.       'hrStorageDescr' => 'Available memory',
  369.       'hrStorageAllocationUnits' => '1024',
  370.       'hrStorageSize' => '15923672',
  371.       'hrStorageUsed' => '0',
  372.     ),
  373.     33 =>
  374.     array (
  375.       'hrStorageIndex' => '33',
  376.       'hrStorageType' => 'hrStorageFixedDisk',
  377.       'hrStorageDescr' => '/dev/shm',
  378.       'hrStorageAllocationUnits' => '4096',
  379.       'hrStorageSize' => '2049238',
  380.       'hrStorageUsed' => '0',
  381.     ),
  382.     35 =>
  383.     array (
  384.       'hrStorageIndex' => '35',
  385.       'hrStorageType' => 'hrStorageFixedDisk',
  386.       'hrStorageDescr' => '/run',
  387.       'hrStorageAllocationUnits' => '4096',
  388.       'hrStorageSize' => '1024619',
  389.       'hrStorageUsed' => '1051',
  390.     ),
  391.     37 =>
  392.     array (
  393.       'hrStorageIndex' => '37',
  394.       'hrStorageType' => 'hrStorageFixedDisk',
  395.       'hrStorageDescr' => '/run/wrappers',
  396.       'hrStorageAllocationUnits' => '4096',
  397.       'hrStorageSize' => '2049238',
  398.       'hrStorageUsed' => '108',
  399.     ),
  400.     39 =>
  401.     array (
  402.       'hrStorageIndex' => '39',
  403.       'hrStorageType' => 'hrStorageFixedDisk',
  404.       'hrStorageDescr' => '/',
  405.       'hrStorageAllocationUnits' => '4096',
  406.       'hrStorageSize' => '12692951',
  407.       'hrStorageUsed' => '626824',
  408.     ),
  409.     40 =>
  410.     array (
  411.       'hrStorageIndex' => '40',
  412.       'hrStorageType' => 'hrStorageFixedDisk',
  413.       'hrStorageDescr' => '/nix/store',
  414.       'hrStorageAllocationUnits' => '4096',
  415.       'hrStorageSize' => '12692951',
  416.       'hrStorageUsed' => '626824',
  417.     ),
  418.     52 =>
  419.     array (
  420.       'hrStorageIndex' => '52',
  421.       'hrStorageType' => 'hrStorageFixedDisk',
  422.       'hrStorageDescr' => '/boot',
  423.       'hrStorageAllocationUnits' => '4096',
  424.       'hrStorageSize' => '130812',
  425.       'hrStorageUsed' => '8177',
  426.     ),
  427.     55 =>
  428.     array (
  429.       'hrStorageIndex' => '55',
  430.       'hrStorageType' => 'hrStorageFixedDisk',
  431.       'hrStorageDescr' => '/run/user/1000',
  432.       'hrStorageAllocationUnits' => '4096',
  433.       'hrStorageSize' => '409847',
  434.       'hrStorageUsed' => '0',
  435.     ),
  436.   ),
  437. )  
  438. array (
  439.   'storage_id' => 1814,
  440.   'device_id' => 661,
  441.   'storage_mib' => 'hrstorage',
  442.   'storage_index' => '33',
  443.   'storage_type' => 'hrStorageFixedDisk',
  444.   'storage_descr' => '/dev/shm',
  445.   'storage_size' => 8393678848,
  446.   'storage_units' => 4096,
  447.   'storage_used' => 0,
  448.   'storage_free' => 8393678848,
  449.   'storage_perc' => 0,
  450.   'storage_perc_warn' => 60,
  451.   'storage_deleted' => 0,
  452.   'units' => '4096',
  453.   'used' => 0,
  454.   'size' => 8393678848,
  455.   'free' => 8393678848,
  456. )  
  457. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","8393678848","8393678848",4096,0,1814][0m 0.31ms]
  458.  
  459.  
  460. Storage /run: hrstorage
  461.  
  462.  
  463.  
  464. array (
  465.   'storage_id' => 1815,
  466.   'device_id' => 661,
  467.   'storage_mib' => 'hrstorage',
  468.   'storage_index' => '35',
  469.   'storage_type' => 'hrStorageFixedDisk',
  470.   'storage_descr' => '/run',
  471.   'storage_size' => 4196839424,
  472.   'storage_units' => 4096,
  473.   'storage_used' => 4304896,
  474.   'storage_free' => 4192534528,
  475.   'storage_perc' => 0,
  476.   'storage_perc_warn' => 60,
  477.   'storage_deleted' => 0,
  478.   'units' => '4096',
  479.   'used' => 4304896,
  480.   'size' => 4196839424,
  481.   'free' => 4192534528,
  482. )  
  483. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["4304896","4192534528","4196839424",4096,0,1815][0m 0.18ms]
  484.  
  485.  
  486. Storage /run/wrappers: hrstorage
  487.  
  488.  
  489.  
  490. array (
  491.   'storage_id' => 1816,
  492.   'device_id' => 661,
  493.   'storage_mib' => 'hrstorage',
  494.   'storage_index' => '37',
  495.   'storage_type' => 'hrStorageFixedDisk',
  496.   'storage_descr' => '/run/wrappers',
  497.   'storage_size' => 8393678848,
  498.   'storage_units' => 4096,
  499.   'storage_used' => 442368,
  500.   'storage_free' => 8393236480,
  501.   'storage_perc' => 0,
  502.   'storage_perc_warn' => 60,
  503.   'storage_deleted' => 0,
  504.   'units' => '4096',
  505.   'used' => 442368,
  506.   'size' => 8393678848,
  507.   'free' => 8393236480,
  508. )  
  509. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["442368","8393236480","8393678848",4096,0,1816][0m 0.17ms]
  510.  
  511.  
  512. Storage /: hrstorage
  513.  
  514.  
  515.  
  516. array (
  517.   'storage_id' => 1817,
  518.   'device_id' => 661,
  519.   'storage_mib' => 'hrstorage',
  520.   'storage_index' => '39',
  521.   'storage_type' => 'hrStorageFixedDisk',
  522.   'storage_descr' => '/',
  523.   'storage_size' => 51990327296,
  524.   'storage_units' => 4096,
  525.   'storage_used' => 2567471104,
  526.   'storage_free' => 49422856192,
  527.   'storage_perc' => 5,
  528.   'storage_perc_warn' => 60,
  529.   'storage_deleted' => 0,
  530.   'units' => '4096',
  531.   'used' => 2567471104,
  532.   'size' => 51990327296,
  533.   'free' => 49422856192,
  534. )  
  535. 5% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2567471104","49422856192","51990327296",4096,5,1817][0m 0.15ms]
  536.  
  537.  
  538. Storage /nix/store: hrstorage
  539.  
  540.  
  541.  
  542. array (
  543.   'storage_id' => 1818,
  544.   'device_id' => 661,
  545.   'storage_mib' => 'hrstorage',
  546.   'storage_index' => '40',
  547.   'storage_type' => 'hrStorageFixedDisk',
  548.   'storage_descr' => '/nix/store',
  549.   'storage_size' => 51990327296,
  550.   'storage_units' => 4096,
  551.   'storage_used' => 2567471104,
  552.   'storage_free' => 49422856192,
  553.   'storage_perc' => 5,
  554.   'storage_perc_warn' => 60,
  555.   'storage_deleted' => 0,
  556.   'units' => '4096',
  557.   'used' => 2567471104,
  558.   'size' => 51990327296,
  559.   'free' => 49422856192,
  560. )  
  561. 5% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2567471104","49422856192","51990327296",4096,5,1818][0m 0.15ms]
  562.  
  563.  
  564. Storage /boot: hrstorage
  565.  
  566.  
  567.  
  568. array (
  569.   'storage_id' => 1819,
  570.   'device_id' => 661,
  571.   'storage_mib' => 'hrstorage',
  572.   'storage_index' => '52',
  573.   'storage_type' => 'hrStorageFixedDisk',
  574.   'storage_descr' => '/boot',
  575.   'storage_size' => 535805952,
  576.   'storage_units' => 4096,
  577.   'storage_used' => 33492992,
  578.   'storage_free' => 502312960,
  579.   'storage_perc' => 6,
  580.   'storage_perc_warn' => 60,
  581.   'storage_deleted' => 0,
  582.   'units' => '4096',
  583.   'used' => 33492992,
  584.   'size' => 535805952,
  585.   'free' => 502312960,
  586. )  
  587. 6% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["33492992","502312960","535805952",4096,6,1819][0m 0.15ms]
  588.  
  589.  
  590. Storage /run/user/1000: hrstorage
  591.  
  592.  
  593.  
  594. array (
  595.   'storage_id' => 1820,
  596.   'device_id' => 661,
  597.   'storage_mib' => 'hrstorage',
  598.   'storage_index' => '55',
  599.   'storage_type' => 'hrStorageFixedDisk',
  600.   'storage_descr' => '/run/user/1000',
  601.   'storage_size' => 1678733312,
  602.   'storage_units' => 4096,
  603.   'storage_used' => 0,
  604.   'storage_free' => 1678733312,
  605.   'storage_perc' => 0,
  606.   'storage_perc_warn' => 60,
  607.   'storage_deleted' => 0,
  608.   'units' => '4096',
  609.   'used' => 0,
  610.   'size' => 1678733312,
  611.   'free' => 1678733312,
  612. )  
  613. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","1678733312","1678733312",4096,0,1820][0m 0.15ms]
  614.  
  615.  
  616.  
  617. >> Runtime for poller module 'storage': 0.0239 seconds with 44824 bytes
  618. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [8/0.02s]  
  619. #### Unload poller module storage ####
  620.  
  621. Modules status: Global+  
  622. OS  
  623. Device  
  624.  
  625. #### Load poller module netstats ####
  626. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0'[0m]  
  627. IP-MIB::icmpInMsgs.0 = 516
  628. IP-MIB::icmpOutMsgs.0 = 520
  629. IP-MIB::icmpInErrors.0 = 0
  630. IP-MIB::icmpOutErrors.0 = 0
  631. IP-MIB::icmpInEchos.0 = 72
  632. IP-MIB::icmpOutEchos.0 = 8
  633. IP-MIB::icmpInEchoReps.0 = 4
  634. IP-MIB::icmpOutEchoReps.0 = 72
  635. IP-MIB::icmpInDestUnreachs.0 = 440
  636. IP-MIB::icmpOutDestUnreachs.0 = 440
  637.  
  638.  
  639. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0'[0m]  
  640. IP-MIB::icmpInParmProbs.0 = 0
  641. IP-MIB::icmpInTimeExcds.0 = 0
  642. IP-MIB::icmpInSrcQuenchs.0 = 0
  643. IP-MIB::icmpInRedirects.0 = 0
  644. IP-MIB::icmpInTimestamps.0 = 0
  645. IP-MIB::icmpInTimestampReps.0 = 0
  646. IP-MIB::icmpInAddrMasks.0 = 0
  647. IP-MIB::icmpInAddrMaskReps.0 = 0
  648. IP-MIB::icmpOutTimeExcds.0 = 0
  649. IP-MIB::icmpOutParmProbs.0 = 0
  650.  
  651.  
  652. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m]  
  653. IP-MIB::icmpOutSrcQuenchs.0 = 0
  654. IP-MIB::icmpOutRedirects.0 = 0
  655. IP-MIB::icmpOutTimestamps.0 = 0
  656. IP-MIB::icmpOutTimestampReps.0 = 0
  657. IP-MIB::icmpOutAddrMasks.0 = 0
  658. IP-MIB::icmpOutAddrMaskReps.0 = 0
  659.  
  660.  
  661. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0'[0m]  
  662. IP-MIB::ipForwDatagrams.0 = 0
  663. IP-MIB::ipInDelivers.0 = 8772
  664. IP-MIB::ipInReceives.0 = 11236
  665. IP-MIB::ipOutRequests.0 = 6038
  666. IP-MIB::ipInDiscards.0 = 0
  667. IP-MIB::ipOutDiscards.0 = 220
  668. IP-MIB::ipOutNoRoutes.0 = 1
  669. IP-MIB::ipReasmReqds.0 = 0
  670. IP-MIB::ipReasmOKs.0 = 0
  671. IP-MIB::ipReasmFails.0 = 0
  672.  
  673.  
  674. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]  
  675. IP-MIB::ipFragOKs.0 = 0
  676. IP-MIB::ipFragFails.0 = 0
  677. IP-MIB::ipFragCreates.0 = 0
  678. IP-MIB::ipInUnknownProtos.0 = 0
  679. IP-MIB::ipInHdrErrors.0 = 0
  680. IP-MIB::ipInAddrErrors.0 = 0
  681.  
  682.  
  683. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  684. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  685.  
  686.  
  687. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0'[0m]  
  688. SNMPv2-MIB::snmpInPkts.0 = 1546
  689. SNMPv2-MIB::snmpOutPkts.0 = 1545
  690. SNMPv2-MIB::snmpInBadVersions.0 = 0
  691. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
  692. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
  693. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
  694. SNMPv2-MIB::snmpInTooBigs.0 = 0
  695. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  696. SNMPv2-MIB::snmpInBadValues.0 = 0
  697. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  698.  
  699.  
  700. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0'[0m]  
  701. SNMPv2-MIB::snmpInGenErrs.0 = 0
  702. SNMPv2-MIB::snmpInTotalReqVars.0 = 8426
  703. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  704. SNMPv2-MIB::snmpInGetRequests.0 = 854
  705. SNMPv2-MIB::snmpInGetNexts.0 = 0
  706. SNMPv2-MIB::snmpInSetRequests.0 = 0
  707. SNMPv2-MIB::snmpInGetResponses.0 = 0
  708. SNMPv2-MIB::snmpInTraps.0 = 0
  709. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  710. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
  711.  
  712.  
  713. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m]  
  714. SNMPv2-MIB::snmpOutBadValues.0 = 0
  715. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  716. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  717. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  718. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  719. SNMPv2-MIB::snmpOutGetResponses.0 = 1547
  720. SNMPv2-MIB::snmpOutTraps.0 = 0
  721. SNMPv2-MIB::snmpSilentDrops.0 = 0
  722. SNMPv2-MIB::snmpProxyDrops.0 = 0
  723.  
  724.  
  725. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  726. UDP-MIB::udpInDatagrams.0 = 1992
  727. UDP-MIB::udpOutDatagrams.0 = 2359
  728. UDP-MIB::udpInErrors.0 = 0
  729. UDP-MIB::udpNoPorts.0 = 440
  730.  
  731.  
  732. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m]  
  733. TCP-MIB::tcpActiveOpens.0 = 2
  734. TCP-MIB::tcpPassiveOpens.0 = 3
  735. TCP-MIB::tcpAttemptFails.0 = 0
  736. TCP-MIB::tcpEstabResets.0 = 0
  737. TCP-MIB::tcpCurrEstab.0 = 1
  738. TCP-MIB::tcpInSegs.0 = 5830
  739. TCP-MIB::tcpOutSegs.0 = 3190
  740. TCP-MIB::tcpRetransSegs.0 = 1
  741. TCP-MIB::tcpInErrs.0 = 0
  742. TCP-MIB::tcpOutRsts.0 = 4
  743.  
  744.  
  745.  
  746.  
  747. >> Runtime for poller module 'netstats': 0.3024 seconds with 46952 bytes
  748. >> [0;36mSNMP[0m: [11/0.30s] [1;33mMySQL[0m: [0/0.00s]  
  749. #### Unload poller module netstats ####
  750.  
  751. Modules status: Global+  
  752. OS  
  753. Device  
  754.  
  755. #### Load poller module hr-mib ####
  756. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  757. hrSystemMaxProcesses.0 = 0
  758. hrSystemProcesses.0 = 106
  759. hrSystemNumUsers.0 = 1  
  760.  
  761.  ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[661][0m 0.37ms]
  762.  
  763.  Users
  764.  
  765. >> Runtime for poller module 'hr-mib': 0.0240 seconds with 35232 bytes
  766. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [1/0.00s]  
  767. #### Unload poller module hr-mib ####
  768.  
  769. Modules status: Global+  
  770. OS  
  771. Device  
  772.  
  773. #### Load poller module ucd-mib ####
  774. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
  775. ssIndex.0 = 1
  776. ssErrorName.0 = systemStats
  777. ssSwapIn.0 = 0
  778. ssSwapOut.0 = 0
  779. ssIOSent.0 = 0
  780. ssIOReceive.0 = 0
  781. ssSysInterrupts.0 = 42
  782. ssSysContext.0 = 65
  783. ssCpuUser.0 = 0
  784. ssCpuSystem.0 = 0
  785. ssCpuIdle.0 = 99
  786. ssCpuRawUser.0 = 4146
  787. ssCpuRawNice.0 = 0
  788. ssCpuRawSystem.0 = 2333
  789. ssCpuRawIdle.0 = 509548
  790. ssCpuRawWait.0 = 1367
  791. ssCpuRawKernel.0 = 0
  792. ssCpuRawInterrupt.0 = 0
  793. ssIORawSent.0 = 1120978
  794. ssIORawReceived.0 = 563714
  795. ssRawInterrupts.0 = 320494
  796. ssRawContexts.0 = 573144
  797. ssCpuRawSoftIRQ.0 = 6
  798. ssRawSwapIn.0 = 0
  799. ssRawSwapOut.0 = 0
  800. ssCpuRawSteal.0 = 0
  801. ssCpuRawGuest.0 = 0
  802. ssCpuRawGuestNice.0 = 0
  803. ssCpuNumCpus.0 = 1  
  804.  
  805. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  806. laLoadInt.1 = 0
  807. laLoadInt.2 = 0
  808. laLoadInt.3 = 0  
  809.  
  810.  
  811. >> Runtime for poller module 'ucd-mib': 0.0336 seconds with 4184 bytes
  812. >> [0;36mSNMP[0m: [2/0.03s] [1;33mMySQL[0m: [0/0.00s]  
  813. #### Unload poller module ucd-mib ####
  814.  
  815. Modules status: Global+  
  816. OS  
  817. Device  
  818.  
  819. #### Load poller module ipSystemStats ####
  820. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  821. ipSystemStatsInReceives.ipv4 = 11125
  822. ipSystemStatsInReceives.ipv6 = 0
  823. ipSystemStatsHCInReceives.ipv4 = 11125
  824. ipSystemStatsHCInReceives.ipv6 = 0
  825. ipSystemStatsInOctets.ipv4 = 57773733
  826. ipSystemStatsInOctets.ipv6 = 0
  827. ipSystemStatsHCInOctets.ipv4 = 57773733
  828. ipSystemStatsHCInOctets.ipv6 = 0
  829. ipSystemStatsInHdrErrors.ipv4 = 0
  830. ipSystemStatsInHdrErrors.ipv6 = 0
  831. ipSystemStatsInNoRoutes.ipv4 = 0
  832. ipSystemStatsInNoRoutes.ipv6 = 0
  833. ipSystemStatsInAddrErrors.ipv4 = 0
  834. ipSystemStatsInAddrErrors.ipv6 = 0
  835. ipSystemStatsInUnknownProtos.ipv4 = 0
  836. ipSystemStatsInUnknownProtos.ipv6 = 0
  837. ipSystemStatsInTruncatedPkts.ipv4 = 0
  838. ipSystemStatsInTruncatedPkts.ipv6 = 0
  839. ipSystemStatsInForwDatagrams.ipv4 = 0
  840. ipSystemStatsInForwDatagrams.ipv6 = 0
  841. ipSystemStatsHCInForwDatagrams.ipv4 = 0
  842. ipSystemStatsHCInForwDatagrams.ipv6 = 0
  843. ipSystemStatsReasmReqds.ipv4 = 0
  844. ipSystemStatsReasmReqds.ipv6 = 0
  845. ipSystemStatsReasmOKs.ipv4 = 0
  846. ipSystemStatsReasmOKs.ipv6 = 0
  847. ipSystemStatsReasmFails.ipv4 = 0
  848. ipSystemStatsReasmFails.ipv6 = 0
  849. ipSystemStatsInDiscards.ipv4 = 0
  850. ipSystemStatsInDiscards.ipv6 = 0
  851. ipSystemStatsInDelivers.ipv4 = 8690
  852. ipSystemStatsInDelivers.ipv6 = 0
  853. ipSystemStatsHCInDelivers.ipv4 = 8690
  854. ipSystemStatsHCInDelivers.ipv6 = 0
  855. ipSystemStatsOutRequests.ipv4 = 5957
  856. ipSystemStatsOutRequests.ipv6 = 28
  857. ipSystemStatsHCOutRequests.ipv4 = 5957
  858. ipSystemStatsHCOutRequests.ipv6 = 28
  859. ipSystemStatsOutNoRoutes.ipv4 = 1
  860. ipSystemStatsOutNoRoutes.ipv6 = 27
  861. ipSystemStatsOutForwDatagrams.ipv4 = 0
  862. ipSystemStatsOutForwDatagrams.ipv6 = 0
  863. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
  864. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
  865. ipSystemStatsOutDiscards.ipv4 = 220
  866. ipSystemStatsOutDiscards.ipv6 = 3
  867. ipSystemStatsOutFragReqds.ipv4 = 0
  868. ipSystemStatsOutFragReqds.ipv6 = 0
  869. ipSystemStatsOutFragOKs.ipv4 = 0
  870. ipSystemStatsOutFragOKs.ipv6 = 0
  871. ipSystemStatsOutFragFails.ipv4 = 0
  872. ipSystemStatsOutFragFails.ipv6 = 0
  873. ipSystemStatsOutFragCreates.ipv4 = 0
  874. ipSystemStatsOutFragCreates.ipv6 = 0
  875. ipSystemStatsOutTransmits.ipv4 = 5736
  876. ipSystemStatsOutTransmits.ipv6 = 4294967294
  877. ipSystemStatsHCOutTransmits.ipv4 = 5736
  878. ipSystemStatsHCOutTransmits.ipv6 = 18446744073709551614
  879. ipSystemStatsOutOctets.ipv4 = 806301
  880. ipSystemStatsOutOctets.ipv6 = 1876
  881. ipSystemStatsHCOutOctets.ipv4 = 806301
  882. ipSystemStatsHCOutOctets.ipv6 = 1876
  883. ipSystemStatsInMcastPkts.ipv4 = 86
  884. ipSystemStatsInMcastPkts.ipv6 = 0
  885. ipSystemStatsHCInMcastPkts.ipv4 = 86
  886. ipSystemStatsHCInMcastPkts.ipv6 = 0
  887. ipSystemStatsInMcastOctets.ipv4 = 2760
  888. ipSystemStatsInMcastOctets.ipv6 = 0
  889. ipSystemStatsHCInMcastOctets.ipv4 = 2760
  890. ipSystemStatsHCInMcastOctets.ipv6 = 0
  891. ipSystemStatsOutMcastPkts.ipv4 = 0
  892. ipSystemStatsOutMcastPkts.ipv6 = 27
  893. ipSystemStatsHCOutMcastPkts.ipv4 = 0
  894. ipSystemStatsHCOutMcastPkts.ipv6 = 27
  895. ipSystemStatsOutMcastOctets.ipv4 = 0
  896. ipSystemStatsOutMcastOctets.ipv6 = 1800
  897. ipSystemStatsHCOutMcastOctets.ipv4 = 0
  898. ipSystemStatsHCOutMcastOctets.ipv6 = 1800
  899. ipSystemStatsInBcastPkts.ipv4 = 2314
  900. ipSystemStatsHCInBcastPkts.ipv4 = 2314
  901. ipSystemStatsOutBcastPkts.ipv4 = 0
  902. ipSystemStatsHCOutBcastPkts.ipv4 = 0
  903. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
  904. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
  905. ipSystemStatsRefreshRate.ipv4 = 60000
  906. ipSystemStatsRefreshRate.ipv6 = 60000  
  907.  
  908. ipv4 ipv6
  909.  
  910. >> Runtime for poller module 'ipSystemStats': 0.0253 seconds with 20560 bytes
  911. >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s]  
  912. #### Unload poller module ipSystemStats ####
  913.  
  914. Modules status: Global+  
  915. OS  
  916. Device  
  917.  
  918. #### Load poller module ports ####
  919. SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[661][0m 0.63ms]
  920.  
  921. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  922. ifName.1 = lo
  923. ifName.2 = ens192
  924. ifInMulticastPkts.1 = 0
  925. ifInMulticastPkts.2 = 84
  926. ifInBroadcastPkts.1 = 0
  927. ifInBroadcastPkts.2 = 0
  928. ifOutMulticastPkts.1 = 0
  929. ifOutMulticastPkts.2 = 0
  930. ifOutBroadcastPkts.1 = 0
  931. ifOutBroadcastPkts.2 = 0
  932. ifHCInOctets.1 = 80080
  933. ifHCInOctets.2 = 58228576
  934. ifHCInUcastPkts.1 = 880
  935. ifHCInUcastPkts.2 = 16633
  936. ifHCInMulticastPkts.1 = 0
  937. ifHCInMulticastPkts.2 = 84
  938. ifHCInBroadcastPkts.1 = 0
  939. ifHCInBroadcastPkts.2 = 0
  940. ifHCOutOctets.1 = 80080
  941. ifHCOutOctets.2 = 812920
  942. ifHCOutUcastPkts.1 = 880
  943. ifHCOutUcastPkts.2 = 5186
  944. ifHCOutMulticastPkts.1 = 0
  945. ifHCOutMulticastPkts.2 = 0
  946. ifHCOutBroadcastPkts.1 = 0
  947. ifHCOutBroadcastPkts.2 = 0
  948. ifHighSpeed.1 = 10
  949. ifHighSpeed.2 = 10000
  950. ifPromiscuousMode.1 = false
  951. ifPromiscuousMode.2 = false
  952. ifConnectorPresent.1 = false
  953. ifConnectorPresent.2 = true
  954. ifAlias.1 =
  955. ifAlias.2 =
  956. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  957. ifCounterDiscontinuityTime.2 = 0:0:00:00.00  
  958.  
  959. ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m]
  960. ifDescr.1 = lo
  961. ifDescr.2 = ens192  
  962.  
  963. ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m]
  964. ifAdminStatus.1 = up
  965. ifAdminStatus.2 = up  
  966.  
  967. ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m]
  968. ifOperStatus.1 = up
  969. ifOperStatus.2 = up  
  970.  
  971. ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m]
  972. ifLastChange.1 = 0
  973. ifLastChange.2 = 0  
  974.  
  975. ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m]
  976. ifType.1 = softwareLoopback
  977. ifType.2 = ethernetCsmacd  
  978.  
  979. ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m]
  980. ifPhysAddress.1 =
  981. ifPhysAddress.2 = 0:50:56:ba:28:3c  
  982.  
  983. ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m]
  984. ifMtu.1 = 65536
  985. ifMtu.2 = 1500  
  986.  
  987. ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m]
  988. ifInErrors.1 = 0
  989. ifInErrors.2 = 0  
  990.  
  991. ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m]
  992. ifOutErrors.1 = 0
  993. ifOutErrors.2 = 0  
  994.  
  995. ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m]
  996. ifInDiscards.1 = 0
  997. ifInDiscards.2 = 0  
  998.  
  999. ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m]
  1000. ifOutDiscards.1 = 0
  1001. ifOutDiscards.2 = 0  
  1002.  
  1003. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  1004. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  1005.  
  1006. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  1007. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  1008. dot1qPvid = No Such Object available on this agent at this OID  
  1009.  
  1010. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  1011. array (
  1012.   1 =>
  1013.   array (
  1014.     'ifName' => 'lo',
  1015.     'ifInMulticastPkts' => '0',
  1016.     'ifInBroadcastPkts' => '0',
  1017.     'ifOutMulticastPkts' => '0',
  1018.     'ifOutBroadcastPkts' => '0',
  1019.     'ifHCInOctets' => '80080',
  1020.     'ifHCInUcastPkts' => '880',
  1021.     'ifHCInMulticastPkts' => '0',
  1022.     'ifHCInBroadcastPkts' => '0',
  1023.     'ifHCOutOctets' => '80080',
  1024.     'ifHCOutUcastPkts' => '880',
  1025.     'ifHCOutMulticastPkts' => '0',
  1026.     'ifHCOutBroadcastPkts' => '0',
  1027.     'ifHighSpeed' => '10',
  1028.     'ifPromiscuousMode' => 'false',
  1029.     'ifConnectorPresent' => 'false',
  1030.     'ifAlias' => '',
  1031.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  1032.     'ifDescr' => 'lo',
  1033.     'ifAdminStatus' => 'up',
  1034.     'ifOperStatus' => 'up',
  1035.     'ifLastChange' => '0',
  1036.     'ifType' => 'softwareLoopback',
  1037.     'ifPhysAddress' => '',
  1038.     'ifMtu' => '65536',
  1039.     'ifInErrors' => '0',
  1040.     'ifOutErrors' => '0',
  1041.     'ifInDiscards' => '0',
  1042.     'ifOutDiscards' => '0',
  1043.   ),
  1044.   2 =>
  1045.   array (
  1046.     'ifName' => 'ens192',
  1047.     'ifInMulticastPkts' => '84',
  1048.     'ifInBroadcastPkts' => '0',
  1049.     'ifOutMulticastPkts' => '0',
  1050.     'ifOutBroadcastPkts' => '0',
  1051.     'ifHCInOctets' => '58228576',
  1052.     'ifHCInUcastPkts' => '16633',
  1053.     'ifHCInMulticastPkts' => '84',
  1054.     'ifHCInBroadcastPkts' => '0',
  1055.     'ifHCOutOctets' => '812920',
  1056.     'ifHCOutUcastPkts' => '5186',
  1057.     'ifHCOutMulticastPkts' => '0',
  1058.     'ifHCOutBroadcastPkts' => '0',
  1059.     'ifHighSpeed' => '10000',
  1060.     'ifPromiscuousMode' => 'false',
  1061.     'ifConnectorPresent' => 'true',
  1062.     'ifAlias' => '',
  1063.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  1064.     'ifDescr' => 'ens192',
  1065.     'ifAdminStatus' => 'up',
  1066.     'ifOperStatus' => 'up',
  1067.     'ifLastChange' => '0',
  1068.     'ifType' => 'ethernetCsmacd',
  1069.     'ifPhysAddress' => '0:50:56:ba:28:3c',
  1070.     'ifMtu' => '1500',
  1071.     'ifInErrors' => '0',
  1072.     'ifOutErrors' => '0',
  1073.     'ifInDiscards' => '0',
  1074.     'ifOutDiscards' => '0',
  1075.   ),
  1076. )  
  1077.  valid  
  1078.  valid  
  1079.  
  1080. Port lo: lo (1 / #11865) ifHCInOctets  
  1081. ifHCOutOctets  
  1082. ifHCInUcastPkts  
  1083. ifHCOutUcastPkts  
  1084. ifInBroadcastPkts  
  1085. ifOutBroadcastPkts  
  1086. ifInMulticastPkts  
  1087. ifOutMulticastPkts  
  1088. ifHighSpeed (10)  
  1089. VLAN = ?  Using ifDescr as ifAlias  
  1090. Reporting disabled by user setting  
  1091. lo
  1092.  ifInOctets (0 B) 0 Bps 41 secs  
  1093.  
  1094.  ifOutOctets (0 B) 0 Bps 41 secs  
  1095.  
  1096.  ifInErrors (0 B) 0 Bps 41 secs  
  1097.  
  1098.  ifOutErrors (0 B) 0 Bps 41 secs  
  1099.  
  1100.  ifInUcastPkts (0 B) 0 Bps 41 secs  
  1101.  
  1102.  ifOutUcastPkts (0 B) 0 Bps 41 secs  
  1103.  
  1104.  ifInNUcastPkts (0 B) 0 Bps 41 secs  
  1105.  
  1106.  ifOutNUcastPkts (0 B) 0 Bps 41 secs  
  1107.  
  1108.  ifInDiscards (0 B) 0 Bps 41 secs  
  1109.  
  1110.  ifOutDiscards (0 B) 0 Bps 41 secs  
  1111.  
  1112.  ifInUnknownProtos (0 B) 0 Bps 41 secs  
  1113.  
  1114.  ifInBroadcastPkts (0 B) 0 Bps 41 secs  
  1115.  
  1116.  ifOutBroadcastPkts (0 B) 0 Bps 41 secs  
  1117.  
  1118.  ifInMulticastPkts (0 B) 0 Bps 41 secs  
  1119.  
  1120.  ifOutMulticastPkts (0 B) 0 Bps 41 secs  
  1121. bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["80080",80080,0,0,"80080",80080,0,0,"0",0,0,0,"0",0,0,0,"880",880,0,0,"880",880,0,0,1687434108,1687434067,41,11865][0m 0.37ms]
  1122.  
  1123. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,11865][0m 0.26ms]
  1124.  
  1125. 1 updated  
  1126.  
  1127. Port ens192: ens192 (2 / #11866) ifHCInOctets  
  1128. ifHCOutOctets  
  1129. ifHCInUcastPkts  
  1130. ifHCOutUcastPkts  
  1131. ifInBroadcastPkts  
  1132. ifOutBroadcastPkts  
  1133. ifHCInMulticastPkts  
  1134. ifOutMulticastPkts  
  1135. ifHighSpeed (10000)  
  1136. VLAN = ?  Using ifDescr as ifAlias  
  1137. ens192
  1138.  ifInOctets (14906 B) 363.56097560976 Bps 41 secs  
  1139.  
  1140.  ifOutOctets (13773 B) 335.92682926829 Bps 41 secs  
  1141.  
  1142.  ifInErrors (0 B) 0 Bps 41 secs  
  1143.  
  1144.  ifOutErrors (0 B) 0 Bps 41 secs  
  1145.  
  1146.  ifInUcastPkts (164 B) 4 Bps 41 secs  
  1147.  
  1148.  ifOutUcastPkts (65 B) 1.5853658536585 Bps 41 secs  
  1149.  
  1150.  ifInNUcastPkts (0 B) 0 Bps 41 secs  
  1151.  
  1152.  ifOutNUcastPkts (0 B) 0 Bps 41 secs  
  1153.  
  1154.  ifInDiscards (0 B) 0 Bps 41 secs  
  1155.  
  1156.  ifOutDiscards (0 B) 0 Bps 41 secs  
  1157.  
  1158.  ifInUnknownProtos (0 B) 0 Bps 41 secs  
  1159.  
  1160.  ifInBroadcastPkts (0 B) 0 Bps 41 secs  
  1161.  
  1162.  ifOutBroadcastPkts (0 B) 0 Bps 41 secs  
  1163.  
  1164.  ifInMulticastPkts (0 B) 0 Bps 41 secs  
  1165.  
  1166.  ifOutMulticastPkts (0 B) 0 Bps 41 secs  
  1167. bps(2.91 kbps/2.69 kbps)bytes(14.56 KiB/13.45 KiB)pkts(4 pps/1.59 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["58228576",58213670,363.5609756097561,14906,"812920",799147,335.9268292682927,13773,"0",0,0,0,"0",0,0,0,"16633",16469,4,164,"5186",5121,1.5853658536585367,65,1687434108,1687434067,41,11866][0m 0.26ms]
  1168.  
  1169. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"84",84,0,0,"0",0,0,0,11866][0m 0.24ms]
  1170.  
  1171. 2 updated  
  1172.  
  1173. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1687434108,1687434067,null][0m 0.14ms]
  1174.  
  1175. 0 updated  
  1176.  
  1177. >> Runtime for poller module 'ports': 0.2495 seconds with 98024 bytes
  1178. >> [0;36mSNMP[0m: [14/0.24s] [1;33mMySQL[0m: [6/0.02s]  
  1179. #### Unload poller module ports ####
  1180.  
  1181. Modules status: Global-  
  1182. OS  
  1183. Device  
  1184. Module [ xdsl ] disabled globally.
  1185.  
  1186. Modules status: Global+  
  1187. OS  
  1188. Device  
  1189.  
  1190. #### Load poller module customoid ####
  1191. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[661][0m 0.29ms]
  1192.  
  1193.  
  1194. >> Runtime for poller module 'customoid': 0.0007 seconds with 1464 bytes
  1195. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1196. #### Unload poller module customoid ####
  1197.  
  1198. Modules status: Global+  
  1199. OS-  
  1200. Device  
  1201. Module [ bgp-peers ] disabled on os.
  1202.  
  1203. Modules status: Global-  
  1204. OS  
  1205. Device  
  1206. Module [ junose-atm-vp ] disabled globally.
  1207.  
  1208. Modules status: Global-  
  1209. OS  
  1210. Device  
  1211. Module [ printer-supplies ] disabled globally.
  1212.  
  1213. Modules status: Global+  
  1214. OS  
  1215. Device  
  1216.  
  1217. #### Load poller module ucd-diskio ####
  1218. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[661][0m 0.23ms]
  1219.  
  1220.  
  1221. >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 928 bytes
  1222. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1223. #### Unload poller module ucd-diskio ####
  1224.  
  1225. Modules status: Global-  
  1226. OS  
  1227. Device  
  1228. Module [ wifi ] disabled globally.
  1229.  
  1230. Modules status: Global+  
  1231. OS  
  1232. Device  
  1233.  
  1234. #### Load poller module wireless ####
  1235. Attempting to initialize OS: linux  
  1236. Attempting to initialize Group OS: unix  
  1237. OS initialized: LibreNMS\OS\Shared\Unix  
  1238. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[661][0m 0.31ms]
  1239.  
  1240.  
  1241. >> Runtime for poller module 'wireless': 0.0018 seconds with 104056 bytes
  1242. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1243. #### Unload poller module wireless ####
  1244.  
  1245. Modules status: Global+  
  1246. OS-  
  1247. Device  
  1248. Module [ ospf ] disabled on os.
  1249.  
  1250. Modules status: Global-  
  1251. OS  
  1252. Device  
  1253. Module [ isis ] disabled globally.
  1254.  
  1255. Modules status: Global-  
  1256. OS  
  1257. Device  
  1258. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  1259.  
  1260. Modules status: Global-  
  1261. OS  
  1262. Device  
  1263. Module [ cisco-remote-access-monitor ] disabled globally.
  1264.  
  1265. Modules status: Global-  
  1266. OS  
  1267. Device  
  1268. Module [ cisco-cef ] disabled globally.
  1269.  
  1270. Modules status: Global-  
  1271. OS  
  1272. Device  
  1273. Module [ slas ] disabled globally.
  1274.  
  1275. Modules status: Global-  
  1276. OS  
  1277. Device  
  1278. Module [ cisco-mac-accounting ] disabled globally.
  1279.  
  1280. Modules status: Global-  
  1281. OS  
  1282. Device  
  1283. Module [ cipsec-tunnels ] disabled globally.
  1284.  
  1285. Modules status: Global-  
  1286. OS  
  1287. Device  
  1288. Module [ cisco-ace-loadbalancer ] disabled globally.
  1289.  
  1290. Modules status: Global-  
  1291. OS  
  1292. Device  
  1293. Module [ cisco-ace-serverfarms ] disabled globally.
  1294.  
  1295. Modules status: Global-  
  1296. OS  
  1297. Device  
  1298. Module [ cisco-asa-firewall ] disabled globally.
  1299.  
  1300. Modules status: Global-  
  1301. OS  
  1302. Device  
  1303. Module [ cisco-voice ] disabled globally.
  1304.  
  1305. Modules status: Global-  
  1306. OS  
  1307. Device  
  1308. Module [ cisco-cbqos ] disabled globally.
  1309.  
  1310. Modules status: Global-  
  1311. OS  
  1312. Device  
  1313. Module [ cisco-otv ] disabled globally.
  1314.  
  1315. Modules status: Global-  
  1316. OS  
  1317. Device  
  1318. Module [ cisco-qfp ] disabled globally.
  1319.  
  1320. Modules status: Global-  
  1321. OS  
  1322. Device  
  1323. Module [ cisco-vpdn ] disabled globally.
  1324.  
  1325. Modules status: Global-  
  1326. OS  
  1327. Device  
  1328. Module [ nac ] disabled globally.
  1329.  
  1330. Modules status: Global-  
  1331. OS  
  1332. Device  
  1333. Module [ netscaler-vsvr ] disabled globally.
  1334.  
  1335. Modules status: Global-  
  1336. OS  
  1337. Device  
  1338. Module [ aruba-controller ] disabled globally.
  1339.  
  1340. Modules status: Global+  
  1341. OS  
  1342. Device  
  1343.  
  1344. #### Load poller module entity-physical ####
  1345.  
  1346. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 392 bytes
  1347. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1348. #### Unload poller module entity-physical ####
  1349.  
  1350. Modules status: Global-  
  1351. OS  
  1352. Device  
  1353. Module [ entity-state ] disabled globally.
  1354.  
  1355. Modules status: Global+  
  1356. OS  
  1357. Device  
  1358.  
  1359. #### Load poller module applications ####
  1360. SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[661][0m 0.29ms]
  1361.  
  1362.  
  1363. >> Runtime for poller module 'applications': 0.0013 seconds with 28384 bytes
  1364. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1365. #### Unload poller module applications ####
  1366.  
  1367. Modules status: Global+  
  1368. OS-  
  1369. Device  
  1370. Module [ stp ] disabled on os.
  1371.  
  1372. Modules status: Global+  
  1373. OS  
  1374. Device  
  1375.  
  1376. #### Load poller module ntp ####
  1377.  
  1378. >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes
  1379. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1380. #### Unload poller module ntp ####
  1381.  
  1382. Modules status: Global-  
  1383. OS  
  1384. Device  
  1385. Module [ loadbalancers ] disabled globally.
  1386.  
  1387. Modules status: Global-  
  1388. OS  
  1389. Device  
  1390. Module [ mef ] disabled globally.
  1391.  
  1392. Modules status: Global+  
  1393. OS  
  1394. Device  
  1395.  
  1396. #### Load poller module mpls ####
  1397.  
  1398. >> Runtime for poller module 'mpls': 0.0004 seconds with 36872 bytes
  1399. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1400. #### Unload poller module mpls ####
  1401.  
  1402. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[661][0m 0.33ms]
  1403.  
  1404.  
  1405. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.856,661][0m 0.28ms]
  1406.  
  1407. Updating 10.1.250.132  
  1408.  
  1409. Polled in 1.856 seconds
  1410. ### Start Device Groups ###
  1411. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.26ms]
  1412.  
  1413. SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) [0;33m[][0m 1.57ms]
  1414.  
  1415. SQL[[1;33mselect exists(select * from `devices` where ((`devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ?) AND `devices`.`sysDescr` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%staff%","censw%","lscsw%","%Intel%",661][0m 0.31ms]
  1416.  
  1417. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.%","2920-48G-POE+",661][0m 0.27ms]
  1418.  
  1419. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where ((`ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) AND `devices`.`os` LIKE ? AND `devices`.`hostname` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.1.250.%","10.1.251.%","[1;37mindows%","porcupine",661][0m 0.26ms]
  1420.  
  1421. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where ((`ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `devices`.`hostname` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) AND (`devices`.`os` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.250.%","10.2.251.%","[0;35mc001","10.2.150.%","10.2.151.%","[1;37mindows%",661][0m 0.29ms]
  1422.  
  1423. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`os` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Linux%","[5mreeBSD%","%OpenBSD%","callastorySP","ciscoprime","crafty","emccallhome","foundation%","informacast","%VMware%","lobster","pr","bonobo","Cisco Unified Communications Manager%",661][0m 0.26ms]
  1424.  
  1425. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` != ? AND `devices`.`hostname` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%vc%","vcenter.indypl.org","vcenter7",661][0m 0.21ms]
  1426.  
  1427. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%doorcounter%",661][0m 0.2ms]
  1428.  
  1429. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.%","[0;35mc%",661][0m 0.24ms]
  1430.  
  1431. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["iDRAC%",661][0m 0.2ms]
  1432.  
  1433. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["Ecoreader",661][0m 0.2ms]
  1434.  
  1435. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[661][0m 0.22ms]
  1436.  
  1437. Groups Added:  
  1438. Groups Removed:  
  1439. ### End Device Groups, runtime: 0.0267s ###
  1440.  
  1441. #### Start Alerts ####
  1442. SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[661][0m 0.28ms]
  1443.  
  1444. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) &lt;= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (7)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2023-06-22T11:41:48.386512Z","2023-06-22T11:41:48.386512Z",0,1,"11:41:48","11:41:48","11:41:48","11:41:48","[44m%","device",661,"device_group","location",46][0m 0.65ms]
  1445.  
  1446. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[661][0m 0.35ms]
  1447.  
  1448. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1449.         LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
  1450.         LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
  1451.         LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
  1452.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  1453.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  1454.         WHERE a.disabled = 0 AND (
  1455.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  1456.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  1457.             OR (a.invert_map = 1  AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL))
  1458.         ) [0;33m[661,661,661,661,661,661,661,661,661,661,661][0m 2.02ms]
  1459.  
  1460. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
  1461.  
  1462. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[661][0m 0.33ms]
  1463.  
  1464. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,661][0m 0.2ms]
  1465.  
  1466. Status: [0;34mNOCHG[0m  
  1467. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
  1468.  
  1469. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[661][0m 0.31ms]
  1470.  
  1471. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,661][0m 0.19ms]
  1472.  
  1473. Status: [0;34mNOCHG[0m  
  1474. Rule [0;35m#3 (Device rebooted):[0m  
  1475.  
  1476. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> 50 [0;33m[661][0m 0.32ms]
  1477.  
  1478. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,661][0m 0.18ms]
  1479.  
  1480. Status: [0;34mNOCHG[0m  
  1481. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
  1482.  
  1483. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.39ms]
  1484.  
  1485. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,661][0m 0.19ms]
  1486.  
  1487. Status: [0;34mNOCHG[0m  
  1488. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
  1489.  
  1490. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 1.16ms]
  1491.  
  1492. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,661][0m 0.18ms]
  1493.  
  1494. Status: [0;34mNOCHG[0m  
  1495. Rule [0;35m#11 (Wireless Sensor under limit):[0m  
  1496.  
  1497. SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current &lt;= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.37ms]
  1498.  
  1499. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,661][0m 0.2ms]
  1500.  
  1501. Status: [0;34mNOCHG[0m  
  1502. Rule [0;35m#12 (State Sensor Critical):[0m  
  1503.  
  1504. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.87ms]
  1505.  
  1506. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,661][0m 0.74ms]
  1507.  
  1508. Status: [0;34mNOCHG[0m  
  1509. Rule [0;35m#13 (UPS is running on the bypass):[0m  
  1510.  
  1511. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 4 AND sensors.sensor_type = "upsOutputSourceState" [0;33m[661][0m 0.54ms]
  1512.  
  1513. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,661][0m 0.28ms]
  1514.  
  1515. Status: [0;34mNOCHG[0m  
  1516. Rule [0;35m#14 (UPS is running on the battery):[0m  
  1517.  
  1518. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 5 AND sensors.sensor_type = "upsOutputSourceState" [0;33m[661][0m 0.52ms]
  1519.  
  1520. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[14,661][0m 0.27ms]
  1521.  
  1522. Status: [0;34mNOCHG[0m  
  1523. Rule [0;35m#15 (UPS has a low battery):[0m  
  1524.  
  1525. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBatteryStatusState" [0;33m[661][0m 0.54ms]
  1526.  
  1527. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,661][0m 0.29ms]
  1528.  
  1529. Status: [0;34mNOCHG[0m  
  1530. Rule [0;35m#16 (UPS has a depleted battery):[0m  
  1531.  
  1532. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 4 AND sensors.sensor_type = "upsBatteryStatusState" [0;33m[661][0m 0.57ms]
  1533.  
  1534. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,661][0m 0.28ms]
  1535.  
  1536. Status: [0;34mNOCHG[0m  
  1537. Rule [0;35m#17 (UPS has a heavy load):[0m  
  1538.  
  1539. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_descr REGEXP "Percentage load" AND sensors.sensor_current >= 90 AND sensors.sensor_type = "rfc1628" [0;33m[661][0m 0.53ms]
  1540.  
  1541. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,661][0m 0.28ms]
  1542.  
  1543. Status: [0;34mNOCHG[0m  
  1544. Rule [0;35m#18 (Dell Server Raid Battery Failed/Degraded):[0m  
  1545.  
  1546. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.15.1.4.1" [0;33m[661][0m 0.54ms]
  1547.  
  1548. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,661][0m 0.29ms]
  1549.  
  1550. Status: [0;34mNOCHG[0m  
  1551. Rule [0;35m#19 (Dell Server CPU Status Critical):[0m  
  1552.  
  1553. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 2 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.1.1100.32.1.5" [0;33m[661][0m 0.58ms]
  1554.  
  1555. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,661][0m 0.27ms]
  1556.  
  1557. Status: [0;34mNOCHG[0m  
  1558. Rule [0;35m#20 (Dell Server Disk Controller State Failed/Degraded):[0m  
  1559.  
  1560. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.1.1.5" [0;33m[661][0m 0.51ms]
  1561.  
  1562. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,661][0m 0.32ms]
  1563.  
  1564. Status: [0;34mNOCHG[0m  
  1565. Rule [0;35m#21 (Dell Server Disk Array State Failed/Degraded):[0m  
  1566.  
  1567. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|5]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.4.1.4" [0;33m[661][0m 0.49ms]
  1568.  
  1569. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,661][0m 0.29ms]
  1570.  
  1571. Status: [0;34mNOCHG[0m  
  1572. Rule [0;35m#22 (Dell Server PSU State Critical/NonRecvoverable):[0m  
  1573.  
  1574. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[5|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.1.600.12.1.5" [0;33m[661][0m 0.6ms]
  1575.  
  1576. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[22,661][0m 0.26ms]
  1577.  
  1578. Status: [0;34mNOCHG[0m  
  1579. Rule [0;35m#23 (Dell Server Virtual Disk Failed/Degraded):[0m  
  1580.  
  1581. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.140.1.1.4" [0;33m[661][0m 0.52ms]
  1582.  
  1583. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[23,661][0m 0.25ms]
  1584.  
  1585. Status: [0;34mNOCHG[0m  
  1586. Rule [0;35m#24 (Cisco PSU status failed):[0m  
  1587.  
  1588. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 8 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.5.1.3" [0;33m[661][0m 0.44ms]
  1589.  
  1590. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[24,661][0m 0.24ms]
  1591.  
  1592. Status: [0;34mNOCHG[0m  
  1593. Rule [0;35m#25 (Cisco Fan Status failed ):[0m  
  1594.  
  1595. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 9 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.4.1.3" [0;33m[661][0m 0.48ms]
  1596.  
  1597. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[25,661][0m 0.28ms]
  1598.  
  1599. Status: [0;34mNOCHG[0m  
  1600. Rule [0;35m#26 (Dell iDRAC Processor Status Critical):[0m  
  1601.  
  1602. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 5 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.1100.30.1.5" [0;33m[661][0m 0.46ms]
  1603.  
  1604. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[26,661][0m 0.24ms]
  1605.  
  1606. Status: [0;34mNOCHG[0m  
  1607. Rule [0;35m#27 (Dell iDRAC Virtual Disk Failed/Degraded):[0m  
  1608.  
  1609. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[3|4]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.5.1.20.140.1.1.4" [0;33m[661][0m 0.49ms]
  1610.  
  1611. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[27,661][0m 0.22ms]
  1612.  
  1613. Status: [0;34mNOCHG[0m  
  1614. Rule [0;35m#28 (Dell iDRAC Memory Status Critical):[0m  
  1615.  
  1616. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 5 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.1100.50.1.5" [0;33m[661][0m 0.49ms]
  1617.  
  1618. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[28,661][0m 0.23ms]
  1619.  
  1620. Status: [0;34mNOCHG[0m  
  1621. Rule [0;35m#29 (Dell iDRAC Voltage Probe Status Failed):[0m  
  1622.  
  1623. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.20.1.5" [0;33m[661][0m 0.48ms]
  1624.  
  1625. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[29,661][0m 0.22ms]
  1626.  
  1627. Status: [0;34mNOCHG[0m  
  1628. Rule [0;35m#30 (Dell iDRAC Amperage Probe Status Failed):[0m  
  1629.  
  1630. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.30.1.5" [0;33m[661][0m 0.48ms]
  1631.  
  1632. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[30,661][0m 0.22ms]
  1633.  
  1634. Status: [0;34mNOCHG[0m  
  1635. Rule [0;35m#31 (Dell iDRAC Battery Status Failed):[0m  
  1636.  
  1637. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.50.1.5" [0;33m[661][0m 0.49ms]
  1638.  
  1639. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[31,661][0m 0.25ms]
  1640.  
  1641. Status: [0;34mNOCHG[0m  
  1642. Rule [0;35m#32 (Dell iDRAC Global System Status Critical/NonRecoverable):[0m  
  1643.  
  1644. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[5|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.2.2.1" [0;33m[661][0m 0.43ms]
  1645.  
  1646. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[32,661][0m 0.27ms]
  1647.  
  1648. Status: [0;34mNOCHG[0m  
  1649. Rule [0;35m#33 (Storage percentage exceeded):[0m  
  1650.  
  1651. SQL[[1;33mSELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND storage.storage_perc >= storage.storage_perc_warn [0;33m[661][0m 0.44ms]
  1652.  
  1653. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[33,661][0m 0.29ms]
  1654.  
  1655. Status: [0;34mNOCHG[0m  
  1656. Rule [0;35m#36 (State Sensor Warning):[0m  
  1657.  
  1658. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 1) = 1 AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.65ms]
  1659.  
  1660. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[36,661][0m 0.28ms]
  1661.  
  1662. Status: [0;34mNOCHG[0m  
  1663. Rule [0;35m#37 (Cisco ASA Primary unit changed to standby):[0m  
  1664.  
  1665. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_descr = "Primary Unit.*" AND sensors.sensor_current = 10 AND sensors.sensor_prev = 9 [0;33m[661][0m 0.46ms]
  1666.  
  1667. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[37,661][0m 0.22ms]
  1668.  
  1669. Status: [0;34mNOCHG[0m  
  1670. Rule [0;35m#38 (Interface Errors Rate greater than 100):[0m  
  1671.  
  1672. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOutErrors_rate >= 100 OR ports.ifInErrors_rate >= 100) [0;33m[661][0m 0.53ms]
  1673.  
  1674. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[38,661][0m 0.22ms]
  1675.  
  1676. Status: [0;34mNOCHG[0m  
  1677. Rule [0;35m#39 (Service warning):[0m  
  1678.  
  1679. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status = 1 [0;33m[661][0m 0.39ms]
  1680.  
  1681. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[39,661][0m 0.21ms]
  1682.  
  1683. Status: [0;34mNOCHG[0m  
  1684. Rule [0;35m#40 (Service critical):[0m  
  1685.  
  1686. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status = 2 [0;33m[661][0m 0.34ms]
  1687.  
  1688. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[40,661][0m 0.21ms]
  1689.  
  1690. Status: [0;34mNOCHG[0m  
  1691. Rule [0;35m#41 (APC UPS Battery Needs Replacement):[0m  
  1692.  
  1693. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2 [0;33m[661][0m 0.4ms]
  1694.  
  1695. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[41,661][0m 0.2ms]
  1696.  
  1697. Status: [0;34mNOCHG[0m  
  1698. Rule [0;35m#42 (APC UPS Diagonstics Test Result):[0m  
  1699.  
  1700. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvTestDiagnosticsResults" AND (sensors.sensor_current = 2 OR sensors.sensor_current = 3) [0;33m[661][0m 0.41ms]
  1701.  
  1702. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[42,661][0m 0.2ms]
  1703.  
  1704. Status: [0;34mNOCHG[0m  
  1705. Rule [0;35m#43 (APC UPS Switched to Battery Power):[0m  
  1706.  
  1707. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND (sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus") AND (sensors.sensor_current != 4 AND sensors.sensor_type = "upsAdvTestDiagnosticsResults") [0;33m[661][0m 0.31ms]
  1708.  
  1709. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[43,661][0m 0.2ms]
  1710.  
  1711. Status: [0;34mNOCHG[0m  
  1712. Rule [0;35m#44 (APC UPS in Hardware Failure Bypass Mode):[0m  
  1713.  
  1714. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.39ms]
  1715.  
  1716. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[44,661][0m 0.42ms]
  1717.  
  1718. Status: [0;34mNOCHG[0m  
  1719. Rule [0;35m#45 (APC UPS in Emergency Static Bypass Mode):[0m  
  1720.  
  1721. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 16 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.44ms]
  1722.  
  1723. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[45,661][0m 0.2ms]
  1724.  
  1725. Status: [0;34mNOCHG[0m  
  1726. Rule [0;35m#46 (APC UPS in Smart Trim Mode):[0m  
  1727.  
  1728. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 12 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.41ms]
  1729.  
  1730. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[46,661][0m 0.2ms]
  1731.  
  1732. Status: [0;34mNOCHG[0m  
  1733. Rule [0;35m#47 (HP Procurve Fan Fault):[0m  
  1734.  
  1735. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_oid = ".1.3.6.1.4.1.11.2.14.11.1.2.6.1.4.1" AND sensors.sensor_current = 2 [0;33m[661][0m 1.02ms]
  1736.  
  1737. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[47,661][0m 0.33ms]
  1738.  
  1739. Status: [0;34mNOCHG[0m  
  1740. Rule [0;35m#48 (Cisco NX-OS device has a bad fan):[0m  
  1741.  
  1742. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND devices.os = "nxos" AND sensors.sensor_type = "cefcFanTrayOperStatus" AND sensors.sensor_current = "[3-4]" [0;33m[661][0m 0.47ms]
  1743.  
  1744. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[48,661][0m 0.31ms]
  1745.  
  1746. Status: [0;34mNOCHG[0m  
  1747. Rule [0;35m#52 (Cisco IP SLA):[0m  
  1748.  
  1749. SQL[[1;33mSELECT * FROM devices,slas WHERE (devices.device_id = ? AND devices.device_id = slas.device_id) AND slas.deleted = 0 AND slas.opstatus = 3 [0;33m[661][0m 0.38ms]
  1750.  
  1751. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[52,661][0m 0.4ms]
  1752.  
  1753. Status: [0;34mNOCHG[0m  
  1754. #### End Alerts ####
  1755. ./poller.php 10.1.250.132 2023-06-22 07:41:48 - 1 devices polled in 2.183 secs  
  1756.  
  1757. [0;36mSNMP[0m [35/0.78s]: Snmpget[18/0.48s] Snmpwalk[17/0.30s]  
  1758. [1;33mSQL[0m [158/0.56s]: Select[136/0.51s] Insert[1/0.00s] Update[21/0.04s]  
  1759.