SessionDetails Table

 

Topic Last Modified: 2010-12-13

Each record represents one peer-to-peer session, which could be a VoIP-VoIP phone call, two-party IM session, or other type of session. You can perform a table join with the Media Table to find the details of each media involved in this session.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. Reference to Dialogs Table.

SessionIdSeq

int

Primary

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

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

ContentTypeID

Int

Foreign

Content type used in the session. Reference to the ContentTypes 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 the SIP request. Reference to the Users Table.

SessionStartedById

int

Foreign

ID of the user who started the session. Reference to the Users Table.

OnBehalfOfId

Int

 

Indicates the ID of the user of who the caller is on behalf. Reference to the Users Table.

ReferredById

Int

Foreign

ID of the user by who the call is referred. Reference to the Users Table.

ServerID

Int

Foreign

ID of the front-end server used for this session. Reference to the Servers Table.

PoolId

 

Foreign

ID of the pool in which the session was captured. Reference to the 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 a desk phone or not.

IsUser2IntegratedWithDeskPhone

Bit

 

Whether User2 is integrated with a 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. Listed are the definitions of the types:

 

IM

1

FILE_TRANSFER

2

REMOTE_ASSISTANCE

4

APP_SHARING

8

AUDIO

16

VIDEO

32

APP_INVITE

64

User1Flag

smallint

 

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

  • Integrated with desktop phone - 1

User2Flag

smallint

 

A bit set that indicates the User2 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

  • A call made by agent on behalf of a response group - 2

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