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
  • 378 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