Need to Export a List of iDash Users with Admin Privileges

Products

• iDash Workload Automation

Issue/Introduction

How can I export a list of users defined in iDash that have Administrator privileges?

Environment

CA Workload Automation iDash r12+

Resolution

If you want a list of Admin users only, you can query the iDash DB for this information: 

 

************ 

SQL SERVER 

************ 

select distinct id, tag, value from dbo.idash_config 

where tag = 'idash.user.account.type' and value = 'Admin' 

 

************ 

ORACLE 

************ 

select distinct id, tag, value from idash_config 

where tag = 'idash.user.account.type' and value = 'Admin'

Additional Information

Click here for the command to get a list of all users, Administrators and Regular, defined in iDash. (See Example: List Existing Users)