ErrorReport table in Lync Server 2013

 

Topic Last Modified: 2012-09-28

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 Lync Server 2013 for more information.
FromUserId	int	Foreign	User who originated the request that caused the error. See the Users table in Lync Server 2013 for more information.
ToUserId	int	Foreign	Destination user for the request that caused the error. See the Users table in Lync Server 2013 for more information.
ConferenceUriId	int	Foreign	Conference URI related to the error. See the ConferenceUris table in Lync Server 2013 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 Lync Server 2013 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 Lync Server 2013 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 in Lync Server 2013 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 Lync Server 2013 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 Lync Server 2013 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.