Novell ZENworks Network Access Control 5.0, User Manual, Page: 445 / 534

Database Design (Data Dictionary) 445
no
vd
ocx
(e
n)
24
Ma
rch 20
09
os_details VARCHAR(100) The specific version of the
operating system of the endpoint.
password VARCHAR(50) DEFAULT NULL The password used during the
test.
logged_on_user VARCHAR(100) The user logged onto endpoint last
time it was tested.
policy_id VARCHAR(50) DEFAULT NULL The identification number of the
last policy used.
last_run_id INT4 DEFAULT NULL A foreign key into the test_result
table that references the last test
run for this endpoint.
prev_run_id INT4 A foreign key into the test_result
table that references the run
before the last test run for this
endpoint.
last_test_dt INT4 DEFAULT NULL The time of the last test.
last_status VARCHAR(50) DEFAULT NULL A text description of what
happened, for example pass or
fail.
last_status_id INT4 NOT NULL DEFAULT 0 An internal code that represents
last_status.
grace_period INT4 DEFAULT NULL The duration of time that the
endpoint has temporary access.
grace_period_start INT4 DEFAULT NULL The time the grace period starts.
grace_period added to
grace_period_start determines the
time the endpoint will go into
quarantine.
last_test_result_id INT4 DEFAULT NULL The test result ID of the failed test
with the most severe action taken.
For example, -1 indicates all tests
passed. If two tests failed, this
contains the ID of the test that had
the most severe action taken. An
email sent is a less severe action
than a quarantine immediately.
crt_dt INT4 NOT NULL The date the endpoint was first
seen. (create date)
last_activity_dt INT4 NOT NULL The date the endpoint was last
seen.
last_connect_dt INT4 NOT NULL The date the endpoint was first
seen if it has never been
disconnected, or the last time the
endpoint reconnected.
last_disconnect_dt INT4 NOT NULL The date the endpoint was
disconnected for inactivity.