Viewing the Inventory Information Using ConsoleOne

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


Configuring the Inventory Database

If you want to use ConsoleOne to view the inventory information stored in the database, 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:

  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.


Viewing the Inventory Summary of an Inventoried Workstation

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

To view the inventory information of an inventoried workstation:

  1. Configure the Inventory database.

    For more information, see Configuring the Inventory Database.

  2. Right-click an inventoried workstation object, then click Actions, then click Inventory.

    or

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

ZENworks® 6.5 Desktop Management provides the following inventory information collected from the inventoried workstations:

Scan Data Group Scan Data Item Description

Inventory Information icon Inventory Information

General Dictionary Version

Version number of the General Dictionary

 

Inventory Server

Name of the Inventory server to which the scans are sent

 

Last Scan Date

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

 

Private Dictionary Version

Version number of the Private Dictionary

 

Scan Mode

Mode used by the Inventory scanner to scan the inventoried workstation

 

Version

Version number of the Inventory scanner

Hardware/Software Inventory icon Hardware/Software Inventory > General icon General > System Information icon System Information

Asset Tag

Asset tag number that the ROM-based setup program creates

 

Computer Model

Identifying information of the computer, for example, Compaq, Dell, and others.

 

Computer Type

Type of computer, such as IBM PC, and others

 

Machine Name

DNS name of the inventoried workstation

 

Management Technology

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

 

Model Number

Model number of the inventoried workstation

 

Serial Number

Serial number of the inventoried workstation assigned by manufacturer

 

Tag

Unique identifier of system information

Hardware/Software Inventory icon Hardware/Software Inventory > General icon General > System Identification icon 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 workstation as represented in eDirectory, such as the fully qualified DN of the inventoried workstation

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

Current login user

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

 

Last login user

User most recently logged into the Primary eDirectory tree through Novell Client when the inventoried workstation was scanned

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

Name

Domain name of the inventoried workstation

Hardware/Software Inventory icon Hardware/Software Inventory > Software icon Software > Application Vendors icon Application Vendors > Vendor_name > Software Group icon software_group_name > Software icon 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 is 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 inventoried workstation

 

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 icon Hardware/Software Inventory > Software icon Software > Application Vendors icon Application Vendors > Vendor_name > Software Group icon software_group_name > Software icon software > Patches icon Patches

Name

Vendor-defined name for the patch

Hardware/Software Inventory icon Hardware/Software Inventory > Software icon Software > Application Vendors icon Application Vendors > Vendor_name > Software Group icon software_group_name > Software icon software > Representative File Information icon 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 which 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 workstation

 

Software Dictionary ID

ID of the file as represented in the General software dictionary

Hardware/Software Inventory icon Hardware/Software Inventory > Software icon Software > Disk Usage icon 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 icon Hardware/Software Inventory > Software icon Software > Device Drivers icon Device Drivers > Pointing Device Drivers icon Pointing Device Drivers > Pointing Device Drivers icon Pointing Device driver name

Name

Name of the mouse driver

 

Version

Version number of the mouse driver

Hardware/Software Inventory icon Hardware/Software Inventory > Software icon Software > Device Drivers icon Device Drivers > Display Drivers icon 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 icon Hardware/Software Inventory > Software icon Software > Device Drivers icon Device Drivers > Network Drivers icon Network Drivers

Description

Description of the network driver

 

Name

Network driver name

 

Version

Version number of the network driver

Hardware/Software Inventory icon Hardware/Software Inventory > Software icon Software > Operating Systems icon Operating System

Code Page

Language code page of the operating system

 

OS Type

Operating system of the inventoried workstation

 

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 icon Hardware/Software Inventory > Hardware icon Hardware > Monitor icon Monitor

Device ID

Unique ID of a desktop monitor that is attached to an inventoried workstation

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 Workstation 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 icon Hardware/Software Inventory > Hardware icon Hardware > Chassis icon 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 inventoried workstation

For example, System Enclosure 0

Hardware/Software Inventory icon Hardware/Software Inventory > Hardware icon Hardware > Pointing Device icon Pointing Device > Pointing Device icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Keyboard icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Display Adapter icon Display Adapter > Display Adapter icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > BIOS icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Processor icon 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, Pentium III, and others

 

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 icon Hardware/Software Inventory > Hardware icon Hardware > Modem 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 icon Hardware/Software Inventory > Hardware icon Hardware > Battery 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 icon Hardware/Software Inventory > Hardware icon Hardware > Power Supply icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Memory icon Memory

Total Memory

Total memory of the inventoried workstation

Hardware/Software Inventory icon Hardware/Software Inventory > Hardware icon Hardware > Disk Drives icon Disk Drives > Floppy icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Disk Drives icon Disk Drives > Floppy icon Physical Disk > Floppy icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Disk Drives icon Disk Drives > Floppy icon Physical Disk > Removable Disk icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Disk Drives icon Disk Drives > Logical Disk icon Logical Disk > Logical Disk icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Disk Drives icon Disk Drives > CD ROM icon CDROM

Name

Name of the CD drive attached to the inventoried workstation

 

Description

Description of the CD

 

Drive Letter

Mapped drive name of the CD

 

Manufacturer

Vendor name

 

Caption

Caption of the CD

Hardware/Software Inventory icon Hardware/Software Inventory > Hardware icon Hardware > Ports icon Ports > Serial Port icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Ports icon Ports > Parallel Port icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Bus icon 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 icon Hardware/Software Inventory > Hardware icon Hardware > Network Adapter icon 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 data 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 icon Hardware/Software Inventory > Hardware icon Hardware > Sound Adapter icon Sound Adapter

Description

Description of the multimedia component for the workstation

 

Name

Label of the multimedia card

 

Provider

Name of the provider

Hardware/Software Inventory icon Hardware/Software Inventory > Network icon Network > Network icon DNS

DNS Name

The DNS name of the inventoried workstation

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

IP Address

The unique address assigned to a computer on an IP Internet

 

Subnet Mask

The subnet mask of the inventoried workstation 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 icon Hardware/Software Inventory > Network icon Network > Network icon Network (instance_number) > Network icon IPX

IPX Address

The IPXTM address of the inventoried workstation

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

MAC Address

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

Hardware/Software Inventory icon Hardware/Software Inventory > Network icon Network > IP

IP Address

The unique address assigned to a computer on an IP Internet

 

Subnet Mask

The subnet mask of the inventoried workstation 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 workstation

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 icon Hardware/Software Inventory > System icon System > System IRQ icon 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 icon Hardware/Software Inventory > System icon System > System Cache icon 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 icon Hardware/Software Inventory > System icon System > System DMA icon 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 icon Hardware/Software Inventory > System icon System > System Slot icon 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 icon Hardware/Software Inventory > System icon System > Motherboard icon 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 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:


Viewing Inventory Information by Querying the Database

Using ConsoleOne, you can query the Inventory database to display the hardware and software components of inventoried workstations 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 workstation. 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, select a container.

  2. Invoke the 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 Inventory database, 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 the query:

    Query the Inventory database for: By default, the Workstations option will be enabled. The query locates all inventoried workstations satisfying the query expression. If ZENworks 6.5 Server Management and ZENworks 6.5 Desktop Management are installed in the same environment, then the Workstations, the Servers, and Both options will be available. When you select Workstations, the query locates all inventoried workstations satisfying the query expression. Choose Both to include all inventoried workstations and inventoried servers satisfying the query expression.

    Find Type: Select Simple or Advanced. Click Simple to specify a simple query. When you choose a Simple 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 workstations 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.

    Attribute: Select the component or component attributes. Attributes that you can specify to query on the inventoried workstations 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:

    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

    For more information on using the relational operators, see Using Relational Operators .

    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:

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

  4. Click Find.

    This will query based on the query criteria you specify and display the inventoried workstations that match the query in the Query Results window.

    In the Query Results window, double-click the inventoried workstation or click File, then click Advanced Inventory to view the inventory information of the inventoried workstation.


Using Relational Operators

  • Match: Use the Match operator to find the inventoried workstations that satisfy the query condition.

    For example, use the Match operator to find all the inventoried workstations with IP address 164.99.151.%,

  • NULL: Use the NULL operator to query for those inventoried workstations 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 workstations for which BIOS.Manufacturer is not scanned, form a BIOS.Manufacturer is NULL query. This query will display the inventoried workstations 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 workstations that negate the given query.

    For example, two workstations W1 and W2 contain serial ports COM1 and COM2. The query (SerialPort='COM1') will return W1 and the query (SerialPort!='COM1') will also return the W1 because W1 contains the serial port COM2. To query the inventoried workstations 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.


Viewing the Minimal Inventory Information from an eDirectory Object

The Scanners store minimal inventory information as an eDirectory Workstation object. You can view this minimal information from ConsoleOne. The Minimal Information page lists the inventory information of the scanned inventoried workstations.

For more information about the listed items in this page, see Mapping Between Minimal Information Attributes and Attributes in the Inventory Database.

To view the inventory information stored in eDirectory:

  1. Right-click an inventoried workstation that has been successfully scanned, click Properties, click the ZENworks Inventory tab, then click Minimal Information.

If you click the More Workstation Information button in this page, the Workstation Inventory window will be displayed.


Mapping Between Minimal Information Attributes and Attributes in the Inventory Database

The following table shows the mapping between minimal information attributes and attributes in the Inventory database:

Minimal Information Inventory Database

Asset Tag

Scanned Inventory - Asset Tag

BIOS Type

Hardware - BIOS - Type

Computer Model

Scanned Inventory.Computer Model

Computer Type

Scanned Inventory.Computer Type

Disk Information

Hardware - Disk - Hard Disk - Drive Letter

IP Address

Network - IP Address

IPX Address

Network - IPX Address

Last Scan Date

Date and time when the inventoried workstation was scanned

MAC Address

Network - MAC Address

Memory Size

Hardware - Memory - Total Extended Memory

Model Number

Scanned Inventory.Model Number

NIC Type

Hardware - Network Adapter Driver - Description

Novell Client

Novell Client version

OS Type

Software - Operating Systems - OS - Name

OS.Version

Software - Operating Systems - OS - Version

Processor

Hardware - Processor

Serial Number

Workstation Serial Number

Subnet Mask

Network - Subnet Mask

Video Type

Hardware - Display - Type


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.

You can print or export the report as desired. Remember that any reports you generate will be empty if you have not configured ZENworks 6.5 Desktop Management to start populating the Inventory database with the information you want.

This section covers the information on the following topics:


Prerequisites for Generating Inventory Reports

Before running the inventory reports, ensure that you have installed the appropriate ODBC client. For more information, see Novell ZENworks 6.5 Desktop Management Installation Guide.


Types of Inventory Reports

You can generate the types of reports described below, assuming you have already configured ZENworks 6.5 Desktop Management to start populating the Inventory database with the information you want. The following table lists the Simple Inventory lists that provide information on individual aspects of Workstation Inventory, such as operating systems and their selection criteria. The table also lists the Comprehensive Inventory Reports that combine several aspects of Workstation Inventory into each report, such as memory, hard disk, and processor.

The following table lists the Inventory reports, and also provide information on individual aspects of each report such as the selection criteria and the information displayed in the 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 workstations.

 

BIOS Listing

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

List of all the inventoried workstations 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 workstations that match the specified battery name.

 

Bus Listing

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

List of all inventoried workstations with the selected bus type.

 

CDROM Listing

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

List of all inventoried workstations 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 workstations 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 workstations 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 workstation.

 

Keyboard Listing

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

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

 

Modem Listing

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

List of all inventoried workstations 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 workstations 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 workstations 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 workstations 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 check 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 workstations 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 workstations 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 workstations with a processor family (such as Pentium Pro), processor maximum clock speed, and the processor current clock speed of the machines.

You can also check 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 workstations 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 workstation.

 

System Chassis Listing

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

List of all inventoried workstations 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 workstation.

You can also check 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 workstations within a range of memory size (such as 200-400 MB) and the total number of such machines.

You can also check 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 workstations that match the specified operating system type and version.

You can also check 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 workstation.

 

System Information Listing

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

List of all inventories workstations 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 workstation.

Software Inventory

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

 

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

 

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 workstations 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 workstations 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 workstations 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 workstations 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 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 workstation 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstations 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 workstation.

 

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 workstations 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 workstations 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 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 6.5 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 6.5 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 6.5 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 6.5 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 6.5 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 6.5 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 6.5 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

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

    • To invoke the Inventory report from a database object, right-click the database object, then click Reporting.
    • To invoke the Inventory report from the ConsoleOne Tools menu, you must first configure the database, and then click Tools, then click ZENworks Reports. For more information on how to configure the Inventory 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 will be enabled only if both ZENworks 6.5 Desktop Management and ZENworks 6.5 Server Management are installed on the same machine.

    For example, if you want to view the inventory information of all inventoried workstations, select Workstation as the scope selection criteria. The report will display the inventory information of all inventoried workstations within the configured Inventory database.

    Based on the type of report you want, you can filter the information. For example, to view all inventoried workstations 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.

    Depending on the type of report you want, you can filter the information.

    Follow these guidelines as you work with the Reporting dialog:

    • The selection criteria in the Inventory report is 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 character data only.

      The following table lists examples of wildcards.

      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 workstation 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, Portugese, and Japanese. Other double-byte characters might not be displayed properly in the Inventory reports.


Understanding the Proxy Database

When you run the reports from a non-English management console on a Sybase* Inventory database running on NetWare, the Sybase database will start on the console on invoking the selected report. This is called the ZENworks 6.5 Desktop Management proxy database.

A Sybase ASA icon is displayed in the system tray of the management console as soon as you run the selected report. The proxy database automatically connects to the remote database on which the reports are being invoked and retrieves the required information. Because the data in the remote database (Sybase running on NetWare) is stored in UTF-8 format and Crystal Reports cannot display the characters encoded in UTF-8 format, the proxy database converts all UTF-8 data into the local Windows language character set.

The following sections provide information on:


Invoking the Proxy Database

The proxy database is invoked in the following scenarios:

  • If reports are invoked from a non-English management console on the ZENworks 6.5 Desktop Management or ZENworks for Desktops 4.x Sybase Inventory database running on NetWare.
  • If reports are invoked from a non-English management console on the ZENworks for Desktops 4.x Sybase Inventory database running on Windows.

The proxy database is not invoked in the following scenarios:

  • If reports are invoked from an English management console.
  • If reports are invoked from a non-English management console on the ZENworks 6.5 Desktop Management or ZENworks for Desktops 4.x Inventory database mounted on Oracle* or MSSQL 2000 database.
  • If reports are invoked from a non-English management console on the ZENworks 6.5 Desktop Management Sybase Inventory database running on Windows.
  • If any inventory components other than reports are invoked.

Two proxy databases can be mounted simultaneously; one for the ZENworks 6.5 Desktop Management database and, the other for the ZENworks for Desktops 4.x database.


Shutting Down the Proxy Database

If you close the Reporting dialog box or if you close ConsoleOne, you must manually shut down the proxy database.

To manually shut down the proxy database:

  1. In the management console, right-click the proxy database icon located in the system tray, then click Exit.


Configuring the Proxy Databases to Run on Ports Other Than the Default Ports

If the default ports that are used by Sybase are also used by other applications, there might be potential port conflicts. To avoid this, you can configure the proxy database to run on ports other than the default ports.

  1. Bring up Proxy DB on Port 2639/2640 depending on the database port with the database messages redirected to a file.

    If 2639/2640 are already blocked by some other application, then Sybase mounts the proxy database on a free port that it finds and puts this information in the output file. On trying to connect, there is an error message "Unable to connect..."

  2. Exit Proxy Sybase, get the port number from the output file, and enter the port number into the Proxy Ports configuration file (consoleone\1.2\bin\zen\sybaseproxy\proxyproperties.properties)

  3. Invoke the reports again, so Sybase will read the proxy ports configuration file, get the port, and start Sybase in the specified port.

    The Reporting snap-in would modify ODBC DSN with the new port information.

  4. Restart ConsoleOne for the changes to take effect.


Printing an Inventory Report

  1. Generate and view the report.

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

  3. Click the printer icon.


Exporting an Inventory Report to a File

  1. Generate and view the report.

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

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

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

    If you want to export the Inventory report to an HTML file, you can select HTML 3.2 or HTML 4.0 (DHTML) file format. We recommend that you export to HTML 4.0 (DHTML) because the data exported to HTML 3.2 will not be 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 will not be 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

You can use the Crystal Report Designer to generate reports with the 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.

    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 will be 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 rpt 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 file.

    NOTE:  if the userreports.ini file is empty, the user cannot view the user-defined reports in the inventory reports tree.

  4. Click Run Selected Report.