ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
API Gateway: Search for Administrators
Article ID: 212116
CA API Gateway
Is there a way to search for all users that have the Administrator role? Going to Tasks --> Users and Authentication --> Search Identity Provider doesn't show this information.
API Gateway: 9.4+
This information can be retrieved from the database:
SELECT a.name, c.name FROM internal_user a INNER JOIN rbac_assignment b ON hex(a.goid) = b.identity_id INNER JOIN rbac_role c ON hex(c.goid) = hex(b.role_goid) AND c.name = 'Administrator' ORDER BY a.name ASC;