Media table in Lync Server 2013

 

Topic Last Modified: 2012-09-28

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 Lync Server 2013 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 Lync Server 2013 for more information.
MediaId	tinyint	Primary, Foreign	Unique number identifying this media type. See the MediaList table in Lync Server 2013 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.