Script to find out which AE agent is connecting to

[Peter Wong]

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?

TIA all!

------------------------------
Peter Wong
AWA Administrator
TCS/Woolworths Group
------------------------------

[Christoph Rekers]

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:

Cheers

Christoph 

------------------------------
----------------------------------------------------------------
Automic AE Consultant and Trainer since 2000
----------------------------------------------------------------
------------------------------