Need to Export a List of iDash Users with Admin Privileges

book

Article ID: 15459

calendar_today

Updated On:

Products

CA Workload Automation iDash

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)