Table sem5.dbo.SEM_APPLICATION
Keeps all applications information

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DOMAIN_ID char 32
APP_HASH char 32 Checksum of the learned application. Including name, path, file checksum, file size and so on.
APPLICATION_NAME nvarchar 520 ('') Name of the learned application
APPLICATION_PATH nvarchar 520  √  null Path of the learned application
APP_DESCRIPTION nvarchar 2048  √  null Description of the learned application
CHECKSUM char 32 File checksum of the application binary
FILE_SIZE bigint 8  √  null File size of the application binary
VERSION varchar 256  √  null File version of the application binary
LAST_MODIFY_TIME bigint 8  √  null Last modify time of the application binary
USN bigint 8 Update serial number; used by replication
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
DELETED tinyint 1 The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null
SHA2 char 64  √  null FileSHA2 algorithm
SIGNER_NAME nvarchar 512  √  null Signer name
SHA1 char 40  √  null FileSHA1 algorithm
INTERESTING tinyint 1 ((0)) This is whether this application was flagged for detection by the administrator using the Detect Process option in the Centralized Exceptions policy
COMPANY_NAME nvarchar 520  √  null Company name

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
DOMAIN_ID + APP_HASH Primary key Asc/Asc PK_SEM_APPLICATION
SHA2 Performance Asc I_SEM_APPLICATION_SHA2
USN Performance Asc I_SEM_APPLICATION_USN