Topic Last Modified: 2012-09-28

Progress reports are based on data uploaded by the client to the database after a call or session is completed. Progress reports will be written only for calls and sessions that Lync Server 2013 determines might be useful for diagnostic purposes.

The ErrorTime, ErrorReportSeq and ProgressReportSeq fields don’t necessarily refer to errors but to messages that indicate the status of calls or messages.

Column Data Type Key/Index Details

ErrorTime

datetime

Primary, Foreign

Date and time of the progress error report that contains this progress report. See the ErrorReport Table for more information.

ErrorId

int

Primary, Foreign

ID number used in conjunction with ErrorTime, ProgressReportSeq to uniquely identify a progress report. See the ErrorReport Table for more information.

ErrorReportSeq

int

Primary, Foreign

ID number that identifies the error report. ErrorReporSeq is used in conjunction with ErrorTime to uniquely identify an error report. See the ErrorReport Table for more information

This field was introduced in Microsoft Lync Server 2013.

ProgressReportSeq

int

Primary

ID number to identify the progress report. Used in conjunction with ErrorTime and ErrorReportSeq to uniquely identify a progress report.

MsDiagId

int

Diagnostic ID of the progress report.

This field was introduced in Microsoft Lync Server 2013.

SourceId

int

Foreign

Server that sent the error report (if the report was sent from a server component). See the Servers Table for more information.This field was introduced in Microsoft Lync Server 2013.

ApplicationId

int

The Lync Server process that the report is about. See the Application Table for more information.

Detail

image

Progress report details, stored in binary format to save space.This data can be converted to text format using this syntax:

cast(cast(Detail as varbinary(max)) as varchar(max))

TelemetryId

uniqueIdentifier

Unique identifier that correlates 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) for a specific component to join a conference.

This field was introduced in Microsoft Lync Server 2013.