Automic Workload Automation

Expand all | Collapse all

Generating a list of file watch events

Jump to Best Answer
  • 1.  Generating a list of file watch events

    Posted 07-25-2018 01:30 PM

    I’ve been asked to generate a listing of all “file watch” events.  Is there an easy way to to this?  The search function does not show the different types. 

     

     

    Any help, thoughts are appreciated.

     

    Thanks



  • 2.  Re: Generating a list of file watch events

    Posted 07-25-2018 02:24 PM

    Just off the top of my head, applications can watch for files in at least three different ways;

     

    1) An EVENT type of job object (there are multiple types so you'd need a filter).

    2) As a workflow task precondition rule.

    3) Custom script logic.

     

    I suppose one could figure out how to search for each three types and combine the three result sets.  But not exactly trivial.  Some of these searches would have to be done with SQL directly against the UC4 database.

     

    Is this request worth the effort?  What will the information be used for?



  • 3.  Re: Generating a list of file watch events

    Posted 07-25-2018 02:52 PM

    What I am hoping to generate is a list of event objects which are file watchers.   Information has been requested by customer.



  • 4.  Re: Generating a list of file watch events

    Posted 07-26-2018 02:52 AM

    try the following filter for an activity window:

     

    Object Type = EVNT

    HOST = the name of the Agent or ("Windows" / "Unix")

     

    This may show you the result in the Activity Window you are looking for

     

    regards

     

    Thomas



  • 5.  Re: Generating a list of file watch events

    Posted 07-26-2018 03:48 AM

    Yo

     

    as a start you can use this (T-)SQL

     

    select OH_NAME, OEA_EventType,OEA_HostAttrType, OEA_EventSubType, OEA_EventSubType2, OEA_Path from OH, oea

    where oh_otype = 'evnt'

    and oh_client = 1

    and OH_DeleteFlag = 0

    and oh_idnr = oea_oh_idnr

     

    change client # to your needs

     

    column explanation here:

    https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE/latest/DB%20Schema/db/_structure/HTML/OEA.html 

     

    cheers, Wolfgang



  • 6.  Re: Generating a list of file watch events

    Posted 07-26-2018 02:06 PM

    Thanks, that worked for defined events.  Of course now my customer only cares about events which are active.  Our app teams are horrible at cleaning up obsolete objects.   Any chance you can help me with the join as described by Kreth02.  I'd really appreciate as I'm struggling with it and not really all that familiar with the UC4 db.  



  • 7.  Re: Generating a list of file watch events

    Posted 07-26-2018 06:42 AM

    Hi,

     

    Is your Customer looking for a list of File Events defined in your AE System/Client or is he/she looking for a list of running file events ?

     

    searching defined file events use the OH table as shown by Wolfgang.

    searching active events you would need to join the EH table with the OH table

     

    cheers

    Thomas



  • 8.  Re: Generating a list of file watch events

    Posted 07-26-2018 02:09 PM

    Thanks, of course now they want "running" events....



  • 9.  Re: Generating a list of file watch events
    Best Answer

    Posted 07-27-2018 04:00 AM

    Hi -- okay I guess in that case you can find the details for your customer in the EH table

     

    In the DB Schema you may use 

     

    EH_EventTypechar (2)CHAR (2 CHAR)char(2)trueEvnt: TT time event(timer), TS time event(time of execution) FS/FT filesystem, CN console, FA = filesystem automatic, RN = IA.RULE, ON = IA.COLLECTOR Call-Op: OOA_TYP: question, message or alarm

     

    as criteria

     

    Regards

    Thomas



  • 10.  Re: Generating a list of file watch events

    Posted 07-27-2018 02:09 PM

    Thank you all.  You've given me enough to bring a smile to my customer.