ConferenceSessionDetails view
The ConferenceSessionDetails view stores information about multiparty sessions. Each record represents one conference session, which could be either the session with Focus or the session with a specific conferencing server. 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 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). |
| ConferenceUri |
nvarchar(450) |
URI of the conference. |
| ConferenceUriType |
nvarchar(256) |
Type of conference URI. See the UriTypes table for more information. |
| ConfInstance |
uniqueidentifier |
Identifier that differentiates between instances of recurring conferences. Each recurring conference instance has the same ConferenceURI but a different ConfInstance value. |
| McuConferenceUri |
nvarchar(450) |
URI of the conferencing server. |
| McuConferenceUriType |
nvarchar(256) |
Type of conferencing server URI. See the UriTypes table for more information. |
| UserUri |
nvarchar(450) |
URI of the user involved in the session. |
| UserUriType |
nvarchar(256) |
Type of URI of the user whose was part of the session. See the UriTypes table for more information. |
| UserTenant |
nvarchar(256) |
Tenant of the user whose was part of the session. See the Tenants table for more information. |
| UserEndpointId |
uniqueidentifier |
Unique identifier of the user whose was part of the session. |
| EndTime |
datetime |
End time of the session. |
| ConferenceClientVersion |
nvarchar(256) |
Version of conference server. |
| ConferenceClientType |
int |
Type of conference server. See the UserAgentDef table for more information. |
| ConferenceCategory |
nvarchar(64) |
Conference server category. |
| UserClientVersion |
nvarchar(256) |
Version of client used by the user who participated in the session. |
| UserClientType |
int |
Client used by the user who participated in the session. See the UserAgentDef table for more details. |
| UserClientCategory |
nvarchar(64) |
Name of the category of the client used by the user who was part of the session. |
| OnBehalfOfUri |
nvarchar(450) |
URI of the user on whose behalf the session was started. |
| OnBehalfOfUriType |
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. |
| ReferredByUriTenant |
nvarchar(256) |
Tenant of the user who referred the session. See the Tenants table for more information. |
| DialogId |
varstring(775) |
SIP dialog ID. The format is :dialog;from-tag;to-tag |
| ReplaceDialogIdTime |
datetime |
ID number to identify the dialog which was replaced by current 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 session that is replaced by this 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 of the is: dialog;from-tag;to-tag |
| IsStartedByConfServer |
bit |
Indicates whether the session was started by the conferencing server. |
| IsEndedByConfServer |
bit |
Indicates whether the session was ended by the conferencing server. |
| IsUserInternal |
bit |
Indicates whether the user logged on from the internal network. |
| 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 session SIP headers. |
| ContentType |
nvarchar(256) |
Content type 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. |
| MediationServer |
nvarchar(256) |
Mediation Server used by the user who participated in the session. |
| Gateway |
nvarchar(256) |
Gateway used by the user who participated the session. |
| EdgeServer |
nvarchar(256) |
FQDN of the Edge server used by the user who participated in the session. |
| UserFlag |
smallint |
Indicates the attributes of the user who participated in the session. The following attribute definitions allowed: 0x01 - Integrated with desktop phone |
| CallFlag |
smallint |
Indicates the call attributes. The following attribute definitions are allowed: 0x01 - Retried Session0 x02 - A call made by agent on behalf of a Response Group |