SessionDetails view

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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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 in Skype for Business Server 2015 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.
LastModifiedTime
Datetime
For internal use by the Monitoring service.
This field was introduced in Skype for Business Server 2015.