Dear Folks,
Again this is the continuation of my previous blogs on Query builder.
BusinessObjects Query builder queries
BusinessObjects Query builder queries - Part II
BusinessObjects Query builder queries - Part III
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
WHERE SI_KIND='SERVER'
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>
Relationship queries
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
where CHILDREN("SI_NAME='DataConnection-Universe'","SI_NAME='efashion-webi'")
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
Basics
BusinessObjects Query builder - Basics
BusinessObjects Query builder – Best practices & Usability
Sample Queries
BusinessObjects Query builder queries
BusinessObjects Query builder queries - Part II
BusinessObjects Query builder queries - Part III
BusinessObjects Query builder queries - Part IV
BusinessObjects Query builder – Exploring Visualization Objects
BusinessObjects Query builder – Exploring Monitoring Objects
BusinessObjects Query builder - Exploring Lumira & Design studio Objects
Use cases
BusinessObjects Environment assessment using Query builder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |