|Applies To||RSA Product Set: Adaptive Authentication (OnPrem)|
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.3
O/S Version: 6
|Issue||As discussed in our call, currently offline tasks are purging records in EVENT_LOG more than 180 days. We are planning to reduce EVENT_LOG table history from 180 days to 120 or 90 days. Can you create a case to analyze possible impacts on Risk Score/Risk Analysis if we go for this change? Here is some statistics for Risk Score usage inside Rules in Production status: Org Total # of Prod Rules Total # of Prod rules using Risk Score in their condition Org 1 26 10 Org 2 13 5|
|Resolution||Engineering provided this to be run from sql plus as schema owner to purge the EVENT_log table.|
Please run this when the offline task is not running. You can run this online, no need to take an outage.
This should not take that long. This should reduce the size to 120 days.
You can run this in production before upgrading to 7.3 to reduce the EVENT_LOG to 120 days.
No need to purge any other tables. Please test it and let me know if there are any questions.