# Audit log options

**URL:** <https://forum.inductiveautomation.com/t/audit-log-options/14411>\
**Category:** Ignition\
**Created:** [May 29, 2017, 10:11am UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411 "2017-05-29T10:11:24Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tom.wouters](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\
**Post date:** [May 29, 2017, 10:11am UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/1 "2017-05-29T10:11:24Z")

</div>

Hello,

I have configured my audit profile and everything works.

Now I want to add two things to my audit log;

I want te computer name added to the table. In the configuration settings at the advanced settings the host for the query is filled in “ACTOR\_HOST” but it doesn’t show up when I link the audit profile to the table. How do I add the computer name to this table?

A second thing I wanted to do is add a timeline so users can filter to specific times themselves. When you link the audit profile you have to fill in when it has to log. Is there a possibility so users can enter specific times themselves?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![tom.wouters](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\
**Post date:** [May 30, 2017, 9:14am UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/2 "2017-05-30T09:14:07Z")

</div>

Okay I found how to add a date to the audit log by putting a “date range” object on the screen and linking the dates in the options of the audit log.

Now I only need to find out how to get the PC name in the columns if anyone could help me with that it would be great!

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [May 30, 2017, 12:25pm UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/3 "2017-05-30T12:25:01Z")

</div>

I generally use a DB query to get this info. It does not appear to be exposed in the built in function.

```auto
SELECT * FROM audit_events

```

You can filter on the ACTOR\_HOST column in your query.

Just beware, HOSTNAME can be in-accurate depending on the network environment. Our company uses a lot of laptops and during roaming and DHCP there can be scenarios where hostname can be incorrect. I think Ignition does a better job than windows networking to report hostname, but I throw out the warning anyways. You don’t want to rely on the hostname to be 100% accurate.

---

<div class="post-metadata">

**Author:** ![tom.wouters](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\
**Post date:** [May 31, 2017, 7:15am UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/4 "2017-05-31T07:15:50Z")

</div>

Hello ryanjmclaughlin this works great. Except I need to manually be able to edit the dates. I have a “date range” on the screen with an SQL query I don’t think it’s possible to adjust the dates?

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [May 31, 2017, 11:51am UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/5 "2017-05-31T11:51:28Z")

</div>

Easy! Check out the Dynamic Filters section on this page of the docs for a dynamic date example in SQL

[https://docs.inductiveautomation.com:8443/display/DOC79/SQL+Query+Binding](https://docs.inductiveautomation.com:8443/display/DOC79/SQL+Query+Binding)

---

<div class="post-metadata">

**Author:** ![tom.wouters](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\
**Post date:** [May 31, 2017, 12:07pm UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/6 "2017-05-31T12:07:49Z")

</div>

Thank you ryanjmclaughlin this worked!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [January 6, 2022, 4:54pm UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411/7 "2022-01-06T16:54:11Z")

</div>

Split this topic on January 6, 2022, 4:54pm UTC

2 posts were split to a new topic: [Issues querying audit log](https://forum.inductiveautomation.com/t/issues-querying-audit-log/54734)
