1. LibreNMS Poller
2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.39ms]
3.  
4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.33ms]
5.  
6. SQL[[1;33mselect version() [0;33m[][0m 0.31ms]
7.  
8. ===================================
9. Version info:
10. Commit SHA: 8d863fbc83f3702cf556ef44cbf49041bf42f7b0
11. Commit Date: 1659921127
12. DB Schema: 2022_07_19_081224_plugins_unique_index (244)
13. PHP: 7.4.30
14. Database: MariaDB 10.6.7-MariaDB-2ubuntu1.1
15. RRDTool: 1.7.2
16. SNMP: 5.9.1
17. ==================================DEBUG!
18. Updating os_def.cache  
19. Starting polling run:
20.  
21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'ztvi-sw1.fm2.ztvi.org' ORDER BY `device_id` ASC [0;33m[][0m 0.69ms]
22.  
23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[13][0m 0.44ms]
24.  
25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[13][0m 0.35ms]
26.  
27. Attempting to initialize OS: generic  
28. OS initialized: LibreNMS\OS\Generic  
29. Hostname:    ztvi-sw1.fm2.ztvi.org
30. Device ID:   13
31. OS:          generic
32. Resolved IP: 2602:fc59:b0::2
33.  
34.  
35. [FPING] '/usr/bin/fping6' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'ztvi-sw1.fm2.ztvi.org'
36.  
37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.374/0.403/0.419  
38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
39. SNMPv2-MIB::sysObjectID.0 = No Such Object available on this agent at this OID
40.  
41.  
42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.374,0.419,0.403,3,3,0,13,"2022-08-08 15:25:55"][0m 0.38ms]
43.  
44. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.403,13][0m 0.39ms]
45.  
46. 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[13][0m 0.4ms]
47.  
48. Modules status: Global+  
49. OS  
50. Device  
51.  
52. #### Load poller module core ####
53. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' 'udp6:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
54. .*.*.0 = No Such Object available on this agent at this OID
55. .*.*.0 = No Such Object available on this agent at this OID
56. .*.*.0 = No Such Object available on this agent at this OID
57. .*.*.0 = No Such Object available on this agent at this OID
58.  
59.  
60. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
61. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
62. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
63.  
64.  
65. Uptime seconds: 0
66.  
67.  
68. >> Runtime for poller module 'core': 0.0848 seconds with 62288 bytes
69. >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [0/0.00s]  
70. #### Unload poller module core ####
71.  
72. Modules status: Global+  
73. OS  
74. Device  
75.  
76. #### Load poller module unix-agent ####
77.  
78. >> Runtime for poller module 'unix-agent': 0.0005 seconds with 9368 bytes
79. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
80. #### Unload poller module unix-agent ####
81.  
82. Modules status: Global+  
83. OS  
84. Device  
85.  
86. #### Load poller module os ####
87. Generic :(
88. Location:
89. Hardware:
90. OS Version:
91. OS Features:
92. Serial:
93.  
94. >> Runtime for poller module 'os': 0.0019 seconds with 112376 bytes
95. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
96. #### Unload poller module os ####
97.  
98. Modules status: Global+  
99. OS  
100. Device  
101.  
102. #### Load poller module availability ####
103. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[13][0m 0.38ms]
104.  
105. Availability:
106. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[13][0m 0.33ms]
107.  
108. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[13,1659911155][0m 0.34ms]
109.  
110. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,49][0m 0.25ms]
111.  
112. 1 day : 100%
113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[13,1659392755][0m 0.34ms]
114.  
115. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,50][0m 0.24ms]
116.  
117. 7 days : 100%
118. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[13,1657405555][0m 0.33ms]
119.  
120. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,51][0m 0.25ms]
121.  
122. 30 days : 100%
123. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[13,1628461555][0m 0.33ms]
124.  
125. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,52][0m 0.23ms]
126.  
127. 365 days : 100%
128.  
129. >> Runtime for poller module 'availability': 0.0064 seconds with 86320 bytes
130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.03s]  
131. #### Unload poller module availability ####
132.  
133. Modules status: Global+  
134. OS  
135. Device  
136.  
137. #### Load poller module ipmi ####
138. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[13][0m 0.43ms]
139.  
140. array (
141. )  
142.  
143. >> Runtime for poller module 'ipmi': 0.0009 seconds with 1592 bytes
144. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
145. #### Unload poller module ipmi ####
146.  
147. Modules status: Global+  
148. OS  
149. Device  
150.  
151. #### Load poller module sensors ####
152. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[13][0m 0.35ms]
153.  
154.  
155. >> Runtime for poller module 'sensors': 0.0006 seconds with 456 bytes
156. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
157. #### Unload poller module sensors ####
158.  
159. Modules status: Global+  
160. OS  
161. Device  
162.  
163. #### Load poller module processors ####
164. Attempting to initialize OS: generic  
165. OS initialized: LibreNMS\OS\Generic  
166. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[13][0m 0.36ms]
167.  
168.  
169. >> Runtime for poller module 'processors': 0.0015 seconds with 59056 bytes
170. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
171. #### Unload poller module processors ####
172.  
173. Modules status: Global+  
174. OS  
175. Device  
176.  
177. #### Load poller module mempools ####
178. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[13][0m 0.42ms]
179.  
180.  
181. >> Runtime for poller module 'mempools': 0.0015 seconds with 76976 bytes
182. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
183. #### Unload poller module mempools ####
184.  
185. Modules status: Global+  
186. OS  
187. Device  
188.  
189. #### Load poller module storage ####
190. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[13][0m 0.37ms]
191.  
192.  
193. >> Runtime for poller module 'storage': 0.0007 seconds with 904 bytes
194. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
195. #### Unload poller module storage ####
196.  
197. Modules status: Global+  
198. OS  
199. Device  
200.  
201. #### Load poller module netstats ####
202. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6: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' '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' '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]  
203. IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID
204. IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID
205. IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID
206. IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID
207. IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID
208. IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID
209. IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID
210. IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID
211. IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID
212. IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID
213. IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID
214. IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID
215. IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID
216. IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID
217. IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID
218. IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID
219. IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID
220. IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID
221. IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID
222. IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID
223. IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID
224. IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID
225. IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID
226. IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID
227. IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID
228. IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID
229.  
230.  
231. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6: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' '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]  
232. IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID
233. IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID
234. IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID
235. IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID
236. IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID
237. IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID
238. IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID
239. IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID
240. IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID
241. IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID
242. IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID
243. IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID
244. IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID
245. IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID
246. IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID
247. IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID
248.  
249.  
250. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
251. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
252.  
253.  
254. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6: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' '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' '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]  
255. SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID
256. SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID
257. SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID
258. SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID
259. SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID
260. SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID
261. SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID
262. SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID
263. SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID
264. SNMPv2-MIB::snmpInReadOnlys.0 = No Such Object available on this agent at this OID
265. SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID
266. SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID
267. SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID
268. SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID
269. SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID
270. SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID
271. SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID
272. SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID
273. SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID
274. SNMPv2-MIB::snmpOutNoSuchNames.0 = No Such Object available on this agent at this OID
275. SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID
276. SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID
277. SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID
278. SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID
279. SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID
280. SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID
281. SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID
282. SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID
283. SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID
284.  
285.  
286. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
287. UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID
288. UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID
289. UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID
290. UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID
291.  
292.  
293. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp6: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]  
294. TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID
295. TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID
296. TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID
297. TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID
298. TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID
299. TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID
300. TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID
301. TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID
302. TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID
303. TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID
304.  
305.  
306.  
307.  
308. >> Runtime for poller module 'netstats': 0.2494 seconds with 23760 bytes
309. >> [0;36mSNMP[0m: [6/0.25s] [1;33mMySQL[0m: [0/0.00s]  
310. #### Unload poller module netstats ####
311.  
312. Modules status: Global+  
313. OS  
314. Device  
315.  
316. #### Load poller module hr-mib ####
317. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
318. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
319. hrSystemProcesses.0 = No Such Object available on this agent at this OID
320. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
321.  
322.  
323.  
324. >> Runtime for poller module 'hr-mib': 0.0404 seconds with 640 bytes
325. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s]  
326. #### Unload poller module hr-mib ####
327.  
328. Modules status: Global+  
329. OS  
330. Device  
331.  
332. #### Load poller module ucd-mib ####
333. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'systemStats'[0m]
334. systemStats = No more variables left in this MIB View (It is past the end of the MIB tree)  
335.  
336. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
337. laLoadInt.1 = No Such Object available on this agent at this OID
338. laLoadInt.2 = No Such Object available on this agent at this OID
339. laLoadInt.3 = No Such Object available on this agent at this OID  
340.  
341.  
342. >> Runtime for poller module 'ucd-mib': 0.0789 seconds with 200 bytes
343. >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [0/0.00s]  
344. #### Unload poller module ucd-mib ####
345.  
346. Modules status: Global+  
347. OS  
348. Device  
349.  
350. #### Load poller module ipSystemStats ####
351. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'ipSystemStats'[0m]
352. ipSystemStatsTable = No Such Object available on this agent at this OID  
353.  
354. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
355.  
356.  
357. >> Runtime for poller module 'ipSystemStats': 0.0523 seconds with 912 bytes
358. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [0/0.00s]  
359. #### Unload poller module ipSystemStats ####
360.  
361. Modules status: Global+  
362. OS  
363. Device  
364.  
365. #### Load poller module ports ####
366. 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[13][0m 0.83ms]
367.  
368. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'ifXEntry'[0m]
369. ifXEntry = No Such Object available on this agent at this OID  
370.  
371. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
372. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'ifEntry'[0m]
373. ifEntry = No Such Object available on this agent at this OID  
374.  
375. Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
376. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
377. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
378.  
379. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
380. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp6:HOSTNAME:161' 'dot1qPvid'[0m]
381. dot1qPvid = No Such Object available on this agent at this OID  
382.  
383. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
384. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[13][0m 0.43ms]
385.  
386. array (
387. )  
388.  
389. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1659997555,null,1659997555][0m 0.22ms]
390.  
391. 0 updated  
392.  
393. >> Runtime for poller module 'ports': 0.2003 seconds with 30776 bytes
394. >> [0;36mSNMP[0m: [4/0.20s] [1;33mMySQL[0m: [3/0.01s]  
395. #### Unload poller module ports ####
396.  
397. Modules status: Global+  
398. OS  
399. Device  
400.  
401. #### Load poller module customoid ####
402. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[13][0m 0.38ms]
403.  
404.  
405. >> Runtime for poller module 'customoid': 0.0008 seconds with 1360 bytes
406. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
407. #### Unload poller module customoid ####
408.  
409. Modules status: Global+  
410. OS  
411. Device  
412.  
413. #### Load poller module bgp-peers ####
414. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[13][0m 0.47ms]
415.  
416.  
417. >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 14368 bytes
418. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
419. #### Unload poller module bgp-peers ####
420.  
421. Modules status: Global-  
422. OS  
423. Device  
424. Module [ junose-atm-vp ] disabled globally.
425.  
426. Modules status: Global-  
427. OS  
428. Device  
429. Module [ printer-supplies ] disabled globally.
430.  
431. Modules status: Global+  
432. OS  
433. Device  
434.  
435. #### Load poller module ucd-diskio ####
436. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[13][0m 0.33ms]
437.  
438.  
439. >> Runtime for poller module 'ucd-diskio': 0.0007 seconds with 784 bytes
440. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
441. #### Unload poller module ucd-diskio ####
442.  
443. Modules status: Global-  
444. OS  
445. Device  
446. Module [ wifi ] disabled globally.
447.  
448. Modules status: Global-  
449. OS  
450. Device  
451. Module [ wireless ] disabled globally.
452.  
453. Modules status: Global+  
454. OS  
455. Device  
456.  
457. #### Load poller module ospf ####
458. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[13][0m 0.37ms]
459.  
460.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUt' '-Os' 'udp6:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]  
461. ospfGeneralGroup = No Such Object available on this agent at this OID
462.  
463.  
464. SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[13,""][0m 0.33ms]
465.  
466. 0
467. >> Runtime for poller module 'ospf': 0.0495 seconds with 92480 bytes
468. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [2/0.01s]  
469. #### Unload poller module ospf ####
470.  
471. Modules status: Global-  
472. OS  
473. Device  
474. Module [ isis ] disabled globally.
475.  
476. Modules status: Global-  
477. OS  
478. Device  
479. Module [ cisco-ipsec-flow-monitor ] disabled globally.
480.  
481. Modules status: Global-  
482. OS  
483. Device  
484. Module [ cisco-remote-access-monitor ] disabled globally.
485.  
486. Modules status: Global-  
487. OS  
488. Device  
489. Module [ cisco-cef ] disabled globally.
490.  
491. Modules status: Global-  
492. OS  
493. Device  
494. Module [ slas ] disabled globally.
495.  
496. Modules status: Global-  
497. OS  
498. Device  
499. Module [ cisco-mac-accounting ] disabled globally.
500.  
501. Modules status: Global-  
502. OS  
503. Device  
504. Module [ cipsec-tunnels ] disabled globally.
505.  
506. Modules status: Global-  
507. OS  
508. Device  
509. Module [ cisco-ace-loadbalancer ] disabled globally.
510.  
511. Modules status: Global-  
512. OS  
513. Device  
514. Module [ cisco-ace-serverfarms ] disabled globally.
515.  
516. Modules status: Global-  
517. OS  
518. Device  
519. Module [ cisco-asa-firewall ] disabled globally.
520.  
521. Modules status: Global-  
522. OS  
523. Device  
524. Module [ cisco-voice ] disabled globally.
525.  
526. Modules status: Global-  
527. OS  
528. Device  
529. Module [ cisco-cbqos ] disabled globally.
530.  
531. Modules status: Global-  
532. OS  
533. Device  
534. Module [ cisco-otv ] disabled globally.
535.  
536. Modules status: Global-  
537. OS  
538. Device  
539. Module [ cisco-qfp ] disabled globally.
540.  
541. Modules status: Global-  
542. OS  
543. Device  
544. Module [ cisco-vpdn ] disabled globally.
545.  
546. Modules status: Global-  
547. OS  
548. Device  
549. Module [ nac ] disabled globally.
550.  
551. Modules status: Global-  
552. OS  
553. Device  
554. Module [ netscaler-vsvr ] disabled globally.
555.  
556. Modules status: Global-  
557. OS  
558. Device  
559. Module [ aruba-controller ] disabled globally.
560.  
561. Modules status: Global+  
562. OS  
563. Device  
564.  
565. #### Load poller module entity-physical ####
566.  
567. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 472 bytes
568. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
569. #### Unload poller module entity-physical ####
570.  
571. Modules status: Global+  
572. OS  
573. Device  
574.  
575. #### Load poller module entity-state ####
576. SQL[[1;33mSELECT S.entity_state_id, S.entStateLastChanged, P.entPhysicalIndex FROM entityState AS S LEFT JOIN entPhysical AS P USING (entPhysical_id) WHERE S.device_id=? [0;33m[13][0m 0.4ms]
577.  
578.  
579. >> Runtime for poller module 'entity-state': 0.0008 seconds with 1104 bytes
580. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
581. #### Unload poller module entity-state ####
582.  
583. Modules status: Global+  
584. OS  
585. Device  
586.  
587. #### Load poller module applications ####
588. SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[13][0m 0.34ms]
589.  
590.  
591. >> Runtime for poller module 'applications': 0.0011 seconds with 29416 bytes
592. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
593. #### Unload poller module applications ####
594.  
595. Modules status: Global+  
596. OS  
597. Device  
598.  
599. #### Load poller module stp ####
600. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[13][0m 0.36ms]
601.  
602.  
603. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[13][0m 0.34ms]
604.  
605.  
606. >> Runtime for poller module 'stp': 0.0022 seconds with 80000 bytes
607. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.01s]  
608. #### Unload poller module stp ####
609.  
610. Modules status: Global+  
611. OS  
612. Device  
613.  
614. #### Load poller module ntp ####
615.  
616. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
617. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
618. #### Unload poller module ntp ####
619.  
620. Modules status: Global-  
621. OS  
622. Device  
623. Module [ loadbalancers ] disabled globally.
624.  
625. Modules status: Global-  
626. OS  
627. Device  
628. Module [ mef ] disabled globally.
629.  
630. Modules status: Global+  
631. OS  
632. Device  
633.  
634. #### Load poller module mpls ####
635.  
636. >> Runtime for poller module 'mpls': 0.0003 seconds with 23656 bytes
637. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
638. #### Unload poller module mpls ####
639.  
640. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[13][0m 0.34ms]
641.  
642.  
643. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.859,13][0m 0.32ms]
644.  
645. Updating ztvi-sw1.fm2.ztvi.org  
646.  
647. Polled in 1.859 seconds
648. ### Start Device Groups ###
649. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.31ms]
650.  
651. 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) [0;33m[][0m 0.39ms]
652.  
653. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%ipmi%",13][0m 0.33ms]
654.  
655. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%vhost%","%ipmi%",13][0m 0.3ms]
656.  
657. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;32mw%",13][0m 0.29ms]
658.  
659. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? AND `devices`.`hostname` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;35mve%","%vhost%",13][0m 0.29ms]
660.  
661. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[13][0m 0.31ms]
662.  
663. Groups Added:  
664. Groups Removed:  
665. ### End Device Groups, runtime: 0.0097s ###
666.  
667. #### Start Alerts ####
668. 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[13][0m 0.35ms]
669.  
670. 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(`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` = ?))) as `exists` [0;33m["2022-08-08T22:25:55.895145Z","2022-08-08T22:25:55.895145Z",0,1,"22:25:55","22:25:55","22:25:55","22:25:55","[41m%","device",13][0m 0.55ms]
671.  
672. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[13][0m 0.46ms]
673.  
674. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
675.         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 = ?)
676.         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 = ?))
677.         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 = ?))
678.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
679.         WHERE a.disabled = 0 AND (
680.             (d.device_id IS NULL AND g.group_id IS NULL)
681.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
682.             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))
683.         ) [0;33m[13,13,13,13,13,13,13,13][0m 1.42ms]
684.  
685. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
686.  
687. 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[13][0m 0.43ms]
688.  
689. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,13][0m 0.29ms]
690.  
691. Status: [0;34mNOCHG[0m  
692. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
693.  
694. 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[13][0m 0.41ms]
695.  
696. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,13][0m 0.27ms]
697.  
698. Status: [0;34mNOCHG[0m  
699. Rule [0;35m#3 (Device rebooted):[0m  
700.  
701. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 10 [0;33m[13][0m 0.38ms]
702.  
703. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,13][0m 0.27ms]
704.  
705. Status: [0;34mNOCHG[0m  
706. Rule [0;35m#6 (Port utilisation over threshold):[0m  
707.  
708. SQL[[1;33mSELECT * 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 [0;33m[13][0m 0.7ms]
709.  
710. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,13][0m 0.27ms]
711.  
712. Status: [0;34mNOCHG[0m  
713. Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m  
714.  
715. 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[13][0m 0.51ms]
716.  
717. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,13][0m 0.27ms]
718.  
719. Status: [0;34mNOCHG[0m  
720. Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m  
721.  
722. SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current &lt; sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[13][0m 0.49ms]
723.  
724. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,13][0m 0.29ms]
725.  
726. Status: [0;34mNOCHG[0m  
727. Rule [0;35m#9 (Service up/down):[0m  
728.  
729. SQL[[1;33mSELECT * 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 [0;33m[13][0m 0.51ms]
730.  
731. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,13][0m 0.27ms]
732.  
733. Status: [0;34mNOCHG[0m  
734. Rule [0;35m#12 (State Sensor Critical):[0m  
735.  
736. 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 [0;33m[13][0m 0.85ms]
737.  
738. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,13][0m 0.28ms]
739.  
740. Status: [0;34mNOCHG[0m  
741. #### End Alerts ####
742. ./poller.php ztvi-sw1.fm2.ztvi.org 2022-08-08 15:25:55 - 1 devices polled in 2.116 secs  
743.  
744. [0;36mSNMP[0m [18/0.79s]: Snmpget[11/0.45s] Snmpwalk[7/0.33s]  
745. [1;33mSQL[0m [72/0.30s]: Select[62/0.27s] Delete[2/0.01s] Insert[1/0.00s] Update[7/0.02s]  
746.