How to email each assignment group only their own pending tasks weekly

[Adesh26]

Hi everyone,

I’m trying to implement a weekly automated emITSM forumail in ServiceNow with the following requirement:

Goal:

• Every Monday

• Each assignment group should receive only the tasks assigned to their group

• Groups should not see tasks from other groups
  
  Any Idea how to do this?
  
  Note : If I create a normal report using group by Assignment group it just creates a report which shows all the tasks grouped by assignment group

[nithinvarmK]

hi @Adesh26 

you can use a scheduled script that runs every monday and create reports seperately for each assignment group

[Roshnee Dash]

A standard “Group by Assignment Group” report will display all groups in one output, which doesn’t meet the requirement of showing only tasks for each individual group.

You can achieve this by using Scheduled Jobs, Event Registry, and Notifications.
Steps:

1. Create an Event (e.g., weekly.group.tasks)
2. Create a Notification linked to that event
3. Set up a Scheduled Script Execution to run every Monday
   • Navigate to: System Definition → Scheduled Script Executions
   • Configure it to run weekly on Monday at your preferred time
   • Write a script that gathers tasks for each group, builds an HTML table, and queues the event (using GlideRecord queries based on your logic)

If you need more help, feel free to ask!