# Using Security - Audit Log Function on Table to filter Audit Log

**URL:** <https://forum.inductiveautomation.com/t/using-security-audit-log-function-on-table-to-filter-audit-log/33938>\
**Category:** Ignition\
**Created:** [April 15, 2020, 12:31am UTC](https://forum.inductiveautomation.com/t/using-security-audit-log-function-on-table-to-filter-audit-log/33938 "2020-04-15T00:31:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![franklepkowski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/franklepkowski/32/4808_2.png) [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\
**Post date:** [April 15, 2020, 12:31am UTC](https://forum.inductiveautomation.com/t/using-security-audit-log-function-on-table-to-filter-audit-log/33938/1 "2020-04-15T00:31:54Z")

</div>

Hello,

Looking for a little guidance on the following.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fe04fffaefdcda4d132741001c591d6fd756fcaf.png)

If I pass parameters for say Actor filter, what value would I need to set it to in order to return all actors vs a single actor.

Thanks,

Frank

---

<div class="post-metadata">

**Author:** ![franklepkowski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/franklepkowski/32/4808_2.png) [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\
**Post date:** [April 15, 2020, 1:08am UTC](https://forum.inductiveautomation.com/t/using-security-audit-log-function-on-table-to-filter-audit-log/33938/2 "2020-04-15T01:08:51Z")

</div>

I think through some testing I have arrived at one solution. As long as the parameter values are blank it returns everything. Unless there is a better way to do this I will stick with it.

---

<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:** [April 15, 2020, 3:51pm UTC](https://forum.inductiveautomation.com/t/using-security-audit-log-function-on-table-to-filter-audit-log/33938/3 "2020-04-15T15:51:37Z")

</div>

Leaving blank is fine, or you can use a SQL wildcard - `%`; ultimately, the actor filter you provide makes its way into a SQL `LIKE` clause in the query given to the database:  
[https://www.w3schools.com/sql/sql\_like.asp](https://www.w3schools.com/sql/sql_like.asp)