Need data like logonsource in Teradata

Moderator: NorbertKrupa

Post Reply
wahab
Newbie
Newbie
Posts: 1
Joined: Tue Dec 22, 2015 12:01 pm

Need data like logonsource in Teradata

Post by wahab » Fri Oct 13, 2017 6:14 pm

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.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Need data like logonsource in Teradata

Post by JimKnicely » Sun Oct 15, 2017 2:14 am

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Database Administration”