Hi Team,
We are checking for browser requestors for our application and how many users are using it on a daily basis.
We are using the PR_DAILY_USAGE with pzUserType as “H”.
Could you please help to understand what does the below columns signify in PR_DAILY_USAGE table?
pzInteractionCount, pzInvocationCount, pzNoInvocationFlowCount
Thanks in advance
@ashwinkumars
Table information:
PR_DAILY_USAGE:
Stores daily usage summaries (Log-License-Usage-Daily class) on requestor and background process use of rules for license compliance.
PR_HOURLY_USAGE:
Stores hourly data summaries on requestor and background process use of rules for license compliance. A rough estimate of number of records is Number of Users * 24 hours * 8 days, the retention period. This table should not be partitioned
PR_USAGE_SUMMARY:
Stores summaries of a customer’s license compliance data; depending on the license configuration, a record can summarize data for a month, a quarter, or a year. Assume the table stores 7 years of quarterly summaries
Please see past forum questions:
Unable to understand Daily Usage reports (Log-License-Usage-Daily List) | Support Center
How to calculate Usage Summary using data from pr_daily_usage table | Support Center
Usage Summary Report | Support Center
The Pega 7.x documentation:
How to analyze system-wide usage with the Log-Usage class
For current Pega functionality:
Creating usage reports
Usage metrics for applications with the Interactions and Interactions Per Node landing pages