XYGATE Merged Audit Reference Manual

XYGATE Merged Audit
®
Reference Manual
Appendix E: XMA Host Macros
XYPRO Technology Corporation 209 Proprietary and Confidential
E8: XMA_AUDIT_REPORT
XMA_AUDIT_REPORT is invoked by the XMA_REPORT macro described in
Chapter 4. It generates an SQLCI report using the criteria selected with the Report
Selection Pane.
The XYGATE Configuration and Audit Reporting manual provides more information for
these selection criteria. Refer to the chapter “XYGATE Audit Report Manager (XRM)”
and look in the section “Design a Report.” (To get this and other XYPRO documents,
refer to the section “Additional XYPRO Reference Manuals” in this manual.)
You can use the XMA_AUDIT_REPORT macro to create custom reports. String the
criteria together in the order shown, on one line, separated by spaces. Do not omit any
criteria. You can use the macro at a TACL prompt, as an obey file, or as part of a
TACL macro for an SQLCI report, either of which can be made into batch jobs.
Note: You must enter all the criteria in the exact order as shown below or the macro
will not function correctly.
You run the macro on the command line in an obey file or in a TACL macro.
Syntax:
XMA_AUDIT_REPORT <from-date> <from-time> <to-date> <to-time> <subject-user>
<subject-login-name> <terminal> <system> <object-type>
<object-name> <outcome> <audit-file-name> <output-filename>
<sort-type> <operation> <debug> <rulename> <product-code>
<alerted> <result> <messagecode> <messageid>
Where:
from-date
The earliest date to be included in the report. Enter in YYYY-MM-DD
format.
from-time
The earliest time on the <from-date> to be included in the report.
Enter in HH:MM format (24-hour format).
to-date
The last date to be included in the report. Enter in YYYY-MM-DD
format.
to-time
The last time on the <to-date> to be included in the report. Enter in
the HH:MM (24-hour format).
subject-user
The subject userid in <group number, user number> format,
or
*,*
for all userids.
subject-login-name
May be any of the following:
• The Guardian userid in <group name.username> format
• SAFEGUEARD alias
• * for all login names.
terminal
All or part of a terminal name or
*
for all.
system
All of part of a valid node name or
*
for all nodes.