Report on Assignment Group Changes for particular group

[Gary Larsen]

I need a report on all incidents with Assignment Group Changes for a particular group I have made a report using Incident_metric but that gives me all incidents with any assignment group changes. I only need incidents that the one group was involved in 

hope that makes since 

[Gary Larsen]

Hello yes I already tried that and it gives me all of that teams incidents but doesn’t include other teams that had the incident. the only way I have found to do this involves preprocessing the results before creating the

here is an example of what I am looking for I am searching for incidents that my chinaRMB team has been involved in 

Here is the steps I have done to get what I need, but really need away of doing this in Servcenow

FYI all of our groups names begin with fg_sn

1. Filter on Value starts with fg_sn gives me a list of all indents with all assignment groups
2. 2 export to CVC
3. Import to DB browser for sqlite
4. Export results to excel
5. 

[Arav]

Hi @Gary Larsen , I thought your initial description stated you needed those incidents where the specific group in question was involved. Anyways, try modifying the filter in my suggestion above to "Value starts with fg_sn".

Thanks,

Arav

[Gary Larsen]

yes in my screen shot I am filtering on fg_sn but that gives me for all groups I just want the incidents for the group fg_sn_mosaic_chinarmb and all groups that had the incident before and after them. 

I would like to to do the SQL step in the second screen shot in the servicenow is that possible in servicenow reporting? the attached is my end goal for the report

[Uncle Rob · Accepted solution]

I'm not sure this is possible because it needs two sweeps.
You must first determine the incidents that were ever assigned to X.
Then you must find every other group that ever touched any of those tickets.

Best I could see you doing is a script that does the calculations and then just dumps the results somewhere.

[Arav]

@Gary Larsen in that case, you may have to do this in two steps as Robert indicated.

Generate the first report and export the list to an excel. Copy the incident numbers after removing duplicates.

Run another report on incident_metric with conditions "Number is one of <incident numbers from report 1 >" and "Definition is Assignment Group".

Thanks,

Arav