on 09-11-2014 12:17 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.