1. In ConsoleOne®, right-click the container where you want to create the object, click New, then click Object to display the New Object dialog box.

2. Select ZENworks database, then click OK to display the New ZENworks Database dialog box.

   

3. In the Name box, type a name for the database, such as Desktop Management Database_ZENServer.

4. Select the Define additional properties check box, then click OK to display the ZENworks Database property page.

   

5. In the Server DN field, browse for and select the Server object for the server where the database is physically installed and running.

6. Fill in the name and password fields for the Read-write, Read only, and Write only users:

   Database (read-write) user name: Specify a username to provide both read and write access to the database. If you are using a Sybase database created by the Desktop Management Server installation program, the user name is MW_DBA.

   Database (read-write) password: Specify a password for the Read-Write user. If you are using a Sybase database created by the Desktop Management Server installation program, the password is novell.

   Database (read only) user name: Specify a username to provide only read access to the database. If you are using a Sybase database created by the Desktop Management Server installation program, the user name is MW_READER.

   Database (read only) password: Specify a password for the Read Only user. If you are using a Sybase database created by the Desktop Management Server installation program, the password is novell.

   Database (write only) user name: Specify a username to provide only write access to the database. If you are using a Sybase database created by the Desktop Management Server installation program, the user name is MW_UPDATER.

   Database (write only) password: Specify a password for the Write Only user. If you are using a Sybase database created by the Desktop Management Server installation program, the password is novell.

7. Click OK to save the information.

To provide the ODBC information:

1. Right-click the database object, then click Properties.

2. Click the ODBC Driver Information tab.

   

3. Fill in the following fields:

   Driver file name: Specify the name of the workstation ODBC driver file that Application Launcher will use to access the database. For Sybase, you can leave the field empty, in which case Application Launcher automatically detects the installed driver.

   Data source name: Enter NAL Reporting.

   Connection parameters: Specify the appropriate commands to connect to the database. For Sybase, these commands are:

   CommLinks=TCPIP{Host=IPAddress:2638};AutoStop=Yes;Integrated=No;DBN=NAL;ENG=IPAddress
   

   where IPAddress is the actual IP address of the server where the database resides.

4. Click OK to save the ODBC driver information.

To grant rights:

1. Right-click the ZENworks Database object, then click Trustees of this object.

2. Click Add trustee.

3. Select [PUBLIC], then click OK to add [PUBLIC] to the list of trustees.

   Adding [PUBLIC] as a trustee gives every user Read and Compare rights to all of the database object's properties, including the various user names and passwords that can be used to access the database. To avoid this, you need to limit the [PUBLIC] access to the three ODBC properties.

4. In the Property list, select [All Attribute Rights], then click Delete property to remove it from the list.

5. Click Add property to display the Add Property dialog box, select zendbODBCConnectionParameters, then click OK to add it to the Property list.

   The default rights, Read and Compare, are sufficient. You do not need to change these rights.

6. Repeat Step 5 to add the following properties (keep the default rights: Read and Compare):

   • zendbODBCDataSouceName
   • zendbODBCDriverFileName
   • Host Server
   • Network Address
   • zendbUser
   • zendbPassword

7. Click OK, then click OK again to save the changes.

To activate a ZENworks Database policy and associate containers with it:

1. In ConsoleOne®, right-click the Service Location Package you want to use, then click Properties.

   or

   If you do not have a Service Location Package, right-click the container where you want to create one, click New, then click Policy Package. Follow the instructions provided in the Policy Package Wizard to create a Service Location Package.

   

2. On the General page, select the check box in the Enabled column to enable the ZENworks Database Policy.

3. Select the ZENworks Database Policy in the list, click Properties to display the ZENworks Database properties page, then click the Application Management tab to display the Application Management page.

   

4. In the Database DN field, browse for and select the database object you want to use for application event reporting. This should be the same object you configured in Configuring the Database's ODBC Information.

5. Click OK to return to the General page.

6. Click Associations to display the Associations page.

   

   You use this page to associate the Service Location Package with the containers where the users or workstations reside whose reports you want sent to the database. If a parent container includes several containers where User and Workstation objects reside, you can select the parent container rather than each individual container.

7. Click Add, browse for and select the container you want to add, then click OK to add it to the list.

8. Repeat Step 7 to add additional containers.

9. When you've finished adding containers, click OK to save the information.