XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix E: XMA Host Macros
XYPRO Technology Corporation 213 Proprietary and Confidential
E10: XMA_DATETIME_MAKE
The XMA_DATETIME_MAKE macro will calculate a date in the past equal to the
<days> entered. This macro can be used to calculate dates and create date ranges to
include in a customized XMA report.
For example, if you enter 7, the macro will calculate the date seven days prior to the
current date. An entry of 30 or 31 would be one month into the past. You can enter up
to 3000 days in the past.
The macro can be run on the command line or used in a TACL macro or SQLCI report
to create ad-hoc or batch jobs. In the example below, the macro is run twice: once to
calculate the date seven days in the past (line 6), and once to calculate the date one
day in the past (line 8). These values are put together and passed to the
XMA_AUDIT_REPORT macro beginning on line 10 as selection criteria to generate a
report.
This example will produce a report of failed operations for the last seven days, sorted
by TIME, and written to the spooler with a location of $S.#XYGATE.XMAREP
Syntax:
XMA_DATETIME_MAKE <# days in the past>
Example: (In a TACL macro)
?tacl macro
#frame
[#push
t_t1
]
xma_datetime_make 7
#set t_t1 [xma_dt_year4]-[xma_dt_month]-[xma_dt_day] 00:00
xma_datetime_make 1
#set t_t1 [t_t1] [xma_dt_year4]-[xma_dt_month]-[xma_dt_day] 23:59
[xma_audit_report
[t_t1] == date range
*.* == user
== login name
== terminal
== system
== objecttype
== object name
FAIL == outcome
$DATA.XMATBLS == XMA audit subvol
$S.#xygate.xmarep == output location
TIME == sort order
== operation
== debug
== rulename
]
#unframe
6
8
10