How to capture first Assignment Group in a report?

[Chris286]

Hello,

I currently have a business requirement to capture the first assignment group of any given # of tickets in a report. For example, I would need a report that shows all incidents where the first Assignment group was "Test AG" over the last week. I'm unsure of how to achieve this, any ideas?

[Community Alums · Accepted solution]

This isn't something that's easy to capture as part of reporting using out-of-the-box functionality. 

You'll want to add a new field to the table called u_first_assignment_group (or something similar) and then write a business rule to capture that data. 

This will only help you going forwards, and you won't be able to report on historic data.

[Chris286]

Hi Mike,

This is the approach we ended up pursuing, thanks for the help!

[Harika Bhupathi]

Hello @Chris 

Refer below links, which will help you

https://community.servicenow.com/community?id=community_question&sys_id=257906b8dbd11f882e247a9e0f96...

https://docs.servicenow.com/bundle/london-servicenow-platform/page/administer/assessments/task/t_Cre...

BR,

Harika

[Appli]

Hi, you may consider creating a script based Metric definition that will capture the first assignment group, than make a report to show these groups from the incident_metric table. Or, as it was already suggested, add your custom reference field to incident table and record there a first assignment group' sys_id with a help of business rule.

Hope it helps