ErrorReport view in Lync Server 2013
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 in Lync Server 2013 for more information. |
FromTenant |
nvarchar(256) |
Tenant of the user who originated the error. See the Tenants table in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 Lync Server 2013 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 Lync Server 2013 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 in Lync Server 2013 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 Lync Server 2013 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. |