ProgressReport table in Lync Server 2013
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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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. |