How to find Folder names containing reports in SAP BO in Personal Folders

[Former Member]

Hi,

I am looking for a way to build a query to find out the folder names that have a report under them in the Personal Folder section. There a near to 1000 folders created under Personal Folders manually opening one by one takes for ever to identify if they have a report created under them. Kindly help with any possible way to get this done quick.

[denis_konovalov]

I have fixed your tags. Please select more careful next time.

[former_member398039]

Hi Ashwin,

This would be better fit under another tag (maybe SDK), but to get you started. You can use Query Builder (http://<tomcat>:8080/AdminTools) and you will probably need two queries to accomplish this.

1. Find out the Folder ID where the objects are:

SELECT SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_INSTANCE=0 AND SI_NAME = 'MyReportName'

2. Using the unique IDs from the above query, find out the names of those Folders:

SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID IN (ID1, ID2, ID3...)

Hope that helps.
James