Easier SSRS log querying

I’m working on setting up a scale-out SSRS installation.  We’ll be shutting down the old URL soon and everyone should be off it.  I can tell who is still hitting the old URL, which leads to the old server by using this query.

We’re using the ExecutionLog2 view in the reportserver database. Much easier than joining tables together and trying to build paths to reports with a CTE.

More information on this view.

2 thoughts on “Easier SSRS log querying”

  1. Vinaigrette:Your problem is that you have an expectation of the post that was not my intent. You think I should do full justice to the alien & sedition act. That’s fine – but … uhm … that’s not what I wanted to write about. You write as though there’s some checklist that I ignored.So no, there’s nothing missing here.

Leave a Reply

Your email address will not be published. Required fields are marked *