Metrics on Specific Assignment group changes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2023 09:28 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2023 10:06 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 12:40 AM
Hi @Deep_D ,
If you ensure you have the metric definition as below:
And afterwards create the reports as below on the incident_metric table:
As you can see from the sys_history, this match when incident was assigned to the chosen assignment group:
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 02:30 AM
Hi @Deep_D ,
Hope you are doing great.
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 :
navigate to the Metrics module & create a new metric.
Provide a suitable name for the metric
In the metric configuration, select the appropriate table where the assignment group field resides. Typically, table related to your specific IT asset management process.
Set the "Breakdown" field to "Assignment Group" to ensure the metric is focused on the assignment group field.
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.
Regards,
Riya Verma