Error message

Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in _menu_load_objects() (line 579 of /www/webvol38/16/9svvwb3gxs5tmhv/benzzon.se/public_html/includes/menu.inc).

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