Media table

Each record represents one media type used in a peer-to-peer session. One session would be represented by multiple records in the table, if more than one media type is used.

Note

The Media table should not be used to calculate the media duration for a session. This table contains the signaling details of media exchange in a session. Media exchange is done by the INVITE request, and StartTime indicates the time that the INVITE was sent out. The invite time does not necessarily mean the media start time, because media starts only after the sessionee accepts the session. The EndTime usually means the end time of this session.

Column Data Type Key/Index Details
SessionIdTime
datetime
Primary, Foreign
Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
SessionIdSeq
int
Primary, Foreign
ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
MediaId
tinyint
Primary, Foreign
Unique number identifying this media type. See the MediaList table for more information.
StartTime
datetime
Primary
This is the time that a media request was sent out, not the real media start time. StartTime includes the session setup time.
EndTime
datetime
This is the end time of the session.