How can i create a report that shows me the ticket count of all the active assignment groups.

[Graham Cameron]

We are currently running on Jakarta but moving to London in month and then Madrid by the end of the year.

But I have been asked to create a report to show the activity for all the Assignment groups we have. The plan is to decommission the assignment groups with no tickets that are not being used. But there doesnt seem to be a report that shows the ticket count of all assignment groups that don't have any tickets for all active assignment groups.

If there was a filter that says "tasks open" with variable being less than 1 against the assignment groups table that would be handy.

I heard people mention database views in the past but i dont know exactly how to do that. I know there are guides for database views. But i dont know how to use them to get to the data i need.

I have heard other people mention javascript. But again i dont know how you add this into a report to get to what i need.

Does anyone have any ideas here?

[Alberto Consonn]

Hi Graham,

you coudl try the solution provided below, it should work even if it looks quite complex:

https://community.servicenow.com/community?id=community_question&sys_id=8805cb2ddbd8dbc01dcaf3231f96...

If I have answered your question, please mark my response as correct and/or helpful so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Graham Cameron]

Hi Alberto

Thanks for commenting but that solution is to discover whether an assignment group has touched a ticket which although useful it is not what i am looking for.

My aim is to remove stale assignment groups. So i want to run a report which shows me Assignment groups without any tickets in them. Ideally those that havent had any tickets in them for a while but i understand that might need to be PA based. But i would just take being able to report on Assignment groups with not tickets assigned.

[Adam Stout · Accepted solution]

This report would give you all assignment groups that have not had any task assigned to them in the last 12 months.  This would miss a group that did have one but was reassigned leaving no tasks with it currently assigned to them.

[Graham Cameron]

Thanks Adam, i couldnt run this as a report because i couldnt located the related list conditions. I can however set this up as a filtered view which is what i have and it seems to be run ok. Thanks for your help.

If there is a way to run this as a report i am clearly missing something or its just because we are using an older instance. I am trying to run this on Jakarta before we move to London in a few weeks time.