Posted: 18 Mar 2021 11:39 EDT Last activity: 19 Mar 2021 6:09 EDT
PR_HOURLY_USAGE data retention period
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.
***Edited by Moderator: Pooja Gadige to add platform capability tag***
@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.
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'
Where pzPeriodEnding >= '2018-05-21' and pzUserType = 'H'
Group By pzPeriodEnding,pzUserType,pzNodeName
Order by pzPeriodEnding DESC
@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!