Skip to Content
0

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

Oct 04, 2017 at 08:03 AM

289

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joe Peters Oct 04, 2017 at 07:48 PM
1

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.

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for answer! I had got information from

SI_DESTINATIONS field but I cannot directly access to

SI_MAIL_ADDRESSES field.

This example does not work: SELECT SI_DESTINATIONS.SI_DEST_SCHEDULEOPTIONS.SI_MAIL_ADDRESSES FROM CI_INFOOBJECTS WERE SI_RECURRING = 1

If I right understand I must use SDK to retrieve destination e-mail.

0

No, you can't directly SELECT a subproperty of a property bag.

0
Former Member

HI Joe-

Could you please provide the exact query to find the Webi report schedule destination address in query builder.

I have used below query but it is not working.

Query:

SELECT SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_DESTINATIONS FROM CI_INFOOBJECTS WHERE SI_RUNNABLE_OBJECT = 1

Thanks

Mahendra Reddy

0

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.

0
Kamiya Vishwakarma Oct 04, 2017 at 04:08 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded