Hi @rp@n
the difference between two views in addition to Sukrut Parab
ExecutionLog3 more clarfiy , so you will find in the view stutcure , ExecutionLog3 have muliple cases more than ExecutionLog2
ExecutionLog3
SELECT EL.InstanceName, COALESCE (C.Path, 'Unknown') AS ItemPath, EL.UserName, EL.ExecutionId, CASE (RequestType) WHEN 0 THEN 'Interactive' WHEN 1 THEN 'Subscription' WHEN 2 THEN 'Refresh Cache' ELSE 'Unknown' END AS RequestType, EL.Format,
EL.Parameters, CASE (ReportAction)
WHEN 1 THEN 'Render' WHEN 2 THEN 'BookmarkNavigation' WHEN 3 THEN 'DocumentMapNavigation' WHEN 4 THEN 'DrillThrough' WHEN 5 THEN 'FindString' WHEN 6 THEN 'GetDocumentMap' WHEN 7 THEN 'Toggle' WHEN 8 THEN 'Sort' WHEN 9 THEN 'Execute'
WHEN 10 THEN 'RenderEdit' ELSE 'Unknown' END AS ItemAction, EL.TimeStart, EL.TimeEnd, EL.TimeDataRetrieval, EL.TimeProcessing, EL.TimeRendering, CASE (Source)
WHEN 1 THEN 'Live' WHEN 2 THEN 'Cache' WHEN 3 THEN 'Snapshot' WHEN 4 THEN 'History' WHEN 5 THEN 'AdHoc' WHEN 6 THEN 'Session' WHEN 7 THEN 'Rdce' ELSE 'Unknown' END AS Source, EL.Status, EL.ByteCount, EL.[RowCount], EL.AdditionalInfo
FROM dbo.ExecutionLogStorage AS EL WITH (NOLOCK) LEFT OUTER JOIN
dbo.Catalog AS C WITH (NOLOCK) ON EL.ReportID = C.ItemID
ExecutionLog2
SELECT EL.InstanceName, COALESCE (C.Path, 'Unknown') AS ReportPath, EL.UserName, EL.ExecutionId, CASE (RequestType) WHEN 0 THEN 'Interactive' WHEN 1 THEN 'Subscription' ELSE 'Unknown' END AS RequestType, EL.Format, EL.Parameters, CASE (ReportAction)
WHEN 1 THEN 'Render' WHEN 2 THEN 'BookmarkNavigation' WHEN 3 THEN 'DocumentMapNavigation' WHEN 4 THEN 'DrillThrough' WHEN 5 THEN 'FindString' WHEN 6 THEN 'GetDocumentMap' WHEN 7 THEN 'Toggle' WHEN 8 THEN 'Sort' ELSE 'Unknown' END AS
ReportAction, EL.TimeStart, EL.TimeEnd, EL.TimeDataRetrieval, EL.TimeProcessing, EL.TimeRendering, CASE (Source)
WHEN 1 THEN 'Live' WHEN 2 THEN 'Cache' WHEN 3 THEN 'Snapshot' WHEN 4 THEN 'History' WHEN 5 THEN 'AdHoc' WHEN 6 THEN 'Session' WHEN 7 THEN 'Rdce' ELSE 'Unknown' END AS Source, EL.Status, EL.ByteCount, EL.[RowCount], EL.AdditionalInfo
FROM dbo.ExecutionLogStorage AS EL WITH (NOLOCK) LEFT OUTER JOIN
dbo.Catalog AS C WITH (NOLOCK) ON EL.ReportID = C.ItemID
