CREATE TABLE [dbo].[HARAUDITEVENT]
(
[AUDITEVENTOBJID] [int] NOT NULL,
[PARENTAUDITEVENTOBJID] [int] NOT NULL,
[ACTIONOBJID] [int] NOT NULL,
[SUCCESSFAILURE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARAUDITE__SUCCE__0AD2A005] DEFAULT ('F'),
[EVENTTIME] [datetime] NOT NULL,
[USROBJID] [int] NULL,
[USERNAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTHOSTNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTPROCESSID] [int] NULL,
[SERVERHOSTNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SERVERPROCESSID] [int] NULL,
[RESOURCEOBJID] [int] NULL,
[RESOURCENAME] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RESOURCETYPEOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENT] ADD CONSTRAINT [HARAUDITEVENT_PK] PRIMARY KEY CLUSTERED ([AUDITEVENTOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENT_ACTID_IND] ON [dbo].[HARAUDITEVENT] ([ACTIONOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENT_EVTID_IND] ON [dbo].[HARAUDITEVENT] ([EVENTTIME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENT_RESID_IND] ON [dbo].[HARAUDITEVENT] ([RESOURCEOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARAUDITEVENT_RTID_IND] ON [dbo].[HARAUDITEVENT] ([RESOURCETYPEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARAUDITEVENT] ADD CONSTRAINT [HARAUDITEVENT_ACTID_FK] FOREIGN KEY ([ACTIONOBJID]) REFERENCES [dbo].[HARACTION] ([ACTIONOBJID])
GO
ALTER TABLE [dbo].[HARAUDITEVENT] ADD CONSTRAINT [HARAUDITEVENT_RTID_FK] FOREIGN KEY ([RESOURCETYPEOBJID]) REFERENCES [dbo].[HARRESOURCETYPE] ([RESOURCETYPEOBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HARAUDITEVENT table stores the actual auditable actions recorded by the audit system.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of the audit action associated with this log entry. This column is an index to the HARACTION table.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'ACTIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Sequence Object ID identifying the audit log entry for a particular audit action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'AUDITEVENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the CA SCM client host machine that initiated the transaction that requested the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'CLIENTHOSTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Process identifier of the process on the client host machine that initiated the transaction that requested the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'CLIENTPROCESSID'
GO
EXEC sp_addextendedproperty N'Caption', N'Date and time of when the auditable action was attempted.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'EVENTTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Sequence Object ID identifying the audit log entry for a particular audit action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'PARENTAUDITEVENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the resource affected by the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'RESOURCENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the CA SCM object that is operated on by the auditable action. Depending on the action, this identifier is a reference to the CA SCM tables: HARENVIRONMENT, HARSTATE, HARSTATEPROCESS, HARLINKEDPROCESS, HARVIEW, HARUSERS.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'RESOURCEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the resource type associated with the resource affected by this auditable action. This column is a reference to the HARRESOURCETYPE table.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'RESOURCETYPEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the CA SCM server host machine that processed the transaction requesting the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'SERVERHOSTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Process identifier associated with the CA SCM server process that processed the transaction requesting the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'SERVERPROCESSID'
GO
EXEC sp_addextendedproperty N'Caption', N'Indicator of the success or failure of the action that is logged. S=action was successful, F=action failed.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'SUCCESSFAILURE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the user attempting to perform the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the user attempting to perform the auditable action.', 'SCHEMA', N'dbo', 'TABLE', N'HARAUDITEVENT', 'COLUMN', N'USROBJID'
GO