Need to Export a List of iDash Users with Admin Privileges

Document ID : KB000015459
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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

Environment:
CA Workload Automation iDash r12+
Answer:

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)