sm_timestamp

This marks the time at which the entry was made to the database.

NOT NULL

DATE

sm_categoryid

The identifier for the type of logging. It may be one of the following:

• 1 = Auth
• 2 = Agent
• 3 = AgentGroup
• 4 = Domain
• 5 = Policy
• 6 = PolicyLink
• 7 = Realm
• 8 = Response
• 9 = ResponseAttr
• 10 = ResponseGroup
• 11 = Root
• 12 = Rule
• 13 = RuleGroup
• 14 = Scheme
• 15 = UserDirectory
• 16 = UserPolicy
• 17 = Vendor
• 18 = VendorAttr
• 19 = Admin
• 20 = AuthAzMap
• 21 = CertMap
• 22 = ODBCQuery
• 23 = SelfReg
• 24 = PasswordPolicy
• 25 = KeyManagement
• 26 = AgentKey
• 27 = ManagementCommand
• 28 = RootConfig

NOT NULL

NUMBER(38)

sm_categoryid
(continued)

• 29 = Variable
• 30 = VariableType
• 31 = ActiveExpr
• 32 = PropertyCollection
• 33 = PropertySection
• 34 = Property
• 35 = TaggedString
• 36 = TrustedHost
• 37 = SharedSecretPolicy

NOT NULL

NUMBER(38)

sm_eventid

This marks the particular event that caused the logging to occur. It may be one of the following:

• 1 = Create
• 2 = Update
• 3 = UpdateField
• 4 = Delete
• 5 = Login
• 6 = Logout
• 7 = LoginReject
• 8 = FlushAll
• 9 = FlushUser
• 10 = FlushUsers
• 11 = FlushRealms
• 12 = ChangeDynamicKeys
• 13 = ChangePersistentKey
• 14 = ChangeDisabledUserState
• 15 = ChangeUserPassword
• 16 = FailedLoginAttemptsCount
• 17 = ChangeSessionKey

NOT NULL

NUMBER(38)

sm_hostname

This is not used by the reports generator for administrative logging.

VARCHAR2(255)

sm_sessionid

This is the session identifier for this user's activity.

VARCHAR2(255)

sm_username

The username for this administrator.

VARCHAR2(512)

sm_objname

This is the object in the administrator that is being accessed.

VARCHAR2(512)

sm_objoid

This is the unique identifier for the object being accessed in the administrator. This is not used by the reports generator.

VARCHAR2(64)

sm_fielddesc

This is some descriptive text for the action being taken by the administrator.

VARCHAR2(1024)

sm_domainoid

This is the unique identifier for the domain that has an object being modified in the administrator. This is not used by the reports generator.

VARCHAR2(64)

sm_status

This is some descriptive text about the action. This is not used by the reports generator.

VARCHAR2(1024)