API Gateway: Search for Administrators

Products

• CA API Gateway

Issue/Introduction

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.

Environment

API Gateway: 9.4+

Resolution

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;