cancel
Showing results for 
Search instead for 
Did you mean: 

How to retrieve list of Reports?

former_member230417
Participant
0 Kudos

Hi All,

Can someone please help me retrieving list of reports that is scheduled to a particular email address.

For query builder it falls under a different property bag and hence I am not sure about how to retrieve it.

eg: Retrieve list of all WEBI Reports scheduled to abc@sap.com.

Thank you in Advance.

Regards,

Nachiket

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member198519
Active Contributor
0 Kudos

Try referring this SCN thread:

former_member185603
Active Contributor
0 Kudos

See the below link - macros

All Scheduler List

pavan_k11
Active Participant
0 Kudos

Hi Nachiket,

As you know its not possible using QB.

Either use the above query and retrieve SI_SCHEDULEINFO.SI_DESTINATIONS property in excel and filter manually or use Java SDK.

Following KBA can be used as a ref for retrieving the list.

http://service.sap.com/sap/support/notes/1960144

IProperties mailAddress = (IProperties)schedulingOptions.getProperties("SI_MAIL_ADDRESSES");

This property will give you the email ID. You can modify the code in this KBA to get desired results.

This KBA is for 3.1 but I think it should work for 4.x as well.

DayaJha
Active Contributor
0 Kudos

Hi Nachiket,

Please use below query query to get list of reports scheduled to Email.

To find out list of reports scheduled to Email:

SELECT TOP 10000 SI_SCHEDULEINFO.SI_DESTINATIONS, SI_NAME, SI_ID FROM CI_INFOOBJECTS WHERE SI_KIND IN ('CRYSTALREPORT','pdf','excel') AND SI_SCHEDULEINFO.SI_DESTINATIONS LIKE '%CRYSTALENTERPRISE.SMTP%' AND SI_INSTANCE = 1

You can use query builder to get the data or else use other tool, please refer below link for your reference.

InfoStore Query Builder (with export to Excel)

Hope this will help!!!!

Thanks,

Daya