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.
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
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?
What I am hoping to generate is a list of event objects which are file watchers. Information has been requested by customer.
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
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:
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.
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
Thanks, of course now they want "running" events....
Thank you all. You've given me enough to bring a smile to my customer.
Retrieving data ...