CDA: Find all users with Administrator rights

Products

• CA Continuous Delivery Automation - Automation Engine

Issue/Introduction

Is there a method to find all users within Automic Continuous Delivery Automation (CDA) that have 'Administrator' access?

Resolution

There is no out of the box method directly to generate in the UI, but for the purposes of listing all users and what users have admin access:

select * from member inner join usr on usr.id = member.id;

This will return the user information as well as 'isadmin' which will show if they are an administrator.