search cancel

How to use Audit History Report filters

book

Article ID: 243276

calendar_today

Updated On:

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.

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)

Environment

Release : 6.x

Component :CA RELEASE AUTOMATION REPORTING

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

Attachments