ConferenceSessionDetails Table
Topic Last Modified: 2010-11-09
Each record represents one conference session, which could be either the session with Focus or the session with a specific conferencing server.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
SessionIdTime |
Datetime |
Primary, Foreign |
Time of session request; used in conjunction with SessionIdSeq to uniquely identify a conference session. Reference to Dialogs Table. |
SessionIdSeq |
int |
Primary, Foreign |
ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a conference session. Reference to Dialogs Table. |
ConferenceUriId |
Int |
Foreign |
Focus conference URI related to this session. Reference to the ConferenceUris Table. This URI is a Focus-based conference URI. |
McuConferenceUriId |
Int |
Foreign |
Conferencing server conference URI related to this session. Reference to the ConferenceUris Table. This URI is the conferencing server-based conference URI. For Focus conference sessions, this column will be null. |
UserId |
int |
Foreign |
ID of one user in the conference session. Reference to the Users Table. |
UserEndpointId |
uniqueidentifier |
A GUID to identify the instance of endpoint. For example, if one user logs on to different machines with the same account, then each machine will have a different endpoint ID. |
|
OnBehalfOfId |
int |
Indicates the ID of the user of who the caller is on behalf. Reference to Users Table. |
|
ReferredById |
Int |
Foreign |
ID of the user by who the call is referred. Reference to Users Table. |
UserClientVersionId |
int |
Foreign |
Client version used by the conference user. Reference to the ClientVersions Table. |
ConfClientVersionId |
Int |
Foreign |
Client version used by the conference server. Reference to the ClientVersions Table. |
ReplaceDialogIdTime |
datetime |
Foreign |
ID number to identify the dialog which was replaced by current session. Reference to Dialogs Table |
ReplaceDialogIdSeq |
Int |
Foreign |
ID number to identify the session. Used in conjunction with ReplacesDialogIdTime to uniquely identify a session that is replaced by this session. Reference to Dialogs Table. |
IsStartedByConfServer |
Bit |
Is this session started by the A/V Conferencing Server? |
|
IsEndedByConfServer |
Bit |
Is this session ended by the A/V Conferencing Server? |
|
IsUserInternal |
Bit |
Whether user is logged on from internal or not. |
|
ResponseCode |
int |
Session Initiation Protocol (SIP) response code to the session invitation. |
|
DianosticId |
int |
Diagnostic ID captured from SIP header. |
|
ServerId |
Int |
Foreign |
ID of the front-end server used for this session. Reference to Servers Table. |
PoolId |
Foreign |
ID of the pool in which the session was captured. Reference to Pools Table. |
|
MediationServerId |
int |
Foreign |
The Mediation Server the call is using, reference to the MediationServers Table. |
GatewayId |
Int |
Foreign |
The gateway the call is using. Reference to Gateways Table. |
EdgeServerId |
int |
Foreign |
The Edge Server the call is using. Reference to EdgeServers Table. |
ContentTypeID |
Int |
Foreign |
Content type used in the session. Reference to the ContentTypes Table. |
InviteTime |
datetime |
|
The time of the first INVITE request. |
ResponseTime |
datetime |
|
The time of the first INVITE response. |
SessionEndTime |
datetime |
|
The time when the session is ended. |
UserFlag |
smallint |
|
A bit set that indicates the user attributes. The following attribute definitions are listed:
|
CallFlag |
smallint |
|
A bit set that indicates the call attributes. The following attribute definitions are listed:
|
* For most sessions, SessionIdSeq will have the value of 1. If multiple sessions start at exactly the same time, the SessionIdSeq for one will be 1, for another will be 2, and so on.