Trigger notification with multiple records to user

[Arun61]

We have a requirement like when knowledge articles are outdated then we have to trigger a notification every week to author and cmdb_ci owner. 

if ci owner have 3 outdated articles then need to trigger only one mail which includes all the articles number

example subject: - Below articles are outdated.

KB000001

KB000002

KB000003

How can i achieve this

[Saurabh Gupta]

Hi,
You can use the GlideAggregate API to perform this operation.

GlideAggregate | ServiceNow Developers

[Manisha Reddy K]

Hi @Arun61 ,

     Create a workflow with condition as workflow is outdated.

1) In the timer activity, add 7 days

2) In the script activity, please add the below code

3) From the event pass the KB Numbers in an array and print the KB numbers through mail script in the email notification body.

Please mark this as helpful if it is