Query Tidal for file events

[ddouglassd]

We have found a need to track file events. Is there a way of querying the Tidal database to get a list of all file events (output similar to what is produced by right-clicking and selecting 'Export' on 'File Events' under 'Definitions -> Events'. We are looking for something that can be either scripted or have a Tidal job produce an output file that can be parsed. I have not found a way of accessing File Events from the Command Line Program.

[Marc Clasby]

The following SQL query will give you the File Event names (You would need DB Read Access, you can have a runtime user or run yourself)

SELECT [trgmst_name]

FROM [Admiral].[dbo].[trgmst]

WHERE [trgmst_type]=4

There query is simple enough to get a quick list of names however if you want more details or it to look like the GUI you will need to make multiple joins to other tidal tables (for owner, agent, etc.)

If you want some help let me know

Marc