The following sections explain the various types of information you can view using Novell® ConsoleOne®:
You can list hardware and software components found on the inventoried workstation and any custom information you have specified for the workstation.
The Workstation Inventory window displays the inventory items for an inventoried workstation. This window displays the information from the last inventory scan for the inventoried workstation.
For more information about viewing the inventory information of an inventoried workstation, see Section 77.1.2, Viewing the Inventory Summary of an Inventoried Workstation.
You can list inventoried workstations with the inventory information from the Inventory database satisfying the criteria you specify in the Inventory Query window. You form a query by specifying the component and its attribute for the inventoried workstations within the selected database sites.
For more information about querying the Inventory database, see Section 77.1.3, Viewing Inventory Information by Querying the Database.
You can list minimal information stored in the eDirectory™ Workstation object.
For more information, see Section 77.1.4, Viewing the Minimal Inventory Information from an eDirectory Object.
You can use a list of reports that generate the inventory information from the Inventory database specific to your needs.
For more information, see Section 77.1.5, Running Inventory Reports.
You can now quickly and easily view the inventory information.
For more information, see Section 77.1.6, Quickly and Easily Viewing the Inventory Data Using Quick Reports.
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 is used for generating inventory reports, viewing inventory information, and for querying the inventory information from the database.
To configure the Inventory database:
In ConsoleOne, select a container.
Invoke Configure DB.
To invoke Configure DB from a database object, right-click the database object, click
, then click . This configures the database object.To invoke the Configure DB dialog box from the ConsoleOne
menu, click , then click .Click
to browse for and select the ZENworks Database object.You can also select an existing ZENworks Database object from the list of Database objects.
This Database object contains the database settings such as the protocol, port in use by the database, and others.
To apply this database configuration to all the sessions, select the
check box.Click
.The database you configured is used for data retrieval unless you change it again using this same procedure.
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:
Configure the Inventory database.
For more information, see Section 77.1.1, Configuring the Inventory Database.
Right-click an inventoried workstation object, then click
, then click .or
In the Query Results window, double-click an inventoried workstation.
ZENworks® 7 Desktop Management provides the following inventory information collected from the inventoried workstations:
Table 77-1 Inventory information as displayed in Inventory Summary
Scan Data Group |
Scan Data Item |
Description |
---|---|---|
Inventory Information |
General Dictionary Version |
Version number of the General Dictionary NOTE:The General Dictionary version is not same as the ZENworks product version. |
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 > 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 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 > 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 workstation as represented in eDirectory, such as the fully qualified DN of the inventoried workstation |
Hardware/Software Inventory > General > Login Details > eDirectory Login Details |
Current login user |
User logged into 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 > General > Login Details > Windows Domain |
Name |
Domain name of the inventoried workstation |
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 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 > 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 workstation |
|
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 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 > Hardware > 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 > 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 inventoried workstation 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 workstation |
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 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 > 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 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 > Hardware > 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 > Network > DNS |
DNS Name |
The DNS name of the inventoried workstation |
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 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 > Network (instance_number) > IPX |
IPX Address |
The IPX™ address of the inventoried workstation |
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 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 > 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 workstation resides.
Recent Information: Set to Yes if the Inventory database has been updated with the latest inventory information of the selected inventoried workstation.
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:
In ConsoleOne, select a container.
Invoke the query.
To invoke the Inventory query from a database object, right-click the database object, click
, then click .To invoke the Inventory query from the ConsoleOne Section 77.1.1, Configuring the Inventory Database.
menu, you must first configure the Inventory database, then click , click , then click . For more information on how to configure the Inventory database, seeSpecify the criteria for the query:
Query the Inventory database for: By default, the
option is enabled. The query locates all inventoried workstations satisfying the query expression. If ZENworks 7 Server Management and ZENworks 7 Desktop Management are installed in the same environment, then the , the , and options are available. When you select , the query locates all inventoried workstations satisfying the query expression. Choose to include all inventoried workstations and inventoried servers satisfying the query expression.Find Type: Select
or . Click to specify a simple query. When you choose a query, you specify one attribute, relational operators, and the value of the attribute. Choose 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 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 |
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 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.
Click
.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
, then click to view the inventory information of the inventoried workstation.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 displays 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') returns W1 and the query (SerialPort!='COM1') also returns 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.
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:
Right-click an inventoried workstation that has been successfully scanned, click
, click the tab, then click .If you click the More Workstation Information button in this page, the Workstation Inventory window is displayed.
The following table shows the mapping between minimal information attributes and attributes in the Inventory database:
Table 77-2 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 |
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 would be empty if you have not configured ZENworks 7 Desktop Management to start populating the Inventory database with the information you want.
This section covers the information on the following topics:
Before running the inventory reports, make sure that you have installed the appropriate ODBC client. For more information, see the Novell ZENworks 7 Desktop Management Installation Guide.
You can generate the types of reports described below, assuming you have already configured ZENworks 7 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.
Table 77-3 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 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 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 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 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 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 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 workstations 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 workstations 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 workstation. |
System Information Listing |
Scope, Machine Name, IP Address, DNS Name, and Computer Manufacturer |
List of all inventoried 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 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 workstation. |
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 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 workstation 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 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. |
|
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. |
|
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.
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
.To invoke the Inventory report from the ConsoleOne Section 77.1.1, Configuring the Inventory Database.
menu, you must first configure the database, click , then click . For more information on how to configure the Inventory database, seeClick the report you want to generate.
The description for the report is displayed on the right side of the screen.
See the table with listing of simple Inventory lists and listing of the comprehensive inventory reports.
Specify the selection criteria.
The
selection criteria is enabled only if both ZENworks 7 Desktop Management and ZENworks 7 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 displays 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.
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 "workstation1". If you query using work*, then workstation1 is found. If you query using work?, then the machine is not found. To find workstation1 using the ?, you must query using work????????, 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.
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 |
Click
.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.
When you run the reports from a non-English management console on a Sybase Inventory database running on NetWare, the Sybase database starts on the console on invoking the selected report. This is called the ZENworks 7 Desktop Management proxy database.
A
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:
The proxy database is invoked in the following scenarios:
If reports are invoked from a non-English management console on the ZENworks 7 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 7 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 7 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 7 Desktop Management database and, the other for the ZENworks for Desktops 4.x 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:
In the management console, right-click the proxy database icon located in the system tray, then click
.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.
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, “Unable to connect...” error message is displayed.
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)
Invoke the reports again, so Sybase reads the proxy ports configuration file, get the port, and start Sybase in the specified port.
The Reporting snap-in modifies ODBC DSN with the new port information.
Restart ConsoleOne for the changes to take effect.
To change the default settings of the Printer, click the
icon and modify the settings.Click the
icon.On the toolbar, click the
icon.In the Export dialog box, specify the location and file format.
If you choose to export the Inventory report to a text file, in the Export to Text dialog box, select the
option and set the value to 16 because the data exported is truncated if the value is less than 16.If you want to export the Inventory report to an HTML file, you can select
or 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:
Export the report to Microsoft Excel.
NOTE:If you choose to export to .csv at this point, the report is not properly exported.
Open the .xls file.
Click
, then click .In the
field, choose .Click
.Click
.Browse for and select the directory where you want to save the exported file.
Click
.You can use the Crystal Report Designer to generate reports displaying information in the Inventory database.
Before generating the reports, you must make sure 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:
On the machine where you are designing the report, set the ODBC DSN name to ZenInventory.
Click
, click , then click .Double-click
, then click .Select the ODBC driver for the database you want to connect to.
Click
.Specify the Data Source name as ZenInventory and specify the details.
NOTE:If you want to specify a data source name other than ZenInventory, you must configure the ODBC name on the each of the machines where you invoke user-defined reports through ConsoleOne.
After you have designed the report, place the report in the \consoleone\version\reporting\canned\novellreporting\ zeninventory\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.
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.
Click
.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:
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
, then click .To invoke the Quick Report from the ConsoleOne
menu, click , then click .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.
Invoke the Quick Report wizard.
The Create and Manage Quick Reports page is displayed.
Click
.In the Define Query page, define the query criteria and specify the scope for viewing the data from the Inventory database.
You can use either the default query or define a new query.
To use the default query, click Next. The Quick Report is created with the default query: System Identification.Name Matches %.
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.
(Optional) If you want to apply the filter condition defined in the Define Query window, select the
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.
Click
to change the query.For detailed information on how to change the query, see Section 77.1.3, Viewing Inventory Information by Querying the Database.
Review the query and make changes as necessary. The Query to Perform pane displays the query you define.
Click
.In the Database Fields page, do the following:
From the
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.
Click to add the selected inventory attribute to the Selected Fields list.
If you select a group attribute, all attributes of the group are added. For example, if you select the
attribute, the attributes such as vendor name, product name, and version are included in the list.To add an additional inventory attribute, repeat Step 4.a and Step 4.b.
NOTE:You can change the order of the attributes using and .
To view the report, click
.The data is displayed in the Query Results window. For more information about the Query Results window, see Working with the Query Results Window.
To save the report, click
, specify the filename, and then click .IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.
Click
.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 icon to browse and select the directory.
IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.
Click
.(Optional) In the Define Query page, change the existing query criteria and specify the scope for viewing the data from the Inventory database.
To define a new query:
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.
(Optional) If you want to apply the filter condition, select the
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.
Click
to change the query.For detailed information on how to change the query, see Section 77.1.3, Viewing Inventory Information by Querying the Database.
Review the query and make changes as necessary. The Query to Perform pane displays the query you define.
Click
.(Optional) In the Database Fields page, do the following:
From the
list, select the inventory attribute that you want to report.By default,
is selected. You cannot deselect or change the order of this attribute.Click to add the selected inventory attribute to the Selected Fields list.
If you select a group attribute, all attributes of the group are added. For example, if you select the
attribute, the attributes such as vendor name, product name, and version are included in the list.To add an additional inventory attribute, repeat Step 4.a and Step 4.b.
NOTE:You can change the order of the attributes using and .
To view the report, click
.The report is displayed in the Query Results window. For more information about the Query Results window, see Working with the Query Results Window.
To save the report, click
, specify the filename, and then click .IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.
Click
.You can view the data retrieved by the Quick Report using any of the following methods:
In the Database Fields page, click
.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 icon to browse and select the directory.
IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.
Click
.The data is displayed in the Query Results window. For more information about the Query Results window, see Working with the Query Results Window.
In the Create and Manage Quick Reports page, select the Quick Report that you want to delete from the list of Quick Reports.
You can select and delete multiple reports 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 delete a Quick Report residing in another directory, click the icon to browse and select the directory.
IMPORTANT:Only the saved Quick Reports are listed on the Create and Manage Quick Reports page.
Click
.In Create and Manage Quick Reports page, click
.The Configure ZENworks Database window is displayed.
Click
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.
Click
.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.
You can perform the following operations in this window:
View the data in a browser.
IMPORTANT:When you click
in Browser, the inventory data is exported in the XML format for rendering in the browser. Make sure 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
in Browser, you want the data to displayed in a new Internet Explorer window, do the following:Stop the data retrieval process.
The Quick Report retrieves the data from the ZENworks Inventory database. You can stop the retrieval process by clicking
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.
Click
.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.
Click
.In the
list, select the column by which you want to sort the entries.Select either
or .Configure the
drop-down lists.Click
.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:
Click the
button.In the
drop-down list, select .Select the
option.In the
drop-down list, select .Select the
option.Click
.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 |