Display Event Log

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.