ARM Schema

The tables created with the SQL Script are listed below.

 

tbl_Transactions

TransactionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Transactions PRIMARY KEY CLUSTERED ,

ParentTransactionID numeric(18, 0) NULL REFERENCES tbl_Transactions(TransactionID),

TransactionObject varchar (50) NOT NULL

tbl_EventRules

EventID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_EventRules PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

SiteName varchar (50) NULL ,

EventName varchar (50) NULL ,

EventType varchar (50) NULL ,

ConditionValues varchar (1000) NULL ,

ResultID numeric(18, 0) NOT NULL ,

TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_Actions

ActionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Actions PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

SiteName varchar (50) NULL ,

EventName varchar (50) NULL ,

ActionType varchar (50) NULL ,

Parameters varchar (1000) NULL ,

IsFailedAction bit NULL ,

ResultID numeric(18, 0) NOT NULL ,

TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE,

Details  varchar(1000)

tbl_Authentications

AuthenticationID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Authentications PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

RemoteIP varchar (15) NOT NULL ,

RemotePort numeric(18, 0) NULL ,

LocalIP varchar (15) NOT NULL ,

LocalPort numeric(18, 0) NULL ,

Protocol varchar (50) NULL ,

SiteName varchar (50) NULL ,

UserName varchar (50) NULL ,

PasswordHash varchar (500) NULL ,

SettingsLevels varchar (500) NULL ,

ResultID numeric(18, 0) NOT NULL ,

EventID numeric(18, 0) NOT NULL REFERENCES tbl_EventRules(EventID),

TransactionID numeric(18, 0) NOT NULL References tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_Groups

GroupID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Groups PRIMARY KEY CLUSTERED,

GroupName varchar (50) NULL ,

AuthenticationID numeric(18, 0) NOT NULL REFERENCES tbl_Authentications(AuthenticationID) ON DELETE CASCADE

tbl_CustomCommands

CustomCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_CustomCommands PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

SiteName varchar (50) NULL ,

Command varchar (50) NULL ,

CommandParameters varchar (1000) NULL ,

ExecutionTime numeric(18, 0) NULL ,

ResultID numeric(18, 0) NOT NULL ,

TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_ProtocolCommands

ProtocolCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ProtocolCommands PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

RemoteIP varchar (15) NULL ,

RemotePort numeric (18,0) NULL ,

LocalIP varchar (15) NULL ,

LocalPort numeric (18,0) NULL ,

Protocol varchar (50) NULL ,

SiteName varchar (50) NULL ,

Command varchar (10) NULL ,

CommandParameters varchar (1000) NULL ,

FileName varchar (500) NULL ,

VirtualFolderName varchar (500) NULL ,

PhysicalFolderName varchar (500) NULL ,

FileSize numeric(18, 0) NULL ,

TransferTime numeric(18, 0) NULL,

BytesTransferred numeric(18, 0) NULL ,

ResultID numeric(18, 0) NOT NULL ,

TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_ResultCodes

ResultID numeric(18, 0) NOT NULL CONSTRAINT PK_tbl_ResultCodes PRIMARY KEY CLUSTERED,

Description varchar (100) NULL ,

Category varchar (10) NULL

tbl_SocketConnections

SocketID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_SocketConnections PRIMARY KEY CLUSTERED,

Time_stamp datetime NOT NULL ,

RemoteIP varchar (15) NULL ,

RemotePort numeric (18,0) NULL ,

LocalIP varchar (15) NULL ,

LocalPort numeric(18, 0) NULL ,

SiteName varchar (50) NULL ,

ResultID numeric(18, 0) NOT NULL ,

TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_ClientOperations

ClientOperationID numeric (18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ClientOperations PRIMARY KEY CLUSTERED ,

Time_stamp datetime NOT NULL ,

Protocol varchar (50) NULL ,

RemoteAddress varchar (50) NULL ,

RemotePort numeric (18, 0) NULL ,

Username varchar (50) NULL ,

RemotePath varchar (500) NULL ,

LocalPath varchar (500) NULL ,

Operation varchar (50) NULL ,

BytesTransferred numeric (18, 0) NULL ,

TransferTime numeric (18, 0) NULL ,

ResultID numeric (18, 0) NOT NULL ,

TransactionID numeric (18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE

tbl_AdminCommands

[AdminCommandID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_AdminCommands PRIMARY KEY CLUSTERED,

[Time_Stamp] [datetime] NULL ,

[TransactionID] [numeric](18, 0) ,

[Login] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Data] [varchar] (7800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

tbl_PCIViolations

[PCIViolationID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_PCIViolations PRIMARY KEY CLUSTERED,

[Time_Stamp] [datetime] NULL ,

[ViolationID] [int] NULL ,

[SiteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[SettingsLevel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Admin] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Reason] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

tbl_ServerInternalEvents

[ServerInternalEventID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ServerInternalEvents PRIMARY KEY CLUSTERED,

[Time_Stamp] [datetime] NULL ,

[SiteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[SettingsLevel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[EventName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Parameters] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]