Summary

BI Publisher, Location of Email Addresses for Recurring Reports (Under Destination Type = Email)

Content

Hello,

I need some help finding the BIP Table that email addresses are stored in for recurring reports. I have located the reports but cannot locate email addresses the reports will be delivered to.

I have close to 70 recurring scheduled reports that I need to send the business a spreadsheet of 1. Report Name. 2. Emails that the report will be distributed to.

Again... only need to know what table to add to find the Email Addresses that the reports will be delivered to. (See Attachment for Application Screenshot)

Thanks in advance.

Kevin

Select

      *

From

      xmlp_sched_job sj

Where

      sj.schedule_description != 'sched_single'

      And sj.status != 'P'

Order By

      sj.report_url