SQL Query to list all External Dependencies

book

Article ID: 89126

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL Query to list all External Dependencies

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

?Sometimes Users require a report on all External Dependencies they have set.

Solution

?SQL can be used in Internal Variable or directly against the database.

 

select oh.oh_client as Client, oh.oh_name as Workflow, jpp.jpp_object as Task from oh,jpp where oh_idnr=jpp_oh_idnr and jpp_otype='<XTRNL>'