Article Content
Article Number | 000033887 |
Applies To | RSA Product Set: RSA Identity Governance and Lifecycle RSA Product/Service Type: Appliance |
Issue | At a number of customer sites we are seeing larger amounts of data. Often some of this data does not appear to be vital to auditors and while important to ACM while doing the work, they are probably candidates for cleanup after the work is complete. Similarly, there are a number of tables that may hold a few months worth of data instead of holding data forever. We will be seeing how to prune, that is, cleanup what is not needed long term, from the data in RSA Via Lifecycle and Governance. |
Resolution | Access Request PruningUsing your SQL tool of choice, run the stored procedure providing a date we should prune from the database. We will clean data for any requests that are in a final state created on or before this date. EXECUTE Data_Retention_Pkg.Prune_Access_Request(TO_DATE('27-08-2016','DD-MM-YYYY')); This example will remove the unneeded data for any completed/cancelled change requests that was created on or before August 27, 2016. You could also use SYSDATE – n days rather than type an explicit date in if you wanted to do a relative n days type of call. EXECUTE Data_Retention_Pkg.Prune_Access_Request(SYSDATE-30);
|