How to Write BOXI Admin Reports using query builder
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>'")