Report to capture assignment group change from group A to group B for requests and incidents

[NaBian]

I am working on report

1.the number of incidents and requests(RITM) that have been assigned from Assignment group: A to group B. 2. the number of incidents and requests (RITM) that have been assigned from Assignment group: B to any other Assignment group

[MackI]

hi @NaBian 

1. Utilizing Core Metric Definitions
ServiceNow has a core functionality, separate from the premium PA offering, designed to track continuous changes to fields:
• The Metric Definition plugin (com.glide.metrics) can be activated to define metrics to monitor within the system.
• With these defined metrics and the information available within the database, it is possible to generate reports that can be added to dashboards or automatically generated and distributed.
Your requirement to count assignments from Group A to Group B is essentially a metric that tracks the historical state change of the Assignment group field. This historical data is typically captured by configuring a Metric Definition on the task table (or the incident and sc_req_item tables) to record every time the Assignment Group value changes.
2. Standard Reporting for Historical Data
Once the platform captures the metrics regarding when the Assignment group field changed:
• You would report directly against the Metric Instance table (or related database views) where these changes are recorded.
• You would filter these records based on the original group and the new group.
For example, to meet Requirement 1 (A to B): You would query metric records related to the Assignment Group field where the Value changed from Group A to Group B.
For example, to meet Requirement 2 (B to any other group): You would query metric records where the Value changed from Group B and the New Value was not Group B (and not empty).

It would be much easier , if you have platform analytics subscription--let me know if you are successfully implement platform analytics for the instance.

Disclaimer: Please note that the information and advice provided above are based on my personal experience and are not official solutions or professional advice from DXC Technology. No patent code or solution from DXC Technology has been shared

If this response helped resolve your problem, please kindly mark it as the Best Answer ‌🌠‌. If it gave you some useful insight, a Helpful ‌⛑‌ mark would be wonderful too! Your feedback encourages me to contribute more to our amazing community.

[NaBian]

Hi, Mackl 

Thanks for looking into this one, how can I query to meet Requirement 1 (A to B): You would query metric records related to the Assignment Group field where the Value changed from Group A to Group B, as I can only filter value is group A.

I do have platform analytics enabled.

Na

[AndersBGS]

Hi @NaBian ,

For the reports that you're working on, metric definition would be the right approach. You can create a metric definition that looks at assignment group changes both for incidents and requests.