Table sem5.dbo.COMMAND
Keeps the Command status for 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
HARDWARE_KEY char 32
COMMAND_ID char 32
DOMAIN_ID char 32 The domain ID currently being administered when the command is created
USN bigint 8 Update serial number; used by replication
BEGIN_TIME bigint 8 ((0)) Time that the command launched at the client in GMT
LAST_UPDATE_TIME bigint 8 ((0)) Time of last status reported by client in GMT
STATE_ID int 4 ((0)) Command status: a numeric value corresponding to one of
0 = INITIAL
1 = RECEIVED
2 = IN_PROGRESS
3 = COMPLETED
4 = REJECTED
5 = CANCELLED
6 = ERROR

When first created, command status = INITIAL. It indicates that the endpoint has not received it yet.
SUB_STATE_ID int 4  √  null Command-specific status:
-1 = Unknown
0 = Success
1 = Client did not execute the command
2 = Client did not report any status
3 = Command was a duplicate and not executed
4 = Spooled command could not restart
5 = Restart command not allowed from the console
6 = Unexpected error
100 = Success
101 = Security risk found
102 = Scan was suspended
103 = Scan was aborted
105 = Scan did not return status
106 = Scan failed to start
110 = Auto-Protect could not be turned on
120 = LiveUpdate download is in progress
121 = LiveUpdate download failed
131 = Quarantine delete failed
132 = Quarantine delete partial success
SUB_STATE_DESC nvarchar 520  √  null Command-specific extra information like number of files scanned or error message.
ESTIMATED_DURATION int 4 ((0)) Agent estimation of command duration in minutes. 0 = no estimate or negligible time.
PERCENT_COMPLETE tinyint 1 ((0)) Progress (0-100%) of command based on estimated duration.
TIME_STAMP bigint 8 The time when the command is added into system (GMT), which is server side time
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 varchar 260  √  null
RESERVED_BINARY varbinary 1000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
HARDWARE_KEY + COMMAND_ID Primary key Asc/Asc PK_COMMAND
USN Performance Asc I_COMMAND_USN