Topic Last Modified: 2012-09-28

The Dialogs table is a supporting table that stores the information about DialogIDs for peer-to-peer sessions.

Column Data Type Key/Index Details

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.

ExternalChecksum

int

 

Checksum of the ExternalID. This field is used to increase the speed of database searches.

ExternalId

varbinary(775)

 

SIP dialog ID, stored as a binary. The format of the binary is:

dialog;from-tag;to-tag

This data can be converted to text format by using this syntax:

cast(cast(ExternalId as varbinary(max)) as varchar(max))