1x.insert.mql 2.7 KB

1
  1. insert into /m3event/devops/alerts_status (acknowledged, admin, adminphone, agent, alarmkey, alarmtype, alertgroup, alertkey, alertsubtype, alerttype, area, bname, bsm_classname, bsm_identity, bsm_subidentity, businessimpact, bussinesscategory, causetype, ccpc, ccpcbank, chineseflag, ciid, cmdbenrichstatus, cname, cnsummary, contact, contactman, contactphone, corrscore, customer, deviceios, devicelocation, devicemodel, devicepurpose, devicetype, domaingroup, domainsubgroup, duration, emailstatus, entity, eventclass, eventid, eventstatus, eventtime, eventtype, evtproccode, expiretime, explain, extendedattr, firstoccurrence, flag, flash, grade, id, identifier, idname, impactflag, instance, internallast, itmdisplayitem, lastoccurrence, localnodealias, localobjrelate, localpriobj, localrootobj, localsecobj, localtertobj, location, logticket, lpar, machineid, maintainstatus, maintenance, manager, market, msg_id, n_maintenance_status, name, netype, nmoscausetype, nmosdomainname, nmosentityid, nmoseventmap, nmosmanagedstatus, nmosobjinst, nmosserial, node, nodealias, nodename, nodetype, objectfullname, oldrow, omni_class, omni_serial, orgcode, originalseverity, ownergid, owneruid, phone, physicalcabinet, physicalcard, physicallocation, physicalport, physicalslot, plateng, platform, policylevel, policyname, poll, probesubsecondid, processreq, recordtime, region, remotenodealias, remoteobjrelate, remotepriobj, remoterootobj, remotesecobj, remotetertobj, resolve, rowserial, servername, serverserial, service, servicenowerrorcode, servicenowstate, servicenowsysid, severity, siteid, situationfullname, smsflag, statechange, status, submodel, subsystem, summary, suppressescl, syscode, sysplex, tags, tally, tasklist, ticketstatus, tiggerflag, tsrmflag, ttnumber, ttstate, ttuser, type, upgradeflag, url, x733corrnotif, x733eventtype, x733probablecause, x733specificprob) values (0, '', '', 'ICMP Monitor', '', '', '日志', '', '', '', '', '', '', '', '', 0, '', 0, 0, '', 0, '', 0, '', '', '', '', '', 0, '', '', '', '', '', '', 'jxcs', '', 61068540, 0, 'node:10.12.1.25', '', '', 0, '', 0, '已恢复', 0, '', '', 1717354641803, 0, 0, 0, '2270044152371596744', '11.0.9.188ICMP13', '', 0, '', -6962759745885, '', 2250540366140, '', 0, '', '', '', '', '', 0, '', '', 0, 0, 'SYSLOG', '', '', 0, '4819836511531606239', '', 0, '', 0, '', 0, 0, '', '11.0.9.188', 'BJINCS02', '', '', '', 0, '300', 0, '', 3, 0, 0, '', '', '', '', 0, 0, '', '', '严重告警', 'PING_5', 0, 0, 0, 0, '', '', 0, '', '', '', '', '', 0, '', 1122332233, '', 0, 0, '', 5, '', '', 0, -6962759745885, 12, '', '', '[ERROR] HT31-KFCSINT-LEF43 %%01SSL/5/SSL_CONNECT_FAIL(I)CID=0X344284', 0, '', '', null, 74066, 0, '', 0, 0, '', 0, '', 1, 0, '', '', 0, 0, '');