The following sections will explain the various types of information you can view using ConsoleOne:
The Inventory Summary window displays the inventory items for an inventoried server. This window displays the data from the last inventory scan for the inventoried server. For more information, see Viewing the Inventory Summary of an Inventoried Server .
For more information about querying the Inventory database, see Viewing Inventory Information of Inventoried Servers by Querying the Database .
For more information, see Running Inventory Reports .
If you want to view the inventory information stored in the database from ConsoleOne, you must configure the database. The inventory information from the Inventory database that you configure will be used for generating inventory reports, viewing inventory information, and for querying the inventory information from the database.
To configure the Inventory database:
In ConsoleOne, select a container.
Invoke Configure DB.
Click Browse to browse for and select the ZENworks Database object.
You can also select an existing ZENworks Database object from the list of Database objects.
This Database object contains the database settings such as the protocol, port in use by the database, and others.
To apply this database configuration to all the sessions, select the Apply Configuration Across Sessions check box.
Click OK.
The database you configured is used for data retrieval unless you change it again using this same procedure.
The Inventory Summary window displays the data from the last inventory scan for the inventoried server.
To view the inventory information of an inventoried server:
Configure the Inventory database.
For more information, see Configuring the Inventory Database .
Right-click an inventoried server > click Actions > click Inventory.
ZfS provides the following inventory information collected from the inventoried servers:
NOTE: For an enumerated attribute, the value will be displayed in the format enumerated_value [enumerated_ID]. For example, Processor.Processor Family = Pentium (R) III [17].
The Status bar displays the following information:
Tree Name: Displays the eDirectory tree name where the inventoried workstation or inventoried server resides.
Recent Information: Set to Yes if the Inventory database has been updated with the latest inventory information of the selected inventoried server.
Using ConsoleOne, you can query the Inventory database to display the hardware and software components of inventoried servers that you want to view. The Inventory Query window displays the information satisfying the criteria you specify.
The Inventory database stores inventory data (general, hardware, software, network, and system information) for each inventoried server. Querying the Inventory database helps to create groups of similar devices and to focus your reports on specific types of machines. For example, you can query the database to find machines that have an i486D processor and a VGA card.
To query the Inventory database for inventory information:
In ConsoleOne, click a container.
Invoke Query.
Specify the criteria for query:
Query the Inventory database for: By default, the Servers option will be enabled. The query locates all inventoried servers satisfying the query expression. If ZENworks for Servers 3 and ZENworks for Desktops 4 are installed in the same environment; the Workstations, the Servers and the Both options will be available. When you select Servers, the query locates all inventoried servers satisfying the query expression. Choose Both to include all workstations and inventoried servers satisfying the query expression.
Find Type: Select Quick or Advanced. Click Quick to specify a simple query. When you choose a Quick query, you specify one attribute, relational operators, and the value of the attribute. Choose Advanced query to specify many attributes. You can combine multiple query groups so each group defines a set of query criteria. For example, use the Advanced query to run a query to discover all devices in the database with 486 processors and use query connectors, and add another query to discover which of these inventoried servers have a VGA color video adapter.
Display Machine(s) Not Satisfying the Query: Select the check box to retrieve machines that do not satisfy the query.
Select Attribute: Select the component or component attributes. Attributes that you can specify to query on the inventoried servers are grouped into the following categories: General, Software, Hardware, Network, and System.
The custom attribute will be prefixed by an asterisk (*).
For example, to find the machines that do not have pointing device installed, select Pointing Device as the component. To specify the version of BIOS as a component in the query, select BIOS as the component and VERSION as the component attribute.
Operator or Relational Operator: Select to determine the relationship between the components and the value. The relational operators are grouped on the basis on the data type of the attribute selected in the Select Attribute window as shown in the following table:
NOTE: If the query does not display the result when the data type of the attribute is Custom and the relational operator is Numeric or Date, use the Equal To operator to find the values for the custom attributes that are stored in the Inventory database.
If you select only the component in the Select Attribute window, the Relational Operator will be set to NULL by default and other relational operators will not be available.
Value: Description values are the possible values of an inventory component. For example, 6.0 is a possible value for the DOS-Version attribute. Description values are not case-sensitive.
NOTE: For an enumerated attribute, the value will be displayed in the format, enumerated_value [enumerated_ID]. For example, Processor.Processor Family = Pentium (R) III [17].
If you choose Matches ([ ]) or Does Not Match (![ ]) as the relational operator, you can use wildcards to substitute characters in the Value field. The following table lists the wildcards that can be used according the SQL documentation:
NOTE: To define a query using special characters such as ? or [, specify the query in the following formats: [?] or [ [ ].
The list of description values displayed for an Inventory component is taken from the Inventory database corresponding to the component.
Logical Operator: This option is available only for the Advanced query. Logical Operator forms query groups that will be combined with the previous query group by using the relational operator specified between the query groups.
Save: This option is available only for the Advanced query. It saves the query expression as a file in the location that you specify. The query file does not have a default extension; however, we recommend the .QRY extension for easy reference.
Load:This option is available only for the Advanced query. It loads the query file that you specify. You must provide the full filename with its extension.
Click Find.
This will query based on the query criteria you specify and display the inventoried servers that match the query in the Query Results window.
In the Query Results window, double-click the inventoried server or click File > Advanced Query to view the inventory information of the inventoried server.
Match: Use the Match operator to find the inventoried servers that satisfy the query condition.
For example, use the Match operator to find all the inventoried servers with IP address 164.99.151.%,
NULL: Use the NULL operator to query for those inventoried servers whose particular attribute is not scanned but the component has been scanned and some attributes are populated.
For example, to find a list of inventoried servers for which BIOS.Manufacturer is not scanned, form a BIOS.Manufacturer is NULL query. This query will display the inventoried servers for which the BIOS has been scanned.
NOT SATISFYING: Use the NOT SATISFYING query (or the NOT SATISFYING filter condition) to find filter conditions for the inventoried servers that negate the given query.
For example, two servers S1 and S2 contain serial ports COM1 and COM2. The query (SerialPort='COM1') will return S1 and the query (SerialPort!='COM1') will also return the S1 because S1 contains the serial port COM2. To query the inventoried servers that do not contain the serial port COM1 you must use <NOT SATISFYING>(SerialPort='COM1'). To use the NOT SATISFYING option, click the Display Machines Not Satisfying the Query check box in the query window.
You can run reports to gather inventory information from the Inventory database. The Inventory reports are designed using Crystal Reports.
You can select from a predefined set of report forms to generate a report. The inventory report is displayed in the Crystal Viewer window.
You can print or export the report as desired. Remember that any reports you generate will be empty if you have not configured ZfS to start populating the Inventory database with the data you want.
This section covers information on the following sections:
Before running the inventory reports you must make sure that the appropriate ODBC client for Sybase* or Oracle* is installed on the machine running ConsoleOne. The ODBC driver will be automatically configured on the machine when you invoke the Inventory report.
You can install the Sybase ODBC driver version 7.0.0.313 from the ZENworks for Servers Companion CD. To install the Sybase ODBC driver, copy the \ODBC\SYBASE\SYBASEODBC.ZIP from the ZENworks for Servers Companion CD to a drive. For installation instructions, refer to the ODBC\SYBASE\ODBCREADME.TXT on the ZENworks for Servers Companion CD.
You can generate the types of reports described below, assuming you have already configured ZfS to start populating the inventory database with the data you want. The following table gives the Simple Inventory lists that provide information on individual aspects of Server Inventory, such as the operating system and the selection criteria. The table also lists the Comprehensive Inventory Reports that combine several aspects of Server Inventory into each report, such as memory, hard disk, and processor.
Inventory Report Group | Report Name | Selection Criteria | Information Displayed in the Inventory Report |
---|---|---|---|
Hardware Inventory |
Asset Management Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name You can also select to display the following options in the report: Memory, Processor, Display Adapter, Keyboard, Pointing Device, Fixed and Removable Disk, Floppy, CD ROM, and Network Adapter. |
Memory, processor, display details, keyboard, pointing device, fixed and removable disk, floppy, CD drive, and network adapter details for each system |
|
BIOS Listing |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, BIOS Install Date, and Manufacturer |
List of all the machines with a BIOS manufacturer, BIOS release date, and the total number of such machines |
|
Devices Listing |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, and Devices Based on the device selected in the Devices drop-down list, the filter condition for the selected device will be displayed. |
List of all machines with a particular device. The devices are pointing device, keyboard, bus, video adapter, network adapter, sound adapter, modem, battery, and power supply. |
|
Storage Devices Inventory Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name You can also select to display the following options in the report: Fixed disk and Removable Disk, Logical Disk, Floppy, and CD ROM. |
Fixed disk, removable disk, logical disk, floppy, and CD drive details for each system |
|
Storage Device Listing |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, and Devices Based on the storage device selected in the Devices drop-down list, the filter condition for the selected device will be displayed. |
List of all machines with a particular storage device. The storage devices are fixed and removable disk, floppy, and CD drive |
|
System Information Listing |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name |
List of all machines with system information for each machine |
System Configuration Inventory |
Hardware Summary Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Operating System Type, Operating System Version, Processor Family, Max Clock Speed (Lower Bound in MHz), Max Clock Speed (Upper Bound in MHz), Total Memory (Lower Bound in MB), Total Memory (Upper Bound in MB), Fixed disk Size (Lower Bound in GB), and Fixed Disk Size (Upper Bound in GB) |
Operating system name, operating system version, processor family, processor maximum clock speed, memory, and fixed disk size for each machine |
|
Memory Listing |
Show Chart, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Total Memory (Lower Bound in MB), and Total Memory (Upper Bound in MB) |
List of all the machines within a range of memory size (such as 200-400 MB) and the total number of such machines |
|
Networking Information Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name You can also select to display the following options in the report: Network Adapter Type, DNS Name, IP Address, MAC Address, IPX Address, and Windows Domain Name. |
Network adapter type, DNS, IP address, MAC address, IPX address, and Windows Domain name for each system |
|
Operating System Listing |
Show Chart, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Operating System Type, and Operating System Version |
List of all the machines with an operating system type, an operating system version, and the total number of such machines |
|
Processor Listing |
Show Chart, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Processor Family, Maximum Speed (Lower Bound in MHz), Maximum Speed (Upper Bound in MHz), Current Speed (Lower Bound in MHz), and Current Speed (Upper Bound in MHz) |
List of all the machines with a processor family (such as Pentium Pro), processor maximum clock speed, and processor current clock speed of such machines |
|
System Internal Hardware Inventory Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name You can also select to display the following options in the report: System IRQ, System Cache, System DMA, System Slot, and Motherboard. |
IRQ, cache, DMA, slot, and motherboard for each system |
Software Inventory |
Application Software Inventory Report |
Product Location, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Include Product Location, Software Vendor, Software Name, and Software Version |
Software with product name, version, vendor, product ID, product location, and recent information for each system |
|
Software Listing |
Include Product Location, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Software Vendor, Software Name, and Software Version |
List of all the machines with a software vendor, software name, version, and the total number of such machines |
|
Software Summary Listing |
Show Chart, Scope, Software Vendor, Software Name, and Software Version |
Lists the number of machines with a particular software version HINT: The Software Summary Listing chart might not be displayed properly because there is too much software data in your Inventory database. For the chart to be displayed properly, use the selection criteria effectively to restrict the results displayed according to your requirement. |
|
System Software Inventory Report |
Scope, Distinguished Name, Distinguished Tree Name, IP Address, and DNS Name You can also select to display the following options in the report: Display Driver, Pointing Device Driver, Network Adapter Driver, and NetWare Client. |
Drivers (such as pointing device drivers, network adapter drivers, and display drivers) and NetWare Client for each system. |
Others |
Inventory Scan Listing |
Show Chart, Scope, Distinguished Name, Distinguished Tree Name, IP Address, DNS Name, Last Scan Date (On or Before), Inventory Server Name, and Recent Information |
Date and time of the last inventory scan, Inventory server name, and recent information on each system |
|
User Defined Reports For more information on how to create user-defined reports, see Understanding User-Defined Reports |
Based on the options specified by the user in the CONSOLEONE\ConsoleOne_version\BIN\USERREPORTS.INI file |
Displays the user-defined report. |
NOTE: The Show Chart selection criteria display a graphical representation of the Inventory report.
If the Reporting dialog box allows wildcards, you can use an asterisk (*) or question mark (?) with all selection criteria except for Distinguished Name and Distinguished Tree Name. The wildcard characters can be used for character data only.
For Distinguished Name, if you just specify a part of the DN, all machine names containing the specified string in the DN are displayed. For example, if you want to know the list of machine whose Distinguished Name contains "novell.invtree", specify "novell.invtree" as the selection criterion and all the machines whose DN contains "novell.invtree" are displayed in the Inventory report.
Even for Distinguished Tree Name, if you just specify a part of the tree name, all machines containing the specified string in the machine name are displayed in the Inventory report.
The following table lists examples of wildcards usage.
To generate the inventory report:
Invoke Inventory report by using any of the following methods:
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.
Specify the selection criteria.
The Scope selection criteria will be enabled only if both ZfD 4 and ZfS 3 are installed on the same machine.
For example, if you want to view the inventory information of all inventoried servers, select Server as the scope selection criteria. The report will display 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 NT* operating system, you select the Operating System Listing, and specify the selection criteria Scope as Both, Operating System Type as Windows NT, Operating System Version as 3.0
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.
To print a report:
To change the default settings of the Printer, click the Printer Setup icon and modify the settings.
Click the Printer icon .
To export an inventory report to a file:
On the toolbar, click the Export Report icon .
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 will not be formatted properly.
If you want to export the Inventory report to a comma-separated value (.CSV) file, do the following:
Click OK.
Browse for and select the directory where you want to save the exported file.
Click OK.
Using the Crystal Report Designer you can generate reports with the data present in the Inventory database.
Before generating the reports, you must ensure that the report file (.RPT) is created using Crystal Report Designer 8.0 or later. For more information on how to create a .RPT file, see the Crystal Report documentation.
To generate the User-defined Inventory report:
On the machine where you are designing the report, set the ODBC DSN name to ZenInventory.
To set the ODBC name:
Click Start > Settings > Control Panel > ODBC Data Sources (32 Bit) > Click Add.
Select the ODBC driver for the database you want to connect to.
Click Finish.
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.
After you have designed the report, place the report in the \CONSOLEONE\VERSION\REPORTING\CANNED\NOVELLREPORTING\ZENINVENTORY\EN directory.
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
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.
Click Run Selected Report.