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