ARM Schema

The tables created during installation are listed below. Because all of EFT's modules and features are available during the trial, all of the tables below are created, even if you do not activate that module/feature.

tbl_Actions - Logs Actions performed when Event Rules are processed

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

Time_stamp datetime NOT NULL ,

SiteName nvarchar(50) NULL ,

EventName nvarchar(50) NULL ,

ActionType nvarchar(50) NULL ,

Parameters nvarchar(1000) NULL ,

IsFailedAction bit NULL ,

ResultID numeric(18, 0) NOT NULL ,

EventID numeric(18, 0) NOT NULL ,

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

Details nvarchar(1000)

tbl_AdminActions - Logs Actions performed by administrators in EFT

ID numeric(18, 0) IDENTITY(1,1) NOT NULL,

Timestamp datetime NULL,

FunctionName nvarchar(200) NULL,

Action nvarchar(200) NULL,

AffectedArea nvarchar(200) NULL,

AffectedName nvarchar(200) NULL,

ChangeOriginator nvarchar(200) NULL,

TransactionID numeric(18, 0) NULL,

SiteName nvarchar(300) NULL

tbl_AS2Actions - Contains information about separate Actions for each AS2 transaction:

ActionID numeric(18, 0) identity

TransactionID numeric(18, 0)

ActionStatus numeric(18, 0)

ActionType numeric(18, 0)

ErrorCode nvarchar(1000)

TimeStamp datetime

FileID numeric(18, 0)

tbl_AS2Files - Contains information about files transferred via AS2:

FIleID numeric(18, 0) identity

TransactionID numeric(18, 0)

FileName nvarchar(300)

ContentType nvarchar(50)

LocalPath nvarchar(300)

RemotePath nvarchar(300)

tbl_AS2Transactions - Contains details of AS2 Transactions:

TransactionID numeric(18, 0) identity

MIC nvarchar(100) (EFT calculates the AS2 MIC using SHA-1. You can ignore the words "MD5" that appear in the MIC column of the AS2-related reports.)

StartTime datetime

CompleteTime datetime

Direction numeric(18, 0)

MDN text

MDNSignatureType nvarchar(50)

MDNType numeric(18,0)

LocalHost nvarchar(300)

RemoteHost nvarchar(300)

TransactionStatus numeric(18,0)

SiteName nvarchar(300)

FromAS2ID nvarchar(300)

ToAS2ID nvarchar(300)

ErrorCode nvarchar(1000)

PayloadSignatureType nvarchar(50)

PayloadEncryptionType nvarchar(50)

PayloadHeaders text

MDNAS2MessageID nvarchar(300)

PayloadAS2MessageID nvarchar(300)

MDNHTTPResponse text

tbl_Authentications - Logs authentication attempts for administrators and users per Site

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

Time_stamp datetime NOT NULL ,

RemoteIP nvarchar(15) NOT NULL ,

RemotePort numeric(18, 0) NULL ,

LocalIP nvarchar(15) NOT NULL ,

LocalPort numeric(18, 0) NULL ,

Protocol nvarchar(50) NULL ,

SiteName nvarchar(50) NULL ,

UserName nvarchar(50) NULL ,

PasswordHash nvarchar(500) NULL ,

SettingsLevels nvarchar(500) NULL ,

ResultID numeric(18, 0) NOT NULL ,

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

tbl_ClientOperations - Logs upload/download/create/etc Actions performed by clients (FTP, HTTP, etc)

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

Time_stamp datetime NOT NULL ,

Protocol nvarchar(50) NULL ,

RemoteAddress nvarchar(50) NULL ,

RemotePort numeric (18, 0) NULL ,

Username nvarchar(50) NULL ,

RemotePath nvarchar(500) NULL ,

LocalPath nvarchar(500) NULL ,

Operation nvarchar(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

LogFileName

tbl_CustomCommands - Logs details of custom commands being executed. These are typically launched by Event Rules

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

Time_stamp datetime NOT NULL ,

SiteName nvarchar(50) NULL ,

Command nvarchar(50) NULL ,

CommandParameters nvarchar(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_EventRules - Logs details of Event Rules that have been processed

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

Time_stamp datetime NOT NULL ,

SiteName nvarchar(50) NULL ,

EventName nvarchar(50) NULL ,

EventType nvarchar(50) NULL ,

ConditionValues nvarchar(1000) NULL ,

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

EventGUID numeric(18, 0) NOT NULL

tbl_Groups - Provides plain text group name for reporting (part of db normalization)

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

GroupName nvarchar(50) NULL ,

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

tbl_PCIViolations - Logs PCI violations for PCI DSS compliance testing reports

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

Time_Stamp datetime NULL ,

ViolationID int NULL ,

SiteName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

SettingsLevel nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

UserName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

Admin nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

Reason nvarchar(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

tbl_ProtocolCommands - Logs detailed client commands sent for various protocols (ftp, http, etc)

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

Time_stamp datetime NOT NULL ,

RemoteIP nvarchar(15) NULL ,

RemotePort numeric (18,0) NULL ,

LocalIP nvarchar(15) NULL ,

LocalPort numeric (18,0) NULL ,

Protocol nvarchar(50) NULL ,

SiteName nvarchar(50) NULL ,

Command nvarchar(10) NULL ,

CommandParameters nvarchar(1000) NULL ,

FileName nvarchar(500) NULL ,

VirtualFolderName nvarchar(500) NULL ,

PhysicalFolderName nvarchar(500) NULL ,

IsInternal

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_SAT_Emails - Logs the notification e-mails sent by the SAT module

ID numeric(18, 0) IDENTITY (1, 1) NOT NULL ,

txid int NOT NULL ,

email nvarchar (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

emailType int NULL

"emailType" is a "0" for TO:, "1" for CC:, "2" for BCC:

tbl_SAT_Files - Logs the files uploaded by the SAT module

id numeric(18, 0) IDENTITY (1, 1) NOT NULL ,

txid int NOT NULL ,

filename nvarchar (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

filesize bigint NULL

tbl_SAT_Transactions - Audits transactions managed by the Secure Ad Hoc Transfer (SAT) module.

ID numeric(18, 0) IDENTITY (1, 1) NOT NULL ,

time_stamp datetime NULL ,

fromEmail nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

subject nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

body nvarchar(5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

tempUserName nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

siteName nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

expiryDays int NULL ,

tempPassword nvarchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

transactionGUID uniqueidentifier NULL,

reserved1 nvarchar(2000) NULL,

reserved2 nvarchar(2000) NULL

tbl_Schema_Version - Maintains the current version of the ARM schema

Id smallint NOT NULL,

Version nchar(7) NOT NULL

tbl_ServerInternalEvents

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

Time_Stamp datetime NULL ,

SiteName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

SettingsLevel nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

UserName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

EventName nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

Parameters nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

tbl_SocketConnections - Logs details (ip addresses, port numbers, etc) of individual socket connections for various protocols (ftp, http, etc).

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

Time_stamp datetime NOT NULL ,

RemoteIP nvarchar(15) NULL ,

RemotePort numeric (18,0) NULL ,

LocalIP nvarchar(15) NULL ,

LocalPort numeric(18, 0) NULL ,

SiteName nvarchar(50) NULL ,

ResultID numeric(18, 0) NOT NULL ,

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

tbl_Transactions - Provides transaction references to correlate data from various ARM tables

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

TransactionObject nvarchar(50) NOT NULL

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

(Refer to Result IDs for a description of the Result ID columns that appear in some reports.)

This help file is for EFT v6.5. For other versions, please refer to http://help.globalscape.com/help/index.html.

(If the Index and Contents are hidden, click Show in the top left corner.)

If this help topic did not help you, search the Knowledgebase or pose your question in the Globalscape User Forum.
For the most up-to-date information, to view version history, updates, and activation instructions; or to download a PDF of this user guide, visit the Support Center at http://www.globalscape.com/support.
For information about Globalscape, visit www.globalscape.com, subscribe to our newsfeed, or follow us on Twitter.

Last modified: 16 July 2018 16:25:22