SQL with Manoj

SELECT 
       Cat.[Name] AS ReportName, 
       Cat.[Path] AS ReportPath, 
       ELog.[Format] AS ReportFormat, 
       ELog.[UserName] AS RunBy, 
       ELog.[TimeStart] AS RunDateTime, 
       CONVERT(nvarchar(10), ELog.[TimeStart], 101) AS RunDate,  
       CASE(ELog.[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 [DataSource],
       CASE(ELog.[RequestType])
              WHEN 0 THEN 'Interactive'
              WHEN 1 THEN 'Subscription'
              WHEN 2 THEN 'Refresh Cache'
              ELSE 'Unknown'
       END AS RequestType,
       1 AS [NumRuns], 
       ELog.[TimeDataRetrieval],
       ELog.[TimeProcessing],
       ELog.[TimeRendering],
       ELog.[ByteCount],
       ELog.[RowCount]
FROM ELogecutionLog AS ELog 
INNER JOIN [Catalog] AS Cat ON ELog.ReportID = Cat.ItemID 
WHERE Cat.Type = 2
AND ELog.[TimeStart] >= '2016-08-01'
ORDER BY ELog.TimeStart DESC