Extract emailaddress of Data Driven Subscription from reporting services database Tables

• kartick-465343

  SSC Enthusiast

  Points: 165

  More actions

  November 7, 2014 at 1:30 pm

  #294990

  Hi

  Scenario:

  One scheduled data driven subscription Email Deliver with TO, CC, ReportFormat, Subject, BodyText and other necessary Report parameters are coming from a Storeprocedure.

  Question:

  Is there anyway I can extract the above information from report server database? Extensionsettings in subscription table has the field name from stored procedure that i used but not the actual value populated during execution. I'm able to extract report parameters from execution table's Parameter column but not the TO,CC,Etc values.

  Any Help is appreciated.

  Thanks

• HD_JOHN

  SSC Rookie

  Points: 36

  More actions

  December 5, 2014 at 10:15 am

  #1763024

  Take a look at this. It may be what you are looking for.

  http://stackoverflow.com/questions/18960965/ssrs-subscriptions-how-to-view-all-report-recipients