9.2 Setting Up Reporting

The reporting setup you need depends on the kind of reports you want to generate, as summarized in the table below. Steps for completing the reporting setup are given after the table.

IMPORTANT:Reporting works only if you run ConsoleOne on a Windows computer with 128 MB of RAM. It doesn't work if you run ConsoleOne on NetWare, Linux, Solaris, or Tru64. In addition, the eDirectory tree you are reporting on must contain a NetWare volume to install the report catalog files on. If your eDirectory tree doesn't contain a NetWare server, you can't set up reporting in ConsoleOne.

To Generate These Reports

Complete This Setup

Novell-defined eDirectory reports, with minimal customization

  1. Install Reporting Services extensions to the schema of your eDirectory tree.

  2. Install the Novell-defined report catalogs in your eDirectory tree.

  3. On each Windows computer that you will use to generate reports, install the ODBC driver for eDirectory and configure the data source you want.

Reports provided by other products, such as ZENworks

See the documentation for the product that provides the reports.

Custom reports designed from scratch

  1. Complete the above setup for generating Novell-defined eDirectory reports.

  2. Add the JReport Designer tool to your ConsoleOne installation as explained in Section 9.4, Designing Custom Reports.

In This Section

9.2.1 Installing Reporting Services Schema Extensions

  1. Click anywhere in an eDirectory tree.

  2. Click Tools > Install.

  3. Follow the instructions in the wizard to complete the installation.

    Be sure to select Reporting Services on the second screen. Help is available throughout the wizard.

9.2.2 Installing Novell-Defined Report Catalogs

  1. Select the container that you want to put the Report Catalog objects in.

    HINT:You can install the Catalog objects in as many containers as you want. This lets different organizations or departments configure their reports independently.

  2. Click Tools > Install Novell-Defined Reports.

  3. Select the report catalogs to install and the location to store the associated catalog files.

    See Section 9.1, Available Reports for descriptions of the Novell-defined report catalogs.

    Click Help for details on selecting the location to store the catalog files.

  4. Click Install.

9.2.3 Installing the ODBC Driver for eDirectory on a Windows Computer

  1. If ConsoleOne isn't installed locally on the Windows computer, in Windows Explorer locate the mapped or shared drive that represents the remote server volume where ConsoleOne is installed.

    Otherwise, skip this step.

  2. Browse to the folder where ConsoleOne is installed.

    By default, this is:

    Windows

    C:\NOVELL\CONSOLEONE\1.2

    NetWare

    SYS:PUBLIC\MGMT\CONSOLEONE\1.2

  3. In the \REPORTING\BIN subfolder, double-click ODBC.EXE.

  4. Follow the instructions in the wizard to complete the installation.

9.2.4 Configuring the Data Source Used by a Report Catalog

  1. In the Windows control panel, double-click the ODBC icon.

  2. On the User DSN tab, click Add > select the ODBC driver to be used > click Finish.

    Select Novell ODBC Driver for NDS if you want to use eDirectory as your data source. This is required for the Novell-defined eDirectory report catalogs.

  3. In the Data Source Setup dialog box, enter a name for the data source and fill in any other information required by your reporting system > click OK.

    The name should match the data source specified in the report catalog. For the Novell-defined eDirectory report catalogs, enter "NDS Reporting" as the name and skip the other fields in the dialog box. (They are ignored by the Novell-defined NDS report catalogs.)

  4. Click OK.