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

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

PROMON > 1.  User Control does not provide the IP Address for local connections.
PROMON > R&D > 1. Status > 4. Processes/Clients > 4. Local Clients does not show the IP Address
PROMON > R&D > 1. Status > 4. Processes/Clients > 6. Remote Clients shows the IP Address

PROMON > 1.  User Control
 
  Usr  Name       Type   Wait Table                Dbkey     Trans      PID Sem Srv Login  Time    IPV# Remote Addr
    5 user1    SELF/ABL   --      0                    0         0     4372   0   0 mm/dd/yy hh:mm < no IP ADDRESS >
   23 user2    REMC/ABL   --      0                    0         0        0   0   2 mm/dd/yy hh:mm IPV4 172.22.3.88

PROMON > R&D > Status: Local Clients
 
  Usr  Name       Type   Wait            Wait Info  Trans id   Login time     Pid
    5 user1    SELF/ABL   --                     0         0  mm/dd/yy hh:mm 4372
 

 

This is the expected behavior:
 ​_Connect-IPAddress was one of the new _Connect VST's added in OpenEdge 10.1C. 

Since OpenEdge 10.2A, the _Connect-IPAddress VST displays the client's IP address for ABL remote clients not local connections.
The field will not have a value if the remote client is from OpenEdge 10.1B or before and is documented in:

Use _Connect-Type to select Remote Client connections only.

The following ABL code example demonstrates and can be customised to requirements:
 

FOR EACH _Connect NO-LOCK WHERE _Connect-Name <> ? AND _Connect-Type = 'REMC':
    IF AVAILABLE _Connect THEN
        DISPLAY _Connect-Type _Connect-ClientType _Connect-Name _Connect-ID SKIP
        _Connect-Pid  _Connect-Device _Connect-IPAddress  SKIP
        SUBSTRING(_Connect-Time,5,6) LABEL "con DATE" 
        SUBSTRING(_Connect-Time,12,8) LABEL "con TIME"
        _Connect-Transid _Connect-Server .
END.

• If specific client-types are required the WHERE condition can use _Connect-Type, for example:

FOR EACH _Connect NO-LOCK WHERE _Connect-Name <> ? AND _Connect-Type = 'REMC' AND _Connect-ClientType = 'SQLC' :

The following SQL code example demonstrates and can be customised to requirements:

$   sqlexp testdb -S <port> -user sysprogress -password sysprogress -infile listAllSqlConnections.sql -outfile connectionsSql.txt

Where listAllSqlConnections.sql contains the following statement:

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' AND "_Connect-ClientType" = 'SQLC'; 

Progress Article:

_Connect-IPAddress UNAVAILABLE for self-service query [000058396]