Topic Last Modified: 2012-10-01

The SessionDetails view stores information about peer-to-peer sessions, which could be a VoIP-VoIP phone call, two-party IM session, or other type of session. This view was introduced in Microsoft Lync Server 2013.

Column Data Type Details

SessionIdTime

datetime

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table Table for more information.

SessionIdSeq

int

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs Table for more information.

InviteTime

datetime

Time of the first INVITE request. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

FromUri

nvarchar(450)

URI of the user who started the session.

ToUri

nvarchar(450)

URI of the user who joined the session.

FromUriType

nvarchar(256)

Type of URI of the user who started the session. See the UriTypes Table for more information.

ToUriType

nvarchar(256)

Type of URI of the user who joined the session. See the UriTypes Table for more information.

FromTenant

nvarchar(450)

Tenant of the user who started the session. See the Tenants Table for more information.

ToTenant

nvarchar(256)

The tenant of the user who joined the session. See the Tenants Table for more information.

FromEndpointId

uniqueidentifier

Unique identifier of the endpoint of the user who started the session.

ToEndpointId

uniqueidentifier

Unique identifier of the endpoint of the user who joined the session.

EndTime

datetime

End time of the session.

FromMessageCount

int

Number of messages sent by the user who started the session.

ToMessageCount

int

Number of messages sent by the user who joined the session.

FromClientVersion

nvarchar(256)

Version of client used by the user who started the session.

FromClientType

int

Client used by the user who started the session. See the UserAgentDef Table for more details.

FromClientCategory

nvarchar(64)

Name of the category of the client used by the user who started the session.

ToClientVersion

nvarchar(256)

Version of client used by the user who joined the session

ToClientType

int

Client used by the user who joined the session. See the UserAgentDef Table for more details.

ToClientCategory

nvarchar(64)

Name of the category of the client used by the user who joined the session.

TargetUri

nvarchar(450)

URI of the target user of the session.

TargetUriType

nvarchar(450)

Type of URI of the target user for the session. See the UriTypes Table for more information.

OnBehalfOfUri

nvarchar(450)

URI of the user on whose behalf the session was started.

OnnnBehalfOfUriType

nvarchar(256)

Type of URI of the user on whose behalf the session was started. See the UriTypes Table for more information.

OnBehalfOfTenant

nvarchar(256)

Tenant of the user whose on behalf the session was started. See the Tenants Table for more information.

ReferredByUri

nvarchar(450)

URI of the user who referred the session.

ReferredByUriType

nvarchar(256)

Type of URI of the user who referred the session. See the UriTypes Table for more information.

ReferredByTenant

nvarchar(256)

Tenant of the user who referred the session. See the Tenants Table for more information.

DialogId

varchar(775)

SIP dialog ID. The format is:

dialog;from-tag;to-tag

CorrelationId

uniqueidentifier

GUID used to correlate multiple sessions.

ReplaceDialogIdTime

datetime

Time of the dialog which was replaced by the session. Used in conjunction with ReplaceDialogIdSeq to uniquely identify a dialog that is replaced by the session. See the Dialogs Table for more information.

ReplaceDialogIdSeq

int

ID number to identify the session. Used in conjunction with ReplaceDialogIdTime to uniquely identify a dialog that is replaced by the session. See the Dialogs Table for more information.

ReplacesDialogId

varchar(775)

SIP dialog ID the session replaces. The format is:

dialog;from-tag;to-tag

ResponseTime

datetime

Time of the response to the first INVITE message. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

ResponseCode

int

SIP response code to the session invitation. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

DiagnosticId

int

Diagnostic ID captured from SIP headers.

ContentType

nvarchar(256)

Type of content for the session.

FrontEnd

nvarchar(256)

FQDN of the Front End server that captured the data for the session.

Pool

nvarchar(256)

FQDN of the pool that captured the data for the session.

FromEdgeServer

nvarchar(256)

FQDN of the Edge server used by the user who started the session.

ToEdgeServer

nvarchar(256)

FQDN of the Edge server used by the user who started the session

IsFromInternal

bit

Indicates whether the user who started the session logged on from the internal network.

IsToInternal

bit

Indicates whether the user who joined the session logged on from the internal network.

CallPriority

nvarchar(256)

Call priority of the session.

FromUserFlag

smallint

Indicates the attributes of the user who started the session. The following attribute definitions are allowed:

0x01 - Integrated with desktop phone

ToUserFlag

smallint

Indicates the attributes of the user who started the session. The following attribute definitions are allowed:

0x01 - Integrated with desktop phone

CallFlag

smallint

Indicates the call attributes. The following attribute definitions are allowed:

0x01 - Retried Session

0x02 - A call made by agent on behalf of a Response Group

Location

varchar(max)

Location of emergency call.