I want to extract list of reports that are already created in CA BOXI 3.3. Is there any command to do so? If no, how is it feasible to achieve this thing?
Thanks & Regards,
Balram Singh Deswal
A blog post from SAP Community has a good set of examples - here is a link to one of our posts from last year: handy CABI Query Builder example queries
Here's an example he lists to obtain a list of all reports and documents those are in public folders including Sub folders. (Excluding instances, personal documents and inbox documents)
SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND IN ('FullClient', 'Txt', 'Excel', 'Webi', 'Analysis', 'Pdf', 'Word', 'Rtf', 'CrystalReport', 'Agnostic') AND SI_RUNNABLE_OBJECT = 0 AND SI_INSTANCE_OBJECT = 0 AND SI_ANCESTOR = 23
Thanks a lot Raghu!
In addition to what Raghu had mentioned, the queries listed will not run in the SQL. Make sure you login to query builder and then run the query. For more information on how to login to query builder, you may refer the below URL:
Thanks a lot Naveen!