sqlbelle.wordpress.com
Retrieve SSRS Report Definition, Role Assignments, Executions Using T-SQL
Just a few queries against the ReportServer database that might come in handy… Of course, these are just some sample queries. Tune and modify according to your needs …