Tracking daily Job scheduler case processing without adding a custom flag

General
,
1

Hello everyone,

Problem Statement:
We need to know how many cases a Job scheduler process each day and then display the processed cases in a Report definition. Due to company policies, we can’t add a new flag/property to track this.

We have look at properties such as pxUpdateOpName, pxUpdateOperator and pyLastUpdatedBy, but we are not sure whether any of them can identify cases that were processed.

Is there any standard property or other mechanism that indicates a case was processed by a Job scheduler? If so, can that property be used as a filter or column in a Report Definition?

Thanks in advance for your help

2

If you join with History-Work class and assuming you’re on 25.x, then probably you can check how many cases process that particular step (pxTaskLabel) for each day.

3

you may use pxCommitDateTime and aggregate function to count cases in a report definition group by pxCommitDateTime to fetch number of cases updated by JS .Query will be like Select pxCommitDateTime,count(*) from Work Table group by pxCommitDateTime.