Data Masker Logo

[Net 2000 Ltd. Home][Data Masker Home][Data Masker Manual][Data Masker FAQ]

The Data Masker Audit Table

The Data Masker software requires an audit table to be present in the target database. The audit table is always named DMS_AUDITTAB and is used to record the rules as they execute. The audit table makes it possible to determine which masking rules have been executed in the database and also makes it possible to restart the rules if an error occurs.

The audit table can be emptied at the start of each masking set run by choosing the Truncate audit table before each run option on the Misc. Setup Tab.

The structure of the Audit Table

The Audit table has the structure shown below.

--
-- copyright (c) 2008 - Net 2000 Ltd. All rights reserved
--                  www.DataMasker.com
--
-- The Data Masker audit table records the successful completion
--   of the masking rules. This makes restarts and auditing
--   possible.
-- 

drop table [DMS_AUDITTAB];
CREATE table [DMS_AUDITTAB]
(
   completion DateTime,
   runid varchar(100),
   ruleblock int,
   ruleid int,
   ruletype varchar(50),
   target varchar(100),
   runtime decimal,
   checkval int,
   status char
);

completion
The Sql Server timestamp indicating the date and time of the rule completion.

runid
Multiple runs of same masking set (or different masking sets) can be recorded in the audit table. This field indicates the set name and the start time of the masking set and allows the records for individual runs to be selected.

ruleblock
The ruleblock of the rule recorded in that audit table row.

ruleid
The ruleid of the rule recorded in that audit table row.

ruletype
A summary of the rule type of the rule recorded in that audit table row.

target
The target table or object of the rule recorded in that audit table row.

runtime
The execution time in seconds of the rule recorded in that audit table row.

checkval
A checksum for the rule. This permits the audit table entries to be checked against a known list to see if previously tested and validated rules have been updated or modified. For rule types of New Run Marker, which indicate the start of a masking set run, the checksum value is the checksum of the collection of rules and also the Data Masker options configuration.

status
The status of the rule. Will always be a C if the rule successfully completed.

The audit table is usually created in the target database when the masking set is created by the New Masking Set Wizard button on the Data Masker Main form. The audit table can also be created or dropped using the tools on the options tab of the Rule Controller form. If an audit table is not present in the target database, the Missing Audit Table Form (as shown below) will be displayed.

The Missing Audit Table Form

The Missing Audit Table Form


[Net 2000 Ltd. Home][Data Masker Home][Data Masker Manual][Data Masker FAQ]