search cancel

How to get a list of all simple users ([email protected] or Domain) created in autosys_secure?


Article ID: 53162


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent



In autosys_secure, AutoSys [email protected] or Domain password, client has used the number [4] option to create several users on a domain but cannot consult a complete list of all the users they created in order to double check their accuracy and spelling. The Show option exists only for superusers while client needs to get the list of simple users following an unknown user error.


The solution is to consult the database using the following query:

select * from cred where owner like '%username%'; 

Important Note: This method can be used only for Consulting information and in case you need to do some updates, it is necessary to do it through autosys_secure utility, otherwise you may risk a database corruption.
Any manual updates or deletes on cred table is strongly prohibited and not supported.


Release: ATSY1C99000-4.5-AutoSys-Job Management-Class 1 Remote Agent