Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Reassigned report from one assignment group to another assignment group

Nanasaheb
Kilo Contributor

I have to create report for reassigned tickets from one group to another group.

as of now i get reports of only resolved tickets which is in that assignment group but i want to add those tickets which is reassigned from (my assignment group) assignment group to other group, anyone have any idea about it.

in short i want to make report for worked and reassigned count for specific assignment group.

 

Thank you in advance..

2 REPLIES 2

Thomas_Davis
Administrator
Administrator

Use the Metric Definitions and Instances.  Luckily Assignment Group already has a metric definition, so all you need to do is report on the metric instance table.  There should already be a database view that joins this with incidents.

There will be one record for each time an Incident was re-assigned and how long that group was assigned to the ticket.

In the Filter Navigator go to Metric > Definitions, then look for Assignment Group.  That is the metric that you want to use.

In a report, you will connect to the metric_instance table, and then filter on Definition = Assignment Group

Sure, will check it and  update you.

Thank You!!