List of Reports Currently Running on Reporting Services
I'm looking for a SQL query to list all the running reports. ReportingServer.dbo.ExecutionLogStorage only seems to record it after it's finished. I could look at Master.dbo.SysProcesses, but then how can I tie that back to the ReprotingServer.dbo.Catalog to get the report name?

Thanks
List of Reports Currently Running on Reporting Services
===

I'm looking for a SQL query to list all the running reports. ReportingServer.dbo.ExecutionLogStorage only seems to record it after it's finished. I could look at Master.dbo.SysProcesses, but then how can I tie that back to the ReprotingServer.dbo.Catalog to get the report name?

Thanks