What is the best way to show the event log in a readable form in a daily report? I have users that want to see what tags were written to and by whom. Is there a way to do this?
Thanks
What is the best way to show the event log in a readable form in a daily report? I have users that want to see what tags were written to and by whom. Is there a way to do this?
Thanks
Not sure what daily report you are using, but creating a table / dataset is fairly easy.
Then you could use that dataset in the Reporting Module to make the report.
Create a Custom Property with the type Dataset.
Then select Functions as the Property Binding.
Select the security → audit log and profile name, etc…
The nice part about this way is you can set the filters to text fields / dropdown menus with ease.
Or you can use SQL Query to get the information.
(I did not change the default values.)
SELECT EVENT_TIMESTAMP,
ACTOR,
ACTION,
ACTION_TARGET,
ACTION_VALUE,
ACTOR_HOST,
ORIGINATING_CONTEXT
FROM
AUDIT_EVENTS
WHERE
event_timestamp >= '{Root Container.Options.StartDate.date}' AND
event_timestamp <= '{Root Container.Options.EndDate.date}'
ORDER BY
event_timestamp DESC
Hope this helps.
Chris
That was pretty much what I was looking for! Thanks Chris.