Hi AWA gurus,
Have this requirement to find out which AE a set of agents are connecting to (we want to know whether they connect to Proxy Client or directly to an AE).
Guess what I am thinking now is to populate a vara with running agents (name, runid).
Then have to use PREP_PROCESS_REPORT to scroll through the log and look for either "cp=" for v12 agents and "connection=" for v21 agents.
Once it finds the text, output agent name and AE connection to a text file.
Am I complicating things? Is there a SQL table that stores all this info so I can directly query it?
Hi @Peter Wong,This works for me under MS SQL Server:
select oh_name, host_tls from oh, host
where oh_idnr = HOST_OH_Idnr
and (HOST_HostAttrType <> 'W' and HOST_HostAttrType <> 'C' and HOST_HostAttrType <> 'TLS_GTW'
and HOST_HostAttrType <>'IA')
and OH_IsTemplate <>'1'
and OH_Idnr > '100000'
order by host_tls asc
This is the result, where host_tls = 0 means: not connected to a TLS-Gateway but to a lagacy CP: