Friday, September 2, 2016

List all the data sources used in SCCM SSRS reporting

If we ever needed to find out about which data source been used for a particular report, then run below query in SQL management studio.
The report will provide all the reports and assigned datasource to them.
****************************************************************
SELECT Catalog.Name, Cat1.Name DataSource
FROM Catalog
JOIN DataSource on Catalog.ItemID = DataSource.ItemID
Join Catalog Cat1 on DataSource.Link = Cat1.ItemID
WHERE Catalog.Type = 2
****************************************************************

No comments:

Post a Comment