17.00 - Example: Using SessionInfoV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The following SELECT statement displays information on all current session.

SELECT UserName, SessionNo, DefaultDatabase, LogonSource
       FROM DBC.SessionInfoV;

Result:

UserName  SessionNo DefaultDatabase LogonSource
--------- --------- --------------- ----------------------------
DBC       1,005     DBC             <TCP/IP> EB9F 141.206.1.84