Report usage from SSRS

There are times when it is useful to know which reports are being run, with designs in the reports are being used, and how frequently.

This information can be extracted from the report server database using the following SQL statement.

SELECT
  ex.UserName, 
  ex.Format, 
  ex.TimeStart, 
  cat.Name, 
  CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate
FROM
  ExecutionLog AS ex INNER JOIN
  Catalog AS cat ON (ex.ReportID = cat.ItemID)
ORDER BY 
  ex.TimeStart DESC