question Report on Assignment Group Changes for particular group in ITSM forum

Report on Assignment Group Changes for particular group

Gary Larsen — Fri, 26 Aug 2022 20:16:42 GMT

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

Re: Report on Assignment Group Changes for particular group

Yousaf — Fri, 26 Aug 2022 20:23:47 GMT

Hi Gary,

Can you please share more details.

if Possible share your configuration as a screenshot perhaps.

Re: Report on Assignment Group Changes for particular group

AnirudhKumar — Fri, 26 Aug 2022 20:26:16 GMT

This should be possible with a filter on the report.

Re: Report on Assignment Group Changes for particular group

Yousaf — Fri, 26 Aug 2022 20:28:07 GMT

Something like this?

Re: Report on Assignment Group Changes for particular group

Arav — Sat, 27 Aug 2022 05:26:35 GMT

Hi,

Please try with the filter below on "incident_metric" and change the value set to your group name.

Thanks,

Arav

Re: Report on Assignment Group Changes for particular group

Gary Larsen — Mon, 29 Aug 2022 12:33:40 GMT

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

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

Re: Report on Assignment Group Changes for particular group

Arav — Tue, 30 Aug 2022 02:05:01 GMT

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

Re: Report on Assignment Group Changes for particular group

Gary Larsen — Tue, 30 Aug 2022 12:19:13 GMT

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

Re: Report on Assignment Group Changes for particular group

Uncle Rob — Tue, 30 Aug 2022 12:28:16 GMT

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.

Re: Report on Assignment Group Changes for particular group

Arav — Wed, 31 Aug 2022 02:25:24 GMT

@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