Skip to Content
avatar image
Former Member

BI 4.2 how to get email (SI_MAIL_ADDRESSES) from SI_DESTINATIONS with Query Builder?

BI 4.2 how to get email (SI_MAIL_ADDRESSES) from SI_DESTINATIONS with Query Builder? I need list of all distanations email of all reports. Thxs.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 04, 2017 at 07:48 PM

    This query might help you:

    select si_scheduleinfo.si_destinations from ci_infoobjects where si_instance = 1 and "si_scheduleinfo.si_destinations.1.si_progid" = 'CrystalEnterprise.Smtp'

    It will return the si_destinations bag from all instances that have an email destination. You'll have to do a little parsing of the result, but the email addresses will be in there.

    Add comment
    10|10000 characters needed characters exceeded

    • The above will list all scheduled WebI reports set to distribute to email. To restrict it to specific addresses:

      select from ci_infoobjects where si_scheduleinfo.si_destinations like '%xxx%' and si_instance = 1

      Where "xxx" is the address.

  • Oct 04, 2017 at 04:08 PM

    You may not be able to fetch this data from Query Builder since it cannot handle nested queries. You can take references from KBA 1530079 - How to retrieve destination e-mail id of a scheduled report? - this would help you to fetch the list of email recipients using sdk.

    Add comment
    10|10000 characters needed characters exceeded