Please help me with the query to find out how many days historical data is available in the UIM database.
In our environment we had set raw data retention period as 90 days and historical data retention period as 720 days.
Now we are planning to reduce the historical data retention period as 360 days.
We cannot do it in a shot, we have to reduce it gradually. As of now we do not have 720 days in the database .hope it will be lesser than 500 days.To reduce it gradually I just wanted to find out how many days of data is available.
Also please suggest me , will changing the retention period will delete the data automatically, or we have to run any query to delete the data.