2012年2月11日星期六

Basic SSRS Question

I am trying to get a count of all the reports that do not use shared
datasource. We are finding a bunch of reports that do not use shared
datasource we would like to get a list of all the reports that do not
use shared datsource.
Also we would like to get a list of all the reports that are set for
subscriptions. There are way too many reports that are on our server
it would be really hard to go in manually to find this information.
I have been quering the dbo.catalog table in the report server to
extract this information however I have had no luck. Are there any
dyanamic views that will givbe me that info? I am sure other have run
into this requirement as well and already figured it out.
Could one of you please help me or point me in the right direction?
ThanksOn Apr 30, 8:59=A0am, shub <shubt...@.gmail.com> wrote:
> I am trying to get a count of all the reports that do not use shared
> datasource. We are finding a bunch of reports that do not use shared
> datasource we would like to get a list of all the reports that do not
> use shared datsource.
> Also we would like to get a list of all the reports that are set for
> subscriptions. =A0There are way too many reports that are on our server
> it would be really hard to go in manually to find this information.
> I have been quering the dbo.catalog table in the report server to
> extract this information however I have had no luck. Are there any
> dyanamic views that will givbe me that info? I am sure other have run
> into this requirement as well and already figured it out.
> Could one of you please help me or point me in the right direction?
> Thanks
Not sure where to look for the datasource info as all of our reports
run from shared data sources i.e. all look the same in that regard.
For the subscription stuff, try this query against the reportserver
database on server you run SSRS on to get a list of all reports with
subscriptions.
SELECT DISTINCT c.name AS RptName, c.Description AS RptDescription,
c.path AS Path, sc.name AS SchedName,
su.Description AS SubsDescription
FROM dbo.Catalog c JOIN
dbo.ReportSchedule rs ON c.ItemID =3D rs.ReportID
JOIN
dbo.Schedule sc ON rs.ScheduleID =3D sc.ScheduleID
JOIN
dbo.Subscriptions su ON rs.SubscriptionID =3D
su.SubscriptionID|||On May 1, 3:30=A0pm, toolman <t...@.infocision.com> wrote:
> On Apr 30, 8:59=A0am, shub <shubt...@.gmail.com> wrote:
>
> > I am trying to get a count of all the reports that do not use shared
> > datasource. We are finding a bunch of reports that do not use shared
> > datasource we would like to get a list of all the reports that do not
> > use shared datsource.
> > Also we would like to get a list of all the reports that are set for
> > subscriptions. =A0There are way too many reports that are on our server
> > it would be really hard to go in manually to find this information.
> > I have been quering the dbo.catalog table in the report server to
> > extract this information however I have had no luck. Are there any
> > dyanamic views that will givbe me that info? I am sure other have run
> > into this requirement as well and already figured it out.
> > Could one of you please help me or point me in the right direction?
> > Thanks
> Not sure where to look for the datasource info as all of our reports
> run from shared data sources i.e. all look the same in that regard.
> For the subscription stuff, try this query against the reportserver
> database on server you run SSRS on to get a list of all reports with
> subscriptions.
> SELECT DISTINCT =A0c.name AS RptName, c.Description AS RptDescription,
> c.path AS Path, sc.name AS SchedName,
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 su.Description AS SubsDescript=ion
> FROM =A0 =A0 =A0 =A0 dbo.Catalog c JOIN
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 dbo.ReportSchedule rs ON c.Ite=mID =3D rs.ReportID
> JOIN
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 dbo.Schedule sc ON rs.Schedule=ID =3D sc.ScheduleID
> JOIN
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 dbo.Subscriptions su ON rs.Sub=scriptionID =3D
> su.SubscriptionID- Hide quoted text -
> - Show quoted text -
Thank you so much. This query certainly helps a lot. I will keep
poking around for the other solution to find all reports that do not
use shared datasource. Thanks again

没有评论:

发表评论