search cancel

Extracting a list of Admin users

book

Article ID: 240875

calendar_today

Updated On:

Products

iDash Workload Automation for CA 7

Issue/Introduction

Is there a way to extract a list of users with Admin access?

Environment

Release :

Component :

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'