SessionIdTime

datetime

Primary

Time of session request; used in conjunction with SessionIdSeq to uniquely identify a session.

SessionIdSeq

int

Primary

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. *

CorrelationId

uniqueidentifier

A GUID to correlate multiple sessions.

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.

User1Id

Int

Foreign

Id of one user in the session. Reference to the Users Table.

User2Id

int

Foreign

Id of the other user in the session. Reference to the Users Table.

TargetUserId

Int

The original To user URI in SIP request. Reference to Users Table.

SessionStartedById

int

Foreign

Id of the user who started the session, reference to the Users Table.

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.

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.

User1ClientVerId

Int

Foreign

Client version used by User1, reference to the ClientVersions Table.

User2ClientVerId

int

Foreign

Client version used by User2, reference to the ClientVersions Table.

User1EdgeServerid

int

Foreign

Edge server used by User1, reference to the EdgeServers Table.

User2EdgeServerid

int

Foreign

Edge server used by User2, reference to the EdgeServers Table.

IsUser1Internal

Bit

Whether user1 is logged on from internal or not.

IsUser2Internal

Bit

Whether user2 is logged on from internal or not.

IsUser1IntegratedWithDeskPhone

Bit

Whether user1 is integrated with desk phone or not.

IsUser2IntegratedWithDeskPhone

Bit

Whether user2 is integrated with desk phone or not.

InviteTime

datetime

The time of the first INVITE request.

ResponseTime

datetime

The time of the response of the first INVITE.

ResponseCode

Int

SIP response code to the session invitation.

DianosticId

Int

Diagnostic Id captured from SIP header.

CallPriority

Int

Foreign

Call priority. Reference to CallPriorities Table.

User1MessageCount

Int

Number of messages sent by User1 during the session.

User2MessageCount

Int

Number of messages sent by User2 during the session.

SessionEndTime

datetime

MediaTypes

int

A bit set that indicates the media type of this session. Below are the definition of the types