Queue Snapshot Comparison (Data Source)

BPDS_QueueSnapshotComparison

Returns queue snapshot data for today’s date using the timezone specified in the snapshot configuration, and compares the data with the same statistic from a previous day’s snapshot data.

Source: Blue Prism Database - Live tables and MI Repository (requires collect utilization and productivity statistics to be enabled under Settings - Reporting).

Sample Chart

Queue Snapshot Comparison

Parameters

Parameter Name Data Type Description Validation
@QueueName Text Enter the name of the queue to be queried. None
@NumberOfSnapshottedDaysPrevious Integer

Enter the number of days to count back from today in order to select the snapshot data to be used in the comparison.

Only the days that are scheduled to have snapshot data taken are included in the count. For example, if today is Monday and snapshots are scheduled to occur every day, entering a value of 1 will compare the snapshots for today (Monday) and yesterday (Sunday). However, if snapshots are scheduled to only occur Monday to Friday, then entering a value of 1 will compare the snapshots for today (Monday) and the previous Friday.

None
@ColumnIdentifier Integer Enter one of the following values to select which metric from the snapshot data to use when comparing the two sets of data:
  • 1 – the total number of items in the queue at the time of the snapshot. This is the default.
  • 2 – the total number of pending items in the queue at the time of the snapshot.
  • 3 – the total number of completed items in the queue at the time of the snapshot.
  • 4 – the total number of referred items in the queue at the time of the snapshot.
  • 5 – the total number of new items added to the queue since the last snapshot was taken.
  • 6 – the total number of items marked as completed in the queue since the last snapshot was taken.
  • 7 – the total number of items marked as referred in the queue since the last snapshot was taken.
  • 8 – the total work time (in seconds) of all items completed in the queue since the last snapshot.
  • 9 – the total work time (in seconds) of all items referred in the queue since the last snapshot.
  • 10 – the total time spent waiting in the queue (in seconds) of all items completed or referred items since the last snapshot.
  • 11 – the total number of new items brought into the queue since midnight, using the time zone configured for the queue.
  • 12 – the total number of new items brought into the queue in the last 24 hours.
  • 13 – the average work time (in seconds) of an item marked completed in the queue this snapshot.
  • 14 – the average work time (in seconds) of an item marked referred in the queue this snapshot.
  • 15 – the average time spent waiting in the queue (in seconds) of an item completed or referred this snapshot.
 1 to 15
@TimeRangeStartTime Text

Enter the time from which to display queue data. If not specified then all time intervals will be displayed using the configuration applied to the queue.

HH:mm (e.g. '01:15', '13:50', '22:10')
@TimeRangeEndTime Text

Enter the time up to which to display queue data. If not specified then all time intervals will be displayed using the configuration applied to the queue.

HH:mm (e.g. '01:15', '13:50', '22:10')