I need a list of BO users that are available in the CMS Repository
The repository resides in an Oracle 10 G DB.
The Most popular responses i have got is a select from the table CI_SYSTEMOBJECTS.
This table is not in the CMS repository that i have.
I just have the following tables
CMS_INFOOBJECTS5
CMS_ALIASES5
CMS_IDNUMBERS5
CMS_VERSIONINFO
CMS_RELATIONS5
CMS_ROOTFRONTIER5
CMS_CCFRONTIER5
CMS_FRONTIER5
Can anyone please help me?
keven_pinto_bouser (BOB member since 2007-11-29)
You shouldn’t query CMS database tables directly, the InfoStore provides a safe way to query all the data in your CMS and BOXI comes with a simple web utility called Query Builder for you to process those queries.
Open the Querybuilder and issue the following :
Select SI_ID, SI_NAME from CI_SYSTEMOBJECTS where SI_PROGID = ‘CrystalEnterprise.User’
You can obviously select more fields if you need them and if you have more than 1000 users, you’ll need to add a TOP N after the Select.
Greg
www.zoom-software.com
Official BO Tech Partner
JGreg (BOB member since 2007-11-21)
You can use this tool to get all the user in your system.
https://bobj-board.org/t/97773
You can also update the user’s email address, full name from a file or from AD.
rs90144 (BOB member since 2006-04-18)
Hi,
If you have less than 1000 users you can use the security viewer.
Regards
Sebastien
Thanks for the reply
I have downloaded the aplication.
It has just a .rep and a CSV.
Do i need to deploy this file to the BO environment or is this a standalone application?
Can you provide some details around this?
keven_pinto_bouser (BOB member since 2007-11-29)
It is a stand alone application.
Open the report in DESKI and you will be able to do what you want… The csv is a sample file that get generated for input or output.
rs90144
rs90144 (BOB member since 2006-04-18)
Its a great App
I am completely new to SDK and am still struggling with getting connecting to the CMS.
I tried to view your Macro but no luck. 
keven_pinto_bouser (BOB member since 2007-11-29)
I don’t think you can view the code. It is locked… But you can easily connect to you CMS and query the user…
The connection parameter is same as any connection parameter for DESKI… The CMS name (Host/Server), bo Userid, bo Password
rs90144 (BOB member since 2006-04-18)