17.1 Viewing the Inventory Information Using ConsoleOne

The following sections explain the various types of information you can view using ConsoleOne:

17.1.1 Configuring the Inventory Database

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 is used for generating inventory reports, viewing inventory information, and for querying the inventory information from the database.

To configure the Inventory database:

  1. In ConsoleOne, select a container.

  2. Invoke Configure DB.

    • To invoke Configure DB from a database object, right-click the database object, click ZENworks Inventory, then click Configure DB. This configures the database object.

    • To invoke the Configure DB dialog box from the ConsoleOne Tools menu, click Tools, click ZENworks Inventory, then click Configure DB.

  3. 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.

  4. To apply this database configuration to all the sessions, select the Apply Configuration Across Sessions check box.

  5. Click OK.

The database you configured is used for data retrieval unless you change it again using this same procedure.

17.1.2 Viewing the Inventory Summary of an Inventoried Server

The Inventory Summary window displays the information from the last inventory scan for the inventoried server.

To view the inventory information of an inventoried server, do the following in ConsoleOne

  1. Configure the Inventory database.

    For more information, see Configuring the Inventory Database.

  2. Right-click any of the following objects: Subscriber, Distributor, or External Subscriber, click Actions, then click Inventory.

    or

    In the Query Results window, double-click an inventoried server.

ZENworks 7 Server Management provides the following inventory information collected from the inventoried servers:

Table 17-1 Inventory information as displayed in Inventory Summary

Scan Data Group

Scan Data Item

Description

Inventory Information

Inventory Server

Name of the Inventory server to which the scans are sent

Last Scan Date

List of all inventoried servers that were scanned on or before the specified date and time

 

Scan Mode

Mode used by the Inventory scanner to scan the inventoried server

 

Version

Version number of the Inventory scanner

 

General Dictionary Version

Version number of the General Dictionary

NOTE:The General Dictionary version is not same as the ZENworks product version.

 

Private Dictionary Version

Version number of the Private Dictionary

Hardware/Software Inventory > General > System Information

Asset Tag

Asset tag number that the ROM-based setup program creates

 

Computer Model

Identifying information of the computer such as Compaq or Dell

 

Computer Type

Type of computer such as IBM PC

 

Machine Name

DNS name of the inventoried server

 

Management Technology

Technology available on the inventoried server such as DMI, WMI, and others

 

Model Number

Model number of the computer

 

Serial Number

Serial number of the computer system assigned by manufacturer

 

Tag

Unique identifier of system information

Hardware/Software Inventory > General > System Identification

Primary Owner Name

The name of the primary user or owner of this system

 

Primary Owner Contact

The phone number of the primary user of this system

 

Name

Name of the inventoried server as represented in eDirectory, such as the fully qualified DN of the inventoried server

Hardware/Software Inventory > General > Login Details > eDirectory Login Details

Current login user

User logged in to the Primary eDirectory tree when the inventoried server was scanned

 

Last login user

User most recently logged in to the Primary eDirectory tree through Novell Client when the inventoried server was scanned

Hardware/Software Inventory > General > Login Details > Windows Domain

Name

Domain name of the inventoried server

Hardware/Software Inventory > Software > Application Vendors > Vendor_name > software_group_name > software

Name

Vendor-defined name of the product represented as a vendor trademark or registered trademark

 

Version

User-friendly version of a product.

For example, the version for Windows 2000 is 2000 or Major.Minor Version of the Product

 

Category

Product category to which the product belongs

For example, Office is a part of the Productivity tools category and Solitaire is a game

 

Description

Description of the product

 

Help Link

Support Web site URL for the product that is available in ARP and MSI

 

Package GUID

Vendor-defined GUID for a product that is available in MSI

 

Product Identifier

A unique, 16-character identifier for an installed product. This identifier is available from MSI on Windows.

The format is ABCD-1234-WXYZ-PQRS

 

Internal Version

Internal version of a product

The format is:

major version.minor version.build.sub build number

or

major version.minor version.build

 

Language

User-friendly name for the language of this copy of the product

 

Uninstall String

The command to invoke for uninstalling this product instance. Currently, this is available in Add/Remove Programs (ARP) and MSI on Windows.

 

Install Source

Identifies the file system path where the installation files were stored when installing this product instance. Currently, this is available in ARP and MSI on Windows.

 

Last Execution Time

Date and time stamp when the product was last executed

 

Frequency of Usage

Number of times the product has been used

 

Friendly Name

Display name of the software

 

Installation Repository

Source of scan, which can be Add/Remove Programs, MSI, Software Dictionary, or PRODUCTS.DAT

 

Support Pack

Installed support pack number of the product

 

Product Edition

Product edition defined by the vendor. For example, Professional

 

Path

Directory path where the product is installed on the computer system

 

AntiVirus Definition Date

NOTE:This is applicable only for antivirus products.

The date of the virus definition file installed on the computer. Some anti-virus products combine date and version into a single string.

 

AntiVirus Definition Version

NOTE:This is applicable only for antivirus products.

The vendor-defined version of the virus definition file that has been installed on a computer.

Hardware/Software Inventory > Software > Application Vendors > Vendor_name > software_group_name > software > Patches

Name

Vendor-defined name for the patch

Hardware/Software Inventory > Software > Application Vendors > Vendor_name > software_group_name > software > Representative File Information

File Name

Name of the file representing the software

 

File Version

Version of the file representing the software

 

File Size

Size of the file representing the software

 

Last Modified

Last modified date of the file representing the software

 

Internal Name

Internal name

 

Product Version

The version of the product represented by this file

 

Company

Vendor name

 

Product Name

The product that this file represents

 

Language

User-friendly name for the language of this copy of the file

 

File Path

Location of the file on the inventoried server

 

Software Dictionary ID

ID of the file as represented in the General software dictionary

Hardware/Software Inventory > Software > Disk Usage

File Extension Name

The file extension for which the disk usage is scanned for.

 

Total Disk Usage

Total disk usage for all the files of the specified extension.

Hardware/Software Inventory > Software > Device Drivers > Pointing Device Drivers > Pointing Device driver name

Name

Name of the mouse driver

 

Version

Version number of the mouse driver

Hardware/Software Inventory > Software > Device Drivers > Display Drivers

Install Date

Install date of the display driver

 

Manufacturer

Name of the display driver manufacturer

 

Is Shadowed (True or False)

If True, the display driver is currently being shadowed

 

Version

Version number of the display driver

Hardware/Software Inventory > Software > Device Drivers > Network Drivers

Description

Description of the network driver

 

Name

Network driver name

 

Version

Version number of the network driver

Hardware/Software Inventory > Software > Operating System

Code Page

Language code page of the operating system

 

OS Type

Operating system of the inventoried server

 

Install Date

Install date of the operating system

 

Caption

Operating system name, for example, Windows 95/Windows 2000

 

Other Description

Additional description of the operating system if available

 

Role

Type of the operating system such as server or workstation

 

Total Virtual Memory Size

Total number of bytes in the virtual address space of the calling process

 

Total Memory Size

Total memory of the operating system

 

Version

Version number of the operating system

Hardware/Software Inventory > Hardware > Monitor

Device ID

Unique ID of a desktop monitor that is attached to a computer system

For example, DesktopMonitor1

 

Description

Description of the monitor.

 

Nominal Size

A number representing the diagonal width of the monitor (the distance from one corner of the screen to the opposite corner of the screen)

For example, 17”

You can customize the scan of the nominal size of the monitor by configuring the HWRules ini file using the Server Inventory policy.

 

Viewable Size

A number representing the diagonal width of the screen image excluding the black borders around the image's edge

For example, 15.8”

 

Manufacturer

Name of the monitor's manufacturer

For example, DELL* Computer Corp

 

Serial Number

Manufacturer's number used to identify a monitor

For example, 23DDC24N9067

 

Model

Product name of the monitor given by the manufacturer

For example, DELL E771a

 

Manufacture Date

Year in which the monitor was manufactured

For example, 2003

 

Model ID

Unique ID of a model of the monitor; it is a combination of the Manufacturer ID and Product ID

For example, DELA001

Hardware/Software Inventory > Hardware > Chassis

Asset Tag

Asset tag number of the system chassis

For example, S11127

 

Number of Power Cords

Total number of power cords attached to a system chassis

 

Chassis Type

Represents whether the system chassis is a laptop, desktop, notebook, docking station and so on

 

Manufacturer

Name of the system chassis manufacturer

For example, Compaq

 

Serial Number

Manufacturer's number used to identify a system chassis

For example, 53R661S

 

Version

Version number of the system chassis

 

Tag

Unique ID of the system chassis attached to a particular computer system

For example, System Enclosure 0

Hardware/Software Inventory > Hardware > Pointing Device > Pointing device name

IRQ Number

Interrupt assigned to this device

 

Name

Identifying information of the mouse

 

Number of Buttons

Number of buttons on the mouse

Hardware/Software Inventory > Hardware > Keyboard

Delay

Delay before the repeat of a key

 

Description

Description of the keyboard, such as IBM Enhanced 101 or 102 keys

 

Layout

Layout of the keyboard

 

Number of Function Keys

Total number of function keys

 

Subtype

Type of the keyboard

 

Typematic Rate

Rate of processing the keys

Hardware/Software Inventory > Hardware > Display Adapter > Display adapter name

Chip Set

Chip set used by the controller to compare system capabilities

 

Current Bits/Pixel

Number of adjacent color bits for each pixel

 

Current Horizontal Resolution

Number of horizontal pixels shown by the display

 

Current Vertical Resolution

Number of vertical pixels shown by the display

 

DAC Type

Digital-to-Analog converter type

 

Description

Description of the display adapter

 

Maximum Memory Supported

Maximum memory that the display adapter supports for VIDEO RAM

 

Maximum Refresh Rate

Maximum refresh rate of the monitor for redrawing the display, measured in Hertz

 

Minimum Refresh Rate

Minimum refresh rate of the monitor for redrawing the display, measured in Hertz

 

Number of Color Planes

Number of color planes supported by the video system

 

Provider

Vendor name

 

Video Architecture

The architecture of the video subsystem in this system, for example, CGA/VGA/SVGA/8514A

 

Video Memory Type

The type of video memory for this adapter, for example, VRAM/SRAM/DRAM/EDO RAM

Hardware/Software Inventory > Hardware > BIOS

BIOS Identification Bytes

Byte in the BIOS that indicates the computer model

 

Install Date

The manufacturing date of the BIOS

 

Manufacturer

BIOS vendor name

 

Caption

BIOS label

 

Primary BIOS

True state indicates Primary BIOS

 

Serial Number

Serial number of the computer, assigned during manufacture

 

Size

Size of the BIOS

 

Version

Version or revision level of the BIOS

Hardware/Software Inventory > Hardware > Processor

Current Clock Speed (in MHz)

Current clock speed of the processor

 

Device ID

Special hexadecimal string identifying the processor type

 

Maximum Clock Speed (in MHz)

Maximum clock speed of the processor

 

Other Family Description

Additional description about the Processor Family, such as Pentium Processor with MMX technology

 

Processor Family

Identification of the processor family such as Pentium II or Pentium III

 

Processor Stepping

Single-byte code characteristic provided by microprocessor vendors to identify the processor model

 

Role

Type of processor such as central processor, math coprocessor, and others

 

Upgrade Method

The method by which this processor can be upgraded, if upgrades are supported

Hardware/Software Inventory > Hardware > Modem

Description

Additional information about the modem

 

Name

Identifying information of the modem

 

Device ID

Special hexadecimal string identifying the modem type

 

Provider

Name of the vendor

Hardware/Software Inventory > Hardware > Battery

Chemistry

The battery chemistry, for example, lithium-ion or nickel metal hydride

 

Design Capacity

The design capacity of the battery in mWatt-hours

 

Design Voltage

The design voltage of the battery in mVolts

 

Install Date

The battery manufacture date

 

Manufacturer

The name of the company that manufactured the battery

 

Name

Device name for this battery, for example, Duracell* DR-36

 

Serial Number

The serial number for this battery

 

Smart Battery Version

The Smart Battery Data Specification version number supported by this battery

Hardware/Software Inventory > Hardware > Power Supply

Description

Expanded description of the input voltage capability for this power supply

 

Total Output Power (in MilliWatts)

Attribute value that represents the total output power of the power supply

Hardware/Software Inventory > Hardware > Memory

Total Memory

Total memory of the inventoried server

Hardware/Software Inventory > Hardware > Disk Drives > Floppy

Capacity

Floppy drive capacity

 

Description

Floppy drive description

 

Drive Letter

Letter name of the drive

 

Manufacturer

Vendor name

 

Physical Cylinders

Floppy drive cylinders

 

Physical Heads

Floppy drive R/W heads

 

Sectors/Track

Floppy drive sectors per track

Hardware/Software Inventory > Hardware > Disk Drives > Physical Disk > Fixed Disk

Description

Description

 

Manufacturer

Vendor name

 

Physical Cylinders

Number of cylinders

 

Physical Heads

Number of heads

 

Sectors/Track

Fixed disk drive sectors per track

 

Size

Size of the fixed disk

Hardware/Software Inventory > Hardware > Disk Drives > Physical Disk > Removable Disk

Description

Description

 

Manufacturer

Vendor name

 

Physical Cylinders

Number of cylinders

 

Physical Heads

Number of heads

 

Sectors/Track

Removable disk drive sectors per track

 

Size

Size of the removable disk

Hardware/Software Inventory > Hardware > Disk Drives > Logical Disk > Logical disk name

Drive Letter

Letter name of the drive

File System Type

Type of file system, such as File Allocation Table (FAT)

 

Free Size

Drive's actual size in MB

 

Volume Label

Name of the hard disk volume

 

Size

Drive's available space in MB

 

Volume Serial Number

Hard disk volume serial number

Hardware/Software Inventory > Hardware > Disk Drives > CDROM

Name

Name of the CD drive attached to the inventoried server

 

Description

Description of the CD

 

Drive Letter

Mapped drive name of the CD

 

Manufacturer

Vendor name

 

Caption

Caption of the CD

Hardware/Software Inventory > Hardware > Ports > Serial Port

Address

Base input/output address for this serial port

 

IRQ Number

IRQ number of the serial port

 

Name

The logical name of the I/O device on this serial port, under this operating environment

Hardware/Software Inventory > Hardware > Ports > Parallel Port

Address

Base I/O address for this parallel port

 

DMA Support (True or False)

If True, DMA is supported

 

Name

The logical name of the input-output device on this parallel port, under this operating environment

 

IRQ Number

IRQ number of the parallel port

Hardware/Software Inventory > Hardware > Bus

Bus Type

Bus type indicates PCI, ISA, and others

 

Description

Bus description

 

Name

Bus name

 

Version

Version of the bus supported by the motherboard

Hardware/Software Inventory > Hardware > Network Adapter

Adapter Type

Type of network adapter, such as FDDI or token ring

 

Auto Sense

A Boolean value indicating whether the network adapter is capable of automatically determining the speed or other communication characteristics of the attached network media

 

Card Manufacturer

Name of the card manufacturer

Description

Adapter description

 

Install Date

Install date of the network adapter

Maximum Speed

Rate at which the information is transferred over the LAN

 

Name

Network adapter name

 

Permanent Address

Node address stored permanently in the adapter

 

Provider

Name of the provider

Hardware/Software Inventory > Hardware > Sound Adapter

Description

Description of the multimedia component for the server

 

Name

Label of the multimedia card

 

Provider

Name of the provider

Hardware/Software Inventory > Network > DNS

DNS Name

The DNS name of the inventoried server

Hardware/Software Inventory > Network > Network (instance_number) > IP

IP Address

The unique address assigned to a computer on an IP Internet

 

Subnet Mask

The subnet mask of the inventoried server paired with an IP address specifies to an IP router which octets or bits in the IP address are the network ID and which octets or bits are the node ID

Hardware/Software Inventory > Network > Network (instance_number) > IPX

IPX Address

The IPX™ address of the inventoried server

Hardware/Software Inventory > Network > Network (instance_number) > MAC

MAC Address

Unique node address permanently coded in the network adapter that identifies a specific computer on a network

Hardware/Software Inventory > Network > IP

IP Address

The unique address assigned to a computer on an IP Internet

 

Subnet Mask

The subnet mask of the inventoried server paired with an IP address specifies to an IP router which octets or bits in the IP address are the network ID and which octets or bits are the node ID

Hardware/Software Inventory > Network > IPX

IPX Address

The IPX address of the inventoried server

Hardware/Software Inventory > Network > MAC

MAC Address

Unique node address permanently coded in the network adapter that identifies a specific computer on a network

Hardware/Software Inventory > System > System IRQ

Availability

Availability of the specific IRQ channel

 

IRQ Number

Number of the Interrupt Request Line (IRQ), from 0 to 15

 

IRQ Trigger Type

IRQ Trigger type

 

Shareable

If True, the system IRQ can be shared across devices

Hardware/Software Inventory > System > System Cache

Associativity

Defines the system cache associativity (direct-mapped, 2-way, 4-way)

 

Cache Type

Defines the system cache type, for example, Instruction, Data, Unified

 

Capacity

Size of the data store where the cache information is kept

 

Error Methodology

Error correction scheme supported by this cache component, for example, Parity/Single Bit ECC/MultiBit ECC

 

Level

Indicates the cache level; internal cache that is built in to the microprocessors; external cache that is between the CPU and DRAM

 

Line Size

Size in bytes of a single cache bucket or line

 

Read Policy

Indicates whether the data cache is for read operations

 

Replacement Policy

Algorithm that the cache uses to determine which cache lines or buckets should be reused

 

Speed

Speed of this System Cache module in nanoseconds

Write Policy

Indicates the two different ways (Write-Back and Write-Through Cache) that the cache can handle to write to the memory

Hardware/Software Inventory > System > System DMA

Availability

Indicates whether Virtual Direct Memory Access (DMA) is supported

Description

Name of the logical device that is currently using this DMA channel

 

DMA Burst Mode

A data transmission mode in which data is sent faster than normal

 

DMA Channel Number

Number of the Direct Memory Access (DMA) channel that a computer uses for transferring data to and from devices quicker than from computers without a DMA channel

Hardware/Software Inventory > System > System Slot

Description

Card currently occupying this slot

 

Maximum Data Width

Maximum bus width of cards accepted in the slot

 

Thermal Rating

Maximum thermal dissipation of the slot in milliwatts

Hardware/Software Inventory > System > Motherboard

Manufacturer

Name of the motherboard manufacturer

Number of Slots

The number of expansion slots in the motherboard for adding more memory, graphic capabilities, and support for special devices

 

Version

Version of the motherboard

 

Description

General description of the motherboard

NOTE:For an enumerated attribute, the value is 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 server 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.

17.1.3 Viewing Inventory Information of Inventoried Servers by Querying the Database

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 information (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:

  1. In ConsoleOne, click a container.

  2. Invoke Query:

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

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

  3. Specify the criteria for query:

    Query the Inventory database for: By default, the Servers option is enabled. The query locates all inventoried servers satisfying the query expression. If ZENworks 7 Server Management and Desktop Management are installed in the same environment; the Workstations, the Servers and the Both options are 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 is prefixed by an asterisk (*).

    For example, to find the machines that do not have a 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:

    Data Type of the Attribute

    Relational Operators

    String

    Equal To (=), Not Equal To (!=), Matches ([ ]), Does Not Match (![ ]) and Is NULL (null)

    Numeric

    Equal (=), Not Equal (!=), Less Than (<), Less Than or Equal To (< =), Greater Than (>), Greater Than or Equal To (>=), and Is NULL (null)

    Date

    After (>), On or After (>=), Before (<), On or Before (< =), and Is NULL (null)

    Enum

    Equal To (=), Not Equal To (!=), and Is NULL (null)

    Custom

    Includes all the relational operators that are grouped under the String, Numeric, and Date data types

    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 is set to NULL by default and other relational operators are not 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 is 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 to the SQL documentation:

    Example

    Specifies to Include

    ?

    Any one character

    _ (underscore)

    Any one character

    %

    Any string of zero or more characters

    []

    Any one character in the specified range or set

    [^]

    Any one character not in the specified range or set

    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 is 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.

  4. 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, then click Advanced Query to view the inventory information of the inventoried server.

Usage of Relational Operators

  • 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 displays 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') returns S1 and the query (SerialPort!='COM1') also returns 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.

17.1.4 Running Inventory Reports

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 would be empty if you have not configured ZENworks 7 Server Management to start populating the Inventory database with the information you want.

This section covers information on the following sections:

Prerequisites for Generating Inventory Reports

Before running the inventory reports, ensure that you have installed the appropriate ODBC client. For more information, see Installing the ODBC Drivers in the Novell ZENworks 7 Server Management Installation Guide.

Types of Inventory Reports

You can generate the types of reports described below, assuming you have already configured ZENworks 7 Server Management to start populating the inventory database with the information you want.

Table 17-2 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.

Table 17-2 List of Inventory reports and information displayed by each report

Inventory Report Group

Report Name

Selection Criteria

Information Displayed in the Inventory Report

Hardware Inventory

Asset Management Report

Scope, Machine 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, CDROM, Network Adapter, and Monitor

Memory, processor, display details, keyboard, pointing device, fixed and removable disk, floppy, CD drive, network adapter, and monitor details for inventoried servers.

 

BIOS Listing

Scope, Machine Name, IP Address, DNS Name, BIOS Install Date, and Manufacturer

List of all the inventoried servers with BIOS manufacturer, BIOS release date, and the total number of such machines.

 

Battery Listing

Scope, Machine Name, IP Address, DNS Name, and Name

List of all inventoried servers that match the specified battery name.

 

Bus Listing

Scope, Machine Name, IP Address, DNS Name, and Bus Type

List of all inventoried servers with the selected bus type.

 

CDROM Listing

Scope, Machine Name, IP Address, DNS Name, Caption, Description, and Manufacturer

List of all inventoried servers that match the specified CD caption, description, and manufacturer's name.

 

Display Adapter Listing

Scope, Machine Name, IP Address, DNS Name, Video Architecture, and Description

List of all inventoried servers that match the specified display adapter's video architecture and description.

 

Floppy Listing

Scope, Machine Name, IP Address, DNS Name, Manufacturer, and Description

List of all inventoried servers that match the specified floppy description and manufacturer's name.

 

Hardware Summary Report

Scope, Machine Name, IP Address, DNS Name, Operating System Type, Operating System Version, Processor Family, Curr. Clock Speed (Lower Bound in MHz), Curr. Clock Speed (Upper Bound in MHz), Total Memory (Lower Bound in MB), Total Memory (Upper Bound in MB), Hard Disk Size (Lower Bound in GB), and Hard Disk Size (Upper Bound in GB)

Operating system name, operating system version, processor family, processor current clock speed, memory, and hard disk size for each inventoried server.

 

Keyboard Listing

Scope, Machine Name, IP Address, DNS Name, Description, and Layout

List of all inventoried servers that match the specified keyboard description and layout.

 

Modem Listing

Scope, Machine Name, IP Address, DNS Name, and Name

List of all inventoried servers that match the specified modem name.

 

Monitor Listing

Scope, Machine Name, IP Address, DNS Name, Manufacturer, Manufacture Date, Nominal Size (Lower Bound in inches), and Nominal Size (Upper Bound in inches)

List of all inventoried servers that match the specified monitor manufacturer's name, manufacture date, and the specified range of monitor's nominal size.

 

Network Adapter Listing

Scope, Machine Name, IP Address, DNS Name, and Name

List of all inventoried servers that match the specified network adapter's name.

 

Physical Disk Listing

Show Chart, Scope, Machine Name, IP Address, DNS Name, Removable, Manufacturer, Description, Total Size (Lower Bound in GB), and Total Size (Upper Bound in GB)

List of all inventoried servers that match the specified physical disk manufacturer's name, description, the specified range of total size and disks that are fixed, removable, or both.

You can also select the Show Chart box to display the Physical Disk Listing report in a pie chart.

 

Pointing Device Listing

Scope, Machine Name, IP Address, DNS Name, Pointing Device Type, and Pointing Device Name

List of all inventoried servers that match the specified pointing device type and name.

 

Power Supply Listing

Scope, Machine Name, IP Address, DNS Name, and Description

List of all inventoried servers that match the specified power supply description.

 

Processor Listing

Show Chart, Scope, Machine 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 inventoried servers with a processor family (such as Pentium Pro), processor maximum clock speed, and the processor current clock speed of the machines.

You can also select the Show Chart box to display the Processor Listing report in a pie chart.

 

Sound Adapter Listing

Scope, Machine Name, IP Address, DNS Name, and Name

List of all inventoried servers that match the specified sound adapter name.

Storage Devices Inventory Report

Scope, Machine Name, IP Address, and DNS Name

You can also select to display the following options in the report: Fixed and Removable Disk, Logical Disk, Floppy, and CDROM.

Fixed disk, removable disk, logical disk, floppy, and CD drive details for each inventoried server.

System Chassis Listing

Scope, Machine Name, IP Address, DNS Name, Chassis Type, and Manufacturer

List of all inventoried servers that match the specified system chassis type and manufacturer's name.

System Configuration Inventory

Inventory Scan Listing

Show Chart, Scope, Machine 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 inventoried server.

You can also select the Show Chart box to display the System Configuration Inventory report in a pie chart.

 

Memory Listing

Show Chart, Scope, Machine Name, IP Address, DNS Name, Total Memory (Lower Bound in MB), and Total Memory (Upper Bound in MB)

List of all the inventoried servers within a range of memory size (such as 200-400 MB) and the total number of such machines.

You can also select the Show Chart box to display the Memory Listing report in a pie chart.

 

Operating System Listing

Show Chart, Scope, Machine Name, IP Address, DNS Name, Operating System Type, and Operating System Version

List of all inventoried servers that match the specified operating system type and version.

You can also select the Show Chart box to display the Operating System Listing in a pie chart.

 

Networking Information Report

Scope, Machine Name, IP Address, and DNS Name

Network adapter type, DNS, IP address, MAC address, IPX address, and Windows Domain name for each inventoried server.

System Information Listing

Scope, Machine Name, IP Address, DNS Name, and Computer Manufacturer

List of all inventories servers that match the specified computer manufacturer's name.

 

System Internal Hardware Inventory Report

Scope, Machine 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 inventoried server.

Software Inventory

Add-Remove Programs by Application

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Software Name

List of all software that are listed in the Add/Remove Programs list for each inventoried server.

Add-Remove Programs by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Software Name

List of all software that are listed in the “Add-Remove Programs” list for each inventoried server.

 

Anti-Virus Signature Files by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Software Name, Min Virus Definition Date and Max Virus Definition Date

List of all antivirus signature files grouped by antivirus product installed on each inventoried server.

 

Anti-Virus Signature Machine Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Software Name, Min Virus Definition Date and Max Virus Definition Date

List showing the count of inventoried servers that have any antivirus product installed.

 

Disk Usage by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and File Extension

List of all inventoried servers and the disk usage that match the specified file extension.

 

Exception List by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, File Name, Vendor Name, and Product Name

List of all inventoried servers and the file information that match the specified filename, vendor name, and product name.

 

Installed NetWare Software by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Software Name

List of all inventoried NetWare machines and the products.dat details that match the given software name.

 

Internet Explorer Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Internet Explorer Version, and Service Pack

List showing the count of inventoried servers with Internet Explorer installed.

 

Internet Explorer Patches by Machine

Scope, Machine Name, IP Address, DNS Name, Internet Explorer Version, and Service Pack

List of all installed patches for the Internet Explorer version that matches the specified value and patch name.

 

Internet Explorer by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Internet Explorer Version, and Service Pack

List of all Internet Explorer installations that match the specified version.

MSI Products by Application

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Software Name, and Vendor Name

List of all products installed on each inventoried server and that are listed in the MSI (Microsoft Installer) database.

 

MSI Products by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Software Name, and Vendor Name

List of all products installed on each inventoried server and that are listed in the MSI (Microsoft Installer) database.

 

Microsoft Office Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Microsoft Office Version, and Service Pack

List of all products that match the specified product name and vendor name, and have been installed from the specified source.

 

Microsoft Office Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Microsoft Office Version, and Service Pack

List showing the count of inventoried servers with Microsoft Office installed.

 

Microsoft Office by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Microsoft Office Version, and Service Pack

List of all Microsoft Office installations that match the specified version.

 

Novell Client Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Novell Client Version, and Service Pack

List of all Novell Client components that match the specified version.

 

Novell Client Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Novell Client Version, and Service Pack

List showing the count of inventoried servers with Novell Client installed.

 

Novell Client by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Novell Client Version, and Service Pack

List of all Novell Client installations that match the specified version.

 

Outlook Express Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Outlook Express Version

List showing the count of inventoried servers with Outlook Express installed.

 

Outlook Express by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Patch Name

List of all Outlook Express installations that match the specified version.

 

Software Dictionary Application Files by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Vendor Name, Software Name, and Software Version

List of all inventoried servers and their software dictionary application files that match the specified vendor, software, and software version.

 

Software Dictionary Applications by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Vendor Name, Software Name, and Software Category

List of all inventoried servers and their software dictionary applications that match the specified vendor, software, and software version.

 

Software Dictionary Versions Machine Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, General Dictionary Version, and Private Dictionary Version

List showing the count of all inventoried servers with specified General Dictionary and Private Dictionary versions.

 

Software Dictionary Versions by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, General Dictionary Version, and Private Dictionary Version

List of all inventoried servers with specified General Dictionary and Private Dictionary versions.

 

Software Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Vendor Name, Software Name, and Software Version

List showing the count of inventoried servers with specified vendor name, software, and version.

 

Software Installations

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Vendor Name, Software Name, and Software Version

List of all inventoried servers with specified vendor name, software, and version.

 

Software by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Vendor Name, Software Name, and Software Version

List of all inventoried servers and software information that match the specified vendor name, software, and version.

 

System Software Inventory Report

Scope, Machine 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 Novell NetWare® Client for each inventoried server.

 

Windows Components by Machine

Scope, Machine Name, IP Address, DNS Name, Windows Version, and Service Pack

List of all Windows components that match the specified version.

 

Windows Installation Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Windows Version, and Service Pack

List showing the count of inventoried servers that have Windows operating system installed.

 

Windows Media Player Count

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Windows Media Player Version

List showing the count of inventoried servers with Windows Media Player installed.

 

Windows Media Player Patches by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Windows Media Player Version

List of all patches for Windows Media Player installations that match the specified version and patch name.

Windows Security Patches by Patch

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Windows Version, and Service Pack

List of all patches for Windows operating systems that match the specified version and patch name.

 

Windows Media Player by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, and Windows Media Player Version

List of all Windows Media Player installations that match the specified version.

 

Windows Operating System by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Windows Version, and Service Pack

List of all Windows operating systems that match the specified version and serial number.

 

Windows Security Patches by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, Max Last Scan Time, Windows Version, and Service Pack

List of all patches for Windows operating systems that match the specified version and patch name.

 

Novell ZENworks Desktop Management Installed Agent Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the agent components of ZENworks 7 Desktop Management installed on these machines.

 

Novell ZENworks Desktop Management Installed Server Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the server components of ZENworks 7 Desktop Management installed on these machines.

 

Novell ZENworks Handheld Management Installed Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the ZENworks 7 Handheld Management components installed on these machines.

 

Novell ZENworks Installed Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the ZENworks 7 components installed on these machines.

 

Novell ZENworks Installed Suites by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the ZENworks 7 suites installed on these machines.

 

Novell ZENworks Server Management Installed Agent Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the agent components of ZENworks 7 Server Management installed on these machines.

 

Novell ZENworks Server Management Installed Server Components by Machine

Scope, Machine Name, IP Address, DNS Name, Min Last Scan Time, and Max Last Scan Time

List of all machines that were successfully last scanned within the specified time range and the server components of ZENworks 7 Server Management installed on these machines.

Others

User Defined Reports

For more information on how to create user-defined reports, see the 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.

Generating Inventory Reports

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.

Printing an Inventory Report

To print a report:

  1. Generate and view the report.

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

  3. Click the Printer icon Printer icon.

Exporting an Inventory Report to a File

To export an inventory report to a file:

  1. Generate and view the report.

  2. On the toolbar, click the Export Report icon Export 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.

Understanding User-Defined Reports

Using the Crystal Report Designer you can generate reports displaying information in the Inventory database.

Before generating the reports, you must ensure that the report file (.rpt) is created using Crystal Report Designer 8.0/8.5. For more information on how to create a .rpt file, see the Crystal Report documentation.

IMPORTANT:Except for the Software Inventory reports, you can use any Inventory report as a template to create a report.

To generate the User-defined Inventory report:

  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.

17.1.5 Quickly and Easily Viewing the Inventory Data Using Quick Reports

In ZENworks 7 Workstation Inventory, provides a new tool called Quick Reports to easily retrieve and view the data from the ZENworks Inventory database. Each Quick Report contains a list of inventory attributes and a query that you define using the Quick Report wizard.

The following sections provide more information about working with Quick Report:

Invoking the Quick Report Wizard

Invoke the Quick Report Wizard using any of the following methods:

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

  • To invoke the Quick Report from the ConsoleOne Tools menu, click ZENworks Inventory, then click Quick Report.

    If you have already configured the Inventory database, the Quick Report wizard uses that database.

    If you have not yet configured the Inventory database, the Quick Report wizard is displayed, and you can configure the database using the wizard. For more information, see Configuring the Inventory Database.

Creating a Quick Report

  1. Invoke the Quick Report wizard.

    The Create and Manage Quick Reports page is displayed.

  2. Click New.

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

    Define Query page

    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.

      Defining a new query criteria

      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:

    Database Fields page
    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 Add icon 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 Move Up icon and Move Down icon.

    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.

Modifying an Existing Quick Report

  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.

    Modifying a Quick Report
  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 Add icon 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 Move Up icon and Move Down icon.

    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.

Viewing the Data Retrieved by the Quick Report

You can view the data retrieved by the Quick Report using any of the following methods:

Viewing the Data While Creating or Modifying a Quick Report
  1. In the Database Fields page, click View.

    Clicking the View button in the Database Fields page
Viewing the Data of a Saved Quick Report
  1. In the Create and Manage Quick Reports page, select the Quick Report that you want to view from the list of Quick Reports.

    You can view 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 view 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 View.

    Clicking the View button in the Create and Manage Quick Reports page

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

Deleting a Quick Report

  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.

    Deleting a Quick Report

Configuring the Inventory Database

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

    Configuring the Inventory database

    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.

Working with the Query Results Window

The Query Results window displays the data stored in the ZENworks Inventory database on querying the selected quick report. The Query Results window displays data for a maximum of 500 inventoried machines.

Figure 17-1 Query Results Window

You can perform the following operations in this window:

  • Export entries to an xml or csv file.

  • Sort the display of entries.

  • View the data in a browser.

    IMPORTANT:When you click View in Browser, the inventory data is exported in the XML format for rendering in the browser. Ensure that the browser, such as Microsoft Internet Explorer or Mozilla* Firefox, is the default application associated with the XML format.

    If Internet Explorer is the default application associated with the XML format and it is already opened, and when you click View in Browser, you want the data to displayed in a new Internet Explorer window, do the following:

    • 1. Invoke Windows Explorer on the machine running Quick Report.
    • 2. Click the Tools menu, then click Folder Options.
    • 3. In the Folder Options window, click the File Types tab.
    • 4. From the list of registered file types, select XML.
    • 5. In the Details for ‘XML' extension pane, click Advanced.
    • 6. In the Edit File Type window, click New.
    • 7. Specify an action name, and in the Application Used to Perform Action field, type Internet_Explorer_installation_directory\iexplore.exe -new %1.
    • 8. Click OK.
    • 9. In Edit File Type window, select the newly created action from the Actions pane, and click Set Default.
    • 10. Click OK, then click Close.
  • Stop the data retrieval process.

    The Quick Report retrieves the data from the ZENworks Inventory database. You can stop the retrieval process by clicking Stop in the status bar of the Query Results dialog box.

    The status bar displays the count of machines whose data has been retrieved. If you stop the process while the data for a single machine has not yet been completely retrieved, the Query Results dialog box displays the data retrieved until that time, but the status bar does not contain any message. And, if you stop the process while the data is being retrieved for multiple machines, the status bar displays the count of machines for which the data has been completely retrieved.

  • Re-order the columns by dragging and dropping them.

  • Re-size the columns.

  • Select the entries by using the mouse or pressing Ctrl+A.

  • Copy and paste the entries to the Clipboard by pressing Ctrl+C and Ctrl+V.

Exporting the Entries to an XML or a CSV File
  1. Click Export.

  2. In the Export Results dialog box, specify the XML or the CSV filename, and select the corresponding file type.

    By default, the file is saved as quick_report_name.xml in the ConsoleOne_installation_directory\consoleone\1.2\reporting\ export directory.

    NOTE:If you specify a filename within double quotes, and without an extension or with an extension other than .xml or .csv, the file is stored in the comma-separated value (CSV) format irrespective of the file type you select.

Sorting the Display Ascending or Descending Order
  1. Click Sort.

  2. In the Sort Items By list, select the column by which you want to sort the entries.

  3. Select either Ascending or Descending.

  4. Configure the Then By drop-down lists.

  5. Click OK.

    For example, the Query Results window has the following entries:

    Product Name

    Vendor Name

    Microsoft Word

    Microsoft

    Microsoft Excel

    Microsoft

    ZENworks

    Novell

    iPrint

    Novell

    GroupWise

    Novell

    Adobe Acrobat

    Adobe

If you want to sort the entries first by the vendor name in the ascending order and then sort all the Novell products in the ascending order, do the following:

  1. Click the Sort button.

  2. In the Sort By drop-down list, select Vendor Name.

  3. Select the Ascending option.

  4. In the Then By drop-down list, select Product Name.

  5. Select the Ascending option.

  6. Click OK.

    The entries are displayed as shown below:

    Product Name

    Vendor Name

    Adobe Acrobat

    Adobe

    Microsoft Excel

    Microsoft

    Microsoft Word

    Microsoft

    GroupWise

    Novell

    iPrint

    Novell

    ZENworks

    Novell