How could I create a dynamic scheduled report with dynamic recipients?

Shant Cancik
Tera Contributor

To simplify what I'm asking, imagine a list of task records with different users set as the "Assigned to".

Now imagine a dynamic report that shows each user the subset of task records where they themselves are the "Assigned to". 

I need a way to have that report send each week to all users who are "Assigned to" users. Each user would be emailed a report that week showing them the tasks their assigned to.

Anyone have an idea on how I should go about this?

1 ACCEPTED SOLUTION

Josh Petrick
Kilo Sage

It's not a very simple solution, but you can use a scheduled job to update the recipients then trigger the scheduled report.  See the article below for a step-by-step walkthrough.

https://community.servicenow.com/community?id=community_article&sys_id=873319531b8b98508672ea89bd4bc...

View solution in original post

5 REPLIES 5

Ah, ok.

Just curious because you went and marked a reply as Correct when I don't think that would have actually worked for your request as that scenario was around sending a report to dynamic recipients...but the data was the same for all of them (a list of records from a table - unfiltered by any specific user, etc.).


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!