SessionIdTime

datetime

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information.

SessionIdSeq

int

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs Table for more information.

InviteTime

datetime

Time of the first INVITE request. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

ConferenceUri

nvarchar(450)

URI of the conference.

ConferenceUriType

nvarchar(256)

Type of conference URI. See the UriTypes Table for more information.

ConfInstance

uniqueidentifier

Identifier that differentiates between instances of recurring conferences. Each recurring conference instance has the same ConferenceURI but a different ConfInstance value.

McuConferenceUri

nvarchar(450)

URI of the conferencing server.

McuConferenceUriType

nvarchar(256)

Type of conferencing server URI. See the UriTypes Table for more information.

UserUri

nvarchar(450)

URI of the user involved in the session.

UserUriType

nvarchar(256)

Type of URI of the user whose was part of the session. See the UriTypes Table for more information.

UserTenant

nvarchar(256)

Tenant of the user whose was part of the session. See the Tenants Table for more information.

UserEndpointId

uniqueidentifier

Unique identifier of the user whose was part of the session.

EndTime

datetime

End time of the session.

ConferenceClientVersion

nvarchar(256)

Version of conference server.

ConferenceClientType

int

Type of conference server. See the UserAgentDef Table for more information.

ConferenceCategory

nvarchar(64)

Conference server category.

UserClientVersion

nvarchar(256)

Version of client used by the user who participated in the session.

UserClientType

int

Client used by the user who participated in the session. See the UserAgentDef Table for more details.

UserClientCategory

nvarchar(64)

Name of the category of the client used by the user who was part of the session.

OnBehalfOfUri

nvarchar(450)

URI of the user on whose behalf the session was started.

OnBehalfOfUriType

nvarchar(256)

Type of URI of the user on whose behalf the session was started. See the UriTypes Table for more information.

OnBehalfOfTenant

nvarchar(256)

Tenant of the user whose on behalf the session was started. See the Tenants Table for more information.

ReferredByUri

nvarchar(450)

URI of the user who referred the session.

ReferredByUriType

nvarchar(256)

Type of URI of the user who referred the session. See the UriTypes Table for more information.

ReferredByUriTenant

nvarchar(256)

Tenant of the user who referred the session. See the Tenants Table for more information.

DialogId

varstring(775)

SIP dialog ID. The format is

:dialog;from-tag;to-tag

ReplaceDialogIdTime

datetime

ID number to identify the dialog which was replaced by current session. See the Dialogs Table for more information.

ReplaceDialogIdSeq

int

ID number to identify the session. Used in conjunction with ReplaceDialogIdTime to uniquely identify a session that is replaced by this session. See the Dialogs Table for more information.

ReplacesDialogId

varchar(775)

SIP dialog ID the session replaces. The format of the is:

dialog;from-tag;to-tag

IsStartedByConfServer

bit

Indicates whether the session was started by the conferencing server.

IsEndedByConfServer

bit

Indicates whether the session was ended by the conferencing server.

IsUserInternal

bit

Indicates whether the user logged on from the internal network.

ResponseTime

datetime

Time of the response to the first INVITE message. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

ResponseCode

int

SIP response code to the session invitation. This field is typically populated by data generated from the initial INVITE message in the session. If there is no INVITE message then the field is populated with the date and time of the first relevant SIP message (BYE, CANCEL, MESSAGE, or INFO).

DiagnosticId

int

Diagnostic ID captured from session SIP headers.

ContentType

nvarchar(256)

Content type for the session.

FrontEnd

nvarchar(256)

FQDN of the Front End server that captured the data for the session.

Pool

nvarchar(256)

FQDN of the pool that captured the data for the session.

MediationServer

nvarchar(256)

Mediation Server used by the user who participated in the session.

Gateway

nvarchar(256)

Gateway used by the user who participated the session.

EdgeServer

nvarchar(256)

FQDN of the Edge server used by the user who participated in the session.

UserFlag

smallint

Indicates the attributes of the user who participated in the session. The following attribute definitions allowed:

0x01 - Integrated with desktop phone

CallFlag

smallint

Indicates the call attributes. The following attribute definitions are allowed:

0x01 - Retried Session0

x02 - A call made by agent on behalf of a Response Group