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

Database Design (Data Dictionary)
D
443
no
vd
ocx
(e
n)
24
Ma
rch 20
09
D
Database Design (Data Dictionary)
This section provides information on the following tables for the Novell ZENworks Network Access
Control database:
Š
Section D.1, “test_result table,” on page 443
Š Section D.2, “Device table,” on page 444
Š
Section D.3, “sa_cluster,” on page 447
Š Section D.4, “sa_node,” on page 447
Š
Section D.5, “sa_user,” on page 447
Š Section D.6, “cluster_to_user,” on page 448
Š
Section D.7, “user_group,” on page 448
Š Section D.8, “user_to_groups,” on page 448
Š
Section D.9, “group_to_permission,” on page 448
D.1 test_result table
Table D-1
test_result
This table is a history of test results for all endpoints.
test_result_id INT4 DEFAULT
nextval('test_result_test_result_id_seq') PRIMARY KEY
run_id INT4 NOT NULL An ID used for associating test results
to a particular test run.
timestamp INT4 NOT NULL The time the test was run.
device_unique_id VARCHAR(100) NOT NULL A foreign key into the device table.
ip_address_str VARCHAR(30) NOT NULL The IP address of the endpoint tested.
netbios VARCHAR(50) DEFAULT NULL The NetBIOS of the endpoint tested.
hostname VARCHAR(50) DEFAULT NULL The host name of the endpoint tested.
logged_on_user VARCHAR(50) DEFAULT NULL The user that was logged on to the
endpoint at the time of the test.
test_name VARCHAR(50) NOT NULL A descriptive name of the test.
test_class VARCHAR(50) NOT NULL A reference to the Python script that
executed the test. For example,
CheckHotFix.
test_module VARCHAR(50) NOT NULL A reference to the Python script that
executed the test. For example,
checkHotFix.