Post reply

ExecutionLogStorage Returns No Records - SSRS

  • April 17, 2021 at 2:00 pm

    #3872415

    Hello,

    I am trying query the log for SSRS. I queried ExecutionLog3 table but did not get any records.

    Logging is enabled and retention period is 60 days. The ExecutionLog3 / ExecutionLogStorage is expected to have the data logged into it.

    What could be the reason for it to return 0 records? Can it be a previledge issue?

    Regards,

    Rohit Chitre

  • April 18, 2021 at 2:10 pm

    #3872716

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • April 22, 2021 at 5:05 am

    This was removed by the editor as SPAM

  • April 23, 2021 at 2:44 pm

    #3874839

    Thank you. Where is your blog?

  • April 23, 2021 at 3:02 pm

    #3874843

    If you can select from the table it wouldn't be a privileges issue, as it doesn't use anything like dynamic data masking or anything to hide data.

    Unsure what is happening, but going to say are you sure your looking at the right ReportServer database for the URL your looking at?

    Open up the SSRS config and just confirm the servername where the RS database is located and ensure its the same one your connected too

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply