Question
Pegasystems Inc.
GB
Last activity: 19 Mar 2021 6:09 EDT
PR_HOURLY_USAGE data retention period
Hello
My insurance client operates one of the world's biggest market place. They are in the process of going live with a market wide application and as such want to keep an eye on the usage and adoption of the new system. Our partner on the ground is developing a report based on the stats collected by our platform in the PR_HOURLY_USAGE database table. Can you please let me know what is the retention period of records in this table? And if there is a way to prevent housekeeping job from purging records from this table without causing any adverse effects. The system is on Pega Cloud.
Many thanks in advance.
Ford Motor Company
US
@RishiSinha I didn't see any House Keeping activities goes against that particular table. Hence the retention period is as long as Customer wish to keep it. I've seen 2011 Hourly usage data even now.
These are couple quaries I use often on MS SQL Server. You can either use thiese sqls or use AES/PDC to run the Enterprise Charts to get this information.
Dailu Usage:
SELECT pzUsageDay,COUNT(*) As 'NoOfOnlineUsers' FROM [DatabaseName].[dbo].[pr_daily_usage] Where pzUsageDay >= '2018-08-01' and pzUsageDay <= '2018-08-31'and pzUserType = 'H' GROUP BY pzUsageDay,pzUserType Order by pzUsageDay DESC
Hourly Usgae by Node:
SELECT TOP 5000 [pzPeriodEnding] As 'Hr of the Day',pzNodeName,COUNT(*) As 'No Of Online Users Per Hr' FROM [DatabaseName].[dbo].[pr_hourly_usage] Where pzPeriodEnding >= '2018-05-21' and pzUserType = 'H' Group By pzPeriodEnding,pzUserType,pzNodeName Order by pzPeriodEnding DESC
Pegasystems Inc.
GB
@SUMAN_GUMUDAVELLY - Thank you very much for the very prompt response! Much appreciated.
Maantic Inc.
IN
There is a OOTB activity Log-.TrimLog which accepts a concrete class and an ancestor of Log- class as a parameter
If you wish to purge data from Log-License-Usage-Hourly, you might want to try this activity.
Pegasystems Inc.
GB
@Tanay Kumar Bal Thank you Tanay. The customer's requirement is not to truncate the data; however, this is incredibly useful piece of information as at some point in the future they will need to start house keeping on this table. Thanks again for the help!