cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract the Count of Reports which are in Public Folders

Former Member
0 Kudos

Hi Experts,

   Here am using the Audit Univese provided by SAP. Am able to get the count here but am seeing all the reports which includes reports which were deleted some time ago. Kindly help us on this. might need to use filter to avoid this i have tried using the event type but didn' work.

Thank you.

Regards,

Maruthi

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185603
Active Contributor
0 Kudos


You need to get the count of the reports from query builder, not from audit.

Select count(si_id) from ci_infoobjects where si_instance=0 and si_ancestor=23

si_instance=0 will omit the report scheduled instances

si_ancestor=23 is for public folders.

Former Member
0 Kudos

Hi Jawahar,

  Thanks for the your reply. Am getting the complete count of Public Folders. But i would like to see as number of reports in each folder. i tweaked your query with si_name . But still it is not giving me the result what am looking for.. if possible could you help us over here..

Thank you.

Regards,

Maruthi

Former Member
0 Kudos

Hi Jawahar,

  Please find the below query to get the count of reports by using the query builder. this gives us the complete count of reports in Public Folders.

Select SI_ID, SI_NAME from CI_INFOOBJECTS where  SI_INSTANCE = 0 and SI_KIND='Folder' and SI_ANCESTOR=23


But from here i would like to get the count of each and every individual  folder.


Thank you.


Regards,

Maruthi