Productivity D2

sprpt_Productivity_d2 Stored Procedure

Productivity D2

A reporting stored procedure used for the following report(s): User Productivity Detail. These reports can be found in the Legacy Reports category. The stored procedure uses the following table(s) to gather its data set: IAgentQueueStats_NoCnfg, Individual.

  • Last Changed Version - 16.2.0.342
  • Last Changed Reason - Updated for fixing dynamic where clause lengths.

SQL Parameter Definitions

Column Parameter Direction Data Type (Size) Description
@WhereClause INPUT nvarchar (MAX)

Filters the data set based on the selected filtering options.

@OrderClause INPUT nvarchar (2048)

Orders the data set based on the selected ordering options.