1. root@librenms:/opt/librenms# ./poller.php -h 10.190.10.30 -m sensors -r -f -d
2. LibreNMS Poller
3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.46ms]
4.  
5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.4ms]
6.  
7. SQL[SELECT version() [] 0.5ms]
8.  
9. ===================================
10. Version info:
11. Commit SHA: 137b7218daa9c4c04c142dd0f5a95721e1bf8c69
12. Commit Date: 1613003590
13. DB Schema: 2021_02_08_224355_fix_invalid_dates (199)
14. PHP: 7.4.3
15. MySQL: 10.3.25-MariaDB-0ubuntu0.20.04.1
16. RRDTool: 1.7.2
17. SNMP: NET-SNMP 5.8
18. ==================================DEBUG!
19. Updating os_def.cache
20. Override poller modules: sensors
21. Starting polling run:
22.  
23. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.190.10.30' ORDER BY `device_id` ASC [] 1.32ms]
24.  
25. SQL[select * from `devices` where `device_id` = ? limit 1 [33] 0.74ms]
26.  
27. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [33] 0.42ms]
28.  
29. Attempting to initialize OS: ict-pdu
30. OS initialized as Generic
31. Hostname:    10.190.10.30
32. Device ID:   33
33. OS:          ict-pdu
34.  
35.  
36. SQL[select `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 ["10.190.10.30"] 1ms]
37.  
38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '10.190.10.30'
39.  
40. response:  {"xmt":3,"rcv":3,"loss":0,"min":1.14,"max":1.32,"avg":1.22,"dup":0,"exitcode":0}
41. SQL[select `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` = ? [33] 0.8ms]
42.  
43. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [7] 0.43ms]
44.  
45. SQL[select 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(`end`) &lt;= ? or time(`start`) > ?))) 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 0 = 1) 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` ["2021-02-11T16:16:20.589016Z","2021-02-11T16:16:20.589016Z",0,1,"16:16:20","16:16:20","16:16:20","16:16:20","%","device",33,"device_group","location",7] 1.79ms]
46.  
47. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":3,"rcv":3,"loss":0,"min":1.14,"max":1.32,"avg":1.22,"device_id":33,"debug":"[]"} 2.12ms]
48.  
49. SQL[UPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? ["2021-02-11 10:16:20",1.22,33] 2.27ms]
50.  
51. SNMP Check response code: 0
52. Modules status: Global+
53. OS
54. Device
55.  
56. #### Load poller module core ####
57. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
58. .*.*.0 = 6593873
59. .*.*.0 = helpdesk
60. .*.*.0 = ICT-PWR-DCB-01
61. .*.*.0 = .*.4.1.39145.10
62. .*.*.0 = ICT Distribution Panel
63.  
64. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
65. Exitcode: 1
66. Timeout: No Response from udp:10.190.10.30:161.
67.  
68. Timeout: No Response from udp:10.190.10.30:161.
69. Uptime seconds: 65939
70. Uptime:  18 hours 18 minutes 59 seconds
71.  
72. >> Runtime for poller module 'core': 6.0491 seconds with 25608 bytes
73. >> SNMP: [2/6.05s] MySQL: [0/0.00s]
74. #### Unload poller module core ####
75.  
76. Modules status: Global+
77. OS
78. Device
79.  
80. #### Load poller module availability ####
81. SQL[SELECT duration FROM availability WHERE device_id = ? [33] 0.73ms]
82.  
83. Availability:
84. SQL[SELECT * FROM availability WHERE device_id = ? [33] 0.43ms]
85.  
86. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [33,1612973786] 0.91ms]
87.  
88. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,117] 0.54ms]
89.  
90. 1 day : 100%
91. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [33,1612455386] 0.68ms]
92.  
93. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,118] 0.5ms]
94.  
95. 7 days : 100%
96. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [33,1610468186] 0.7ms]
97.  
98. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,119] 0.49ms]
99.  
100. 30 days : 100%
101. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [33,1581524186] 0.77ms]
102.  
103. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,120] 0.45ms]
104.  
105. 365 days : 100%
106.  
107. >> Runtime for poller module 'availability': 0.0125 seconds with 39112 bytes
108. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
109. #### Unload poller module availability ####
110.  
111. Modules status: Global+
112. OS
113. Device
114.  
115. #### Load poller module sensors ####
116. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [33] 0.41ms]
117.  
118. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["current",33] 0.56ms]
119.  
120. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.39145.10.8.1.3.0' '.1.3.6.1.4.1.39145.10.8.1.3.1' '.1.3.6.1.4.1.39145.10.8.1.3.2' '.1.3.6.1.4.1.39145.10.8.1.3.3' '.1.3.6.1.4.1.39145.10.8.1.3.4' '.1.3.6.1.4.1.39145.10.8.1.3.5' '.1.3.6.1.4.1.39145.10.8.1.3.6' '.1.3.6.1.4.1.39145.10.8.1.3.7' '.1.3.6.1.4.1.39145.10.8.1.3.8' '.1.3.6.1.4.1.39145.10.8.1.3.9']
121. .*.4.1.39*.3.0 = "-1.9"
122. .*.4.1.39*.3.1 = "-1.2"
123. .*.4.1.39*.3.2 = "0.0"
124. .*.4.1.39*.3.3 = "0.0"
125. .*.4.1.39*.3.4 = "0.0"
126. .*.4.1.39*.3.5 = "0.0"
127. .*.4.1.39*.3.6 = "-1.7"
128. .*.4.1.39*.3.7 = "-1.0"
129. .*.4.1.39*.3.8 = "0.0"
130. .*.4.1.39*.3.9 = "0.0"
131.  
132. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.39145.10.8.1.3.10' '.1.3.6.1.4.1.39145.10.8.1.3.11' '.1.3.6.1.4.1.39145.10.7.0']
133. .*.4.1.39*.3.10 = "0.0"
134. .*.4.1.39*.3.11 = "0.0"
135. .*.4.1.39* = "-3.1"
136.  
137. Checking (snmp) current Output Current #1 1A: MX204 (A)...
138. Checking (snmp) current Output Current #2 2A: QFX5110 (A)...
139. Checking (snmp) current Output Current #3 3A: BLANK 3A...
140. Checking (snmp) current Output Current #4 4A: BLANK 4A...
141. Checking (snmp) current Output Current #5 5A: BLANK 5A...
142. Checking (snmp) current Output Current #6 6A: BLANK 6A...
143. Checking (snmp) current Output Current #7 1B: MX204 (B)...
144. Checking (snmp) current Output Current #8 2B: QFX5110 (B)...
145. Checking (snmp) current Output Current #9 3B: BLANK 3B...
146. Checking (snmp) current Output Current #10 4B: BLANK 4B...
147. Checking (snmp) current Output Current #11 5B: BLANK 5B...
148. Checking (snmp) current Output Current #12 6B: BLANK 6B...
149. Checking (snmp) current System Current...
150.  
151. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
152.  
153. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
154. 0
155.  
156. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
157.  
158. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
159. 0
160.  
161. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
162.  
163. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
164. 0
165.  
166. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
167.  
168. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
169. 0
170.  
171. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
172.  
173. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
174. 0
175.  
176. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
177.  
178. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
179. 0
180.  
181. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
182.  
183. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
184. 0
185.  
186. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
187.  
188. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
189. 0
190.  
191. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
192.  
193. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
194. 0
195.  
196. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
197.  
198. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
199. 0
200.  
201. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
202.  
203. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
204. 0
205.  
206. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
207.  
208. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
209. 0
210.  
211. Warning: is_nan() expects parameter 1 to be float, string given in /opt/librenms/includes/polling/functions.inc.php on line 165
212.  
213. Warning: A non-numeric value encountered in /opt/librenms/includes/polling/functions.inc.php on line 171
214. 0
215. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["state",33] 0.75ms]
216.  
217. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.39145.10.8.1.4.0' '.1.3.6.1.4.1.39145.10.8.1.4.1' '.1.3.6.1.4.1.39145.10.8.1.4.2' '.1.3.6.1.4.1.39145.10.8.1.4.3' '.1.3.6.1.4.1.39145.10.8.1.4.4' '.1.3.6.1.4.1.39145.10.8.1.4.5' '.1.3.6.1.4.1.39145.10.8.1.4.6' '.1.3.6.1.4.1.39145.10.8.1.4.7' '.1.3.6.1.4.1.39145.10.8.1.4.8' '.1.3.6.1.4.1.39145.10.8.1.4.9']
218. .*.4.1.39*.4.0 = 1
219. .*.4.1.39*.4.1 = 1
220. .*.4.1.39*.4.2 = 1
221. .*.4.1.39*.4.3 = 1
222. .*.4.1.39*.4.4 = 1
223. .*.4.1.39*.4.5 = 2
224. .*.4.1.39*.4.6 = 1
225. .*.4.1.39*.4.7 = 1
226. .*.4.1.39*.4.8 = 1
227. .*.4.1.39*.4.9 = 1
228.  
229. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.39145.10.8.1.4.10' '.1.3.6.1.4.1.39145.10.8.1.4.11']
230. .*.4.1.39*.4.10 = 1
231. .*.4.1.39*.4.11 = 1
232.  
233. Checking (snmp) state Fuse #1...
234. Checking (snmp) state Fuse #2...
235. Checking (snmp) state Fuse #3...
236. Checking (snmp) state Fuse #4...
237. Checking (snmp) state Fuse #5...
238. Checking (snmp) state Fuse #6...
239. Checking (snmp) state Fuse #7...
240. Checking (snmp) state Fuse #8...
241. Checking (snmp) state Fuse #9...
242. Checking (snmp) state Fuse #10...
243. Checking (snmp) state Fuse #11...
244. Checking (snmp) state Fuse #12...
245. 1
246. 1
247. 1
248. 1
249. 1
250. 2
251. 1
252. 1
253. 1
254. 1
255. 1
256. 1
257. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["voltage",33] 0.63ms]
258.  
259. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ict' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.39145.10.6.0']
260. .*.4.1.39* = "-55.2"
261.  
262. Checking (snmp) voltage System Voltage...
263. -55.2
264.  
265. >> Runtime for poller module 'sensors': 0.1042 seconds with 3248 bytes
266. >> SNMP: [5/0.10s] MySQL: [4/0.00s]
267. #### Unload poller module sensors ####
268.  
269. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [65939,1.22,33] 2.35ms]
270.  
271. Updating 10.190.10.30
272.  
273. Polled in 7.233 seconds
274. ### Start Device Groups ###
275. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [33] 1.03ms]
276.  
277. SQL[select * from `device_groups` [] 0.41ms]
278.  
279. SQL[select `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) [] 0.79ms]
280.  
281. SQL[select exists(select * from `devices` where (`devices`.`hardware` LIKE ? AND `devices`.`bgpLocalAs` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["X204%","8474%",33] 0.69ms]
282.  
283. SQL[select * from `device_group_device` where `device_id` = ? [33] 0.35ms]
284.  
285. Groups Added:
286. Groups Removed:
287. ### End Device Groups, runtime: 0.0118s ###
288.  
289. #### Start Alerts ####
290. SQL[select 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(`end`) &lt;= ? or time(`start`) > ?))) 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 0 = 1) 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` ["2021-02-11T16:16:26.812019Z","2021-02-11T16:16:26.812019Z",0,1,"16:16:26","16:16:26","16:16:26","16:16:26","%","device",33,"device_group","location",7] 1.61ms]
291.  
292. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [33] 0.58ms]
293.  
294. SQL[SELECT DISTINCT a.* FROM alert_rules a
295.         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 = ?)
296.         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 = ?))
297.         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 = ?))
298.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
299.         WHERE a.disabled = 0 AND (
300.             (d.device_id IS NULL AND g.group_id IS NULL)
301.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
302.             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))
303.         ) [33,33,33,33,33,33,33,33] 2.82ms]
304.  
305. Rule #1 (Device Down! Due to no ICMP response.):
306. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [33] 0.93ms]
307.  
308. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,33] 0.4ms]
309.  
310. Status: NOCHG
311. Rule #2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):
312. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [33] 0.83ms]
313.  
314. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,33] 0.38ms]
315.  
316. Status: NOCHG
317. Rule #3 (Device rebooted):
318. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 30 [33] 0.77ms]
319.  
320. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,33] 0.37ms]
321.  
322. Status: NOCHG
323. Rule #6 (Port utilisation over threshold):
324. SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [33] 1.52ms]
325.  
326. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,33] 0.41ms]
327.  
328. Status: NOCHG
329. Rule #9 (Service up/down):
330. SQL[SELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [33] 1.02ms]
331.  
332. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,33] 0.38ms]
333.  
334. Status: NOCHG
335. Rule #15 (*CUSTOM* Power Sensor under limit - Check Device Health Settings):
336. SQL[SELECT * 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> sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [33] 1.21ms]
337.  
338. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [16,33] 0.4ms]
339.  
340. Status: NOCHG
341. #### End Alerts ####
342. ./poller.php 10.190.10.30 2021-02-11 10:16:26 - 1 devices polled in 7.695 secs
343. SNMP [8/6.16s]: Get[8/6.16s] Getnext[0/0.00s] Walk[0/0.00s]
344. MySQL [22/0.03s]: Cell[9/0.01s] Row[-9/-0.01s] Rows[14/0.02s] Column[1/0.00s] Update[6/0.01s] Insert[1/0.00s] Delete[0/0.00s]