Post reply

SSRS Data-Driven Subscription - How to implement audit/logging

  • June 28, 2016 at 7:39 pm

    #308742

    Hi,

    I am currently implementing a number of SSRS reports (using 2014 version) with data-driven subscriptions.

    There is a requirement to store information of which email addresses the reports get sent to every time the job runs, along with the parameters used.

    I tried to research this on the net but could not find anything on this - surely I will not be first person to have this problem!

    While I can get some useful info, e.g. execution start and end time, parameters, etc. from ReportServer.dbo.ExecutionLog2 view, I can't find anywhere in the DB which store the email addresses' metadata.

    Can anyone think of a way I can get this info and fulfill the requirement?

    Thanks in advance.

  • June 28, 2016 at 9:27 pm

    #1887489

    I'm NOT an SSRS expert, and I wanted to read up on this because I was curious.... That said, I found some articles that you might find interesting/helpful:

    SQLChick on Querying the Execution Log

    How to Audit Report Execution in SSRS

    MS on Execution Log

Viewing 2 posts - 1 through 1 (of 1 total)

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