Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2024 07:00 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2024 12:55 AM
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.