send an email to the inactive users' manager along with link to ritms assigned to this inactive user

[IndiraP]

I got a requirement to 

1. Create a report for Open RITM’s that are currently assigned to inactive users.

2. Automate the report on a monthly basis

3. Determine who and how we notify of existing Open RITM’s to be cleaned up.

   1. Contact the inactive users' manager (email notification from SNOW)

   2. Content: You have an inactive team member that is assigned one or more active tickets that need to be reassigned.

      1. [List of ticket numbers]

I created a report, scheduled job, event and notification: but the email that is sending out for each ritm to each manager.

Can anyone help me here: I want to send only one email to managers with list of ritms with each inactive user. 

[Dr Atul G- LNG]

Hi @IndiraP 

create a report on Sc_req_item

set a condition like this

and then schedule the report to the manager 

OR

USE flow designer

Trigger: Daily

Action:

Look up records - Sc_req_item

condition: assigned to. active = false

For each record\Action\Send notification

RITM.assigenment group.manager