AUDITEVENTOBJID

NUMBER

NOT NULL

Object ID identifying the audit log entry. Identifies a record in the HARAUDITEVENT tables.

ACTIONOBJID

NUMBER

NOT NULL

Object ID of the audit action associated with this log entry.This column is an index to the HARACTION table.

SUCCESSFAILURE

CHAR(1)

NOT NULL

Indicator of the success or failure of the action that is logged. S=action was successful, F=action failed.

ACTIONNAME

VARCHAR (128)

NOT NULL

Name of the audit action (for example, Update state).

EVENTTIME

DATE

NOT NULL

Date and time of when the auditable action was attempted.

USROBJID

NUMBER

NULL

Object Identifier of the user attempting to perform the auditable action.

USERNAME

VARCHAR (128)

NULL

Name of the user attempting to perform the auditable action.

CLIENTHOSTNAME

VARCHAR (128)

NULL

Name of the CA Harvest SCM client host machine that initiated the transaction that requested the auditable action.

CLIENTPROCESSID

NUMBER

NULL

Process identifier of the process on the client host machine that initiated the transaction that requested the auditable action.

SERVERHOSTNAME

VARCHAR (128)

NULL

Name of the CA Harvest SCM server host machine that processed the transaction requesting the auditable action.

SERVERPROCESSID

NUMBER

NULL

Process identifier associated with the CA Harvest SCM server process that processed the transaction requesting the auditable action.

RESOURCETYPEOBJID

NUMBER

NOT NULL

Object identifier of the resource type of the primary resource of this auditable action. This column is a reference to the HARRESOURCETYPE table.

RESOURCETYPENAME

VARCHAR (128)

NOT NULL

Name of the resource type associated with RESOURCETYPEOBJID.

RESOURCEOBJID

NUMBER

NULL

Object Identifier of the primary resource affected by the auditable action. Depending on the action, this identifier is a reference to tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.

Note: The broker object identifier always has identifier 1.

RESOURCENAME

VARCHAR (1024)

NULL

Name of the primary resource affected by the auditable action.

EVENTDESCRIPTION

VARCHAR (4000)

NULL

This textual description of the audit log event is populated for the create and update event for system objects and for login failures.

ER1RESOURCETYPEOBJID

NUMBER

NOT NULL

Object identifier of the resource type associated with the first level ancestor of the primary resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.

ER1RESOURCETYPENAME

VARCHAR (128)

NOT NULL

Name of the resource type associated with ER1RESOURCETYPEOBJID

ER1RESOURCEOBJID

NUMBER

NULL

Object Identifier of the first level ancestor of the primary resource affected by the auditable action. Depending on the action, this identifier is a reference to tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.

Note: the broker object identifier always has identifier 1.

ER1RESOURCENAME

VARCHAR (1024)

NULL

Name of the CA Harvest SCM resource of ER1RESOURCEOBJID

ER2RESOURCETYPEOBJID

NUMBER

NOT NULL

Object identifier of the resource type associated with second level ancestor of the primary resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.

ER2RESOURCETYPENAME

VARCHAR (128)

NOT NULL

Name of the resource type associated with ER2RESOURCETYPEOBJID

ER2RESOURCEOBJID

NUMBER

NULL

Object Identifier of the second level ancestor of the primary resource affected by the auditable action. Depending on the action, this identifier is a reference to tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.

Note: The broker object identifier always has identifier 1.

ER2RESOURCENAME

VARCHAR (1024)

NULL

Name of the CA Harvest SCM resource of ER2RESOURCEOBJID.

ER3RESOURCETYPEOBJID

NUMBER

NOT NULL

Object identifier of the resource type associated with third level ancestor of the primary resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.

ER3RESOURCETYPENAME

VARCHAR (128)

NOT NULL

Name of the resource type associated with ER3RESOURCETYPEOBJID.

ER3RESOURCEOBJID

NUMBER

NULL

Object Identifier of the third level ancestor of the primary resource affected by the auditable action. Depending on the action, this identifier is a reference to tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.

Note: The broker object identifier always has identifier 1.

ER3RESOURCENAME

VARCHAR (1024)

NULL

Name of the CA Harvest SCM resource of ER3RESOURCEOBJID.

ER4RESOURCETYPEOBJID

NUMBER

NOT NULL

Object identifier of the resource type associated with fourth level ancestor of the primary resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.

ER4RESOURCETYPENAME

VARCHAR (128)

NOT NULL

Name of the resource type associated with ER4RESOURCETYPEOBJID.

ER4RESOURCEOBJID

NUMBER

NULL

Object identifier of the fourth level ancestor of the primary resource affected by the auditable action. Depending on the action, this identifier is a reference to tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.

Note: The broker object identifier always has identifier 1.

ER4RESOURCENAME

VARCHAR (1024)

NULL

Name of the CA Harvest SCM resource of ER4RESOURCEOBJID.