Appendix C
Audit Log Database Schema
This appendix provides information about audit data schema values for the supported database types and audit log database mappings.
Oracle
Table C-4 lists the data schema values for the Oracle database type:
Table C-1 Data Schema Values for the Oracle Database Type
|
Database Column
|
Value
|
|
id
|
VARCHAR(50) NOT NULL
|
|
name
|
VARCHAR(128) NOT NULL
|
|
resourceName
|
VARCHAR(128)
|
|
accountName
|
VARCHAR(50)
|
|
objectType
|
CHAR(2)
|
|
objectName
|
VARCHAR(128)
|
|
action
|
CHAR(2)
|
|
actionDate
|
CHAR(8)
|
|
actionTime
|
CHAR(12)
|
|
acctAttrChanges
|
VARCHAR(4000)
|
|
acctAttr01label
|
VARCHAR(50)
|
|
acctAttr01value
|
VARCHAR(128)
|
|
acctAttr02label
|
VARCHAR(50)
|
|
acctAttr02value
|
VARCHAR(128)
|
|
acctAttr03label
|
VARCHAR(50)
|
|
acctAttr03value
|
VARCHAR(128)
|
|
acctAttr04label
|
VARCHAR(50)
|
|
acctAttr04value
|
VARCHAR(128)
|
|
acctAttr05label
|
VARCHAR(50)
|
|
acctAttr05value
|
VARCHAR(128)
|
|
parm01label
|
VARCHAR(50)
|
|
parm01value
|
VARCHAR(128)
|
|
parm02label
|
VARCHAR(50)
|
|
parm02value
|
VARCHAR(128)
|
|
parm03label
|
VARCHAR(50)
|
|
parm03value
|
VARCHAR(128)
|
|
parm04label
|
VARCHAR(50)
|
|
parm04value
|
VARCHAR(128)
|
|
parm05label
|
VARCHAR(50)
|
|
parm05value
|
VARCHAR(128)
|
DB2
Table C-2 lists the data schema values for the DB2 database type:
Table C-2 Data Schema Values for the DB2 Database Type
|
Database Column
|
Value
|
|
id
|
VARCHAR(50) NOT NULL
|
|
name
|
VARCHAR(128) NOT NULL
|
|
resourceName
|
VARCHAR(128)
|
|
accountName
|
VARCHAR(50)
|
|
objectType
|
CHAR(2)
|
|
objectName
|
VARCHAR(128)
|
|
action
|
CHAR(2)
|
|
actionDate
|
CHAR(8)
|
|
actionTime
|
CHAR(12)
|
|
actionStatus
|
CHAR(1)
|
|
interface
|
VARCHAR(50)
|
|
server
|
VARCHAR(128)
|
|
subject
|
VARCHAR(128)
|
|
reason
|
CHAR(2)
|
|
message
|
VARCHAR(255)
|
|
acctAttrChanges
|
CLOB(16M)
|
|
acctAttr01label
|
VARCHAR(50)
|
|
acctAttr01value
|
VARCHAR(128)
|
|
acctAttr02label
|
VARCHAR(50)
|
|
acctAttr02value
|
VARCHAR(128)
|
|
acctAttr03label
|
VARCHAR(50)
|
|
acctAttr03value
|
VARCHAR(128)
|
|
acctAttr04label
|
VARCHAR(50)
|
|
acctAttr04value
|
VARCHAR(128)
|
|
acctAttr05label
|
VARCHAR(50)
|
|
acctAttr05value
|
VARCHAR(128)
|
|
parm01label
|
VARCHAR(50)
|
|
parm01value
|
VARCHAR(128)
|
|
parm02label
|
VARCHAR(50)
|
|
parm02value
|
VARCHAR(128)
|
|
parm03label
|
VARCHAR(50)
|
|
parm03value
|
VARCHAR(128)
|
|
parm04label
|
VARCHAR(50)
|
|
parm04value
|
VARCHAR(128)
|
|
parm05label
|
VARCHAR(50)
|
|
parm05value
|
VARCHAR(128)
|
MySQL
Table C-3 lists the data schema values for the MySQL database type:
Table C-3 Data Schema Values for the MySQL Database Type
|
Database Column
|
Value
|
|
id
|
VARCHAR(50) BINARY NOT NULL
|
|
name
|
VARCHAR(128) BINARY NOT NULL
|
|
resourceName
|
VARCHAR(128)
|
|
accountName
|
VARCHAR(50)
|
|
objectType
|
CHAR(2)
|
|
objectName
|
VARCHAR(128)
|
|
action
|
CHAR(2)
|
|
actionDate
|
CHAR(8)
|
|
actionTime
|
CHAR(12)
|
|
actionStatus
|
CHAR(1)
|
|
interface
|
VARCHAR(50)
|
|
server
|
VARCHAR(128)
|
|
subject
|
VARCHAR(128)
|
|
reason
|
CHAR(2)
|
|
message
|
VARCHAR(255)
|
|
acctAttrChanges
|
BLOB
|
|
acctAttr01label
|
VARCHAR(50)
|
|
acctAttr01value
|
VARCHAR(128)
|
|
acctAttr02label
|
VARCHAR(50)
|
|
acctAttr02value
|
VARCHAR(128)
|
|
acctAttr03label
|
VARCHAR(50)
|
|
acctAttr03value
|
VARCHAR(128)
|
|
acctAttr04label
|
VARCHAR(50)
|
|
acctAttr04value
|
VARCHAR(128)
|
|
acctAttr05label
|
VARCHAR(50)
|
|
acctAttr05value
|
VARCHAR(128)
|
|
parm01label
|
VARCHAR(50)
|
|
parm01value
|
VARCHAR(128)
|
|
parm02label
|
VARCHAR(50)
|
|
parm02value
|
VARCHAR(128)
|
|
parm03label
|
VARCHAR(50)
|
|
parm03value
|
VARCHAR(128)
|
|
parm04label
|
VARCHAR(50)
|
|
parm04value
|
VARCHAR(128)
|
|
parm05label
|
VARCHAR(50)
|
|
parm05value
|
VARCHAR(128)
|
Sybase
Table C-4 lists the data schema values for the Sybase database type:
Table C-4 Data Schema Values for the Sybase Database Type
|
Database Column
|
Value
|
|
id
|
VARCHAR(50) NOT NULL
|
|
name
|
VARCHAR(128) NOT NULL
|
|
resourceName
|
VARCHAR(128)
|
|
accountName
|
VARCHAR(50)
|
|
objectType
|
CHAR(2)
|
|
objectName
|
VARCHAR(128)
|
|
action
|
CHAR(2)
|
|
actionDate
|
CHAR(8)
|
|
actionTime
|
CHAR(12)
|
|
actionStatus
|
CHAR(1)
|
|
interface
|
VARCHAR(50)
|
|
server
|
VARCHAR(128)
|
|
subject
|
VARCHAR(128)
|
|
reason
|
CHAR(2)
|
|
message
|
VARCHAR(255)
|
|
acctAttrChanges
|
TEXT
|
|
acctAttr01label
|
VARCHAR(50)
|
|
acctAttr01value
|
VARCHAR(128)
|
|
acctAttr02label
|
VARCHAR(50)
|
|
acctAttr02value
|
VARCHAR(128)
|
|
acctAttr03label
|
VARCHAR(50)
|
|
acctAttr03value
|
VARCHAR(128)
|
|
acctAttr04label
|
VARCHAR(50)
|
|
acctAttr04value
|
VARCHAR(128)
|
|
acctAttr05label
|
VARCHAR(50)
|
|
acctAttr05value
|
VARCHAR(128)
|
|
parm01label
|
VARCHAR(50)
|
|
parm01value
|
VARCHAR(128)
|
|
parm02label
|
VARCHAR(50)
|
|
parm02value
|
VARCHAR(128)
|
|
parm03label
|
VARCHAR(50)
|
|
parm03value
|
VARCHAR(128)
|
|
parm04label
|
VARCHAR(50)
|
|
parm04value
|
VARCHAR(128)
|
|
parm05label
|
VARCHAR(50)
|
|
parm05value
|
VARCHAR(128)
|
Audit Log Database Mappings
Table C-5 contains the mappings between stored audit log database keys and the display string to which they map in the audit report output. Identity Manager stores items that are used as constants as short database keys to save space in the repository. The product interface does not display these mappings. Instead, you see them only when examining the output of a dump of the audit report results.
Table C-5 Object Key Type, Action, and Action Status Database Keys
|
Audit Object Type
|
DB Key
|
Action
|
DB Key
|
Action Status
|
DB Key
|
|
Administrator
|
AD
|
Approve
|
AP
|
Failure
|
F
|
|
Admin Group
|
AG
|
Change Password
|
CP
|
Success
|
S
|
|
Application
|
AP
|
Change Resource Password
|
CR
|
|
|
|
Audit Config
|
AC
|
Configure
|
CG
|
|
|
|
Audit Log
|
AL
|
Connect
|
CN
|
|
|
|
Email Template
|
ET
|
Create
|
CT
|
|
|
|
Lighthouse Account
|
LA
|
Credentials Expired
|
CE
|
|
|
|
Login Config
|
LC
|
Delete
|
DL
|
|
|
|
Notify
|
NT
|
Delete Account
|
DA
|
|
|
|
Object Group
|
OG
|
Deprovision
|
DP
|
|
|
|
Policy
|
PO
|
Disable
|
DS
|
|
|
|
Remedy Config
|
RC
|
Disconnect
|
DC
|
|
|
|
Resource Account
|
RA
|
Enable
|
EN
|
|
|
|
Resource
|
RS
|
Launch
|
LN
|
|
|
|
Resource Object
|
RE
|
Load
|
LD
|
|
|
|
Role
|
RL
|
Login
|
LG
|
|
|
|
Role Attribute
|
RT
|
Logout
|
LO
|
|
|
|
Task Definition
|
TD
|
Native Change
|
NC
|
|
|
|
Task Instance
|
TI
|
Protect Resource Password
|
PT
|
|
|
|
Task Schedule
|
TS
|
Provision
|
PV
|
|
|
|
User
|
US
|
Reject
|
RJ
|
|
|
|
Workflow Case
|
WC
|
Reprovision
|
RV
|
|
|
|
Workflow Process
|
WP
|
Reset Password
|
RP
|
|
|
|
Workflow Task
|
WT
|
Terminate
|
TR
|
|
|
|
|
|
Update
|
MO
|
|
|
|
|
|
View
|
VW
|
|
|
