FDM Audit report does not show values for unmasked data

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In our testing, we are experiencing what we consider to be inconsistent behavior in TDM audit reports during the data masking process. Specifically, columns containing values that remain unchanged (not masked or masked) are not recorded in the audit report, even when the AUDIT=ALL option is used. Our expectation is that all rows of data should appear showing the original value → original value.

For example, we would like to mask a specific list of cities using the FIXED function to "Toronto". We are using a WHERE condition to match on the city names:

WHERE lower(city) IN ('belleville','shawinigan','dollard-des ormeaux','cornwall','north vancouver','vernon','blainville','west end','chatham','timmins','chateauguay','quinte west','west vancouver','charlottetown')

In the audit log, we are missing the row of data where the original city Toronto does not show in the report ("City","FIXED","Toronto","Toronto")

Environment

ALL Supported FDM releases

Cause

 

 

Resolution

The FDM auditing is working as designed.

When using a WHERE conditions, FDM only fetches the data that meets the WHERE condition. Therefore, rows that do not meet the condition are never fetched by FDM, and therefore, they will not be included in the audit log. The audit logs only contains the rows of data that were masked. Rows not touched by FDM are not reported.