Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / August 2008

Tip: Looking for answers? Try searching our database.

Getting the list of recently viewed reports from report Server(Execution Log)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
archie_123 - 26 Aug 2008 07:49 GMT
Hi All,

I am new to SSRS and I need help.

I want the list of recently viewed reports. I have googled out and came to
know that we can use ExecutionLog table and query the required details.

I want to know how to create the ExecutionLog table and query the recently
viewed reports names.

Please suggest me.
cmayers - 28 Aug 2008 19:36 GMT
In Sql Server there is a database Report Server.  The Execution Log is a
table in that database.

SELECT      ExecutionLog.UserName, ExecutionLog.Parameters, Catalog.Name,
ExecutionLog.TimeStart, ExecutionLog.TimeEnd,
                     ExecutionLog.TimeDataRetrieval, ExecutionLog.Status
FROM         Catalog (nolock) INNER JOIN
                     ExecutionLog (nolock) ON Catalog.ItemID =
ExecutionLog.ReportID
where Executionlog.username <> 'NT AUTHORITY\SYSTEM' ORDER BY  
Executionlog.username, timestart desc

Gives me a list of by usersname and reports.  You can order by
executionlog.timestart to see the latest ones ran.

----
select  name, count(name) as NoTimes
FROM         Catalog (nolock) INNER JOIN
                     ExecutionLog (nolock) ON Catalog.ItemID =
ExecutionLog.ReportID
where Executionlog.username <> 'NT AUTHORITY\SYSTEM'
group by catalog.name
order by count(name) desc
lists reports ran and number of times ran.
Signature

cjm

> Hi All,
>
[quoted text clipped - 7 lines]
>
> Please suggest me.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.