Schedule report with dynamic recipients

[Eli Guttman]

Hi,

I need to generate a scheduled report and send the report content to each assignee.

For example, let's say i have incidents that are pending X days, each incident have an assignee.

I would like to set a scheduled report that will send each assignee his pending incidents.

Is that something that can be done using scheduled report / other way?

Thank you,

Eli.

[Chuck Tomasi]

Hi Eli,

I understand what you are trying to do and the consultant in me has to ask "What's the underlying problem? What are you really trying to solve?" FWIW, Reports are inherently out of date the moment you generate them. Nobody looks at them the minute they are produced. A better case would be to have real-time information the screen. If you have assignees in the system, you need a way to alert them and get their attention. Mailing them a report isn't exactly the best way to do that. Create a report/gauge and place it on the dashboard and encourage them to use that for up to the minute information.

That being said, if you DO want to mail them, I'd use a notification since those parameters can be dealt with dynamically (using field values from the data), whereas reports are statically defined.

Email Notifications - ServiceNow Wiki

[Bradford Shelle]

I'd echo the same sentiments as ctomasi. If you can drive the users to the system, that's the best case scenario.

Now, I do understand that some groups and individuals can be rather....tough to push. Building out a notification is one method to dynamically get the report generated. Another method is to use a scheduled job to dynamically create scheduled reports that run as each individual user (and a second scheduled job to clean up the stale scheduled reports). Take a look at this thread here: Dynamic Criteria on Scheduled Report since it talks about that second option a bit more.

[Eli Guttman · Accepted solution]

Hi,

For the issue i described, i found and article with the correct answer:

https://community.servicenow.com/message/935669?et=watches.email.thread#935669