Novell ZENworks Network Access Control 5.0, User Manual

Page: 444 / 534

444 Novell ZENworks Network Access Control Users Guide
no
vd
ocx
(e
n)
24
Ma
rch 20
09
D.2 Device table
Table D-2
device
group_name VARCHAR(50) NOT NULL The type of test, for example, operating
system, software, security setting, or
browser security policy.
policy_id VARCHAR(50) NOT NULL A unique ID that identifies the policy.
policy_name VARCHAR(50) NOT NULL The name of the policy.
actions_taken TEXT DEFAULT NULL A text description of what happened, for
example, email sent.
severity INT2 DEFAULT NULL A number describing the severity of the
test.
result_code VARCHAR(50) NOT NULL The string 'pass' or 'fail' indicating the
result of the test.
status_code VARCHAR(20) NOT NULL A number that indicates whether the
test ran or not. For example, 0 — Test
did not run, or 1 — Test ran.
result_message TEXT DEFAULT NULL Information about the results of the test.
debug_info TEXT DEFAULT NULL Information about the results of the test.
cluster_id VARCHAR(64) A unique ID that identifies the cluster
that ran the test.
last_result_code VARCHAR(50) A string 'pass' or 'fail' indicating the
result of the previous test for the same
script and endpoint.
This table contains information about known endpoints.
unique_id VARCHAR(100) NOT NULL PRIMARY KEY
ip_address_str VARCHAR(30) NOT NULL The IP address (string in dotted
quad notation) of the endpoint.
mac_address VARCHAR(30) DEFAULT NULL The MAC address of the endpoint.
netbiosname VARCHAR(50) DEFAULT NULL The NetBIOS of the endpoint.
hostname VARCHAR(50) DEFAULT NULL The host name of the endpoint.
domainname VARCHAR(50) DEFAULT NULL The domain name of the endpoint.
username VARCHAR(50) DEFAULT NULL The user name used during the
test.
os VARCHAR(100) DEFAULT NULL The operating system of the
endpoint (eg, 'Windows', 'Linux')