Data retention configured as 90 days for Hourly data and 365 Days for daily sample data.
We need to verify the data retention rollup running properly & old data does it deleting or not ? Please help us on this.
Release : 2.94
Component : CA CAPACITY MANAGER
The rollup data is stored in the CCC database, as follows:
The hourly and daily tables also contain group level metrics used by CCC
Run below select commands from CCC database
select min(insert_date) as first, max(insert_date) as Last from entity_hour_fact
select min(insert_date) as first, max(insert_date) as Last from entity_day_fact
select min(insert_date) as first, max(insert_date) as Last from entity_baseline_fact