Need to fetch how many tasks assigned to particular user

[nikhitha24]

Hi Team,

Please help on the below query,

I want to fetch how many tasks are assigned to particular user ,with  the states are ready, WIP, Pending, using notification email script.

and the send the notification to user saying these are the tasks are assigned to you.

user needs to receive all the tasks updates in one email instead of single email of each task.

Please help me on this how we can achieve this notification.

Thank you,

Nikhitha

[Susan Britt]

Have you considered using the email digest functionality instead of a custom mail script?

https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/notification/concept...

[nikhitha24]

Hi @Susan Britt 

yes I have tried but its not working, emails are not triggering.

I created one notification and i am trying to test email digest notification.

I have checked the allow digest check box, in the notification preferences i have added email digest interval as one hour

But i didn't get any notification for this.

Please help me on this how we can achieve email digest notification.

Please refer the below screenshot

[Susan Britt]

I apologize, I wasn't thinking through the use case.  The email digests are per record (e.g., daily update on all comments for one particular case) and not all records on the table (e.g., all the tasks assigned to you that day). Maybe you can have a scheduled job or flow that runs each evening to query the task table for active records and sends reminder to them to complete all open tasks.  I would suggest thinking through the full requirements before architecting the solution.  For example, do you only want this for end users (i.e., not HR agents or itil users) and would want to direct them to Employee Center to-dos to complete?  Do you only want to send for active approvals or HR Tasks, remembering that the fulfillers (i.e., those working on RITM, Incidents, HR Cases) probably would not want another email if they are in SN daily? Do you only want to send if it's been open over 48 hours?

[Susan Britt]

I did find this article, which may help you - https://www.servicenow.com/community/developer-articles/digest-notifications/ta-p/2323169