Query to list all Shceduled reports in a folder

[Former Member]

Hello,

I am facing challenges in building a query using Query Builder to return scheduled reports in a folder.

I have a folder, say A which has sub folders in it. I would like to build a query to return all the scheduled reports belong to Folder A.

I could build a query but for that i had to get SI_ID of all the sub folders. Is thsi the only way i can do? I would like to use SI_ID of folder A only to get the required data. Can i do that? If yes. How can i do that?

Following is the query i could create:

Select SI_NAME,SI_SCHEDULEINFO.SI_STARTTIME,SI_SCHEDULEINFO.SI_ENDTIME from CI_INFOOBJECTS where SI_PARENTID IN (SI_IDs of all the sub folders) AND SI_KIND='CrsyatlReport'

Please suggest me on this.

Best Regards,

Sastry

[former_member182521 · Accepted solution]

Sastry,

Can we check with the query below.

To extract all the Scheduled report names from specific folder and Its Subfolders

SELECT SI_ID,SI_NAME,SI_PARENT_FOLDER,SI_FILES FROM CI_INFOOBJECTS
WHERE SI_KIND = 'WEBI' AND SI_INSTANCE = 0 AND SI_ANCESTOR = [SI_ID of FOLDER A]
AND SI_RECURRING = 1 AND SI_KIND='CrystalReport'

Please note SI_ANCESTOR is not an Indexed column as a result there will be a performance impact if your BO deployment is relatively big.

For more Query builder related query kindly refer

http://scn.sap.com/community/bi-platform/blog/2012/10/11/businessobjects-query-builder-queries
http://blogs.hexaware.com/business-objects-boogle/business-objects-query-builder/
http://blogs.hexaware.com/business-objects-boogle/business-objects-query-builder-part-ii/

Just give me a shout if you have any more issues.

Regards,
Mani

[Former Member · Accepted solution]

Hi Elumalai,

I wanted to extract list of scheduled report that are present into my system with all the details,

Extracted list should contain all the below field

Instance Name

Owner

Recurrance

Day and Time

Report Name

Destination

File Location/ Email

Email From

Email To

Email CC

Email Subject

Email Message

Specific Name

Folder Name

And i want all these details in a excel.

Can you please help me.

Thank you.

Prakash

[Former Member · Accepted solution]

Can any one tell me how can i put below Query into Visual basic.

select si_id, SI_NAME, si_owner, SI_PARENT_FOLDER, si_children, si_recurring, SI_PROCESSINFO.SI_FILES, SI_PROCESSINFO.SI_LOGON_INFO, SI_PROCESSINFO.SI_RECORD_FORMULA, SI_SCHEDULEINFO.SI_STARTTIME, SI_SCHEDULEINFO.SI_SUBMITTER, SI_SCHEDULEINFO.SI_DESTINATION, SI_SCHEDULEINFO.SI_UISTATUS from CI_INFOOBJECTS where  si_recurring=1 and SI_SCHEDULE_STATUS !=8

Thank you.