Search this insane blog:

Thursday, April 15, 2010

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 nrdev1.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