1.concur.insert.mql 2.6 KB

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