Automic Workload Automation

  • Private Community

  • 1.  How to find all Time Event objects with period less than 15 min

    Posted Feb 27, 2018 04:00 AM
    Hello All,

    We agreed with customer to set a minimum time period for all Time Events to 15 minutes.
    We have more than 4300 EVNT objects.

    Would you please help me how to build SQL query to find all Time Events with interval less than 15 minutes.

    We've tried this but it doesnt show the needed information

     

    select oh_name,OEA_TimePeriod from oh,oea where OH_OType = 'EVNT' and OEA_EventType = 'TT' and OEA_TimePeriod < 0015 and OH_DeleteFlag = 0 and oh_client = 100

     




  • 2.  How to find all Time Event objects with period less than 15 min

    Posted Feb 27, 2018 04:35 AM
    try to  add "oh.OH_IDNR=oea.OEA_OH_IDNR"

    select oh_name,OEA_TimePeriod from oh,oea where OH_OType = 'EVNT' and OEA_EventType = 'TT' and OEA_TimePeriod < 0015 and OH_DeleteFlag = 0 and oh_client = 100 and oh.OH_IDNR=oea.OEA_OH_IDNR


  • 3.  How to find all Time Event objects with period less than 15 min
    Best Answer

    Posted Feb 27, 2018 04:40 AM
    There, fixed that for you :smile:

    select OH_NAME,OEA_TIMEPERIOD from OH join OEA on OEA.OEA_OH_IDNR=OH.OH_IDNR where OH_OType = 'EVNT' and OEA_EventType = 'TT' and OEA_TimePeriod < 15 and OH_DeleteFlag = 0 and oh_client = 100;

    Seems to work fine, at least for me (Oracle DB).

    Hth,
    Carsten


  • 4.  How to find all Time Event objects with period less than 15 min

    Posted Feb 27, 2018 04:47 AM
    Man, I need to be able to do something like "svn lock https://community.automic.com/discussion/11866", reddy.bharathkumar beat me to it.

    Kudos, good Sir  :)


  • 5.  How to find all Time Event objects with period less than 15 min

    Posted Feb 27, 2018 05:36 AM
    Hi Krum,

    I have tried with following statement (you can add OH_DeleteFlag and OH_Client) and it worked at least on MSSQL but also should work on Oracle in the same way:

    select OH_Name, OEA_EventType, OEA_TimePeriod from OH 
    inner join OEA on OEA_OH_Idnr = OH_IDNR

    where OH_OTYPE = 'EVNT'
    and OEA_EventType = 'TT'
    and OEA_TimePeriod <'0015'



  • 6.  How to find all Time Event objects with period less than 15 min

    Posted Feb 27, 2018 05:45 AM
    Thanks a lot!
    Its now working.

    We suspect that we are missing something small.

    Much appreciated!