_Connect-IPAddress UNAVAILABLE for self-service query

_Connect-IPAddress UNAVAILABLE for self-service query.
An ABL self-service connection running a query on remote clients returns: UNAVAILABLE for remote client's IP Address.
An ABL or SQL client/server connection running a query on remote clients _Connect-IPAddress returns the IP address of the remote client.

The following code shows the _Connect-IPAddress as UNAVAILABLE when run by a self-service client but not when run by a client/server client:
 

FOR EACH _Connect NO-LOCK WHERE _Connect-Name <> ? AND _Connect-Type = 'REMC':
    IF AVAILABLE _Connect THEN
        DISPLAY _Connect-Type _Connect-ClientType _Connect-Name  SKIP
        _Connect-Pid  _Connect-Device _Connect-IPAddress.
END.

The following SQL Query returns the IP Address of all remote clients as the SQL client running the query is connected client/server:
 

SELECT "_Connect-Type", "_Connect-ClientType", "_Connect-Name", "_Connect-Pid", "_Connect-Device", "_Connect-IPAddress" FROM 
PUB."_Connect" WHERE "_Connect-Name" IS NOT NULL AND "_Connect-Type" = 'REMC';

 

For the self service client, networking structures have not been set up, as they are not needed. 
The reason the remote connection retrieves the data is because it gets its data from the remote server that has networking set up. 

Until the fix is available, use the workaround below.

To find the IP Address of a Remote Client Connection, run the _Connect VST query:

1. Client Server from a GUI client (prowin32, prowin)
2. Self-service with a CHUI client (mpro, _progres)

Progress Article: 

 _Connect-IPAddress VST displays IP addresses with a question mark.