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

@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