XYGATE Merged Audit Reference Manual

Table Of Contents
XYGATE Merged Audit
®
Reference Manual
Appendix G: Data Mapping
XYPRO Technology Corporation 268 Proprietary and Confidential
G8: iTP Secure WebServer Mapping
iTP Secure WebServer Audit Detail Table
Column Type Record Contents
PARTITIONKEY.
numeric 4
RECORDGMT See General Note 2.
timestamp
GMTSEQNO char 2 MOVER Generated
RECORDLCT timestamp time
RECORDAUDITKEY timestamp MOVER Generated
RECORDSESSIONKEY timestamp MOVER Generated
SEQNO char 9
OUTCOME See General Note 3.
char 1
< 400 = 1,otherwise 3
WARNINGMODE char 1
TESTMODE char 1
SEVERITY char 1
ALERTED See General Note 4.
char 1
PRODUCTCODE char 10 ITPWEB
SUBJECTSYSTEM varchar 64 The node where the iTP
Webserver audit file resides
SUBJECTLOGIN varchar 40 username
SUBJECT_USERNUMBER_MAJOR char 8
SUBJECT_USERNUMBER_MINOR char 8
TARGETLOGIN varchar 40
TARGET_USERNUMBER_MAJOR char 8
TARGET_USERNUMBER_MINOR char 8
OBJECTTYPE - Type of Object varchar 32 File
OBJECTNAME - Name of Object varchar 200 Request
OPERATION-Activity varchar 128 Request
TERMINAL varchar 64
MESSAGEID varchar 20
MESSAGECODE varchar 20
HTTP-status
RULENAME varchar 50
RESULT varchar 256
PARTITIONKEY.
numeric 4
RECORDSESSIONKEY timestamp MOVER Generated
RECORDINSTALLKEY timestamp MOVER Generated
SESSIONID char 36
Continued . . .