Gruup change

[CarolaOtoni]

I need know how i can make a data visualization of the table Sys Audit, that i new know how many incident my group send to anotheres groups? I try if this table but is your data crash. 

[Hemanth M]

Hi @CarolaOtoni ,

Before you take the route of the sys_audit table, have you looked at the OOB metric definitions?

on the incident table > Assignment group? This tracks the duration of the incident in each group, but you can also make use of the assignment group change details.

Open this metric definition and look for Metrics for the actual data - you can report on this

Hope it helps!

[Hemanth M]

Hi @CarolaOtoni ,

If this response helped, please close the loop by accepting the solution or ask a follow-up question.

[Tanushree Maiti]

Hi @CarolaOtoni 

The Sys Audit table is very large and resource-intensive, so using it for this reporting requirement may not be the best approach.

Since the goal is to visualize how many incidents our group has transferred to other groups, ServiceNow provides the Incident Metrics (incident_metric) table  , which is more suitable for tracking incident assignment changes and generating reports.

Therefore, we should use the Incident Metrics table instead of querying the Sys Audit table, where possible, to improve reporting performance.