Queue Service Level 2

sprpt_QueueServiceLevel2 Stored Procedure

Queue Service Level 2

A reporting stored procedure used for the following report(s): Queue Service Level Report. These reports can be found in the Legacy Reports category. The stored procedure uses the following table(s) to gather its data set: IWrkGrpQueueStats, DQServiceLevel_viw.

  • 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.