Question
PayPal
IN
Last activity: 6 Jul 2023 11:00 EDT
Details of column needed from PR_DAILY_USAGE table
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
Accepted Solution
Updated: 6 Jul 2023 11:00 EDT
Pegasystems Inc.
GB
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:
https://support.pega.com/question/unable-understand-daily-usage-reports-log-license-usage-daily-list
https://support.pega.com/question/how-calculate-usage-summary-using-data-prdailyusage-table
https://support.pega.com/question/usage-summary-report
The Pega 7.x documentation:
How to analyze system-wide usage with the Log-Usage class
For current Pega functionality:
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:
https://support.pega.com/question/unable-understand-daily-usage-reports-log-license-usage-daily-list
https://support.pega.com/question/how-calculate-usage-summary-using-data-prdailyusage-table
https://support.pega.com/question/usage-summary-report
The Pega 7.x documentation:
How to analyze system-wide usage with the Log-Usage class
For current Pega functionality:
Usage metrics for applications with the Interactions and Interactions Per Node landing pages