• Here's a query cobbled together from various sources that gives you a fair bit of info including report execution duration. If you've used a shared schedule then the schedule name is useful in combination with the report name. If you have one-off schedule settings then it will get the ugly GUID name.

    select

    U.UserName AS SubscriptionOwner,

    cat.Path AS ReportPath,

    S.EventType AS SubscriptionType,

    S.DeliveryExtension AS DeliveryMethod,

    Sc.Name AS ScheduleName,

    Rs.ScheduleID

    ,cat.path

    ,cat.name

    ,CONVERT(nvarchar(10), min(ex.TimeStart), 103) as Earliest_run

    ,CONVERT(nvarchar(10), max(ex.TimeStart), 103) as Most_Recent_run

    ,sum(case when ex.Format = 'RPL' then 1 else 0 end) as OnScreen

    ,sum(case when ex.Format = 'EXCEL' then 1 else 0 end) as Excel

    ,sum(case when ex.Format = 'MHTML' then 1 else 0 end) as MHTML

    ,sum(case when ex.Format = 'PDF' then 1 else 0 end) as PDF

    ,sum(case when ex.Format = 'CSV' then 1 else 0 end) as CSV

    ,sum(case when ex.Format = 'HTML4.0' then 1 else 0 end) as HTML4

    ,sum(case when ex.Format = 'ATOM' then 1 else 0 end) as ATOM

    ,sum(case when ex.Format = 'IMAGE' then 1 else 0 end) as [IMAGE]

    ,sum(case when ex.Format = 'WORD' then 1 else 0 end) as WORD

    ,sum(case when ex.Format = 'XML' then 1 else 0 end) as [XML]

    ,sum(case when ex.Format NOT in

    ('EXCEL','MHTML','PDF','CSV','HTML4.0','RPL','ATOM','IMAGE','WORD','XML')

    then 1 else 0 end) as Other

    ,AVG(Datediff(ms,ex.timestart,ex.timeend)/1000.0) as execution_duration_seconds_average,

    Max(Datediff(ms,ex.timestart,ex.timeend)/1000.0)

    - Min(Datediff(ms,ex.timestart,ex.timeend)/1000.0) as execution_duration_seconds_variance

    ,AVG(ByteCount) as Bytes

    FROM ExecutionLog AS ex

    INNER JOIN Catalog AS cat ON ex.ReportID = cat.ItemID

    INNER JOIN Subscriptions S ONS.Report_OID = cat.ItemID

    INNER JOINUsers U ON S.OwnerID = U.UserID

    INNER JOIN ReportSchedule RS ONS.SubscriptionID = RS.SubscriptionID

    INNER JOIN Schedule Sc ON RS.ScheduleID = Sc.ScheduleID

    group by cat.path, cat.name, U.UserName,

    cat.Path,

    S.EventType,

    S.DeliveryExtension,

    Sc.Name,

    Rs.ScheduleID

    Order by sum(case when ex.Format = 'RPL' then 1 else 0 end) desc;