SQL: Reporting Services

1 post / 0 new
benzzon
benzzon's picture
SQL: Reporting Services

-- Rapport statistik:

use ReportServer
GO

Select Catalog.Name, TimeStart, TimeEnd, DATEDIFF(minute,TimeStart,TimeEnd)
As Elapsed, TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount,
[RowCount], Status
From ExecutionLog Log
With (nolock)
Join (
    Select ItemID, Path, Name
    From Catalog) Catalog
On Log.ReportID = Catalog.ItemID
Order by DATEDIFF(minute,TimeStart,TimeEnd) DESC
GO