2insert.mql 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314
  1. insert into /devops/alerts_status (
  2. acknowledged,
  3. admin,
  4. adminphone,
  5. agent,
  6. alarmkey,
  7. alarmtype,
  8. alertgroup,
  9. alertkey,
  10. alertsubtype,
  11. alerttype,
  12. area,
  13. bname,
  14. bsm_classname,
  15. bsm_identity,
  16. bsm_subidentity,
  17. businessimpact,
  18. bussinesscategory,
  19. causetype,
  20. ccpc,
  21. ccpcbank,
  22. chineseflag,
  23. ciid,
  24. cmdbenrichstatus,
  25. cname,
  26. cnsummary,
  27. contact,
  28. contactman,
  29. contactphone,
  30. corrscore,
  31. customer,
  32. deviceios,
  33. devicelocation,
  34. devicemodel,
  35. devicepurpose,
  36. devicetype,
  37. domaingroup,
  38. domainsubgroup,
  39. duration,
  40. emailstatus,
  41. entity,
  42. eventclass,
  43. eventid,
  44. eventstatus,
  45. eventtime,
  46. eventtype,
  47. evtproccode,
  48. expiretime,
  49. explain,
  50. extendedattr,
  51. firstoccurrence,
  52. flag,
  53. flash,
  54. grade,
  55. id,
  56. identifier,
  57. idname,
  58. impactflag,
  59. instance,
  60. internallast,
  61. itmdisplayitem,
  62. lastoccurrence,
  63. localnodealias,
  64. localobjrelate,
  65. localpriobj,
  66. localrootobj,
  67. localsecobj,
  68. localtertobj,
  69. location,
  70. logticket,
  71. lpar,
  72. machineid,
  73. maintainstatus,
  74. maintenance,
  75. manager,
  76. market,
  77. msg_id,
  78. n_maintenance_status,
  79. name,
  80. netype,
  81. nmoscausetype,
  82. nmosdomainname,
  83. nmosentityid,
  84. nmoseventmap,
  85. nmosmanagedstatus,
  86. nmosobjinst,
  87. nmosserial,
  88. node,
  89. nodealias,
  90. nodename,
  91. nodetype,
  92. objectfullname,
  93. oldrow,
  94. omni_class,
  95. omni_serial,
  96. orgcode,
  97. originalseverity,
  98. ownergid,
  99. owneruid,
  100. phone,
  101. physicalcabinet,
  102. physicalcard,
  103. physicallocation,
  104. physicalport,
  105. physicalslot,
  106. plateng,
  107. platform,
  108. policylevel,
  109. policyname,
  110. poll,
  111. probesubsecondid,
  112. processreq,
  113. recordtime,
  114. region,
  115. remotenodealias,
  116. remoteobjrelate,
  117. remotepriobj,
  118. remoterootobj,
  119. remotesecobj,
  120. remotetertobj,
  121. resolve,
  122. rowserial,
  123. servername,
  124. serverserial,
  125. service,
  126. servicenowerrorcode,
  127. servicenowstate,
  128. servicenowsysid,
  129. severity,
  130. siteid,
  131. situationfullname,
  132. smsflag,
  133. statechange,
  134. status,
  135. submodel,
  136. subsystem,
  137. summary,
  138. suppressescl,
  139. syscode,
  140. sysplex,
  141. tags,
  142. tally,
  143. tasklist,
  144. ticketstatus,
  145. tiggerflag,
  146. tsrmflag,
  147. ttnumber,
  148. ttstate,
  149. ttuser,
  150. type,
  151. upgradeflag,
  152. url,
  153. x733corrnotif,
  154. x733eventtype,
  155. x733probablecause,
  156. x733specificprob)
  157. values
  158. (0,
  159. '',
  160. '',
  161. 'Snmp Probe',
  162. '',
  163. '',
  164. 'snmp',
  165. 'snmpport_1000',
  166. '',
  167. '',
  168. '',
  169. '',
  170. '',
  171. '',
  172. '',
  173. 0,
  174. '',
  175. 0,
  176. 0,
  177. '',
  178. 0,
  179. '',
  180. 0,
  181. '',
  182. '',
  183. '',
  184. '',
  185. '',
  186. 0,
  187. '',
  188. '',
  189. '',
  190. '',
  191. '',
  192. '',
  193. 'snmp',
  194. '',
  195. 0,
  196. 0,
  197. '',
  198. '',
  199. '',
  200. 0,
  201. '',
  202. 0,
  203. '',
  204. 0,
  205. '',
  206. '',
  207. 1694318500000,
  208. 0,
  209. 0,
  210. 0,
  211. '12237946334400009999',
  212. 'node:node:192.168.0.8',
  213. '',
  214. 0,
  215. '',
  216. -6795364578871,
  217. '',
  218. 1694322269050,
  219. '',
  220. 0,
  221. '',
  222. '',
  223. '',
  224. '',
  225. '',
  226. 0,
  227. '',
  228. '',
  229. 0,
  230. 0,
  231. 'Snmp',
  232. '',
  233. '',
  234. 0,
  235. '12237946334446340014',
  236. '',
  237. 0,
  238. '',
  239. 0,
  240. '',
  241. 0,
  242. 0,
  243. '',
  244. 'node:node:192.168.0.8',
  245. '',
  246. '',
  247. '',
  248. '',
  249. 0,
  250. '',
  251. 0,
  252. '',
  253. 0,
  254. 0,
  255. 0,
  256. '',
  257. '',
  258. '',
  259. '',
  260. 0,
  261. 0,
  262. '',
  263. '',
  264. '',
  265. '',
  266. 0,
  267. 0,
  268. 0,
  269. 0,
  270. '',
  271. '',
  272. 0,
  273. '',
  274. '',
  275. '',
  276. '',
  277. '',
  278. 0,
  279. '',
  280. 11223,
  281. '',
  282. 0,
  283. 0,
  284. '',
  285. 1,
  286. '',
  287. '',
  288. 1,
  289. -6795364578871,
  290. 0,
  291. '',
  292. '',
  293. 'snmp test event',
  294. 0,
  295. '',
  296. '',
  297. null,
  298. 28000,
  299. 0,
  300. '',
  301. 0,
  302. 0,
  303. '',
  304. 0,
  305. '',
  306. 1,
  307. 0,
  308. '',
  309. '',
  310. 0,
  311. 0,
  312. '')
  313. ;