How to use Audit History Report filters

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

While selecting Application Filters on report we don't see the correct filter getting applied and it always show the records not belonging to applications selected.

Environment

Release : 6.x

Component :CA RELEASE AUTOMATION REPORTING

Cause

The query get called from Audit report where it call if the application-id=<APP-ID> or NULL.

SELECT
id , action , applicationId , comments , entity , entityId , executableId , fqn , newValue , oldValue, processId , revisionId , timestamp , username 
FROM auditreportentry
WHERE (applicationId in (x,y,z) OR applicationId IS NULL)

Resolution

As per current design when a user applies an application filter it select the records belonging to specific application along with records where application id is NULL. There are entity filters available in the Audit History Report, which can be used by user to filter records to get specific records.

There are numerous entity type filters available which should be set.

The filters can be set as below