XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Chapter 3. Configuring Filters and the FILTERS File
XYPRO Technology Corporation 57 Proprietary and Confidential
Option 2:
|(SUBSTR(<table>.<column name>,<start>,<length))|
Where:
SUBSTR
is an optional parameter that allows you to select part of a column.
<start>
is the position in the column where you want to start. 1 is the first position.
<length>
is the number of characters you wish to select.
Example 2
alertstring |(substr(audit.recordlct,1,10))|
alertstring -
alertstring |(substr(audit.recordlct,12,8))|
The example above separates the Date and Time portions of the column
RECORDLCT with a hyphen in between. It would display as:
2012-10-24-23:00:01
Data is available from the following tables:
PRODUCT Appendix C2: on page 185.
INSTALL Appendix C3: on page 186
SESSION Appendix C4: on page 187
AUDIT Appendix C5: on page 188
Refer also to the above appendices for the column names.
EMS alerts are defined by ACTIONTYPE = ALERT
If you wish to generate EMS alerts, you must configure the following parameters in the
appropriate Filters:
ALERTTARGET
{\<system.$0} - Defines the EMS collector where the
MOVER will send the EMS message . The default is $0 on the
local node. You can, by entering the pathway node name,
send all the ALERTS for all the nodes on your network to the
EMS collector located on the Pathway node.
ALERTSEVERITY
{CRITICAL | NONCRITICAL}
- Indicates whether or not this
message should be treated as critical within EMS. The default
is NONCRITICAL.
ALERTEMSEVENTNUMBER
You can assign an event number to your EMS message. The
value range is between 1,000 and 32,767. This parameter is
optional. The default is value is 101.
ALERTSTRING
This is the "title" text of the message. The default value is the
contents of the AUDIT.RESULT column. You can include Data
Substitution Tokens.