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

• all_vn

  SSC Veteran

  Points: 255

  More actions

  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.

• pietlinden

  SSC Guru

  Points: 63572

  More actions

  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