BusinessObjects Query builder queries – Part IV
Again this is the continuation of my previous blogs on Query builder.
Have listed few more interesting queries below
To list all the servers and their status with server category
SELECT SI_NAME, SI_SERVER_IS_ALIVE, SI_DISABLED, SI_SERVER_KIND,
SI_FRIENDLY_NAME, SI_EXPECTED_RUN_STATE FROM CI_SYSTEMOBJECTS
Below are the possible values for SI_EXPECTED_RUN_STATE object
-1 -> Server is currently in an invalid state due to a configuration error.
0 -> The expected state of the server is stopped.
1 -> The expected state of the server is running.
2 -> The expected state of the server is restarting.
3 -> The server is not being managed by the Server Intelligence Agent.
4 -> The expected state of the server is immediate shutdown.
To list all hosted services for each server
SELECT SI_ID, SI_NAME, SI_HOSTED_SERVICES FROM CI_SYSTEMOBJECTS WHERE SI_KIND=’SERVER’
To list all the metrics description
SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND=’MetricDescriptions’
To list all the program objects without their instances
SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’PROGRAM’ AND SI_INSTANCE=0
To list all the personal and corporate category details of the report
SELECT SI_ID, SI_NAME, SI_PERSONAL_CATEGORIES, SI_CORPORATE_CATEGORIES
FROM CI_INFOOBJECTS WHERE SI_KIND=’WEBI’ AND SI_NAME = <Name of the Report>
To list the Usergroups associated with a particular User
Select SI_ID, SI_NAME From CI_SYSTEMOBJECTS Where PARENTS(“SI_NAME=’UserGroup-User'”,”SI_NAME=’Administrator'”)
To list the Universes associated with a particular Data connection
Select SI_ID,SI_NAME,SI_KIND From CI_APPOBJECTS
The list of relationship objects and their relationship types are given below
Relationship Objects Relationship Types
Profile-Principal -> PARENT-CHILDREN
DataConnection-Universe -> CHILD-PARENT
Category-Document -> PARENT-CHILDREN
User-Inbox -> PARENT-CHILDREN
Webi-Universe -> PARENT-CHILDREN
User-Favorites -> PARENT-CHILDREN
UserGroup-User -> PARENT-CHILDREN
Universe(Core)-Universe -> CHILD-PARENTS
EnterpriseData-Flash -> CHILD-PARENTS
Universe-UserGroup -> PARENT-CHILDREN
CustomRole-Object -> CHILD-PARENTS
User-PersonalCategory -> PARENT-CHILDREN
Hope you find this Interesting. Thanks for reading.
Query Builder Blog series