Identify all WS3 objects within system

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

What SQL can be used to identify all Webservice 3 REST objects within a system? 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The following can be used, modifying OH_CLIENT to the client you wish to check:

select b.OH_Name, (select a.OH_Name from OH a where a.OH_Idnr = b.OH_OpenUserIdnr), b.OH_OType from OH b, ONA where b.OH_OType = 'CONN' and b.OH_Client = 100 and b.OH_OpenUserIdnr != 0 and 
     b.OH_IsTemplate = 0 and ONA_OH_Idnr = b.OH_Idnr and ONA_HostAttrType = 'CIT' and ONA_JobType = 'WEBSERVICE' and ONA_SubType = 'RESTCONNECTION'
    union
    select b.OH_Name, (select a.OH_Name from OH a where a.OH_Idnr = b.OH_OpenUserIdnr), b.OH_OType from OH b, JBA where b.OH_OType = 'JOBS' and b.OH_Client = 100 and b.OH_OpenUserIdnr != 0 and 
     b.OH_IsTemplate = 0 and JBA_OH_Idnr = b.OH_Idnr and JBA_HostAttrType = 'CIT' and JBA_JobType = 'WEBSERVICE' and JBA_SubType = 'REST'