Mass Report off "Audit History" tab when the "Assigned to" has been updated by a certain user

StephanieH04070
Kilo Contributor

4 weeks ago

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. 

0 Helpfuls
  • 388 Views
2 REPLIES 2

vaishali231
Kilo Sage

4 weeks ago

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












0 Helpfuls

vaishali231
Kilo Sage
In response to vaishali231

3 weeks ago

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



0 Helpfuls