Retrieve user's IP address

[Shawn Smalley]

Is there a built in variable or some way in-app to retrieve the reported users ip address? (like what is returned in the active sessions application for users)

[Johnny Major]

Currently, you could pull the IP address using the current session ID from the table 'VVSESSDATA'

Example:

SELECT
  vvclientip AS ipaddress
FROM
  vvsessdata
WHERE
  vvsessid = 'SESSIONID'

[Shawn Smalley]

Is Session id discernable via a built-in app variable or a program function? I can't seem to find a way to grab it automatically

[sean.lanktree]

Alternately, you can use procedure:

vvUtility_getEnvVar('REMOTE_ADDR')

Below is a link to the docs for this procedure.

https://service.cnxcorp.com/valence-6/index.html#!/api/Valence_RPG_Toolkit.vvUtility

[Shawn Smalley]

Perfect, thank you!