ReportServer - Can we know when a report was last accessed ?

Question

Post reply

ReportServer - Can we know when a report was last accessed ?

mw_sql_developer

SSCoach

Points: 19445
More actions
January 3, 2017 at 12:17 pm

#325027

Select top 100 * FROM Catalog
/* This table does not have the info I am looking for */

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 1

have a look at ExecutionLog3 in the ReportServer database:

https://msdn.microsoft.com/en-us/library/ms159110(v=sql.110).aspx

mw_sql_developer SSCoach Points: 19445 More actions · Answer 2

Cool

Our server is 2008. So the following worked

Use ReportServer

go

select TimeStart ts , * from ExecutionLog order by TimeStart DESC

select TimeStart ts , * from ExecutionLog2 order by TimeStart DESC

QUESTION: Why are there 2 tables ? ExecutionLog and ExecutionLog2

mw_sql_developer SSCoach Points: 19445 More actions · Answer 3

Chris:

How do we know that a report was run manually or via a schedule ? Will this be correct ?

Use ReportServer

go

select ReportPath , COUNT(*) as CNT

from ExecutionLog2 WHERE REQUESTTYPE NOT IN ('Subscription')

GROUP BY ReportPath

ORDER BY 2 desc

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

mw112009 (1/3/2017)
How do we know that a report was run manually or via a schedule ? Will this be correct ?

Yes the RequestType column values are {Interactive, Subscription}

There are multiple versions of this in views because they've added things in different versions of SQL Server but wanted to keep some backward compatibility.