Question
Cox Communications
US
Last activity: 17 Oct 2022 4:05 EDT
More information on Log-ReportStatistics
Is there any documentation available on how the logging is done in the class 'Log-ReportStatistics'? By more documentation, I mean the significance of certain columns/fields in this class.
For example, how and why does the field 'PXREPORTEXECUTIONCOUNT' has a value of more than 1? If a report is being executed, it would be executed once always at a particular given instance, or is this a cumulative value in the time range when the statistics are gathered in the log table?
NCS Pte. Ltd
SG
Hi @SaurabhA7126: I don't see a dedicated documentation for this. Instead please find my views.
PEGA OOTB agent Pega-RulesEngine . ReportStatUsageAgent is responsible for capturing these details. There are few configs (DSS) which controls it too. Please refer https://support.pega.com/question/reports-statistics-are-not-captured-log-reportstatistics-my-reports for those. Using this data, you can monitor your system and can do performance tunings too. Report usage dashboard will give you some default reports which are available (in the same class) to fetch the results. You can use them (or) can create your own reports using them as base. Refer: https://docs-previous.pega.com/reporting/86/reviewing-usage-report-statistics?
Regarding your other question on PXREPORTEXECUTIONCOUNT. It need not required to be always 1 because the agent mentioned above will perform the task based on the interval mentioned. Between 2 runs of agent there is a chance that the same report can be used by the same user more than once.
Some more details can be found here: https://community.pega.com/sites/pdn.pega.com/files/help_v72/rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/related.htm (see "Collecting and reviewing statistics about report usage" section)
Please let me know if this helps.
Thanks