SSRS Scripts

Find reports that are not mapped to a data source:

SELECT
ItemPath = c.[Path],
ItemName = c.Name,
DatasourceRefrenceName=ds.Name
FROM
[Catalog] AS c
INNER JOIN DataSource AS ds ON ds.ItemID = c.ItemID
WHERE
ds.Link IS NULL
AND ds.Extension IS NULL
order by ItemPath

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *