Novell Home

My Favorites

Close

Please to see your favorites.

How to configure Application Reporting in ZfD 4.

(Last modified: 02Aug2004)

This document (10057066) is provided subject to the disclaimer at the end of this document.

goal

How to configure Application Reporting for NAL

fact

Novell ZENworks for Desktops 3.0

Novell ZENworks for Desktops 4

Novell Application Launcher (NAL) 3.1

symptom

Application Launcher reporting is significantly enhanced for ZfD 3.x and 4.  The Application Launcher has its own database, NAL.DB, now with multiple tables, namely successes and failures.

fix

IMPORTANT: Before you set up database reporting for NAL in ZENworks for Desktops 4, keep in mind that Novell does not provide any NAL Reporting canned reports in ZENworks for Desktops 4. A 3rd party utility must be used to run SQL queries to generate the desired reports. (Crystal Reports, Access, Excel, etc.) An alternative is to use NAL log file reporting.  

See these ZFD4 links for more information:
"Generating Reports from a Database"
http://www.novell.com/documentation/zdpr/index.html?page=/documentation/zdpr/zdpradmn/data/a7l5fu4.html

" Setting Up Database Reporting"
http://www.novell.com/documentation/zdpr/index.html?page=/documentation/zdpr/zdpradmn/data/a7l3xhr.html

To use the Application Launcher reporting with ZENworks for Desktops 3:

1.  Install the Sybase database during the ZfD installation.

1a. The ODBC driver for the desired database must be installed on each end user workstation.  This driver comes with Windows NT, 2000, & XP by default. The example below is for Sybase Database.  The ODBC driver must be able to contact the server...this can be tested by using the 'Test Connection' button in the ODBC sources list found in the control panel.  To configure the drivers...refer to the vendor documentation. 

2.  Configure the ODBC Driver Information tab
In ConsoleOne, open the properties of the ZENworks Database object.  On the ODBC Driver Information tab, carefully type the following information:

Driver File Name:        dbodbc6.dll OR dbodbc7.dll (depending on the driver your using)
Data Source Name:        Novell Reporting
Connection Parameters:        CommLinks=TCPIP{Host=<IP>:2638};AutoStop=Yes;Integrated=No;DBN=NAL;ENG=<IP>
        
Note:  Replace <IP> with the IP Address of the server running Sybase.
Click "OK" to save the ODBC driver information.

3.  Grant user's specific, limited rights to the ZENworks database object
Right-click the ZENworks Database object and select Trustees of this Object.  Add a trustee for [Public] or the container (or a parent container) of the users running the NAL applications.  Assign the following rights:
For [Entry Rights], grant Browse
Delete the entry for [All Attributes Rights] and add Read & Compare only for 3 specific property rights:  
    zendbODBCConnectionParameters
    zendbODBCDataSourceName
    zendbODBCDriverFileName

Step 3 is not absolutely required, but if you don't restrict the Attribute Rights, the username and password for accessing the database will be exposed unnecessarily.

4.  Set up a Service Location Package (a type of Policy package).

a. Highlight the desired container and select File > New > Policy Package from main ConsoleOne menu.
b. Select "Service Location Package" and press <Next>.
c. Give the package a name.
d. Check "Define Additional Properties" and press <Finish>.
e. Enable the ZENworks Database policy and click Properties.
f. On the Database Location tab, browse for the ZENworks Database object.
g. Click "OK" to save the DN.
h. On the Associations tab of the Package, associate the service location package with the container where your user objects are located.
Note:  There can be only one Service Location Policy per container.

5.  Enable reporting on desired application objects and select events to store in database (Common > Reporting page of application objects). If you also want to log events to a file, specify the path to the log file, including the filename and extension, if desired.

Now you are ready to test the database reporting capabilities of ZENworks Application Management.  Launch a few applications to make some entries into the database.  Using the included canned reports (for ZfD3x), view the events logged to the database.  To view the canned reports, right-click on the NDS database object and select Reporting.  Choose an available ZENworks NAL Report and choose an Event Type.  Click 'Run Selected Report'.  With the database schema definition you can use 3rd party reporting tools to view and report on the database, as well.

cause

Troubleshooting Application Reporting
See Troubleshooting Application Reporting in ZfD 3 for more information.

For additional information, visit the online documentation:

ZENworks for Desktops 4:  http://www.novell.com/documentation/lg/zdpr/index.html?zdpradmn/data/a6ttaq3.html  

ZENworks for Desktops 3:  http://www.novell.com/documentation/lg/zfd3/docui/index.html

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.

  • Document ID:
  • 10057066
  • Solution ID: NOVL26941
  • Creation Date: 21Sep2000
  • Modified Date: 02Aug2004
    • NovellManagement Products

Did this document solve your problem? Provide Feedback