Home Explore Help
Sign In
libf
/
odbtools
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: abf302da47
Branches Tags
odbtools
/
odbctest
/
mql
/
bench
/
event
/
11alert_insert_del.mql

11alert_insert_del.mql 6.2 KB
History Raw

1234567891011121314151617181920212223242526 
  1. insert into /bench/event/alerts_status1 (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, ld_smsflag, 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, origin_class, originalseverity, originalsummary, 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, vtime, x733corrnotif, x733eventtype, x733probablecause, x733specificprob) values (null, null, null, null, '', 'NA', null, null, 'NA', null, null, null, null, null, null, null, 'tivoli监控平台', null, null, null, null, null, null, 'OMNIBUS服务器', null, null, '韩旭扬', '18840900596', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1752202294000, null, null, null, '102760763574700{%d,mqli}', '10.1.81.124 root: this is a test
    2. 

  2. 10.1.81.124', null, 1, null, null, null, 1752205967000, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '10276076357470077220', null, null, null, null, null, null, null, null, '10.1.81.124', null, null, null, null, null, null, 541322097, null, 200, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 541322097, null, null, null, null, 1, null, null, null, null, null, null, null, 'Jul 11 11:52:47 10.1.81.124 root: this is a test
    3. 

  3. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    4. 

  4. /**
    5. 

  5. loop(1000) 
    6. 

  6. parallel(5)
    7. 

  7. fork(a)
    8. 

  8. **/
    9. 

  9. ;
    10. 

  10. 

  11. insert into /bench/event/alerts_status1 (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, ld_smsflag, 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, origin_class, originalseverity, originalsummary, 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, vtime, x733corrnotif, x733eventtype, x733probablecause, x733specificprob) values (null, null, null, null, '', 'NA', null, null, 'NA', null, null, null, null, null, null, null, 'tivoli监控平台', null, null, null, null, null, null, 'PROBE服务器', null, null, '韩旭扬', '18840900596', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1752202294000, null, null, null, '102760763574700{%d,mqli}', '10.1.81.124 root: this is a test
    12. 

  12. 10.1.81.124', null, 1, null, null, null, 1752205967000, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '10276076357470077220', null, null, null, null, null, null, null, null, '10.1.81.124', null, null, null, null, null, null, 541322097, null, 200, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 541322097, null, null, null, null, 1, null, null, null, null, null, null, null, 'Jul 11 11:52:47 10.1.81.124 root: this is a test
    13. 

  13. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    14. 

  14. /**
    15. 

  15. loop(1000) 
    16. 

  16. parallel(10)
    17. 

  17. fork(a)
    18. 

  18. **/
    19. 

  19. ;
    20. 

  20. 

  21. select * from /bench/event/alerts_status1 limit -1
    22. 

  22. /**
    23. 

  23. wait(a)
    24. 

  24. count(1000)
    25. 

  25. **/
    26. 

  26. ;
    27.