Question
CIBC
CA
Last activity: 6 Jul 2023 11:00 EDT
How to get data from PR_DAILY_USAGE, PR_HOURLY_USAGE table
We are looking for an option to track user activity, particularly to track the number user actively using the application in the peak hours daily/weekly.
It would be helpful if anyone can provide details on how to get data from PR_DAILY_USAGE, PR_HOURLY_USAGE table
Pegasystems Inc.
GB
@Deeba Guru please review the Suggested Content when you input your search key words:
How to calculate Usage Summary using data from pr_daily_usage table
Information on PR_DAILY_USAGE table
Details of column needed from PR_DAILY_USAGE table
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:
@Deeba Guru please review the Suggested Content when you input your search key words:
How to calculate Usage Summary using data from pr_daily_usage table
Information on PR_DAILY_USAGE table
Details of column needed from PR_DAILY_USAGE table
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