API tools faq
paste
Advertisement
Guest User

Debug discovery ruckus

a guest
Feb 2nd, 2015
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.27 KB | None | 0 0
raw download clone embed print report
  1. root@lin:/opt/observium# ./discovery.php -d -m wifi -h 51
  2. DEBUG!
  3. Observium 0.15.2.6237
  4. Discovery
  5.  
  6.  
  7. SQL[SELECT `version` FROM `dbSchema`]
  8.  
  9. SQL[SELECT COUNT(*) FROM ports]
  10.  
  11. SQL[SELECT COUNT(*) FROM devices]
  12.  
  13. SQL[SELECT COUNT(*) FROM `sensors`]
  14.  
  15. SQL[SELECT COUNT(*) FROM `services`]
  16.  
  17. SQL[SELECT COUNT(*) FROM `applications`]
  18.  
  19. SQL[SELECT COUNT(*) FROM `bgpPeers`]
  20.  
  21. SQL[SELECT COUNT(*) FROM `ospf_ports`]
  22.  
  23. SQL[SELECT COUNT(*) FROM `eigrp_ports`]
  24.  
  25. SQL[SELECT COUNT(*) FROM `ipsec_tunnels`]
  26.  
  27. SQL[SELECT COUNT(*) FROM `munin_plugins`]
  28.  
  29. SQL[SELECT COUNT(*) FROM `pseudowires`]
  30.  
  31. SQL[SELECT COUNT(*) FROM `vrfs`]
  32.  
  33. SQL[SELECT COUNT(*) FROM `vminfo`]
  34.  
  35. SQL[SELECT COUNT(*) FROM `users`]
  36.  
  37. SQL[SELECT COUNT(*) FROM `bills`]
  38.  
  39. SQL[SELECT COUNT(*) FROM `alert_table`]
  40.  
  41. SQL[SELECT COUNT(*) FROM `alert_tests`]
  42.  
  43. SQL[SELECT COUNT(*) FROM `groups`]
  44.  
  45. SQL[SELECT COUNT(*) FROM `group_table`]
  46.  
  47. SQL[SELECT SUM(`last_polled_timetaken`) FROM devices]
  48. CMD[DISTROFORMAT=export /opt/observium/scripts/distro]
  49. EXITCODE[0]
  50. RUNTIME[0.0339s]
  51. STDOUT[
  52. OS=Linux
  53. KERNEL=3.13.0-37-generic
  54. ARCH=amd64
  55. DISTRO=Ubuntu
  56. DISTROVER=14.04
  57. SCRIPTVER=1.0.14
  58. ]
  59.  
  60. SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`]
  61.  
  62. SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`]
  63.  
  64. SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`]
  65.  
  66. SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`]
  67.  
  68. SQL[SELECT * FROM `devices` WHERE `status` = 1 AND `disabled` = 0 AND `device_id` = '51' ORDER BY `last_discovered_timetaken` ASC]
  69.  
  70. CMD[/usr/bin/snmpget -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ruckus-ap-king-08':'161' sysObjectID.0 sysUpTime.0]
  71. EXITCODE[0]
  72. RUNTIME[0.0095s]
  73. STDOUT[
  74. sysObjectID.0 = enterprises.25053.3.1.4.13
  75. sysUpTime.0 = 54788767
  76. ]
  77. SNMP_STATUS[TRUE]
  78.  
  79. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  80. ruckus-ap-king-08 51 ruckus
  81. Wifi:
  82. SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '51']
  83.  
  84. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  85. [[RUCKUS-RADIO-MIB]] RUCKUS-RADIO-MIB
  86. CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m RUCKUS-RADIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ruckus 'udp':'ruckus-ap-king-08':'161' RuckusRadioTable]
  87. EXITCODE[0]
  88. RUNTIME[0.0327s]
  89. STDOUT[
  90. ruckusRadioMode.1 = ieee802dot11ng
  91. ruckusRadioMode.2 = ieee802dot11na
  92. ruckusRadioCountry.1 = "42 52 00 "
  93. ruckusRadioCountry.2 = "42 52 00 "
  94. ruckusRadioBSSType.1 = 0
  95. ruckusRadioBSSType.2 = 0
  96. ruckusRadioChannel.1 = 0
  97. ruckusRadioChannel.2 = 0
  98. ruckusRadioDataRate.1 = "auto"
  99. ruckusRadioDataRate.2 = "auto"
  100. ruckusRadioTxPower.1 = full
  101. ruckusRadioTxPower.2 = full
  102. ruckusRadioProtectionMode.1 = none
  103. ruckusRadioProtectionMode.2 = none
  104. ]
  105. SNMP_STATUS[TRUE]
  106.  
  107. CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m RUCKUS-RADIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/ruckus 'udp':'ruckus-ap-king-08':'161' ruckusRadioStatsNumSta]
  108. EXITCODE[0]
  109. RUNTIME[0.0145s]
  110. STDOUT[
  111. ruckusRadioStatsNumSta.1 = 11
  112. ruckusRadioStatsNumSta.2 = 5
  113. ]
  114. SNMP_STATUS[TRUE]
  115. Array
  116. (
  117. [1] => Array
  118. (
  119. [ruckusRadioMode] => ieee802dot11ng
  120. [ruckusRadioCountry] => 42 52 00
  121. [ruckusRadioBSSType] => 0
  122. [ruckusRadioChannel] => 0
  123. [ruckusRadioDataRate] => auto
  124. [ruckusRadioTxPower] => full
  125. [ruckusRadioProtectionMode] => none
  126. [ruckusRadioStatsNumSta] => 11
  127. )
  128.  
  129. [2] => Array
  130. (
  131. [ruckusRadioMode] => ieee802dot11na
  132. [ruckusRadioCountry] => 42 52 00
  133. [ruckusRadioBSSType] => 0
  134. [ruckusRadioChannel] => 0
  135. [ruckusRadioDataRate] => auto
  136. [ruckusRadioTxPower] => full
  137. [ruckusRadioProtectionMode] => none
  138. [ruckusRadioStatsNumSta] => 5
  139. )
  140.  
  141. )
  142. Array
  143. (
  144. [ruckusRadioMode] => ieee802dot11ng
  145. [ruckusRadioCountry] => 42 52 00
  146. [ruckusRadioBSSType] => 0
  147. [ruckusRadioChannel] => 0
  148. [ruckusRadioDataRate] => auto
  149. [ruckusRadioTxPower] => full
  150. [ruckusRadioProtectionMode] => none
  151. [ruckusRadioStatsNumSta] => 11
  152. [radio_mib] => RUCKUS-RADIO-MIB
  153. [radio_number] => 1
  154. [radio_ap] => 0
  155. [radio_type] => ieee802dot11ng
  156. [radio_status] => unknown
  157. [radio_clients] => 11
  158. [radio_txpower] => full
  159. [radio_channel] => 0
  160. [radio_bsstype] => unknown
  161. [radio_protection] => none
  162. [radio_mac] => Array
  163. (
  164. [0] => NULL
  165. )
  166.  
  167. )
  168.  
  169. SQL[UPDATE `wifi_radios` set `radio_clients` ='11',`radio_mac` =NULL WHERE `wifi_radio_id` = '1']
  170. UArray
  171. (
  172. [ruckusRadioMode] => ieee802dot11na
  173. [ruckusRadioCountry] => 42 52 00
  174. [ruckusRadioBSSType] => 0
  175. [ruckusRadioChannel] => 0
  176. [ruckusRadioDataRate] => auto
  177. [ruckusRadioTxPower] => full
  178. [ruckusRadioProtectionMode] => none
  179. [ruckusRadioStatsNumSta] => 5
  180. [radio_mib] => RUCKUS-RADIO-MIB
  181. [radio_number] => 2
  182. [radio_ap] => 0
  183. [radio_type] => ieee802dot11na
  184. [radio_status] => unknown
  185. [radio_clients] => 5
  186. [radio_txpower] => full
  187. [radio_channel] => 0
  188. [radio_bsstype] => unknown
  189. [radio_protection] => none
  190. [radio_mac] => Array
  191. (
  192. [0] => NULL
  193. )
  194.  
  195. )
  196.  
  197. SQL[UPDATE `wifi_radios` set `radio_mac` =NULL WHERE `wifi_radio_id` = '2']
  198. U
  199. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  200.  
  201. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  202.  
  203. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  204.  
  205. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  206.  
  207. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  208.  
  209. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  210.  
  211. SQL[SELECT * FROM `devices_attribs` WHERE `device_id` = '51']
  212.  
  213.  
  214. Module [ wifi ] time: 0.0862s
  215.  
  216. SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='wireless',`last_discovered_timetaken` ='0.086' WHERE `device_id` = '51']
  217.  
  218. SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('51','discover','1422899496.2133','0.086388826370239')]
  219. Device [ ruckus-ap-king-08 ] discovered in 0.086 seconds
  220.  
  221.  
  222. SQL[SELECT * FROM `alert_tests`]
  223.  
  224. SQL[SELECT * FROM `alert_assoc`]
  225.  
  226. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  227.  
  228. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51' AND `type` = 'server']
  229.  
  230. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  231.  
  232. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  233.  
  234. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  235.  
  236. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  237.  
  238. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  239.  
  240. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  241.  
  242. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  243.  
  244. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  245.  
  246. SQL[SELECT count(*) FROM `devices` WHERE device_id = '51']
  247.  
  248. SQL[SELECT * FROM `alert_table` WHERE `device_id` = '51']
  249.  
  250. SQL[SELECT * FROM `processors` WHERE device_id = '51']
  251.  
  252. SQL[SELECT * FROM `sensors` WHERE device_id = '51']
  253.  
  254. SQL[SELECT * FROM `bgpPeers` WHERE device_id = '51']
  255.  
  256. SQL[SELECT * FROM `bgpPeers` WHERE device_id = '51']
  257.  
  258. SQL[SELECT * FROM `ports` WHERE device_id = '51' AND `deleted` != '1']
  259.  
  260. SQL[SELECT * FROM `ports` WHERE device_id = '51' AND `deleted` != '1' AND `ifType` = 'ethernetCsmacd']
  261.  
  262. SQL[SELECT * FROM `ports` WHERE device_id = '51' AND `deleted` != '1' AND `ifType` != 'other' AND `ifType` != 'tunnel' AND `ifType` != 'ieee80211' AND `ifType` != 'ppp']
  263.  
  264. SQL[SELECT * FROM `ports` WHERE device_id = '51' AND `deleted` != '1']
  265.  
  266. SQL[SELECT * FROM `ports` WHERE device_id = '51' AND `deleted` != '1' AND `ifType` = 'ethernetCsmacd' AND `ifOperStatus` = 'up']
  267.  
  268. SQL[SELECT * FROM `devices` WHERE device_id = '51']
  269.  
  270. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7345']
  271.  
  272. SQL[SELECT * FROM `devices` WHERE `device_id` = '51']
  273.  
  274. SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '51']
  275.  
  276. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7345','8','8')]
  277.  
  278. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14202')]
  279.  
  280. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7345','14','14')]
  281.  
  282. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14203')]
  283.  
  284. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7345','11','11')]
  285.  
  286. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14204')]
  287.  
  288. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7346']
  289.  
  290. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7346','8','8')]
  291.  
  292. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14205')]
  293.  
  294. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7346','9','9')]
  295.  
  296. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14206')]
  297.  
  298. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7346','14','14')]
  299.  
  300. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14207')]
  301.  
  302. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7346','11','11')]
  303.  
  304. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14208')]
  305.  
  306. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7347']
  307.  
  308. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7347','8','8')]
  309.  
  310. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14209')]
  311.  
  312. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7347','9','9')]
  313.  
  314. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14210')]
  315.  
  316. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7347','14','14')]
  317.  
  318. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14211')]
  319.  
  320. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7347','11','11')]
  321.  
  322. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14212')]
  323.  
  324. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7348']
  325.  
  326. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7348','8','8')]
  327.  
  328. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14213')]
  329.  
  330. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7348','9','9')]
  331.  
  332. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14214')]
  333.  
  334. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7348','14','14')]
  335.  
  336. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14215')]
  337.  
  338. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7348','11','11')]
  339.  
  340. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14216')]
  341.  
  342. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7349']
  343.  
  344. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7349','8','8')]
  345.  
  346. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14217')]
  347.  
  348. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7349','9','9')]
  349.  
  350. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14218')]
  351.  
  352. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7349','14','14')]
  353.  
  354. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14219')]
  355.  
  356. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7349','11','11')]
  357.  
  358. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14220')]
  359.  
  360. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7350']
  361.  
  362. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7350','8','8')]
  363.  
  364. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14221')]
  365.  
  366. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7350','9','9')]
  367.  
  368. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14222')]
  369.  
  370. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7350','14','14')]
  371.  
  372. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14223')]
  373.  
  374. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7350','11','11')]
  375.  
  376. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14224')]
  377.  
  378. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7351']
  379.  
  380. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7351','8','8')]
  381.  
  382. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14225')]
  383.  
  384. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7351','9','9')]
  385.  
  386. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14226')]
  387.  
  388. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7351','14','14')]
  389.  
  390. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14227')]
  391.  
  392. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7351','11','11')]
  393.  
  394. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14228')]
  395.  
  396. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7352']
  397.  
  398. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7352','8','8')]
  399.  
  400. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14229')]
  401.  
  402. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7352','9','9')]
  403.  
  404. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14230')]
  405.  
  406. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7352','14','14')]
  407.  
  408. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14231')]
  409.  
  410. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7352','11','11')]
  411.  
  412. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14232')]
  413.  
  414. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7353']
  415.  
  416. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7353','8','8')]
  417.  
  418. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14233')]
  419.  
  420. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7353','9','9')]
  421.  
  422. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14234')]
  423.  
  424. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7353','14','14')]
  425.  
  426. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14235')]
  427.  
  428. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7353','11','11')]
  429.  
  430. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14236')]
  431.  
  432. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7354']
  433.  
  434. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7354','8','8')]
  435.  
  436. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14237')]
  437.  
  438. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7354','9','9')]
  439.  
  440. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14238')]
  441.  
  442. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7354','14','14')]
  443.  
  444. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14239')]
  445.  
  446. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7354','11','11')]
  447.  
  448. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14240')]
  449.  
  450. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7355']
  451.  
  452. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7355','8','8')]
  453.  
  454. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14241')]
  455.  
  456. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7355','9','9')]
  457.  
  458. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14242')]
  459.  
  460. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7355','14','14')]
  461.  
  462. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14243')]
  463.  
  464. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7355','11','11')]
  465.  
  466. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14244')]
  467.  
  468. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7356']
  469.  
  470. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7356','8','8')]
  471.  
  472. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14245')]
  473.  
  474. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7356','9','9')]
  475.  
  476. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14246')]
  477.  
  478. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7356','14','14')]
  479.  
  480. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14247')]
  481.  
  482. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7356','11','11')]
  483.  
  484. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14248')]
  485.  
  486. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7357']
  487.  
  488. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7357','8','8')]
  489.  
  490. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14249')]
  491.  
  492. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7357','9','9')]
  493.  
  494. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14250')]
  495.  
  496. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7357','14','14')]
  497.  
  498. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14251')]
  499.  
  500. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7357','11','11')]
  501.  
  502. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14252')]
  503.  
  504. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7358']
  505.  
  506. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7358','8','8')]
  507.  
  508. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14253')]
  509.  
  510. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7358','9','9')]
  511.  
  512. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14254')]
  513.  
  514. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7358','14','14')]
  515.  
  516. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14255')]
  517.  
  518. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7358','11','11')]
  519.  
  520. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14256')]
  521.  
  522. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7359']
  523.  
  524. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7359','8','8')]
  525.  
  526. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14257')]
  527.  
  528. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7359','9','9')]
  529.  
  530. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14258')]
  531.  
  532. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7359','14','14')]
  533.  
  534. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14259')]
  535.  
  536. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7359','11','11')]
  537.  
  538. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14260')]
  539.  
  540. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7360']
  541.  
  542. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7360','8','8')]
  543.  
  544. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14261')]
  545.  
  546. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7360','9','9')]
  547.  
  548. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14262')]
  549.  
  550. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7360','14','14')]
  551.  
  552. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14263')]
  553.  
  554. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7360','11','11')]
  555.  
  556. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14264')]
  557.  
  558. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7361']
  559.  
  560. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7361','8','8')]
  561.  
  562. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14265')]
  563.  
  564. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7361','9','9')]
  565.  
  566. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14266')]
  567.  
  568. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7361','14','14')]
  569.  
  570. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14267')]
  571.  
  572. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7361','11','11')]
  573.  
  574. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14268')]
  575.  
  576. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7362']
  577.  
  578. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7362','8','8')]
  579.  
  580. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14269')]
  581.  
  582. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7362','9','9')]
  583.  
  584. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14270')]
  585.  
  586. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7362','14','14')]
  587.  
  588. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14271')]
  589.  
  590. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7362','11','11')]
  591.  
  592. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14272')]
  593.  
  594. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7363']
  595.  
  596. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7363','8','8')]
  597.  
  598. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14273')]
  599.  
  600. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7363','9','9')]
  601.  
  602. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14274')]
  603.  
  604. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7363','14','14')]
  605.  
  606. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14275')]
  607.  
  608. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7363','11','11')]
  609.  
  610. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14276')]
  611.  
  612. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7364']
  613.  
  614. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7364','8','8')]
  615.  
  616. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14277')]
  617.  
  618. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7364','9','9')]
  619.  
  620. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14278')]
  621.  
  622. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7364','14','14')]
  623.  
  624. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14279')]
  625.  
  626. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7364','11','11')]
  627.  
  628. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14280')]
  629.  
  630. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7365']
  631.  
  632. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7365','8','8')]
  633.  
  634. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14281')]
  635.  
  636. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7365','9','9')]
  637.  
  638. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14282')]
  639.  
  640. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7365','14','14')]
  641.  
  642. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14283')]
  643.  
  644. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7365','11','11')]
  645.  
  646. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14284')]
  647.  
  648. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7366']
  649.  
  650. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7366','8','8')]
  651.  
  652. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14285')]
  653.  
  654. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7366','9','9')]
  655.  
  656. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14286')]
  657.  
  658. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7366','14','14')]
  659.  
  660. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14287')]
  661.  
  662. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7366','11','11')]
  663.  
  664. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14288')]
  665.  
  666. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7367']
  667.  
  668. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7367','8','8')]
  669.  
  670. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14289')]
  671.  
  672. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7367','9','9')]
  673.  
  674. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14290')]
  675.  
  676. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7367','14','14')]
  677.  
  678. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14291')]
  679.  
  680. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7367','11','11')]
  681.  
  682. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14292')]
  683.  
  684. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7368']
  685.  
  686. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7368','8','8')]
  687.  
  688. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14293')]
  689.  
  690. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7368','9','9')]
  691.  
  692. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14294')]
  693.  
  694. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7368','14','14')]
  695.  
  696. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14295')]
  697.  
  698. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7368','11','11')]
  699.  
  700. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14296')]
  701.  
  702. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7369']
  703.  
  704. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7369','8','8')]
  705.  
  706. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14297')]
  707.  
  708. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7369','9','9')]
  709.  
  710. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14298')]
  711.  
  712. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7369','14','14')]
  713.  
  714. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14299')]
  715.  
  716. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7369','11','11')]
  717.  
  718. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14300')]
  719.  
  720. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7370']
  721.  
  722. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7370','8','8')]
  723.  
  724. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14301')]
  725.  
  726. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7370','9','9')]
  727.  
  728. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14302')]
  729.  
  730. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7370','14','14')]
  731.  
  732. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14303')]
  733.  
  734. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7370','11','11')]
  735.  
  736. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14304')]
  737.  
  738. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7371']
  739.  
  740. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7371','8','8')]
  741.  
  742. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14305')]
  743.  
  744. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7371','9','9')]
  745.  
  746. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14306')]
  747.  
  748. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7371','14','14')]
  749.  
  750. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14307')]
  751.  
  752. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7371','11','11')]
  753.  
  754. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14308')]
  755.  
  756. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7372']
  757.  
  758. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7372','8','8')]
  759.  
  760. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14309')]
  761.  
  762. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7372','9','9')]
  763.  
  764. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14310')]
  765.  
  766. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7372','14','14')]
  767.  
  768. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14311')]
  769.  
  770. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7372','11','11')]
  771.  
  772. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14312')]
  773.  
  774. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7373']
  775.  
  776. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7373','8','8')]
  777.  
  778. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14313')]
  779.  
  780. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7373','9','9')]
  781.  
  782. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14314')]
  783.  
  784. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7373','14','14')]
  785.  
  786. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14315')]
  787.  
  788. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7373','11','11')]
  789.  
  790. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14316')]
  791.  
  792. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7374']
  793.  
  794. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7374','8','8')]
  795.  
  796. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14317')]
  797.  
  798. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7374','9','9')]
  799.  
  800. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14318')]
  801.  
  802. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7374','14','14')]
  803.  
  804. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14319')]
  805.  
  806. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7374','11','11')]
  807.  
  808. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14320')]
  809.  
  810. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7375']
  811.  
  812. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7375','8','8')]
  813.  
  814. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14321')]
  815.  
  816. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7375','9','9')]
  817.  
  818. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14322')]
  819.  
  820. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7375','14','14')]
  821.  
  822. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14323')]
  823.  
  824. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7375','11','11')]
  825.  
  826. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14324')]
  827.  
  828. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7376']
  829.  
  830. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7376','8','8')]
  831.  
  832. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14325')]
  833.  
  834. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7376','9','9')]
  835.  
  836. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14326')]
  837.  
  838. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7376','14','14')]
  839.  
  840. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14327')]
  841.  
  842. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7376','11','11')]
  843.  
  844. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14328')]
  845.  
  846. SQL[SELECT * FROM `ports` LEFT JOIN `ports-state` ON `ports`.`port_id` = `ports-state`.`port_id` WHERE `ports`.`port_id` = '7377']
  847.  
  848. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7377','8','8')]
  849.  
  850. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14329')]
  851.  
  852. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7377','9','9')]
  853.  
  854. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14330')]
  855.  
  856. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7377','14','14')]
  857.  
  858. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14331')]
  859.  
  860. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','port','7377','11','11')]
  861.  
  862. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14332')]
  863.  
  864. SQL[SELECT * FROM `devices` WHERE `device_id` = '51']
  865.  
  866. SQL[INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`) VALUES ('51','device','51','17','17')]
  867.  
  868. SQL[INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('14333')]
  869.  
  870. SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','51','1422899495.1731','1.682','1')]
  871. ./discovery.php: ruckus-ap-king-08 - 1 devices discovered in 1.682 secs
  872. NOTE, $config['snmp']['hide_auth'] sets as TRUE, snmp community and snmp v3 auth hidden from debug output.
  873. Memory usage: 4.75MB (peak: 4.75MB)
  874. MySQL: Cell[32/0.15s] Row[35/0.02s] Rows[13/0.07s] Column[0/0s] Update[3/0.03s] Insert[266/0.51s] Delete[0/0s]
  875. Segmentation fault (core dumped)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!