Metrics on Specific Assignment group changes

Deep_D
Tera Contributor

Hi All,

 

When the assignment group changes from ABC to any group, How can we create a metric for a specific assignment group 

for ex: The assignment group changes from ABC Group to any Group and add it in the report. I tried adding an assignment group to metrics but not sure how to add it using the specific assignment group name

 

Thank you

3 REPLIES 3

Prateek kumar
Mega Sage

Once you have the metrics created you can just add a filter of "ABC group" in your report correct


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

AndersBGS
Tera Patron
Tera Patron

Hi @Deep_D ,

 

If you ensure you have the metric definition as below:

 

AndersBGS_0-1687419085078.png

 

And afterwards create the reports as below on the incident_metric table:

AndersBGS_2-1687419547768.png

 

 

As you can see from the sys_history, this match when incident was assigned to the chosen assignment group:

AndersBGS_1-1687419511740.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Riya Verma
Kilo Sage
Kilo Sage

Hi @Deep_D ,

 

Hope you are doing great.

4 / 4

To create a metric that captures the specific assignment group when it changes from ABC Group to any other group in ServiceNow, we can follow the steps :

  1. navigate to the Metrics module & create a new metric.

  2. Provide a suitable name for the metric

  3. In the metric configuration, select the appropriate table where the assignment group field resides. Typically, table related to your specific IT asset management process.

  4. Set the "Breakdown" field to "Assignment Group" to ensure the metric is focused on the assignment group field.

  5. In the "Conditions" section, add a condition that specifies the previous assignment group value as "ABC Group" and the new assignment group value as any other group. This condition will identify instances where the assignment group has changed from ABC Group to a different group.

 

assignment_groupCHANGEdoesNotContainABC Group^assignment_group!=^

        

 

      6. Save the metric configuration, and it will be added to your metrics lis

      7. Now, you can generate reports based on this metric. Select the desired timeframe and other relevant parameters, and the report will display instances where the assignment group changed from ABC Group to another group.

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.
Regards,
Riya Verma