We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Want to show only Incidents Which are assigned to helpdesk and changes to other groups In Report

srikanthr066535
Tera Contributor

‎07-14-2025 03:09 AM

I am creating a Report on Incident table,If incident is assigned to Helpdesk and changed to other groups then i need only those records in the report

0 Helpfuls
  • 780 Views
5 REPLIES 5

Ratul Arora
Kilo Guru

‎07-14-2025 07:52 AM

hi @srikanthr066535 
You can achieve this by leveraging the Audit History (sys_audit) or Assignment Group history tracking.
OR 

Create a Database View joining incident with sys_audit on sys_id = documentkey, and filter where:

  • sys_audit.fieldname = assignment_group

  • sys_audit.oldvalue = Helpdesk

  • incident.assignment_group != Helpdesk



Regards,
Ratul A

0 Helpfuls