2010-04-15

SSRS: What reports do I have uploaded?

/*
this refers to a linked server called myServer
if you don't have a linked server remove the text "myServer."
*/
SELECT CASE C_1.TYPE
WHEN 2 THEN 'Report'
WHEN 3 THEN 'Resource'
WHEN 4 THEN 'Linked Report'
WHEN 5 THEN 'Data Source'
ELSE 'unknown'
END AS TypeOfReport,
C_1.ItemID,
C_1.Path,
C_1.Name,
C_1.ParentID,
C_1.Type,
C_1.[Content],
C_1.Intermediate,
C_1.SnapshotDataID,
C_1.LinkSourceID,
C_1.Property,
C_1.Description,
C_1.Hidden,
C_1.CreatedByID,
C_1.CreationDate,
C_1.ModifiedByID,
C_1.ModifiedDate,
C_1.MimeType,
C_1.SnapshotLimit,
C_1.Parameter,
C_1.PolicyID,
C_1.PolicyRoot,
C_1.ExecutionFlag,
C_1.ExecutionTime,
R.ItemID AS Expr1,
R.Name AS Expr2,
R.id,
R.primary_rs_reports_id,
R.ManagerViewOnly,
R.HasDollars,
R.add_date
FROM myServer.ReportServer.dbo.Catalog AS C_1
LEFT OUTER JOIN admin_primary_rs_reports AS R
ON C_1.ItemID=R.ItemID
WHERE (C_1.Path LIKE '/%')

No comments:

Post a Comment