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. Referenced to the ConferenceUris Table. This URI is focus based conference URI.

McuConferenceUriId

Int

Foreign

Conferencing Server Conference URI related to this session. Referenced 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 different machines with the same account, then each machine will have a different endpoint ID.

OnBehalfOfId

int

Indicate 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 conference user, reference to the ClientVersions Table.

ConfClientVersionId

Int

Foreign

Client version used by 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 conference server.

IsEndedByConfServer

Bit

Is this session ended by the conference server.

IsUserInternal

Bit

Whether user is logged on from internal or not.

ResponseCode

int

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.

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.