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
Tera 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.