I currently have about 500 reports with subscriptions going out to around
1500 email address's. Is there any way of managing these subscriptions so
that I don't have to go to every individual report to add or remove an email
address?Use distribution lists, that way you add and delete the users from a DL and
you have one place to go to do it.
"Brian Smith" wrote:
> I currently have about 500 reports with subscriptions going out to around
> 1500 email address's. Is there any way of managing these subscriptions so
> that I don't have to go to every individual report to add or remove an email
> address?sql
Showing posts with label email. Show all posts
Showing posts with label email. Show all posts
Friday, March 23, 2012
Wednesday, March 21, 2012
reporting services - subscription
Creating a subscription in Reporting Services/SQL Server 2K/ for the automated delivery of an email notification that report is updated.
In the subscription, there is an option:
Delivered by: Report Server E-Mail
that is in the "Report Delivery Options" section.
When this option is selected and the email generated, it comes from the email address of my predecessor former.person@.emailaddress.com, I need to change the address to my own but can't find where to change it. Can anyone point this out?i think its in the config file, i don't have my book with me at the moment
the config files are located on the server @. C:\program files\microsoft sql server\mssql\reporting services... there is 2 directories in there, one for each site (report server / report manager), check the config files and see where one of them specifies the smtp settings, you should be able to change the email addy in there and save it
since its a config file you prolly dont have to stop/start anything
In the subscription, there is an option:
Delivered by: Report Server E-Mail
that is in the "Report Delivery Options" section.
When this option is selected and the email generated, it comes from the email address of my predecessor former.person@.emailaddress.com, I need to change the address to my own but can't find where to change it. Can anyone point this out?i think its in the config file, i don't have my book with me at the moment
the config files are located on the server @. C:\program files\microsoft sql server\mssql\reporting services... there is 2 directories in there, one for each site (report server / report manager), check the config files and see where one of them specifies the smtp settings, you should be able to change the email addy in there and save it
since its a config file you prolly dont have to stop/start anything
Subscribe to:
Posts (Atom)