SCRIPT: How to check SSRS reports with custom datasources?

 SELECT
    reports.name AS ReportName,
    Datasource.Name AS datasource
FROM dbo.Catalog reports
INNER JOIN dbo.DataSource ON DataSource.ItemID = reports.ItemID
WHERE reports.Type = 2
AND NOT EXISTS (SELECT * FROM dbo.Catalog datasources
                WHERE datasources.ItemID = DataSource.Link
                -- 5 is shared
                AND datasources.Type = 5
                );

Comments