Table sem5.dbo.INVENTORYREPORT
Keeps the administrator-defined filters for the Computer Status 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
INVENTORYFILTER_IDX char 32
USER_ID char 32 ('')
FILTERNAME nvarchar 510 ('')
LASTCHECKINTIME datetime 16,3 ('19700101') Last time of check in with parent server
LASTSCANTIME int 4  √  (NULL) Last time machine was scanned:
0 = past week
1 = past month
2 = past three months
3 = past year
4 = past 24 hours
5 = current month
RELATIVEDATETYPE int 4 ('0') Last check in time if relative filtering used:
0 = past week
1 = past month
2 = past three months
3 = past year
4 = past 24 hours
5 = current month
OPERATOR tinyint 1 ((0)) Not used
PATTERN_IDX varchar 255 ('%') Hard-coded English string used as key (filters for Antivirus signature version):
WITHIN_RELATIVE_30 = Within the last 30 days
WITHIN_RELATIVE_90 = Within the last 90 days
OUTSIDE_RELATIVE_30 = Older than the last 30 days
OUTSIDE_RELATIVE_90 = Older than the last 90 days

or virus definition revision which results in an < = query on that revision.
PRODUCTVERSION varchar 32 ('%') Product version by which to filter
PROFILE_VERSION varchar 64 ('%') Profile version by which to filter
IDS_VERSION varchar 64 ('%') Intrusion prevention system signature version by which to filter
GOOD varchar 5 ('%') Not used
LICENSE_STATUS tinyint 1  √  ((127)) Not used
STATUS tinyint 1  √  ((127)) 1 = online, 0 = offline,127 = No filter (all)
ONOFF tinyint 1  √  ((127)) Auto-Protect Status:
0 = filter for off, 127 = No filter (all)
TAMPER_ONOFF tinyint 1  √  ((127)) Tamper Protection status:
0 = filter for off, 127 = No filter (all)
REBOOT_REQUIRED tinyint 1  √  ((127)) Restart required status:
1 = filter for needs restart, 127 = No filter (all)
AVENGINE_ONOFF tinyint 1  √  ((127)) Antivirus Engine Status:
0 = filter for off, 127 = No filter (all)
TPM_DEVICE tinyint 1  √  ((127)) TPM device installed:
1 = filters on device is installed, 127 = No filter (all)
SERVERGROUPLIST nvarchar 510 ('%') Comma-separated, wild-carded list of domain names by which to filter
CLIENTGROUPLIST nvarchar 510 ('%') Comma-separated, wild-carded list of group names by which to filter
PARENTSERVERLIST nvarchar 510 ('%') Comma-separated, wild-carded list of server names by which to filter
SITELIST nvarchar 510 ('%') Comma-separated, wild-carded list of site names by which to filter
R_OS_TYPE int 4  √  ((-1)) 600 = Windows Vista and Windows Server 2008,
502 = Windows 2003 and Windows XP 64 bit,
501 = Windows XP,
500 = Windows 2000,
400 = Windows NT
000 = Other
-1 = No filter (all)
HI_STATUS tinyint 1  √  ((127)) Filters on the following compliance status:
0 = Fail
1 = Success
2 = Pending
3 = Disabled
4 = Ignore
127 = No filter (all)
HI_REASONCODE int 4  √  ((-1)) Filters on the following reasons:
0 = Pass
101 = Antivirus version is out-of-date
102 = Antivirus is not running
103 = Script failed
104 = Check is incomplete
105 = Check is disabled
127 = Location changed
-1 = No filter (all)
SERVICE_PACK nvarchar 128 ('%') OS service pack or % for no filter (all)
WORSTINFECTION_IDX int 4  √  ((-1)) Not used
COMPUTERLIST nvarchar 1024 ('%') Comma-separated, wild-carded list of computer names by which to filter
IPADDRESSLIST nvarchar 510 ('%') Comma-separated, wild-carded list of IP addresses by which to filter
USERLIST nvarchar 510 ('%') Comma-separated, wild-carded list of user names by which to filter
INFECTED varchar 2 ('') On' = filter for infected machines
SORTORDER varchar 32 ('LAST_UPDATE_TIME') Which column to sort for Computer Status log
SORTDIR varchar 5 ('DESC') Ascending or descending
FILVIEW varchar 16 ('SAVCE') Not used
CLIENTTYPE varchar 32 ('') Not used
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 row; 0 = Not Deleted, 1 = Deleted
FIREWALL_ONOFF tinyint 1  √  ((127)) Firewall status:
0 = filters on off, 127 = No filter (all)
DA_ONOFF tinyint 1 ((127)) Download advisor status
Enabled state of DA
0 = off
1 = on
2 = not installed
3 = off by admin policy
127 = unknown.
PTP_ONOFF tinyint 1 ((127)) Proactive threat protection status:
0 = off
1 = on
2 = not installed
3 = off by admin policy
127 = unknown.
Default is 127
CIDS_ONOFF tinyint 1 ((127)) Network intrusion prevention status:
0 = off
1 = on
2 = not installed
3 = off by admin policy
127 = unknown.
Default is 127
DEPLOY_STATUS tinyint 1 ((0)) See SEM_AGENT.DEPLOY_STATUS. Included again in this table because it represents a filter option.
CIDS_BROWSER_IE_ONOFF tinyint 1 ((127)) See SEM_AGENT.CIDS_BROWSER_IE_ONOFF. Included again in this table because it represents a filter option.
CIDS_BROWSER_FF_ONOFF tinyint 1 ((127)) See SEM_AGENT.CIDS_BROWSER_FF_ONOFF. Included again in this table because it represents a filter option.
ELAM_ONOFF tinyint 1 ((127)) Early Launch Anti-Malware status:
0 = off
1 = on
2 = not installed
3 = off by admin policy
127 = unknown.
Default is 127

Analyzed at Mon Oct 29 12:07 PDT 2012

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