CA Service Management

 View Only
  • 1.  How to extract list of reports in CA BOXI 3.3

    Posted Oct 09, 2015 12:26 AM

    Hi Team,

     

    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



  • 2.  Re: How to extract list of reports in CA BOXI 3.3
    Best Answer

    Broadcom Employee
    Posted Oct 09, 2015 07:29 AM

    Hi Balram,

     

    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


    _R



  • 3.  Re: How to extract list of reports in CA BOXI 3.3

    Posted Oct 12, 2015 06:57 AM

    Thanks a lot Raghu!



  • 4.  Re: How to extract list of reports in CA BOXI 3.3

    Posted Oct 13, 2015 02:42 AM

    Hi Balram,

     

    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:

     

    http://scn.sap.com/docs/DOC-42952

     

    Thanks,

    Naveen



  • 5.  Re: How to extract list of reports in CA BOXI 3.3

    Posted Oct 13, 2015 10:53 AM

    Thanks a lot Naveen!