Conferences table in Skype for Business Server 2015
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 Skype for Business Server 2015 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 for more information. |
| OrganizerId |
Int |
Foreign |
ID number to identify the organizer URI of this conference. See the Users table 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. |
|
| LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |
* 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.