XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix E: XMA Host Macros
XYPRO Technology Corporation 214 Proprietary and Confidential
The Letter T denotes TODAY. The following example will generate a report for the
current day.
Example:
?tacl macro
#frame
[#push
t_t1
]
xma_datetime_make t
#set t_t1 [xma_dt_year4]-[xma_dt_month]-[xma_dt_day] 00:00
xma_datetime_make t
#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
ALL == outcome
$DATA.XMATBLS == XMA audit subvol
$S.#xygate.xmarep == output location
TIME == sort order
== operation
== debug
== rulename
]
#unframe
$DATA MAWORK 10> run xma1day
SQL Conversational Interface - T9191D46 - (31MAR01)
COPYRIGHT HP COMPUTER CORPORATION 1987-2001
--- 15628 row(s) selected.
End of SQLCI Session
E11: XMA_DBVOLUME
The XMA_DBVOLUME command will take you to the volume, subvol location of your
SQL database.
Syntax
XMA_DBVOLUME