The Vertica Database Forums

Hi All,
In Teradata, we have LogonSource column which will give us the below information
IP address of the client system.
Teradata Database hostname, knows as the "TDPID".
Client process/thread identifier.
Client system user ID.
Program used on the client system.

Can some one help me to identify, do we have similar kind of information in vertica like client id, program used to connect client system.

Check the V_MONITOR.SESSIONS and the V_MONOTR.USER_SESSIONS system tables:

See:
SESSIONS: https://my.vertica.com/docs/8.1.x/HTML/ ... SSIONS.htm
USER_SESSIONS: https://my.vertica.com/docs/8.1.x/HTML/ ... SSIONS.htm