Reports Usage in SSRS

We are using SSRS for all of our reports and we have a dedicated SQL Server just for this purpose. We wanted to see how many reports are being used on a consistent manner so that we can fine tune those reports for performance. Sometime back Ron wrote a simple query that would do this trick. Just found it in my archives and thought of sharing it with you.

SELECT
c.[name],
COUNT(*)
FROM
dbo.ExecutionLog el inner join dbo.Catalog c on
el.reportid = c.itemid
WHERE
el.timestart between '20090901' and '20091231'
GROUP BY
c.[name]