Reporting

Jesse Rounds
Tera Contributor

Hello, I was asked to update an APM report to reflect the date when a user's ServiceNow account is set to "inactive/locked out". I have these columns appearing in the report: 
- Name
- Business Owner

- Business Owner.Locked out

- System Owner

- System Owner.Locked out

I've looked in the Columns and was unable to find one that specified the date in which the lock out occurred. I would appreciate any assistance. Thanks

1 REPLY 1

Mark Manders
Mega Patron

This is not logged on the record itself. To get this information on your report, create a date/time field on the table and have it filled on inactivation/locked out. It is bad practice to report on the sys_audit table for (huge) performance reasons, so to be able to report on that data, you will need to add it to the table.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark