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.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark