CA Service Management

Expand all | Collapse all

How can I get the list of users and groups of Central Management Console

Jump to Best Answer
  • 1.  How can I get the list of users and groups of Central Management Console

    Posted 07-24-2017 05:51 PM

    Hello I hope you can help me I need to export or get a list of the users and groups created through CMC

     



  • 2.  Re: How can I get the list of users and groups of Central Management Console

    Posted 07-25-2017 08:16 AM

    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.

    Regards,

    Jon I.



  • 3.  Re: How can I get the list of users and groups of Central Management Console

    Posted 07-25-2017 08:57 AM

    Hello
    Thanks for answer I found the table that contains the users.
    Is the table correct?

     

     

    I can not find the table that contains the groups



  • 4.  Re: How can I get the list of users and groups of Central Management Console

    Broadcom Employee
    Posted 07-25-2017 10:25 AM


  • 5.  Re: How can I get the list of users and groups of Central Management Console
    Best Answer

    Broadcom Employee
    Posted 07-26-2017 02:47 PM

    Hey Alexis, 

     

    You can accomplish this by accessing the Query Builder on your CABI Server:

     

    http://localhost:port/AdminTools/querybuilder/query.jsp 

     

    -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'

     

    Regards,

    Brandon 



  • 6.  Re: How can I get the list of users and groups of Central Management Console

    Posted 08-01-2017 09:31 AM


    Hello
    thanks 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