Conferences table in Lync Server 2013

 

Topic Last Modified: 2012-09-28

Each record in this table contains call details about one conference.

Column	Data Type	Key/Index	Details
SessionIdTime	datetime	Primary	Time that the conference request was captured by the CDR agent. Used only as a primary key to uniquely identify a conference instance.
SessionIdSeq	int	Primary	ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a conference instance. *
ConferenceUriId	int	Foreign	Conference URI. See the ConferenceUris table in Lync Server 2013 for more information.
ConfInstance	uniqueidentifier		Useful for recurring conferences; each instance of a recurring conference has the same ConferenceUri, but will have a different ConfInstance.
ConferenceStartTime	datetime		Conference start time.
ConferenceEndTime	datetime		Conference start time.
PoolId	int	Foreign	ID number to identify the pool in which the conference was captured. See the Pools table in Lync Server 2013 for more information.
OrganizerId	Int	Foreign	ID number to identify the organizer URI of this conference. See the Users table in Lync Server 2013 for more information.
Flag	smallint		A bit mask that contains Conference Attributes. Possible values are: 0X01 Synthetic Transaction
Processed	bit		Internal field used by the Monitoring service. This field was introduced in Microsoft Lync Server 2013.

* For most sessions, SessionIdSeq will have the value of 1. If two sessions start at exactly the same time, the SessionIdSeq for one will be 1, and for the other will be 2, and so on.