Mass Report off "Audit History" tab when the "Assigned to" has been updated by a certain user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Friday
Hello, I'm trying to create a report off the "Audit History" tab when the "Assigned to" has been updated by a certain user. I'm having an issue where Assigned to data keeps on swapping back and forth between users.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Saturday
Hey @StephanieH04070
This behavior is actually expected when you report directly from Audit History. Every time Assigned to is updated (by user or system), a new audit entry is created, so it can look like the value is “swapping” back and forth.
Recommended Approach
Instead of relying on the Audit History tab, create a report on the sys_audit table.
Example filters:
Field name = assigned_to
Updated by = specific user
Table name = your table (e.g., Incident / RITM)
Suggested columns:
- Document (record)
- Old value
- New value
- Updated by
- Updated on
This will give you a cleaner and more accurate view of assignment changes made by that user.
*************************************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.
Regards
Vaishali Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
Hey @StephanieH04070
Hope you are doing well.
Did my previous reply answer your question?
If it was helpful, please mark it as correct ✓ and close the thread . This will help other readers find the solution more easily.
Thankyou & Regards
Vaishali Singh
Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb
