I am migrating from SSRS 2005 to SSRS 2008. Is there a way that I can query the data from some of the tables in the ReportServer database (or elsewhere) to find out which reports in the Report Manager are linked to which reports? This query returns linked reports - SELECT Type, ItemID, Path, Name, ParentID, LinkSourceID, Description, ModifiedDate FROM Catalog WHERE (Type = 4) but how do I find the reports the linked reports are linked to? Are the ItemID, ParentID and LinkSourceID fields static or do they change whenever reports are run making this approach totally unusable? Thanks in advance.
@martinson, the ItemIDs etc are fixed and do not change over time. You can join your select back to the dbo.Catalog on LinkSourceID = ItemID to locate the report to which the current report is linked. Anyway, there is no official info from microsoft about the SSRS database schema and this schema can be changed without any notice. But the main schema was not changed from SQL2005 til 2008R2. **Edit:** The only officialy supported way of working with the SSRS is the Web Service SOAP API. Eg. For the Linked reports the reference is [here] and complete Web Service described [here]. :