Is there some way to find out which reports in CRM are actually being used?

All replies

• 

  

  0

  Sign in to vote

  You can use the below query.

  You get all this information from your ReportServer Database. There is view called "dbo.ExecutionLog2" which will give you all report execution history.

  You can query dbo.ExecutionLog2 view with filtering your particular report with full report path. TO get only one record as per your requirements you can select TimeStart or TimeEnd in decending order. For your reference please have a look at following SQL Query.

  SELECTTOP (1) PERCENT 
  	ReportPath, 
  	TimeStart, 
  	TimeEnd, 
  	UserName, 
  	RequestType, 
  	Format, 
  	TimeDataRetrieval, 
  	TimeProcessing, 
  	TimeRendering, 
  	[Source]
  FROM         
  	dbo.ExecutionLog2
  WHERE     
  	(ReportPath = N'/Report Project1/Report1')
  ORDERBY 
  	TimeStart DESC
  Also please refer the below link
  http://www.mssqltips.com/sqlservertip/1306/how-to-know-what-reporting-services-reports-are-being-used/
    

  
  

  
  

  • Edited by Pramod Modavathodi Wednesday, April 2, 2014 10:12 PM
  • Proposed as answer by Pramod Modavathodi Wednesday, April 2, 2014 10:13 PM

  Wednesday, April 2, 2014 10:11 PM
• 

  

  0

  Sign in to vote

  Hi,

  Try running this SQL Script against your ReportServer Database, it should show you the required details.

  SELECT	a.UserName, a.Format, a.TimeStart, b.Name, b.Description, a.[Parameters], a.TimeStart
  FROM	ExecutionLog a INNER JOIN Catalog b ON a.ReportID = b.ItemID
  ORDER BY a.TimeStart DESC

  
  

  ---

  Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

  Wednesday, April 2, 2014 10:12 PM