I need to replace all instances of 1 e-mail address with another, this address is subscribed to multiple reports, and many of those subscriptions are set up to be sent to lots of e-mail addresses so the description field in the subscription table is not returning the full list (the description field is truncated after 55 characters so I can only see the first couple of e-mail addresses that are subscribed).
Where in the ReportServer database can I find a list of e-mail addresses subscribed to a report?
I have had a look around and can't seem to find where the information in the "To:" and "Cc:" and "Bcc:" fields are stored?
Thanks,
Paul.
Thats in the Subscriptions table of the ReportDB. The attribute Extensions settings stores the values of the email addresses, you can simply use a replace command on this XML data.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment