Help Needed: Report for Last Month’s Incidents – First & Last Assignment Group Tracking

[SajidK]

Hi all,
I’m looking to generate a report in ServiceNow for incidents created last month that were initially assigned to the first assignment group and later resolved under the last assignment group.
Could anyone guide me on how to build this report or suggest the best approach to filter and extract this data?

Thanks in advance!

[AndersBGS]

Hi @SajidK ,

My initial thought would be that you should create a metric based on the incident metric definition "assignment group"... This should be available OOTB. 

[palanikumar]

Hi,

I suggest you to create a new field and populate this field with the first assignment group assigned to the ticket. Population of this field can be implemented using a Business Rule.

You can also use the option suggested by Andres, but for reports you may need to join tables if you want to display multiple fields in same report