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: cast(cast(ExternalId as varbinary(max)) as varchar(max))