none
Query for ExecutionLogStorage for reports not used in the past 30 days RRS feed

  • Question

  • I wrote a similar question in the SSRS forum as well.  Maybe someone here might have some idea about this questions.

    I know there's a table calls 'ExecutionLogStorage' and it contains the historical data for the list of reports ran, by whom, the time it takes, and etc.  How do I write a query to find out how many reports did not get used or run the past 30 days?  Ours SSRS is integrated with SharePoint.

    Thanks.

    Wednesday, April 24, 2013 9:51 PM

Answers

  • Ok, I solved my own problem.  I should have researched this a bit more.

    select c.ItemID, c.Name, SUBSTRING(c.Path, (CHARINDEX('}',c.Path) + 1), 100) AS [Path]
    from catalog c (nolock)
    	left join ExecutionLogStorage e (nolock)
    	on c.ItemID = e.ReportID
    where c.ItemID not in
    	(select ReportID from ExecutionLog)

    Wednesday, April 24, 2013 10:05 PM

All replies

  • Ok, I solved my own problem.  I should have researched this a bit more.

    select c.ItemID, c.Name, SUBSTRING(c.Path, (CHARINDEX('}',c.Path) + 1), 100) AS [Path]
    from catalog c (nolock)
    	left join ExecutionLogStorage e (nolock)
    	on c.ItemID = e.ReportID
    where c.ItemID not in
    	(select ReportID from ExecutionLog)

    Wednesday, April 24, 2013 10:05 PM
  • Hi bonusmarch,

    Thanks for your sharing. Your post will help others have concern with these topics. Thanks for your effort again.


    Allen Li
    TechNet Community Support

    Friday, April 26, 2013 2:34 AM
    Moderator