BusinessObjects Enterprise 4.1 search for all reports emailed to a specific email address

[Former Member]

We're in the process of upgrading to 4.1 and are looking forward to using the auditing/metrics features.

The two features we're hoping to find are:

1. Searching all of BOE for any reports scheduled to be emailed to a specific email address

2. Set alerts for long running reports that exceed a given threshold of seconds to process

Any tips in that regard would be greatly appreciated.

Thank you.

[former_member191664 · Accepted solution]

"1. Searching all of BOE for any reports scheduled to be emailed to a specific email address"

You can run the following SQL query in the BO Query Builder

SELECT top 100000 SI_ID, SI_NAME, SI_KIND, SI_SCHEDULEINFO.SI_DESTINATIONS

FROM CI_INFOOBJECTS

WHERE SI_RUNNABLE_OBJECT = 1 AND SI_SCHEDULEINFO.SI_DESTINATIONS.SI_PROGID IN ('CrystalEnterprise.Smtp') You can then use Excel filter to locate any specific email addresses from the property of SI_SCHEDULEINFO.SI_DESTINATIONS.

Regards,

Jin-Chong

[Former Member · Accepted solution]

Jin-Chong,

Thank you. That helps tremendously. We're still on 3.1 and so these issues may be resolved once we are on 4.1 but I have these questions.

1. How do I export it to Excel?

2. Is there any way to store a Query for easy retrieval? from within CMC for example?

Thank you again for you help.

[former_member182521 · Accepted solution]

Use the utility from here. http://www.forumtopics.com/busobj/viewtopic.php?t=175779&sid=bc2441fe73f24215970b2f8a7e338d74

It will give all your subscribed email recepient in a separate column.

[former_member185603 · Accepted solution]

Check this link to export query results to excel. You cannot store the query for future retrieval in CMC.