SessionDetails table
Each record represents one peer-to-peer session, which could be a VoIP-VoIP phone call, two-party IM session, or other type of session. You can perform a table join with the Media table to find the details of each media involved in this session.
The IsUser1IntegratedWithDeskPhone and the IsUser2IntegratedWithDeskPhone fields is dropped from the SessionDetails table used in Skype for Business Server 2015.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
| SessionIdTime |
datetime |
Primary, Foreign |
Time of session request. Used with SessionIdSeq to uniquely identify a session. For more information, see the Dialogs table in Skype for Business Server 2015 for more. |
| SessionIdSeq |
int |
Primary, Foreign |
ID number to identify the session. Used with SessionIdTime to uniquely identify a session.* For more information, see the Dialogs table in Skype for Business Server 2015. |
| CorrelationId |
uniqueidentifier |
A GUID to correlate multiple sessions. |
|
| ReplaceDialogIdTime |
datetime |
Foreign |
ID number to identify the dialog, which was replaced by current session. For more information, see the Dialogs table in Skype for Business Server 2015. |
| ReplaceDialogIdSeq |
int |
Foreign |
ID number to identify the session. Used with ReplacesDialogIdTime to uniquely identify a session that is replaced by this session. For more information, see the Dialogs table in Skype for Business Server 2015. |
| User1Id |
int |
Foreign |
ID of one user in the session. For more information, see the Users table. |
| User2Id |
int |
Foreign |
ID of the other user in the session. For more information, see the Users table. |
| User1EndpointId |
uniqueIdentifier |
GUID that identifies the endpoint used by the first user in the session. This field was introduced in Microsoft Lync Server 2013. |
|
| User2EndpointId |
uniqueIdentifier |
GUID that identifies the endpoint used by the second user in the session. This field was introduced in Microsoft Lync Server 2013. |
|
| TargetUserId |
int |
Foreign |
The original To user URI in the SIP request. For more information, see the Users table. |
| SessionStartedById |
int |
Foreign |
ID of the user who started the session. For more information, see the Users table. |
| OnBehalfOfId |
int |
Foreign |
Indicates the ID of the user of who the caller is on behalf. For more information, see the Users table. |
| ReferredById |
int |
Foreign |
ID of the user by who the call is referred. For more information, see the Users table. |
| ServerId |
int |
Foreign |
ID of the front-end server used for this session. For more information, see the Servers table. |
| PoolId |
int |
Foreign |
ID of the pool in which the session was captured. See the Pools table for more information. |
| ContentTypeID |
int |
Foreign |
Content type used in the session. For more information, see the ContentTypes table in Skype for Business Server 2015. |
| User1ClientVerId |
int |
Foreign |
Client version used by User1. For more information, see the ClientVersions table in Skype for Business Server 2015. |
| User2ClientVerId |
int |
Foreign |
Client version used by User2. For more information, see the ClientVersions table in Skype for Business Server 2015. |
| User1EdgeServerid |
int |
Foreign |
Edge Server used by User1. For more information, see the EdgeServers table in Skype for Business Server 2015. |
| User2EdgeServerid |
int |
Foreign |
Edge Server used by User2. For more information, see the EdgeServers table in Skype for Business Server 2015. |
| IsUser1Internal |
bit |
Whether User1 is logged on from internal or not. |
|
| IsUser2Internal |
bit |
Whether User2 is logged on from internal or not. |
|
| InviteTime |
datetime |
The time of the first INVITE request. This field is populated by data generated from the initial INVITE message in the session. If there's 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 populated by data generated from the initial INVITE message in the session. If there's no INVITE message, then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO). |
|
| ResponseTime |
datetime |
The time of the response to the first INVITE message. This field is populated by data generated from the initial INVITE message in the session. If there's 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's 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 header. |
|
| CallPriority |
int |
Foreign |
Call priority. For more information, see the CallPriorities table in Skype for Business Server 2015. |
| User1MessageCount |
int |
Number of messages sent by User1 during the session. |
|
| User2MessageCount |
int |
Number of messages sent by User2 during the session. |
|
| SessionEndTime |
datetime |
Time at the end of the session. |
|
| MediaTypes |
int |
A bit set that indicates the media type of this session. Listed are the definitions of the types: 1- IM 2- FILE_TRANSFER 4- REMOTE_ASSISTANCE 8- APP_SHARING 16- AUDIO 32- VIDEO 64- APP_INVITE |
|
| User1Flag |
smallint |
A bit set that indicates the User1 attributes. The following attribute definitions are listed: 0x01 - Integrated with desktop phone |
|
| User2Flag |
smallint |
A bit set that indicates the User2 attributes. The following attribute definitions are listed: 0x01 - Integrated with desktop phone |
|
| CallFlag |
smallint |
A bit set that indicates the call attributes. The following attribute definitions are listed: 0x01 - Retried Session 0x02 - A call made by agent on behalf of a response group |
|
| Processed |
bit |
For internal use by the Monitoring service. This field was introduced in Microsoft Lync Server 2013. |
|
| LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |
* For most sessions, SessionIdSeq has the value of 1. If multiple sessions start at exactly the same time, the SessionIdSeq for one is 1, for another is 2, and so on.