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.
Need data like logonsource in Teradata
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Need data like logonsource in Teradata
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
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
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.