SessionDetails view in Lync Server 2013
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 in Lync Server 2013 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 Lync Server 2013 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 in Lync Server 2013 for more information. |
ToUriType |
nvarchar(256) |
Type of URI of the user who joined the session. See the UriTypes table in Lync Server 2013 for more information. |
FromTenant |
nvarchar(450) |
Tenant of the user who started the session. See the Tenants table in Lync Server 2013 for more information. |
ToTenant |
nvarchar(256) |
The tenant of the user who joined the session. See the Tenants table in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 for more information. |
OnBehalfOfTenant |
nvarchar(256) |
Tenant of the user whose on behalf the session was started. See the Tenants table in Lync Server 2013 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 in Lync Server 2013 for more information. |
ReferredByTenant |
nvarchar(256) |
Tenant of the user who referred the session. See the Tenants table in Lync Server 2013 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 Lync Server 2013 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 Lync Server 2013 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. |