XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Chapter 3. Configuring Filters and the FILTERS File
XYPRO Technology Corporation 50 Proprietary and Confidential
You create Filters to tell the MOVERs to do something besides writing records to the
XMA database. For example, if you do not want something added the database, create
a Filter with an ACTIONTYPE of IGNORE. Then audit events matching the selection
criteria in this IGNORE Filter will not be written to the database, but everything else will
be.
DATA Selection Criteria is used to select audit events based on the contents of the
normalized audit data record. The MOVERs normalize the data for each record in their
target products audit trail, which means that they move the contents of each field to
the appropriate columns for insertion in the XMA database. Every column that is
utilized for a given target product is available for generating an ACTION in a Filter.
Syntax:
<table name>.<column name> <operator> <value to trigger the action>
Table Name The two table names used most often are AUDIT and SESSION.
Every audit event generates one SESSION entry in the Audit
Session (AUDSESS) table entry and from one to many detail
records in the Audit Detail table (AUDDET).
Column Name The column name that contains the data you are using to select
records.
Operator =, <>, LIKE, NOTLIKE, CONTAINS, NOTCONTAIN, etc. Refer to
the Operators list on page 43.
Value All or part of the column contents that you wish to use to include or
exclude audit records.
FILTERTYPES
The available Filter types are STRINGFILTER, NOFILTER, and MACROFILTER.
The STRINGFILTER type tells the MOVER that you wish to make a selection based
on the contents of one or more fields within the following tables:
AUDITSESSION Specified as "SESSION" for data selection.
AUDITDETAIL Specified as "AUDIT" for data selection.
AUDITPRODUCT Specified as "PRODUCT" for data selection.
AUDITINSTALL Specified as "INSTALL" for data selection.
The STRINGFILTER is the most common FILTERTYPE that you will use.
The NOFILTER is a _null Filter. All data records would match this FILTERTYPE. It is
recommended that you use this only when you want to gather all events for the
specified MOVER.