ProgressReport Table

 

Topic Last Modified: 2010-11-08

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 Microsoft Lync Server 2010 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 report. Reference to the ErrorReport Table.

ErrorId

int

Primary, Foreign

ID number used in conjunction with ErrorTime, ProgressReportSeq to uniquely identify a progress report. Reference to the ErrorReport Table.

ProgressReportSeq

int

Primary

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

ApplicationId

int

Foreign

The Lync Server process that the report is about. Reference to the Application Table.

Detail

image

 

Progress report details, stored in binary format to save space.

This data can be converted to text format using: cast(cast(Detail as varbinary(max)) as varchar(max)) .