ReportServer Forum

catalinhd

Member

Registered: 2021-04-16

Report Server Automation

Hello,

I have the next scenario: Every time i grant a user access to a report ( Browser, ReportPublisher etc.) i want him to receive an outlook email with the link of the specified report. Is this possible?
Thank you!

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Report Server Automation

Hi catalinhd,

you can use the following script datasource for fetching all reports and the users' corresponding rights on them: reportrights.groovy, available in the reportserver-samples: https://github.com/infofabrik/reportserver-samples

You can save results into some kind of cache. Further, you can periodically call this script datasource (by scheduling a caller script) and compare results with the cache. If it differs, you can save an email to the user with the link to the report. Here you see how to schedule a script periodically: https://reportserver.net/en/guides/scri … g-Scripts/

You may want to schedule the script once per day, e.g. every night.

Regards,
Eduardo

catalinhd

Member

Registered: 2021-04-16

Re: Report Server Automation

Thank you eduardo!