A query for listing all Reports suinga speecific Shared Data Source
I can see teh lsit of dependent Reports linked to a specific Shared Data Source but how to query teh ReportServerDB to get the same.
When I used this query it is only ginvg a sub set of Reports...
Use
ReportServer
go
SELECT
count(Catalog.Name)
AS ReportName
--, DataSource.Name AS DataSourceName
FROM
[Catalog] INNER
JOIN DataSource
ON Catalog.ItemID
= DataSource.ItemID
where
datasource.name
=
'<a shared data source anme>'
SQLCHANTer
August 15th, 2012 5:52pm
--This list gives the Reports using the datasource named <Shared DS Name> as shared data source
Select
C
.Name
AS ReportName
from
catalog C
join datasource d
on
c.itemid
= d.itemid
where
d.link
=
'<link value for the <shared DS Name> a GUID number '
order
by 1
asc
SQLCHANTer
Free Windows Admin Tool Kit Click here and download it now
August 15th, 2012 7:06pm