BusinessObjects Board

count in CMC

security CMC
#1

how to find out the

Count the # of universes
Count the # of users in total
Count the # of Users per Universe

in CMC

Trooper (BOB member since 2007-06-25)

#2

Hi,

Impossible especially for the third question. You must query the CMS using sdk.

Regards

#3

can u tell me how to do that?

Trooper (BOB member since 2007-06-25)

#4

Hi,

This post can help you for the first question. Specific sdk for the last one.

Regards

#5

thanks but i have one more question i dont have the query builder so can i use the query designer for that.

Trooper (BOB member since 2007-06-25)

#6

Query Builder comes with XI. How can you not to have it?

To get the answer of #3 requires a combination of auditing data and the information from Query Builder.

substring :us: (BOB member since 2004-01-16)

#7

Just to clarify - Query Builder is on your ‘Admin launchpad’ page on the left hand side in the middle frame.

These 2 queries below may help, they will list the contents, but will also display a ‘N of M’ type number which you could be looking for.

Otherwise - I totally agree - use the Software Development Kit, which is included with any BO license.

List universes
Select SI_NAME From CI_APPOBJECTS where SI_KIND =‘Universe’

List All Users
SELECT SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_PROGID=‘CrystalEnterprise.USER’

Orange :netherlands: (BOB member since 2006-09-18)