Tag - Business Objects

How to Write BOXI Admin Reports using query builder

In this post i am giving you some information about business object’s admin reports. Buy using built tool query builder, you can generate very powerful admin reports. I have also mentioned another useful tool to kill sessions of user especially when you run out of licenses.

URL to use admin tool query builder : http://yourserver:8080/AdminTools/querybuilder/ie.jsp

Third part web apps to Kill user session and see list of users which are connect to BOXI server.

KillSession: http://yourserver:8080/KillSession/start.jsp

InfoStore is repository of Business objects. It stores all user names, privileges, universe information, categories, folder, sub folders, reports information etc.

1.     Query to know who is logged in to your Business Objects CMS InfoStore.

SELECT  *  FROM  CI_SystemObjects

WHERE

si_kind = ‘Connection’ AND

si_parent_folder = 41 AND

si_authen_method != ‘server-token’

ORDER BY

si_name

2.     Get All Webi reports

Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID=’CrystalEnterprise.Webi’ And SI_INSTANCE=0

3.     Get Full Client Reports

SELECT SI_ID, SI_NAME,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND in( ‘webi’ ,’FullClient’)

4.     Get All reports

Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID=’CrystalEnterprise.Report’ And SI_INSTANCE=0

5.     Get All universes

Select SI_ID, SI_NAME, SI_WEBI, SI_KIND From CI_APPOBJECTS where SI_KIND =’Universe’

6.     Get All Users

SELECT SI_ID, SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_PROGID=’CrystalEnterprise.USER’

7.     Get all groups

Select * from CI_SYSTEMOBJECTS Where SI_KIND=’UserGroup’

8.     Get all folders

Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID=’CrystalEnterprise.Folder’

9.     Get all categories

SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_KIND=’Category’

10.  Get All users for a specific group

select si_name from ci_systemobjects where children(“si_name = ‘usergroup-user'”, “si_name = ‘<group name>'”)

If you like this post please share it with others and visit few of my sponsors thanks very much!!

Read more...