Table sem5.dbo.COMPUTER_APPLICATION
Keeps all applications used in agents

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
AGENT_ID char 32 GUID of the agent
DOMAIN_ID char 32 GUID of the domain to which the client computer belongs
APP_HASH char 32 Hash value of the learned application record
LOCATION_ID char 32 GUID of the location
COMPUTER_ID char 32 GUID of the computer
GROUP_ID char 32 Group GUID
LAST_ACCESS_TIME bigint 8  √  null Last access time of the application on the computer (GMT)
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
CREATOR_SHA2 char 64  √  null SHA2 of process that dropped the file
DOWNLOAD_URL varchar 512  √  null source URL of the first drop on this machine
DETECTION tinyint 1 ((0)) was this involved in a detection on this machine?

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
AGENT_ID + DOMAIN_ID + APP_HASH + LOCATION_ID Primary key Asc/Asc/Asc/Asc PK_COMPUTER_APPLICATION
COMPUTER_ID Performance Asc I_COMPUTER_APPLICATION_CID
DELETED + TIME_STAMP Performance Asc/Asc I_COMPUTER_APPLICATION_DT
USN Performance Asc I_COMPUTER_APPLICATION_USN