Using the following database information, you can create custom reports for the Server Policies and Tiered Electronic Distribution components.
However, for Tiered Electronic Distribution objects such as a Subscriber or the External Subscriber, you should use ZENworks reporting options (see Reporting) or iManager (Novell iManager) for determining the status of Distributions or policies.
The database file (zfslog.db) contains the following information:
The Sybase database (zfslog.db) that ships with Server Management has the following default user ID and password:
Following are the database table definitions for server policies.
Contains one record for each server running the Policy/Package Agent.
Primary key (SERVERID)
Contains one record for each server running the Policy/Package Agent.
Field Name | Type | Use |
|
|
---|---|---|---|---|
SERVERIPKEY |
integer |
|
not null |
Assigned automatically: Default Auto increment. |
SERVERID |
integer |
|
not null |
Links to the SERVERS table. |
IPADDRESS |
varchar |
|
not null |
Server's IP address. |
Primary key (SERVERID) REFERENCES SERVERS
Primary key (SERVERIPKEY)
Contains one record for each version of a software package that the Policy/Package Agent has attempted to process.
Primary key (PACKAGEGUID)
Contains one record for each policy or policy package combination.
Field Name | Type | Use |
|
|
---|---|---|---|---|
POLICYID |
integer |
|
not null |
A globally unique ID. |
POLICYDN |
varchar |
|
|
The DN of the eDirectory policy object. |
POLICYPACKAGE |
varchar |
|
|
The DN of the policy package the policy belongs to. |
POLICYCLASS |
varchar |
|
|
The class or type of policy. For definitions, see Valid Entries for POLICYCLASS. |
POLICYTREENAME |
varchar |
|
|
The name of the tree the policy object is in. |
Primary key (POLICYID)
Contains one record for each action performed.
Field Name | Type | Use |
|
|
---|---|---|---|---|
POLICYACTIONKEY |
integer |
|
not null |
Assigned automatically: Default Auto increment. |
POLICYID |
integer |
|
not null |
Links to the POLICIES table. |
SERVERID |
integer |
|
not null |
Links to the SERVERS table. |
CREATIONDATE |
timestamp |
|
|
Time stamp of the action. |
DESCRIPTION |
varchar |
|
|
Undefined string describing an error. |
CODE |
integer |
|
|
Code representing the result of the action. For definitions, see Valid Entries for CODE. |
ACTIONCODE |
integer |
|
|
The action being performed. For definitions, see Valid Entries for ACTIONCODE. |
Primary key (POLICYACTIONKEY)
RC_POL_SUCCESS |
= 0 |
RC_POL_PARTIAL_SUCCESS |
= 1 |
RC_POL_FAILURE |
= -1 |
RC_POL_EMPTY |
= -2 |
Exception: If the value in the ACTIONCODE field is AC_POL_DOWN_CONNECTIONS or AC_POL_DOWN_DISCONNECTIONS, then the value of CODE is either the current number of active connections, or the number of forced disconnects.
A number 1 in the CODE field can mean one of the following:
This is because the meaning of the entry in the CODE field is determined by the content of the ACTION CODE field.
Contains one record for each action taken on a Server Software Package.
Field Name | Type | Use |
|
|
---|---|---|---|---|
PACKAGEACTIONID |
integer |
|
not null |
Assigned automatically: Default Auto increment. |
PACKAGEGUID |
char |
|
not null |
Links to the PACKAGES table. |
SERVERID |
integer |
|
not null |
Links to the SERVERS table. |
CREATIONDATE |
timestamp |
|
|
Time stamp of the action. |
DESCRIPTION |
varchar |
|
|
For definitions, see Valid Entries for DESCRIPTION. |
CODE |
integer |
|
|
Code representing the results of the action. For definitions, see Valid Entries for CODE. |
ACTIONCODE |
integer |
|
|
Code representing the action being performed. For definitions, see Valid Entries for ACTIONCODE. |
STARTEDPACKAGEACTIONID |
integer |
|
|
0 = started running the package, |
Primary key (PACKAGEACTIONID)
Contains one record for each server Server Software Package component.
Field Name | Type | Use |
|
|
---|---|---|---|---|
SOFTWARECOMPONENTACTIONKEY |
integer |
|
not null |
Assigned automatically: Default Auto increment. |
PACKAGEACTIONID |
integer |
|
not null |
Links to the PACKAGEACTION table. |
NAME |
char |
|
not null |
Name of the software component. |
CREATIONDATE |
timestamp |
|
|
Time stamp of the action. |
DESCRIPTION |
varchar |
|
|
The first record for the component the description is the description provided by the user when the component was created. As the components finish the description is one of those defined under Valid Entries for DESCRIPTION. |
CODE |
integer |
|
|
Code representing the results of the action. For definitions, see Valid Entries for CODE. |
ACTIONCODE |
integer |
|
|
Code representing the action being performed. For definitions, see Valid Entries for ACTIONCODE. |
Primary key (SOFTWARECOMPONENTACTIONKEY)
Following are the database table definitions for Tiered Electronic Distribution.
Contains one record for each Distributor, Subscriber, and External Subscriber in the tree.
Primary key (ID)
Unique (NAME)
Contains one record for each Channel object in the tree.
Field Name | Type | Use |
|
|
---|---|---|---|---|
ID |
numeric(8,0) |
identity |
not null |
Unique number automatically assigned. |
NAME |
varchar(255) |
|
not null |
DN of Channel object. |
Primary key (ID)
Unique (NAME)
Contains one record for each Distribution object in eDirectory.
Primary key (ID)
Unique (NAME)
Contains one record for each version of a Distribution and it is linked to the TAB_DISTRIBUTION table.
Primary key (ID)
Unique (DISTRIBUTION_ID, VERSION)
Contains multiple records for each Distribution version for Send, Received, and Extracted.
Field Name | Type | Use |
|
|
---|---|---|---|---|
ID |
numeric(12,0) |
identity |
not null |
Unique number automatically assigned. |
DIST_VERSION_ID |
numeric(10,0) |
|
not null |
Links to the TAB_DIST_VERSION table. |
NODE_ID |
numeric(8,0) |
|
not null |
Links to the TAB_NODE table for the node performing the following tasks:
|
TIMESTAMP |
datetime |
|
not null |
Time stamp when the action was logged into the database. |
STAGE |
char |
|
not null |
"C"=Create |
STATUS |
char |
|
not null |
"S"=Success |
STATUS_TIMESTAMP |
datetime |
|
not null |
Time stamp when the record was updated. |
REASON_TEXT |
varchar(255) |
|
|
Reason for success or failure. For definitions, see Valid Entries for REASON_TEXT. |
CHANEL_DIST_ID |
numeric(8,0) |
|
|
Links to the TAB_CHANNEL_DISTRIBUTION table. |
Primary key (ID)
The following are valid entries for the REASON_TEXT field name:
Self-explanatory.
This one is received in one of two situations: 1) there is a new configuration on the Subscriber so it needs to be updated before it can receive the Distribution; or, 2) there is a signature exception, such as the Subscriber cannot trust the Distribution came from a Distributor it trusts.
The Distribution was cancelled for a controlled reason.
Something unexpected failed. For example, a socket exception, transport exception, and so on.
Contains one record for each Channel/Distribution.
Primary key (ID)
Unique (CHANNEL_ID, DISTRIBUTION_ID)
Foreign keys set up relationships between tables.
" add foreign key FK_TAB_DIST_REF_591_TAB_NODE (DISTRIBUTOR_ID)" + " references TAB_NODE (ID) on update restrict on delete restrict;";
" add foreign key FK_TAB_DIST_REF_37_TAB_NODE (DISTRIBUTOR_ID)" + " references TAB_DISTRIBUTION (ID) on update restrict on delete restrict;";
" add foreign key FK_TAB_DIST_REF_380_TAB_NODE (DIST_VERSION_ID)" + " references TAB_DIST_VERSION (ID) on update restrict on delete restrict;";
" add foreign key FK_TAB_DIST_REF_1525_TAB_NODE (NODE_ID)" + " references TAB_NODE (ID) on update restrict on delete restrict;";