User Activity 2

sprpt_UserActivity2 Stored Procedure

User Activity 2

A reporting stored procedure used for the following report(s): User Availability Detail, User Availability Summary. These reports can be found in the Legacy Reports category. The stored procedure uses the following table(s) to gather its data set: AgentActivityLog, 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.