Hello I hope you can help me I need to export or get a list of the users and groups created through CMC
You can accomplish this by accessing the Query Builder on your CABI Server:
-Use your Administrator credentials to log in here.
-Once logged in, enter the following query into the Query Text box at the top of the page to return a list of all Users and hit 'Submit Query':
SELECT SI_OWNER FROM CI_INFOOBJECTS WHERE SI_PARENTID=18
-Run the following query to get a list of all Groups:
SELECT SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USERGROUP'
I dont believe there is any type of export button there. You may be able to do it by writing a query against the CMS database.
HelloThanks for answer I found the table that contains the users.Is the table correct?
I can not find the table that contains the groups
Please see the following links that I think will solve your issue:
BusinessObjects Query builder queries | SAP Blogs
BusinessObjects Query builder queries – Part II | SAP Blogs
Query Builder - Business Intelligence (BusinessObjects) - SCN Wiki
How To Fetch User Group Details From SAP Business Intelligence/Objects 4.1/4.2 Servers. | SAP Blogs
How to get list of groups user belongs to
Hope this helps.
Hellothanks for your help
I want to share the final result that I received thanks to his advice
To obtain the list of users, the following query must be executed:
SELECT SI_ID, SI_NAME,SI_ENT_USERFULLNAME,SI_DESCRIPTION,SI_OBTYPE FROM CI_SYSTEMOBJECTS WHERE SI_OBTYPE = 19
The result is presented in blocks and not in rows
I leave the query to obtain the list of groups
SELECT SI_ID, SI_NAME,SI_ENT_USERFULLNAME,SI_DESCRIPTION,SI_OBTYPE FROM CI_SYSTEMOBJECTS WHERE SI_OBTYPE = 20
Retrieving data ...