Cloudera Navigator Audit Database clean up?

[#1]

Is it okay to do some clean up on mysql database of Cloudera navigator Audit?

[#2 · Accepted solution]

@Mondi 

The property setting the retainment period can be found at: Cloudera Manager -> Cloudera Management Service -> Configuration -> and in the search field please type: "Navigator Audit Server Data Expiration Period"

After reducing this retention period and restarting the Nav Audit server role, the tables/data should be purged.

 If you still see old audit data remaining you can proceed with manual purging:

Connect to your database.
> show databases;
> use <nav_audit_database>;
> show tables;
> drop table <audit_event_table>;

You can also set audit filters for difffernt services to have a control on audit collection.

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cn_admcfg_audit_filters.html

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.