select 
		els.UserName
	,isnull(c.Name,'[absent report]') [Name]
	,isnull(c.Path,'') [Path]
	,CASE(els.RequestType)
		WHEN 0 THEN 'Interactive'
		WHEN 1 THEN 'Subscription'
		WHEN 2 THEN 'Refresh Cache'
		ELSE 'Unknown'
	END AS RequestType
	,dateadd(hh,datediff(hh,'20100101',els.TimeStart),'20100101') [Minute]
	,els.TimeStart
	,els.TimeEnd
	, Case When datediff(ss,els.TimeStart,els.TimeEnd) >= 86400  
		     Then Convert(VarChar(5), datediff(ss,els.TimeStart,els.TimeEnd)/86400) + ' days '   
     Else '' End  
	     + Convert(VarChar(10), DateAdd(ss, datediff(ss,els.TimeStart,els.TimeEnd), 0), 108) [Duration]

	,els.TimeDataRetrieval
	,els.TimeProcessing
	,els.TimeRendering
	,els.ExecutionId
	,els.Status 
	,els.Format
	,CASE(els.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
	,case(els.Source)
		when 1 then 'Live'
		when 2 then 'Cache'
		when 3 then 'Snapshot'
		when 4 then 'History'
		when 5 then 'Ad-Hoc'  /*from Report Builder*/
		when 6 then 'Session' /*another request within existing session*/
		when 7 then ' RDCE' /*Report Definition Customization Extension*/
		end [Source]
	,els.Parameters
	,els.AdditionalInfo
from ExecutionLogStorage  els
left join Catalog c on els.ReportID=c.ItemID 

order by els.TimeStart asc