Query for Query Builder

For User Details
select Top 20000 SI_KIND , SI_ID,SI_NAME, SI_LASTLOGONTIME, SI_PASSWORDEXPIRE,SI_FORCE_PASSWORD_CHANGE, SI_CREATION_TIME FROM CI_SYSTEMOBJECTS Where SI_KIND='User'

For Group Details
select Top 1000 SI_KIND ,SI_ID, SI_NAME,SI_OWNER,SI_DESCRIPTION FROM CI_SYSTEMOBJECTS Where SI_KIND='UserGroup'

User and groups Realationship
select top 10 SI_KIND ,SI_ID, SI_GROUP_MEMBERS FROM CI_SYSTEMOBJECTS Where SI_KIND='UserGroup' and SI_NAME='" & GroupName & "'"

Universe Deatils
SELECT TOP 2000 SI_ID, SI_NAME, SI_PARENT_FOLDER, SI_DATACONNECTION,SI_PARENT_CUID FROM CI_APPOBJECTS WHERE SI_KIND='Universe' ORDER BY SI_NAME

Report Deatils
Select Top 50000 SI_ID, SI_NAME,SI_KIND,SI_OWNER,SI_UNIVERSE,SI_PARENT_FOLDER,SI_CUID From CI_INFOOBJECTS Where SI_KIND in( 'FullClient') And SI_INSTANCE=0

SELECT TOP 100000 SI_ID, SI_NAME,SI_KIND,SI_OWNER,SI_UNIVERSE,SI_PARENT_FOLDER,SI_CUID FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='Webi-Universe'","SI_NAME='Univer Name'") AND SI_INSTANCE=0 ORDER BY SI_NAME

SELECT TOP 100000 SI_ID, SI_NAME,SI_KIND,SI_OWNER,SI_UNIVERSE,SI_PARENT_FOLDER,SI_CUID FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='Webi-Universe'","SI_NAME is null ") AND SI_INSTANCE=0 ORDER BY SI_NAME

Universe folder structure details
SELECT TOP 100000 SI_ID, SI_NAME, SI_PATH,SI_PARENTID FROM CI_APPOBJECTS WHERE SI_KIND='Folder' ORDER BY SI_NAME

Report Folder Structure details
SELECT TOP 100000 SI_ID, SI_NAME, SI_PATH, SI_KIND,SI_PARENTID FROM CI_INFOOBJECTS WHERE (SI_KIND='Folder') ORDER BY SI_NAME

SELECT TOP 100000
SI_ID, SI_NAME, SI_PATH, SI_KIND,SI_PARENTID FROM CI_INFOOBJECTS WHERE (SI_KIND='FavoritesFolder') OR (SI_KIND='Inbox') ORDER BY SI_NAME

Server Session Details
SELECT SI_ID, SI_NAME, SI_CREATION_TIME, SI_LOGON_ALIAS, SI_UPDATE_TS, SI_LAST_ACCESS, SI_LASTLOGONTIME, SI_AUTHEN_METHOD FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'Connection' AND SI_FAILOVER_AVAILABLE_UNTIL = NULL AND SI_AUTHEN_METHOD != 'server-token'

Server Details and status
select top 20 SI_ID,SI_FRIENDLY_NAME, SI_CUID, SI_SERVER_IS_ALIVE, SI_SERVER_NAME, SI_METRICS,SI_SERVER_KIND   from CI_SYSTEMOBJECTS where SI_KIND='Server' and SI_SERVER_KIND in ( 'aps','webiserver') order by SI_SERVER_KIND, SI_SERVER_NAME