Session Table
Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.
Each record represents one session which involves audio or audio/video; it contains overall information about the session. A session is defined as an audio or video SIP dialog between two endpoints.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
ConferenceDateTime |
Datetime |
Primary |
Time when the QoE agent receives the first report from either caller or callee; used in conjunction with SessionSeq to uniquely identify a session. |
SessionSeq |
Int |
Primary |
Sequence number to differentiate sessions when they have the same ConferenceDateTime. |
SessionID |
varchar(256) |
|
DialogID which is globally unique. |
Checksum |
Int |
Index |
Checksum of SessionID, for internal use only. |
ConferenceKey |
Int |
Foreign |
Conference key, referenced from the Conference Table. |
CorrelationKey |
Int |
Foreign |
Correlation key, referenced from the SessionCorrelation Table. |
DialogCategory |
bit |
|
Dialog category; 0 is OCS to Mediation Server Leg, 1 is Mediation Server to PSTN gateway leg. |
StartTime |
Datetime |
|
Call start time. |
EndTime |
datetime |
|
Call end time. |
CallerPool |
Int |
Foreign |
The pool of the caller, referenced from the Pool Table. |
CalleePool |
Int |
Foreign |
The pool of the call receiver, referenced from the Pool Table. |
CallerPAI |
Int |
Foreign |
SIP URI in the SIP p-asserted identity (PAI) from the calling endpoint, referenced from the User Table. |
CalleePAI |
int |
Foreign |
SIP URI in the SIP p-asserted identity (PAI) of the receiving endpoint, referenced from the User Table. |
CallerURI |
Int |
Foreign |
Caller’s URI, referenced from the User Table. |
CalleeURI |
int |
Foreign |
Call receiver’s URI, referenced from the User Table. |
CallerEndpoint |
Int |
Foreign |
Caller’s endpoint, referenced from the Endpoint Table. |
CalleeEndpoint |
int |
Foreign |
Call receiver’s endpoint, referenced from the Endpoint Table. |
CallerUserAgent |
Bit |
Foreign |
Caller’s user agent, referenced from the UserAgent Table. |
CalleeUserAgent |
Bit |
Foreign |
Call receiver’s user agent, referenced from the UserAgent Table. |