ErrorReport table in Skype for Business Server 2015
The ErrorReport table stores information about errors that have occurred. Each record is one error occurrence. The errors are captured either by the CDR agent running on the front-end server or sent from the client.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
| ErrorTime |
datetime |
Primary |
Date and time the error occurred. |
| ErrorReportSeq |
int |
Primary |
ID number to identify the error report. Used in conjunction with ErrorTime to uniquely identify an error report. |
| ErrorId |
int |
Foreign |
Unique ID of the error type. See the ErrorDef table in Skype for Business Server 2015 for more information. |
| FromUserId |
int |
Foreign |
User who originated the request that caused the error. See the Users table for more information. |
| ToUserId |
int |
Foreign |
Destination user for the request that caused the error. See the Users table for more information. |
| ConferenceUriId |
int |
Foreign |
Conference URI related to the error. See the ConferenceUris table in Skype for Business Server 2015 for more information. Typically, if ConferenceUriId is not null, then either FromUserId or ToUserId will be null. |
| SessionIdTime |
datetime |
Foreign |
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 |
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. |
| SourceId |
int |
Foreign |
Server that sent the error report (if the report is being sent from a server component). See the Servers table for more information. This field was introduced in Microsoft Lync Server 2013. |
| ApplicationId |
int |
Foreign |
Server that sent the error report (if the report is being sent from a server component). See the Application table in Skype for Business Server 2015 for more information. This field was introduced in Microsoft Lync Server 2013. |
| MsDiagHeader |
image |
More information about the error. This data can be converted to text format by using this syntax: cast(cast(Detail as varbinary(max)) as varchar(max)) |
|
| ClientVersionId |
int |
Foreign |
The client version of endpoint that sends the error report. See the ClientVersions table in Skype for Business Server 2015 for more information. |
| IsCapturedByServer |
bit |
Is the error report captured by the CDR agent running on the front-end server, or sent by the client. |
|
| Flag |
smallint |
Reserved for future use. |
|
| TelemetryId |
uniqueIdentifier |
Unique identifier correlating join time information for the different components involved in a conference. This field was introduced in Microsoft Lync Server 2013. |
|
| SessionSetupTime |
int |
Time (in milliseconds) required for a specific component to join a conference. This field was introduced in Microsoft Lync Server 2013. |
|
| ServerId |
int |
Foreign |
Represents the fully qualified domain name of the server that generated the error report. |
| PoolId |
int |
Foreign |
Represents the fully qualified domain name of the pool where the error report was generated. |
| LastModifiedTime |
Datetime |
For internal use by the Monitoring service. This field was introduced in Skype for Business Server 2015. |