Sign in
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    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