3.1.4.2.2.1.3.43.1 Columns

  • Article

The DISCOVER_CONNECTIONS rowset contains the following columns.

Name

Type

Restriction

Description

CONNECTION_ID

xsd:int

Yes

A unique number that identifies the connection.

CONNECTION_USER_NAME

xsd:string

Yes

The user name under which the connection was initiated.

CONNECTION_IMPERSONATED_USER_NAME

xsd:string

Yes<303>

The impersonated user name, if any.<304>

CONNECTION_HOST_NAME

xsd:string

Yes

The name of the machine that initiated the connection.

CONNECTION_HOST_APPLICATION

xsd:string

The name of the application that initiated the connection.

CONNECTION_START_TIME

xsd:dateTime

The server UTC date and time when the connection was initiated.

CONNECTION_ELAPSED_TIME_MS

xsd:long

Yes<305>

Elapsed time, in milliseconds, since the start of the connection.

CONNECTION_LAST_COMMAND_START_TIME

xsd:dateTime

The server UTC date and time when the last command initiated its execution.

CONNECTION_LAST_COMMAND_END_TIME

xsd:dateTime

The server UTC date and time when the last command finished its execution.

CONNECTION_LAST_COMMAND_ELAPSED_TIME_MS

xsd:long

Yes<306>

The time, in milliseconds, that it took for the last command to execute. If a command is in progress, the column returns the elapsed time, in milliseconds, since the start of the command.<307>

CONNECTION_IDLE_TIME_MS

xsd:long

Yes<308>

The idle time, in milliseconds, since the start of the connection.

CONNECTION_BYTES_SENT

xsd:long

The accumulated number of bytes sent by the connection since the start of the connection.

CONNECTION_DATA_BYTES_SENT

xsd:long

The accumulated number of data bytes sent by the connection since the start of the connection.

Data travels compressed within the connection; this value represents the expanded data sent.

CONNECTION_BYTES_RECEIVED

xsd:long

The accumulated number of bytes received by the connection since the start of the connection.

CONNECTION_DATA_BYTES_RECEIVED

xsd:long

The accumulated number of data bytes received by the connection since the start of the connection.

Data travels compressed within the connection; this value represents the expanded data received.

The rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="CONNECTION_ID" name="CONNECTION_ID" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_USER_NAME" name="CONNECTION_USER_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_IMPERSONATED_USER_NAME" 
                             name="CONNECTION_IMPERSONATED_USER_NAME" 
                             type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_HOST_NAME" name="CONNECTION_HOST_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_HOST_APPLICATION" 
                             name="CONNECTION_HOST_APPLICATION" 
                             type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_START_TIME" name="CONNECTION_START_TIME" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_ELAPSED_TIME_MS" 
                             name="CONNECTION_ELAPSED_TIME_MS" 
                             type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_LAST_COMMAND_START_TIME" 
                             name="CONNECTION_LAST_COMMAND_START_TIME" 
                             type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_LAST_COMMAND_END_TIME" 
                             name="CONNECTION_LAST_COMMAND_END_TIME" 
                             type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_LAST_COMMAND_ELAPSED_TIME_MS" 
                             name="CONNECTION_LAST_COMMAND_ELAPSED_TIME_MS" 
                             type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_IDLE_TIME_MS" name="CONNECTION_IDLE_TIME_MS" 
                            type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_BYTES_SENT" name="CONNECTION_BYTES_SENT" 
                            type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_DATA_BYTES_SENT" 
                             name="CONNECTION_DATA_BYTES_SENT" 
                             type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_BYTES_RECEIVED" name="CONNECTION_BYTES_RECEIVED" 
                            type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="CONNECTION_DATA_BYTES_RECEIVED" 
                             name="CONNECTION_DATA_BYTES_RECEIVED" 
                             type="xsd:long" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>