Dashboard Report, how to show date incidents were moved to new assignment group?

[Fordham]

Basically Subject.

I am creating workcenter dashboards and our main communications hub that distributes incidents to different ques needs to be able to quickly see a list of incidents and the date they were last assigned a new assignment group.

Thanks for any help or ideas!

[M Iftikhar]

Hi @Fordha ,

The sys_audit table is a core ServiceNow table that records changes made to fields in other tables, but only for those tables and fields that have auditing enabled.

In the example below, I’ve filtered the Incident table audits to show changes to the assignment_group field along with the reassignment count. By taking the most recent entry (sys_created_on) for each Incident, you can identify the last time the assignment group was updated.

From there, you can configure a report or create a data source and use a list component on a portal page to display this information on a dashboard.

Thanks & Regards, 
Muhammad Iftikhar 

If my response helped, please mark it as the accepted solution so others can benefit as well.