Question
BNP Paribas
IN
Last activity: 9 Nov 2018 14:58 EST
Information on Columns in PR_DAILY_USAGE, PR_HOURLY_USAGE, PR_USAGE_SUMMARY
Hi All,
Can anyone please help with understanding the meaning of the below columns and also their purpose. I have gone through couple of help articles but they do not provide much information.
Table PR_DAILY_USAGE
PZINTERACTIONCOUNT, PZINVOCATIONCOUNT,PZNOINVOCATIONUSERCOUNT - ?
PZUSAGEHOURSCOUNT - Is this the actual number of hours the user was logged in to the application ?
Table PR_HOURY_USAGE
PZINTERACTIONCOUNT, PZINVOCATIONCOUNT - ?
***Edited by Moderator Marissa to update categories***
Cognizant Technology Limited
IN
Hi Mahendra,
At this point of time I don't have hands on information about the columns, However we have an information about usage summary how it's manipulated and information about PRPC tables PR_USAGE_SUMMARY, PR_DAILY_USAGE, PR_HOURLY_USAGE.
Pega provides a stored procedure(SPPR_AGGREGATE_USAGE) in the PegaRULES schema which summarizes hourly data in pr_hourly_usage and daily usage in pr_daily_usage tables.
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
BNP Paribas
IN
Thanks for the response.
We would really want to understand the meaning of those columns.
It would be helpful as we could get the User activity information (number of hours he was active and using the application, etc.) from this table instead of customizing and creating our own.
Citigroup Inc
IN
We are also looking for an option to track user activity, particularly to track the number of hours a user was actively using the application. It would be helpful if anyone can provide details on this.
Auto-Owners Insurance
US
Hello, this topic relates to a current interest of mine. I am trying to figure out what process updates PR_HOURLY_USAGE. I know that SPPR_AGGREGATE_USAGE reads the table but not what writes to it. Any help available in that regard? Thanks.