Table sem5.dbo.SEM_COMPLIANCE_CRITERIA
Keeps the host compliance event details

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
CRITERIA_IDX char 32
AGENT_SECURITY_LOG_IDX char 32 Foreign key to V_AGENT_SECURITY.AGENT_SECURITY_LOG_IDX
ACTION varchar 64 ('') hard-coded English key - one of:
check
remediation
RULE_NAME nvarchar 512 ('') Admin-provided rule name from policy
RULE_TYPE varchar 64 ('') hard-coded English key - one of:
antivirus
antispyware
patch
servicepack
firewall
custom
unknown - fallback when processing log at the server and action ends up null or blank
CRITERIA varchar 256 ('') hard-coded English key - one of:
as_is_installed
as_is_running
as_signature_ok
av_is_installed
av_is_running
av_signature_ok
file_age_ok
file_date_ok
file_size_ok
file_version_ok
file_download
file_exists
file_checksum_ok
file_execute
fw_is_installed
fw_is_running
patch_is_installed
reg_value_incr
reg_key_exists
reg_value_ok
reg_value_exists
reg_value_set
timestamp_ok
msg_dlg_ok
os_ok
os_lang_ok
process_is_running. means either user app or service
file_delete
service_pack_ok
hi_setup
remediation (provides have overall status of remediation)
unknown. fallback at the server if criteria is null or blank
TARGET nvarchar 512 ('') The target of the criteria, for example, the AV product name, the firewall product name, the file name, the registry key, the registry value, the patch version, the OS version, the process name, or the service name.
RESULT varchar 64 ('') One of:
pass
fail
ignore
error
postponed. for remediation criteria only
unknown. fallback at the server if the criteria or rule ends up without a final status
ERROR varchar 128 ('') One of:
unknown = unknown
product_unknown = product unknown
file_notfound = file not found
filename_invalid = invalid file name
parameter_invalid = invalid condition parameter
parameter_undefined = condition parameter was not specified in the policy
bad_url = URL format is invalid
filedownload_op_err = URL not accessible or failed to create destination file
time_out = action timed out
connection_lost = connection was lost
access_violation = access violation on file
access_denied = access denied
remediation_abort = user aborted remediation
remediation_postpone = user postponed remediation
createdir_failed = directory creation failed
system_err = system error
runas_noprivilege = a required privilege is not held by the client
internal_err = internal error
os_unknown = failed to detect operating system type
DESCRIPTION nvarchar 512 ('') Additional compliance check details. Either exception text or one of:
Checksum_blank = fingerprint value is empty
Failed_to_get_modification_date = failed to get modification date
NAN = not a number
Cannot_parse_URL = cannot parse URL
URL_not_accessible_or_failed_to_create_destination_file = URL not accessible or failed to create destination file
Download_exceeded_limit = download exceeded limit
Destination = destination file access violation
By_User = action initiated by user
Access_denied_by_server = access denied by server
Download_file = download file not found
Process_time_out = process timed out
Failed_to_detect_OS_type = failed to detect OS type
Application_name_is_empty = application name is empty
Probably_software_is_not_installed = probably software is not installed
Signature_age_in_seconds_failed = could not compute signature age
Failed_to_parse_URL = failed to parse URL
Missing_or_no_version_info = missing or no version information
After_script_file_running = after script file run
OS_ignore = operating system check was ignored
Save_failed = save failed
No_previous_time = no previous time
OK_or_YES = user response was OK or Yes
Cancel_or_NO = user response was Cancel or No
Fail_to_get_current_OS_language_version = could not retrieve current operating system language
USN bigint 8 ((1)) Update serial number; used by replication
TIME_STAMP bigint 8 ((0)) Time that the record was modified; used to resolve merge conflict
DELETED tinyint 1 ((0)) The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
CRITERIA_IDX Primary key Asc PK_SEM_COMPLIANCE_CRITERIA
AGENT_SECURITY_LOG_IDX + DELETED + CRITERIA + TARGET + RESULT Performance Asc/Asc/Asc/Asc/Asc I_SEM_COMPLIANCE_LOG_IDX_PLUS