How to determine which client executed a object based on runID

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

A job's runID can be used to determine which client the job was run from by using a VARA.SQLI

Using the search functionality within the Automation Engine is client specific.

An agent log file will include all runID and job names.

This information can be used to query the database.

Environment

Release:
Component: AUTWA

Resolution

1. Create a VARA.SQLI in any client other than 0000 (the user must have permission to create this object type)
2. Choose the database type of the Automation Engine database
3. Run the following SQL:

select * from AH where AH_idnr = '<enter runID here>'
or
select * from AH where  AH_name = '<enter object name here>'

The results will include the AH_Client. This is the client where the job ran from.