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

@michaelli    You can use the CM API to fetch the service configurations by executing below command from terminal   # curl -u admin_uname:admin_pass "http://cm_server_host:7180/api/v19/cm/deployment" The password should be present under the name :  hive_metastore_database_password Refer: https://docs.cloudera.com/documentation/enterprise/5-14-x/topics/cm_intro_api.html#concept_dnn_cr5_mr__section_ztf_lyt_xr   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. ... View more

Hello,    we fixed it, it was a memory problem.   please close it.    best regards,   Simon ... View more