List all subscriptions and recipients

Hi all,
I'm hoping this is an easy question.
Currently we have a large number of reports running on SQL Reporting
Services. The majority of them have subscriptions setup but we don't have
any details. Additionally, some of them are using a distribution list e-mail
and some have each recipient manually entered.
I want to take this opportunity to move as many of them as possible over to
distribution lists.
I would like to get a list of all reports with the following information:
*name of the schedule subscription is using
*how it is sent (e-mail or file)
*if file, i need: file name, path, render format, credentials, overwrite
options, parameters
*if e-mail, i need: recipients, subject, file and/or link, render format,
parameters
*date of last successful send
What is the easiest way of getting this information?
Thanks in advance for any help!
NancyYou should explore "Reportserver database" because it stores everything there
e.g.
catalog has all the report listing and their details, users all user
details, subscription etc...
Amarnath
"Nancy R" wrote:
> Hi all,
> I'm hoping this is an easy question.
> Currently we have a large number of reports running on SQL Reporting
> Services. The majority of them have subscriptions setup but we don't have
> any details. Additionally, some of them are using a distribution list e-mail
> and some have each recipient manually entered.
> I want to take this opportunity to move as many of them as possible over to
> distribution lists.
> I would like to get a list of all reports with the following information:
> *name of the schedule subscription is using
> *how it is sent (e-mail or file)
> *if file, i need: file name, path, render format, credentials, overwrite
> options, parameters
> *if e-mail, i need: recipients, subject, file and/or link, render format,
> parameters
> *date of last successful send
> What is the easiest way of getting this information?
> Thanks in advance for any help!
> Nancy|||Hi Amarnath,
I'm sorry I'm just responding now, we've had some pressing things come up
over the last few months and this got pushed to the back burner.
Where is the reportserver database? How do I access it?
I generally only deal with the "front end" administration, I haven't done
any of it on the back end.
Thanks,
Nancy
"Amarnath" wrote:
> You should explore "Reportserver database" because it stores everything there
> e.g.
> catalog has all the report listing and their details, users all user
> details, subscription etc...
> Amarnath
> "Nancy R" wrote:
> > Hi all,
> >
> > I'm hoping this is an easy question.
> >
> > Currently we have a large number of reports running on SQL Reporting
> > Services. The majority of them have subscriptions setup but we don't have
> > any details. Additionally, some of them are using a distribution list e-mail
> > and some have each recipient manually entered.
> >
> > I want to take this opportunity to move as many of them as possible over to
> > distribution lists.
> >
> > I would like to get a list of all reports with the following information:
> >
> > *name of the schedule subscription is using
> > *how it is sent (e-mail or file)
> > *if file, i need: file name, path, render format, credentials, overwrite
> > options, parameters
> > *if e-mail, i need: recipients, subject, file and/or link, render format,
> > parameters
> > *date of last successful send
> >
> > What is the easiest way of getting this information?
> >
> > Thanks in advance for any help!
> >
> > Nancy