Cloudera Navigator Audit Database clean up?

Mondi — Mon, 18 May 2020 01:59:05 GMT

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

Re: Cloudera Navigator Audit Database clean up?

paras — Tue, 19 May 2020 14:27:40 GMT

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.

question Re: Cloudera Navigator Audit Database clean up? in Support Questions

Cloudera Navigator Audit Database clean up?

Re: Cloudera Navigator Audit Database clean up?

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