Report Needed

[anthonyharp]

I’m new to ServiceNow and I’m looking for help on generating a report to identifying which assignment groups existed and are enabled, and comparing that to the assignment groups that are actively being used.

any help will be gladly appreciated. 

Anthony

[vaishali231]

hey @anthonyharp 

Step 1: Identify All Active Assignment Groups

Table: sys_user_group

Filter:
Active is true

You can create a simple List Report:

1. Navigate to Reports
   
2. Create New
   
3. Table: Group [sys_user_group]
   
4. Condition: Active is true
   
5. Add columns such as:
   
   
• Name
  
• Active
  
  
• Manager
  
• Type
  

This gives you all enabled Assignment Groups in the instance.

Step 2: Identify Assignment Groups Actively Used

Now identify which groups are actually referenced in task-based tables.

Common tables:

• Incident
  
• Problem
  
• Change
  
• Case
  
• Any custom table that extends Task
  

Example using Incident:

Table: incident

Create a report:

• Type: Bar
  
• Filter: Assignment group is not empty
  
• Group by: Assignment group
  
• Aggregation: Count
  

This shows which groups are being used and how many records are assigned to each.

If you want broader coverage, repeat this on the Task table itself. Since Incident, Problem, Change extend Task, this often gives a consolidated view.

*************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.

Doing so helps others in the community and encourages me to keep contributing.

Regards

Vaishali Singh

[vaishali231]

hey @anthonyharp 

Hope you are doing well.

Did my previous reply answer your question?

If it was helpful, please mark it as correct ✓ and close the thread . This will help other readers find the solution more easily.

Regards,
Vaishali Singh

[SohamTipnis]

Hi @anthonyharp,

You can achieve this by creating two reports in ServiceNow. First, create a report on the Group sys_user_group table filtered with Active = true to list all enabled assignment groups. Then create another report on the Task table grouped by Assignment Group to see which groups are actually being used in records. By comparing these two reports, you can easily identify assignment groups that exist but are not actively used.

You can use the below images:

If you find my answer useful, please mark it as Helpful and Correct. ‌‌‌‌‌😊

Regards,
Soham Tipnis
ServiceNow Developer ||  Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10

[Ankur Bawiskar]

@anthonyharp 

what's actual business requirement for this?