I am looking to make a crystal report that shows information on documents that are assigned a certain template. Does anyone know the best way to do this?
Sorry about that. You'll want to look at the all_events view and the pset_id, pset_name columns.
SELECT TOP 10 [event_id]
,[event_time]
,[event_type]
,[succeeded]
,[error_code]
,[session_id]
,[hostname]
,[appname]
,[trustee]
,[pset_id]
,[pset_name]
FROM [all_events]
WHERE event_type = 53
The Audit Trail database schema is documented. You'd need to look at Assign Template events.
I see where it stores the event "Assign template" in the SQL Database. However, I do not see where it says which template is assigned
What version of Audit Trail are you using? In looking at the database schema for Audit Trail 10, the [entry_events] view contains a column called [pset_name] so when you look for rows where the [event_type] column is 53 (i.e. Assign Template events) then the corresponding [pset_name] column values will tell you what template got assigned.
Sorry about that. You'll want to look at the all_events view and the pset_id, pset_name columns.
SELECT TOP 10 [event_id]
,[event_time]
,[event_type]
,[succeeded]
,[error_code]
,[session_id]
,[hostname]
,[appname]
,[trustee]
,[pset_id]
,[pset_name]
FROM [all_events]
WHERE event_type = 53