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:

  • Integrated with desktop phone - 1

CallFlag

smallint

 

A bit set that indicates the call attributes. The following attribute definitions are listed:

  • Retried Session - 1

* 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.