Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Query Tidal for file events

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.

1 REPLY
New Member

Query Tidal for file events

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

335
Views
0
Helpful
1
Replies
CreatePlease to create content