To generate the inventory report:

1. Invoke the Inventory report by using any of the following methods:

   • To invoke the Inventory report from a database object, right-click the database object, then click ZENworks Reports.

   • To invoke the Inventory report from the ConsoleOne Tools menu, you must first configure the database, click Tools, then click ZENworks Reports. For more information on how to configure the database, see Configuring the Inventory Database.

2. Click the report you want to generate.

   The description for the report is displayed on the right side of the screen.

   See the table with listing of simple Inventory lists and listing of the comprehensive inventory reports.

3. Specify the selection criteria.

   The Scope selection criteria is enabled only if both ZENworks 7 Desktop Management and ZENworks 7 Server Management are installed on the same machine.

   For example, to view all inventoried servers that have the Windows 2000 operating system, you would select Operating System Listing, specify the selection criteria scope as Both, and the operating system type as Windows 2000. The report displays the inventory information of all servers within the configured Inventory database.

   Depending on the type of report you want, you can filter the information. For example, to view all inventoried servers with the Windows operating system, you select the Operating System Listing, and specify the selection criteria Scope as Both, the Operating System Type as Windows, and the Operating System Version as 2000.

   Follow these guidelines as you work with the Reporting dialog box:

   • The selection criteria in the Inventory report are case sensitive

     For example, if you want to know the list of machines whose Distinguished Name is CN=MACHINE1.OU=ENG.O=NOVELL, specify OU=ENG.O=NOVELL as the selection criterion. All the machines whose DN contains OU=ENG.O=NOVELL are displayed in the Inventory report, but the machines whose DN contains ou=eng.o=novell are not displayed in the Inventory report.

   • If the Reporting dialog box allows wildcards, you can use an asterisk (*) or question mark (?) with all selection criteria. The wildcard characters can be used for text fields only.

     You can use * to retrieve the remaining entire text of a string where as ? can be used to retrieve only one character of a string.

     Example 1: Lets assume that a machine name is "server1". If you query using ser*, then server1 is found. If you query using ser?, then the machine is not found. To find server1 using the ?, you must query using ser????, where each ? represents a character.

     Example 2: Lets assume that the machine name is "CN=MACHINE1.OU=ENG.O=NOVELL.T=TREE". To find the machine, you can query by using "CN=MA*.OU=ENG.O=NOVELL.T=TREE" or CN=MA*. The machine name can be queried partly also. If you want to query by "O=novell.T=TREE", use * as "*O=novell.T=TREE".

     The following table lists examples of wildcards usage:

     Example	Specifies to Include
     *	All items
     164.99.*	All items starting with 164.99.
     164.9?.215.23	All items starting with 164.9, followed by any character, and ending with ".215.23"
     164.96.215.23	The single named item, in this case the inventoried server with the specified IP address

4. Click Run Selected Report.

   A status box appears displaying the progress of the report generation. When the report is generated, it appears in the viewer. Use the buttons on the toolbar to page through, print, or export the report.

   NOTE:ZENworks Inventory report supports only the following double-byte character languages: German, English, Spanish, French, Portuguese, and Japanese. Other double-byte characters might not be displayed properly in the Inventory reports.

To print a report:

1. Generate and view the report.

2. To change the default settings of the Printer, click the Printer Setup icon and modify the settings.

3. Click the Printer icon .

To export an inventory report to a file:

1. Generate and view the report.

2. On the toolbar, click the Export Report icon .

3. In the Export dialog box, specify the location and file format.

   If you choose to export the Inventory report to a text file, in the Export to Text dialog box, select the User defined option and set the value to 16 because the data exported will be truncated if the value is less than 16.

   If you want to export the Inventory report to an HTML file, you can select HTML 3.2 or HTML 4.0 (DHTML) file format. We recommend that you export to HTML 4.0 (DHTML) because the data exported to HTML 3.2 is not formatted properly.

   If you want to export the Inventory report to a comma-separated value (.csv) file, do the following:

   1. Export the report to Microsoft* Excel.

      NOTE:If you choose to export to .csv at this point, the report is not properly exported.

   2. Open the .xls file.

   3. Click File, then click Save As.

   4. In the Save as type field, choose CSV (Comma delimited) (*.csv).

   5. Click Save.

4. Click OK.

5. Browse for and select the directory where you want to save the exported file.

6. Click OK.

1. On the machine where you are designing the report, set the ODBC DSN name to ZenInventory.

   To set the ODBC name:

   1. Click Start, click Settings, then click Control Panel.

   2. Double-click ODBC Data Sources (32 Bit), then click Add.

   3. Select the ODBC driver for the database you want to connect to.

   4. Click Finish.

   5. Specify the Data Source name as ZenInventory and specify the details.

      NOTE:If you want to specify a data source name other than ZenInventory, you must configure the ODBC name on the each of the machines where you invoke user-defined reports through ConsoleOne.

2. After you have designed the report, place the report in the \consoleone\version\reporting\canned\novellreporting\ zeninventory\locale directory.

   Where locale can be EN for English language reports, FR for French language reports, PT_BR for Portuguese-Brazilian language reports, DE for German language reports, and ES for Spanish language reports. The non-English reports are displayed based on the respective locale of the machine.

3. Set the values in the userreports.ini file in the \consoleone\version\bin directory. The userreports.ini file must contain the following values:

   #[ReportName] <actual name of the report file without the .rpt extension>
   

   #DisplayName=User Defined Report’s display name
   

   #Param1=Constant,Display name,<if combo then {val-1|val-2|val-3}>
   

   #<where Param1 is the internal name of the parameter as stored in the .rpt file>
   

   #<Constants are 1, 2 and 3 for Combo selection, text field and numeric field respectively>
   

   For example, you can set the value as given below:

   [ListSystemInformation]DisplayName=System Information
   

   Role=1,Role,{2|3|5}
   

   IPAddress=2,IP Address
   

   DNName=2,Distinguished Name
   

   DNTree=2,Distinguished Tree
   

   DNSName=2,DNS Name
   

   [ListMemory]
   

   DisplayName=Memory
   

   Role=1,Role,{2|3|5}
   

   IPAddress=2,IP Address
   

   DNName=2,Distinguished Name
   

   DNTree=2,Distinguished Tree
   

   DNSName=2,DNS Name
   

   MemoryLowerLimit=3,Memory Lower Bound
   

4. After you set the values in the userreports.ini file, the User Defined Report is displayed in the Inventory Reports tree. You can specify multiple reports in the userreports.ini files.

   NOTE:If the userreports.ini file is empty, the user cannot view the User Defined Reports in the Inventory Reports tree.

5. Click Run Selected Report.

1. Invoke the Quick Report wizard.

   The Create and Manage Quick Reports page is displayed.

2. Click New.

   

3. In the Define Query page, define the query criteria and specify the scope for viewing the data from the Inventory database.

   

   You can use either the default query or define a new query.

   To use the default query, click Next. The Quick Report is created with the default query: System Identification.Name Matches %.

   To define a new query:

   1. Select one of the following options.

      • Workstations: Select this option to view the data satisfying the specified filter conditions for inventoried workstations. If you have only Desktop Management installed, this option is enabled by default and the other two options are unavailable.

      • Servers: Select this option to view the data satisfying the specified filter conditions for inventoried servers. If you have only Server Management installed, this option is enabled by default and the other two options are unavailable.

      • Both: Select this option to view the data satisfying the specified filter conditions for both inventoried servers and inventoried workstations. If you want to view data for inventoried workstations only, or for inventoried servers only, use one of the other query options. This option is available only if you have both ZENworks 7 Desktop Management and ZENworks 7 Server Management installed.

   2. (Optional) If you want to apply the filter condition defined in the Define Query window, select the Enable Filter option.

      This option is available only if you define the query using the following software classes and its attributes in the Define Query window: Software Group, Software Group File Information, Software Group Patch Information, Software, File Information, Patch Information, Exclude File Information, and Disk Usage.

   3. Click Edit Query to change the query.

      

      For detailed information on how to change the query, see Viewing Inventory Information of Inventoried Servers by Querying the Database.

   4. Review the query and make changes as necessary. The Query to Perform pane displays the query you define.

   5. Click Next.

4. In the Database Fields page, do the following:

   

   1. From the Database Fields list, select the inventory attribute that you want to report.

      By default, System Identification.Name is selected. You cannot deselect or change the order of this attribute.

   2. Click to add the selected inventory attribute to the Selected Fields list.

      If you select a group attribute, all attributes of the group are added. For example, if you select the Software attribute, the Software attributes such as vendor name, product name, and version are included in the Selected Fields list.

   3. To add an additional inventory attribute, repeat Step 4.a and Step 4.b.

      NOTE:You can change the order of the attributes using and .

   4. To view the report, click View.

      The data is displayed in the Query Results window. For more information about the Query Results window, see Working with the Query Results Window.

   5. To save the report, click Save.

      IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.

   6. Click Close.

1. In the Create and Manage Quick Reports page, select the Quick Report that you want to modify from the list of Quick Reports.

   You can modify only one Quick Report at a time.

   By default, the list displays all the Quick Reports saved in the ConsoleOne_installation_directory\consoleone\1.2\reporting\export directory. To modify a Quick Report residing in another directory, click the Browse icon to browse and select the directory.

   IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.

2. Click Edit.

   

3. (Optional) In the Define Query page, change the existing query criteria and specify the scope for viewing the data from the Inventory database.

   1. Select one of the following options.

      • Workstations: Select this option to view the data satisfying the specified filter conditions for inventoried workstations.

      • Servers: Select this option to view the data satisfying the specified filter conditions for inventoried servers.

      • Both: Select this option to view the data satisfying the specified filter conditions for both inventoried servers and inventoried workstations.

   2. (Optional) If you want to apply the filter condition defined in the Define Query window, select the Enable Filter option.

      This option is available only if you define the query using the following software classes and its attributes in the Define Query window: Software Group, Software Group File Information, Software Group Patch Information, Software, File Information, Patch Information, Exclude File Information, and Disk Usage.

   3. Click Edit Query to change the query.

      For detailed information on how to change the criteria, see Viewing Inventory Information of Inventoried Servers by Querying the Database.

   4. Review the query and make changes as necessary. The Query to Perform pane displays the query you define.

   5. Click Next.

4. (Optional) In the Database Fields page, do the following:

   1. From the Database Fields list, select the inventory attribute that you want to report.

      By default, System Identification.Name is selected. You cannot deselect or change the order of this attribute.

   2. Click to add the selected inventory attribute to the Selected Fields list.

      If you select a group attribute, all attributes of the group are added. For example, if you select the Software attribute, the Software attributes such as vendor name, product name, and version are included in the Selected Fields list.

   3. To add an additional inventory attribute, repeat Step 4.a and Step 4.b.

      NOTE:You can change the order of the attributes using and .

   4. To view the report, click View.

      The report is displayed in the Query Results window. For more information about the Query Results window, see Working with the Query Results Window.

   5. To save the report, click Save.

      IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.

   6. Click Close.

1. In the Create and Manage Quick Reports page, select the Quick Report that you want to delete from the list of Quick Reports.

   By default, the list displays all the Quick Reports saved in the ConsoleOne_installation_directory\consoleone\1.2\reporting\ export directory. To delete a Quick Report residing in another directory, click the Browse icon to browse and select the directory.

   IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.

2. Click Delete.

   

1. In Create and Manage Quick Reports page, click Configure DB.

   

   The Configure ZENworks Database window is displayed.

2. Click Browse to select an existing ZENworks database object from the list.

   This database object contains the database settings such as the protocol, port in use by the database, and so forth.

3. Click OK.