How to determine which client executed a object based on runID

Document ID : KB000092346
Last Modified Date : 20/04/2018
Show Technical Document Details
Introduction:
A job's runID can be used to determine which client the job was run from by using a VARA.SQLI
Background:
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.
Instructions:
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.