List autosys security profiles and userid for jobs

Products

• Autosys Workload Automation

Issue/Introduction

How to list AutoSys security profiles and user IDs configured for jobs.

Environment

 

• Product: AutoSys Workload Automation AE 24.x

 

Resolution

The product offers multiple supported methods to retrieve the requested user and security profile information without interacting directly with the application database.

Method 1: Using the autosys_secure Utility

You can execute the interactive autosys_secure command-line utility and navigate the menus as follows:

• To show all users managed with a password:

  
  

   

  autosys_secure
   [5] Manage users.
    [1] Manage users with password.
     [4] Show all users.
  

• To show all users managed with key credentials:

  
  

   

  autosys_secure
   [5] Manage users.
    [2] Manage users with key credentials.
     [4] Show all users.
  

• To show all users managed with a password vault:

  
  

   

  autosys_secure
   [5] Manage users.
    [3] Manage users with password vault.
     [4] Show all users.
  

• To show all security profiles:

  
  

   

  autosys_secure
   [8] Manage security profiles.
    [4] Show a security profile.
     ALL
      [0] ALL
       [0] ALL
  

Method 2: (Available as of 24.2) Using AutoSys Web Server (AEWS) REST API Calls

You can programmatically access these listings via the following AEWS endpoints:

• User listings: https://example.com:9443/AEWS/v4/user

• Security profile listings: https://example.com:9443/AEWS/v4/security-profile

Version and Database Context (Important Note): The underlying database schema is designed strictly for internal product use. Because the database schema may change from version to version, direct database queries are strongly discouraged. It is highly recommended to utilize the native product interfaces (autosys_secure or AEWS REST endpoints) to retrieve this information to ensure forward compatibility during future upgrades.

If you choose to pursue custom database SQL queries at your own discretion, the relevant tables containing this data are:

• ujo_security_profile

• ujo_cred

 

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on the respective region.