Retrieve list of users who have "System Administration" permissions

Products

• VMware Smart Assurance

Issue/Introduction

Retrieve list of users who have "System Administration" permissions in NCM

 

Environment

NCM - 10.1.x

Resolution

• Login to NCM Combination/Database server with root privileges.
• Switch to pgdba user with following command: 

  su - pgdba

• Login to postgres DB with below command: 

  psql voyencedb voyence

• When prompted for password, enter the Database password.
• After login to the Database, run 

  select user_name, permissions from cm_user u left join cm_acl_entry acl on acl.user_id=u.user_id where acl.permissions like '%system-admin%';

Example: 
=======================
voyencedb=# select user_name, permissions from cm_user u left join cm_acl_entry acl on acl.user_id=u.user_id where acl.permissions like '%system-admin%';
user_name |
                                             permissions
-----------+---------------------------------------------------------------------
sysadmin | \254\355\000\005sr\000\023java.util.ArrayListx\201\322\035\231\307a\235\003\000\001I\000\004sizexp\000\000\000\003w\004\000\000\000\003sr\0007com.powerup.configmgr.server.security.PermissionDetails\323:\224s\302\365\373\334\002\000\001L\000\012permissiont\000\022Ljava/lang/String;xpt\000\021principal-presentsq\000~\000\002t\000\024permissions-overridesq\000~\000\002t\000\014system-adminx


Test      | \254\355\000\005sr\000\023java.util.ArrayListx\201\322\035\231\307a\235\003\000\001I\000\004sizexp\000\000\000\002w\004\000\000\000\002sr\0007com.powerup.configmgr.server.security.PermissionDetails\323:\224s\302\365\373\334\002\000\001L\000\012permissiont\000\022Ljava/lang/String;xpt\000\014system-adminsq\000~\000\002t\000\021principal-resentx


(2 rows)
=======================

Here sysadmin and Test are the two users who have "System Administration" permissions in NCM.

The string "system-admin" in the encrypted "permissions" detail in above output indicates user has "System Administration" permissions.