@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.