Skip to main content

AutoSys Workload Automation

· 15 min read
Pradeep Kadambar
Pradeep Kadambar
Creator
AutoSys Workload Automation (formerly CA Workload Automation AE) improves the availability of critical application workloads across the enterprise by dynamically responding to real time business events, mapping workload processes to service level agreements, ensuring continual monitoring, and automating recovery.

Also known as Unicenter AutoSys Job Management

Identities ❌ | Accounts ✔️ | Groups ✔️ | App Roles ❌ | Entitlements ❌

Application​

Steps

  1. Login to RSA G&L console as System Administrator.
  2. Navigate to Resources > Application.
  3. Click on Create Application and select Other Application.
  4. Enter the details as shown below.
    img
  5. Click Finish.

Account Collector​

Steps

  1. Login to RSA G&L console as System Administrator.
  2. Navigate to Resources > Applications.
  3. Click on CA Workload Automation.
  4. Navigate to Collectors tab and click on Create Account Collector. Enter the details as shown below.

    img
  5. Click Next and enter the Oracle database details. Use the Test Connection to make sure the connection details are accurate.

    img
  6. Click Next. Select the appropriate data that you intend to collect.

    img
  7. Click Next. On the Account Data page, enter the following query to collect account information.
SELECT 
  DISPLAY_ID as accountID, 
  CASE WHEN LOCK_ID = 2 THEN 1 ELSE 0 END as isLocked 
FROM 
  WA.ESP_USER‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The following are the important attributes

img

  1. Click Next. On the User Account Mappings Data configuration page enter the following query to map the CA Workload Automation account to user identity.
SELECT
  DISPLAY_ID as accountID,
  DISPLAY_ID as userID
FROM
  WA.ESP_USER‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The following are the important attributes

img

  1. Click Next. In the Group Data configuration section enter the following query to collect groups from CA Workload Automation.
SELECT
  DISTINCT NAME as groupName,
  GROUP_ID as groupID,
  DESCRIPTION as description
FROM
  WA.ESP_GROUP‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The following are the important attributes

img

  1. In the Account Membership Data configuration section enter the following query to collect groups membership information from CA Workload Automation.
SELECT 
  DISTINCT groups.NAME as groupName, 
  users.DISPLAY_ID as accountID 
FROM 
  WA.ESP_GROUP groups 
  INNER JOIN WA.ESP_USERGROUP members ON members.GROUP_ID = groups.GROUP_ID 
  INNER JOIN WA.ESP_USER users ON users.USER_ID = members.USER_ID‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
  1. Click Next. In the User Resolution Rules, map the user to account

    img
  2. Click Next. In the Member Account Resolution Rules, map the account collector.
Target CollectorAccount Attribute
CA Workload Automation ADCAccount Name
  1. Click Finish. Use the Test function to make sure the configurations are accurate.
COL018