The following sections will explain the various types of information you can view using Novell® ConsoleOne®:
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 Viewing the Inventory Summary of an Inventoried Workstation.
For more information about querying the Inventory database, see Viewing Inventory Information by Querying the Database.
For more information, see Viewing the Minimal Inventory Information from an eDirectory Object.
For more information, see Running Inventory 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 will be used for generating inventory reports, viewing inventory information, and for querying the inventory information from the database.
To configure the Inventory database:
In ConsoleOne, select a container.
Invoke Configure DB.
Click Browse to browse for and select the ZENworks Database object.
You can also select an existing ZENworks Database object from the list of Database objects.
This Database object contains the database settings such as the protocol, port in use by the database, and others.
To apply this database configuration to all the sessions, select the Apply Configuration Across Sessions check box.
Click OK.
The database you configured is used for data retrieval unless you change it again using this same procedure.
The Inventory Summary window displays the 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 Configuring the Inventory Database.
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:
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:
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.
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:
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:
NOTE: To define a query using special characters such as ? or [, specify the query in the following formats: [?] or [ [ ].
The list of description values displayed for an Inventory component is taken from the Inventory database corresponding to the component.
Logical Operator: This option is available only for the Advanced query. Logical Operator forms query groups that will be combined with the previous query group by using the relational operator specified between the query groups.
Save: This option is available only for the Advanced query. It saves the query expression as a file in the location that you specify. The query file does not have a default extension; however, we recommend the .qry extension for easy reference.
Load: This option is available only for the Advanced query. It loads the query file that you specify. You must provide the full filename with its extension.
Click Find.
This will query based on the query criteria you specify and display the inventoried 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.
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.
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 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.
The following table shows the mapping between minimal information attributes and attributes in the Inventory database:
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:
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.
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.
Invoke the Inventory report using any of the following methods:
Click the report you want to generate.
The description for the report is displayed on the right side of the screen.
See the table with listing of simple Inventory lists and listing of the comprehensive inventory reports.
Specify the selection criteria.
The Scope selection criteria will be enabled only if both 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:
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.
The following table lists examples of wildcards.
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.
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:
The proxy database is invoked in the following scenarios:
The proxy database is not invoked in the following scenarios:
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.
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:
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, there is an error message "Unable to connect..."
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 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.
Restart ConsoleOne for the changes to take effect.
On the toolbar, click the Export Report icon.
In the Export dialog box, specify the location and file format.
If you choose to export the Inventory report to a text file, in the Export to Text dialog box, select the User defined option and set the value to 16 because the data exported will be truncated if the value is less than 16.
If you want to export the Inventory report to an HTML file, you can select HTML 3.2 or HTML 4.0 (DHTML) file format. We recommend that you export to HTML 4.0 (DHTML) because the data exported to HTML 3.2 will not be formatted properly.
If you want to export the Inventory report to a comma-separated value (.csv) file, do the following:
Click OK.
Browse for and select the directory where you want to save the exported file.
Click OK.
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:
On the machine where you are designing the report, set the ODBC DSN name to ZenInventory.
Click Start, click Settings, then click Control Panel.
Double-click ODBC Data Sources (32 Bit), then click Add
Select the ODBC driver for the database you want to connect to.
Click Finish.
Specify the Data Source name as ZenInventory and specify the details.
NOTE: If you want to specify a data source name other than ZenInventory, you must configure the ODBC name on the each of the machines where you invoke user-defined reports through ConsoleOne.
After you have designed the report, place the report in the \consoleone\version\reporting\canned\novellreporting\zeninventory\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.
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 Run Selected Report.