ErrorReport view

The ErrorReport view stores information about errors reported. 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. This view was introduced in Microsoft Lync Server 2013.

Column Data Type Details
ErrorTime
datetime
Time of error occurred. Used in conjunction with ErrorReportSeq to uniquely identify an error.
ErrorReportSeq
int
ID number to identify the error. Used in conjunction with ErrorTime to uniquely identify an error.
MsDiagId
int
Diagnostic ID for the error report.
FromUri
nvarchar(450)
URI of the user who originated the error.
FromUriType
nvarchar(256)
Type of URI of the user who originated the error. See the UriTypes table for more information.
FromTenant
nvarchar(256)
Tenant of the user who originated the error. See the Tenants table for more information.
ToUri
nvarchar(450)
URI of the user who was the target of the error report.
ToUriType
nvarchar(256)
Type of URI of the user who target of the error report. See the UriTypes Table for more information.
ToTenant
nvarchar(256)
Tenant of the user who target of the error report. See the Tenants table for more information.
ConferenceUri
nvarchar(450)
URI of the conference that was the target of the error report.
ConferenceUriType
nvarchar(256)
URI type of the conference that was the target of the error report. See the UriTypes table for more information.
SessionIdTime
datetime
Time of session request that originated the error report. 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
ID number to identify the session request that originated the error report. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
DialogId
varstring(775)
SIP dialog ID of session that originated the error. The format is:
dialog;from-tag;to-tag
This data can be converted to text format by using this syntax:
cast(cast(ExternalId as varbinary(max)) as varchar(max))
ClientVersion
nvarchar(256)
Version of client used by the user who originated the error.
ClientType
int
Client used by the user who originated the error. See the UserAgentDef table for more details.
ClientCategory
nvarchar(64)
Name of the category of the client used by the user who originated the error.
Source
nvarchar(256)
Name of server that originated the error (if report was sent from a server component).
Application
nvarchar(256)
Name of application that originated the error (if report was sent from a server component).
ResponseCode
int
SIP response code to the session of the SIP message containing the error report.
RequestType
varchar(max)
Type of request that failed.
ContentType
varchar(max)
Content type of the request that failed.
CallType
nvarchar(256)
Type of session. See the CallType table in Skype for Business Server 2015 for more information.
TelemetryId
uniqueidentifier
Unique identifier correlating join time information for the different components involved in a conference.
SetupTime
int
Time (in milliseconds) required for a specific component to join a conference.
IsCapturedByServer
bit
Indicates whether the error report was captured by the CDR agent running on the Front End server, or sent by the client.
Flag
smallint
Reserved for future use.
MsDiagHeader
varchar(max)
Additional information about the error.
FrontEnd
nvarchar
Fully qualified domain name of the Front End server that submitted the report.
Pool
nvarchar
Fully qualified domain name of the pool containing the Front End server that submitted the report.