Topic Last Modified: 2013-01-22

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 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 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 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.