Report of Task handled by assignment group

Gabriel Macedo
Tera Contributor

Hi, I'm trying to find out if there is a way to extract the report that shows all assignment groups the ticket passed through?

I managed to do it with the "metric_instance" table but I would like the TASK information

Has anyone done this? can you help me?
Thanks.

6 REPLIES 6

shloke04
Kilo Patron

Hi,

Metrics is the best friend here in order to get the data you are looking for.

For example: OOB there is a metric on Incident table for Assignment Group field which you can refer and build your own for a different table if you need.

OOB Metric Link for Incident Table:

https://instance.service-now.com/nav_to.do?uri=metric_definition.do?sys_id=39d43745c0a808ae0062603b77018b90

Replace "instance' with your instance name. Attaching the screenshot as well for reference:

find_real_file.png

You can build a Report using this metrics and get the task Info as well:

Result: This gives you info about the ticket as well when you group it by ID.

find_real_file.png

find_real_file.png

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hi @shloke04, thanks for the quick reply.

But I need the movements of REQ/TASKs, in this report we only have Incidents.

Do you know how I get the REQ/TASK report?

Sure @Gabriel Macedo 

As mentioned earlier in my post above, Metric available for Assignment Group on Incident table was an example, you can do the same for any other table as well which has auditing switched on.

So in Order to do this for Catalog task you need to follow the below steps:

1) Navigate to the "Definition" module under Metric Application menu as shown below:

find_real_file.png

2) Configure the Form for Catalog task as shown below.

find_real_file.png

3) After this step you need to report as per steps mentioned above in my post.

Reporting remains the same and let me know if you are facing an issue here.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Tried But didn't get the proper output. Can you please show me step by step.