Table sem5.dbo.COMMAND_REPORT
Keeps the administrator-defined filters for the Command details log

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
COMMANDFILTER_IDX char 32
USER_ID char 32 ('')
FILTERNAME nvarchar 510 ('')
STARTDATEFROM datetime 16,3 ('19700101') Start time
STARTDATETO datetime 16,3 ('19700101') End time
RELATIVEDATETYPE int 4 ((0)) 0 = past week
1 = past month
2 = past three months
3 = past year
4 = past 24 hours
5 = current month
STATE_ID int 4  √  (NULL) Command status
0 = Not received
1 = Received
2 = In progress
3 = Completed
4 = Rejected
5 = Canceled
6 = Error
SUB_STATE_ID int 4  √  (NULL) Status Details
-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
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
PERCENT_COMPLETE tinyint 1  √  (NULL) Command progress
COMPUTERLIST nvarchar 1024 ('') Command separated, wild-carded list of computer names to filter
SORTORDER varchar 32 ('COMPUTER_NAME') Column name in table to sort by
SORTDIR varchar 5 ('asc') DESC = Descending order, ASC = Ascending order
LIMITROWS int 4 ((20)) Number of rows to use for pagination
USERELATIVE char 2 ('on') Use relative dates ('on') or absolute dates
REPORT_IDX int 4 ('0') Not used
REPORTINPUTS nvarchar 128 ('') Special parameters if report needs them
USN bigint 8 ((1)) A USN-based serial number; this ID is not unique.
TIME_STAMP bigint 8 ((0)) The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 ((0)) Deleted rows; 0 = not deleted, 1 = deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USER_ID + FILTERNAME Primary key Asc/Asc PK_COMMANDREPORT