# Display Event Log

**URL:** <https://forum.inductiveautomation.com/t/display-event-log/6257>\
**Category:** Ignition\
**Created:** [April 17, 2013, 11:05pm UTC](https://forum.inductiveautomation.com/t/display-event-log/6257 "2013-04-17T23:05:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [April 17, 2013, 11:05pm UTC](https://forum.inductiveautomation.com/t/display-event-log/6257/1 "2013-04-17T23:05:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![CPowell](https://avatars.discourse-cdn.com/v4/letter/c/a183cd/32.png) [@CPowell](https://forum.inductiveautomation.com/u/CPowell)\
**Post date:** [April 18, 2013, 8:38pm UTC](https://forum.inductiveautomation.com/t/display-event-log/6257/2 "2013-04-18T20:38:46Z")

</div>

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.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/24f5572c2ba4dfdd4bb1d0f238927d8f72916f45.JPG)  

Or you can use SQL Query to get the information.  
(I did not change the default values.)

```auto
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

---

<div class="post-metadata">

**Author:** ![allenr8](https://avatars.discourse-cdn.com/v4/letter/a/e56c9b/32.png) [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\
**Post date:** [April 18, 2013, 10:49pm UTC](https://forum.inductiveautomation.com/t/display-event-log/6257/3 "2013-04-18T22:49:10Z")

</div>

That was pretty much what I was looking for! Thanks Chris.