Symptoms

In Data Certification, when running certification audits, the filter on the template is being ignored.

Example scenario:

• Certification audit "CertAudit" has been configured to use "CertAuditTempl" as a template;
• "CertAuditTempl" runs on cmdb_ci table and uses "CertAuditFilter" as a filter;
• "CertAuditFilter" filters cmdb_ci table to a specific manufacturer resulting in 100 records (cmdb_ci has 100000 records in total);

When running the Certification Audit, 100000  audit records are created instead of just the 100 from the filter.

Release

All releases.

Cause

The user set to "Run As" on the certification audit definitions does not have access to the certification filter (cert_filter) table. For that reason, the script is ignoring the filter configurations.

Resolution

Set the "Run As' user to a proper user on the Certification Audit.