When the .NET Data Provider for Teradata establishes a connection to the Advanced SQL Engine, a string value is composed that is stored in the Data Dictionary System Views column "LogonSource". This column is included in system views such as DBC.SessionInfo and DBC.LogOnOff.

Note
All LogonSource values that are provided by the .NET Data Provider for Teradata and other clients are entered into the SQL Engine in uppercase.

The .NET Data Provider for Teradata follows the format documented in the Teradata Data Dictionary, section "System Views Columns Reference", for network-attached LogonSource values.

Network-attached LogonSource values have eight fields, separated by whitespace. Fields 1 through 3 are composed by the SQL Engine. Fields 4 through 8 are composed by the .NET Data Provider for Teradata.

The literal "(TCP/IP)", to indicate the connection type.
TCP port number on the client system, in hexadecimal.
IP address of the client system.
The SQL Engine hostname, knows as the "TDPID".
Client process/thread identifier.
Client system user ID.
Program used on the client system.
The literal "01 LSS", to indicate LogonSource string version 01.

The maximum allowable size for the LogonSource is 97 characters. The fields will be truncated or removed as needed to ensure the total length does not exceed 97 characters.

An example of a fully constructed LogonSource is as follows:

(TCP/IP) 057E 153.64.135.76 SALES:153.64.116.95:1025 3808 CORP\TDUSER TESTAPP:NET:SS:12.00.00.000 01 LSS

Fields 4 through 7 are described below:

Field 4 - SQL Engine hostname

The TDPID field is composed of:

Original DataSource specified by the application without a COPn suffix. For example, "SALES".
A colon: ":".
The IP address of the SQL Engine that was actually connected. For example, 153.64.116.95. This part of the field will be replaced with COPn if it's an IPv6 address that is longer than the maximum characters allowed. In this case, if a literal IPv6 was specified by the application as the DataSource, the first part of this field will be replaced with the DNS name.
A colon: ":".
The Port of the SQL Engine node that was actually connected. For example, 1025.

This TDPID field is truncated to the space remaining in the 97 characters, after all the other fields are composed.

An example value for this field when the application specifies the DataSource value of "sales" is: SALES:153.64.116.95:1025

Field 5 - Client process identifier

The Client Process identifier field is composed as follows:

The process id is obtained using Process.GetCurrentProcess().Id. If a SecurityException is encountered, the value will contain a "?".

This field is removed if both Field 4 (SQL Engine hostname) and Field 6 (Client system User ID) have been removed and the resulting string is still longer than 97 characters.

An example value of this field is: 3808

Field 6 - Client system User ID

The Client system User ID field is composed as follows:

The domain name is obtained using System.Environment.UserDomainName. If a SecurityException is encountered, the value will contain a "?".
A backslash "\".
The user name is obtained using System.Environment.UserName. If a SecurityException is encountered, the value will contain a "?".

This field is truncated if Field 4 (SQL Engine hostname) was removed and the resulting string is still longer than 97 characters.

An example value for this field is: CORP\TDUSER

Field 7 - Program used on the client system

The program information on the client system is composed as follows:

The program name is obtained using Process.GetCurrentProcess().ProcessName. If a SecurityException is encountered, the value will contain a "?".
A colon ":".
The string literal "NET" which identifies the .NET Data Provider for Teradata.
A colon ":".
The string literal "SS" which identifies the session type as a standard SQL session.
A colon ":".
The 12 character release number for the .NET Data Provider for Teradata in the form "nn.nn.nn.nnn".

An example value for this field is: TESTAPP:NET:SS:12.00.00.000