Novell Home

ZENworks Asset Management Custom Reports

Novell Cool Solutions: Feature
By Mike Gord

Digg This - Slashdot This

Updated: 22 Mar 2007
 

The custom reporting features within the ZENworks Asset Management Web Console provide you with an avenue of retrieving the detailed device information you need to make business decisions. One of the features of custom reporting is the ability to export and import reports, making it easier to share them with other ZENworks Asset Management administrators. As usual, Cool Solutions has decided to make your ZAM administrative life easier by posting reports created by other ZAM professionals. Below you will find the downloadable reports, with their descriptions and instructions for use.

Please share your reports with us, and together we will build a library of cool reports everyone can use and learn from.

Instructions for Use

These reports are for use with the ZENworks Asset Management Web Console.

  1. On the Reports Inventory/Usage page or the Network Discovery page, choose the Custom Reports link.
  2. At the bottom of the page, choose Import Custom Report Definition.
  3. Browse to the downloaded XML file and choose to Import.
  4. The newly imported report will appear underneath an Imported folder
  5. (optional) If desired, click the report link and choose Edit at the bottom of the page to move the report to another folder.

NOTE: Reports can be dependent upon other reports. For more information on dependent reports, see the section in the Web Console Help called Working With Custom Reports, or search the Web Console help for dependent.

Library of Custom Reports

  

Finding machines without Microsoft Daylight Savings Time patch installed

by Christina Chamberlain

Report Description
With DST Patch Machines with DST patch
Without DST Patch Machines without DST patch

Cool Use for this Report

This set of reports is useful for identifying Windows machines (workstation and server operating systems) that do not have the Microsoft Daylight Savings Time patch ? KB931836. Note that this is a set of dependent reports and you must import both. The first report shows machines with the DST patch, the second then shows Windows machines that do not appear in the first.

The Last Scan Date field is added as a displayed column, so that you can determine the date the machine was inventoried. You may wish to use this field in the filter criteria to only show recently inventoried machines, e.g. "Last Scan Date within past 7 days".

Identify machines not scanned within 14 days

by Christina Chamberlain

Report Description
Not scanned past 14 days Useful for identifying machines that have not scanned recently.

Cool Use for this Report

This report is useful for identifying machines that have not scanned recently. You may wish to change the criteria to set a date range specific to your requirements. The current criteria is "Last Scan Date within past 14 days".

To request a scan of connected machines, sort by Client Is Connected, select the machines and click the Scan Selected Workstations link. If the client is not connected, the Disconnection Date indicates the last time the machine was connected.

Identify machines not connected within 14 days

by Christina Chamberlain

Report Description
Not connected past 14 days This report is useful for identifying machines that have not connected to a Collection Server recently.

Cool Use for this Report

This report is useful for identifying machines that have not connected to a Collection Server recently. You may wish to change the criteria to set a date range specific to your requirements. The current criteria is "Disconnection Date within past 14 days".

The Disconnection Date indicates the last time the machine was connected.

Query for the ZENworks Desktop Management Agent Details

by Jared L Jennings

Report Description
agent installed Query machines which have the ZENworks Desktop Management agent installed.
> 7 Query machines which have the ZENworks Desktop Management agent version 7 or greater.
< 7 Query machines which have the ZENworks Desktop Management agent prior to version 7 installed.

Cool Use for this Report

These reports query for the ZENworks Desktop Management agent. Listing machines that do have the agent installed, machines that have the agent version 7 or greater and machines that have a agent older than 7.

"

Dell Systems with Batteries that May Be Subject to Recall

Reports Description
For Microsoft SQL or MSDE Databases This report can be used to help reduce the number of Dell laptops that must be physically examined to determine if the batteries contained in them are subject to the recall announced by Dell in August 2006 and described here.
For Oracle Databases

This report can be used only after:

  1. downloading and applying ZENworks Asset Management Interim Release 8
  2. re-scanning all computers with the ZENworks Asset Management client

Cool Use for this Report

Import the report definition (see instructions above for importing reports to the Web Console). The import will create a new folder in the Web Console Custom Reports called Battery Reports. This folder will contains 3 reports, one is the primary report (Dell Battery Model Report) and the other two (Batteries, List and Batteries, List 2) are reference reports. Use the main report entitled: Dell Battery Model Report (the other reports are sub-reports and should not be modified or run separately).

This report shows all machines that have a battery model that may be subject to recall (based on the battery model numbers published by Dell here. To determine if the batteries shown on this report are actually subject to recall, the physical battery must be examined and the full PPID (Dell Part Piece Identification) must be entered into this page on the Dell web site: http://www.dellbatteryprogram.com/.

NOTES:
  • The report may take a while to run on large databases.
  • Due to the large number of criteria, which is displayed in the report header, you may need to page down (versus scrolling) to get to the data. In Internet Explorer, you may need to export the report to PDF, CSV or Excel to view the data in the report.
  • Your use of the report definition and any information contained in this article is subject to the legal terms of the site found at: http://www.novell.com/company/legal/

Anti-Spyware Definition and Engine Details

Report Description
Anti-spyware definition and engine details Lists installed anti-spyware software products along with version and spyware definition and engine details.

Cool Use for this Report

This custom report can be imported and used after applying the September 2006 Product Recognition Update (see this page to get this PRU: http://support.novell.com/filefinder/20636/index.html) and re-scanning machines to generate a report of recognized anti-spyware software products and the version of their anti-spyware definitions and engine (which is stored in the Additional Information field). Use this report to ensure that your anti-spyware products are up to date.

Finding Machines with Hotfix Installed

by Christina Chamberlain

Reports Description
Hotfix 821557 List of Machines with Hotfix 821557
Hotfix 893066 List of Machines with Hotfix 893066
821557 and 893066 List of Machines with Hotfix 821557 and 893066. This report depends on the reports "Hotfix 821557" and "Hotfix 893066"

Cool Use for this Report

This set of reports is useful for finding machines that have either a particular Hotfix or multiple Hotfixes. The actual Hotfix number you use in this report is up to you, and can be easily edited once you've imported this report into your ZAM system. Notice that if you create single reports for each Hotfix, you can then easily create a summary report of machines that contain multiple Hotfixes by creating a report which is dependent upon the results of other reports.

Finding Machines Where a Memory Value has Changed

Report Description
Memory Changes Displays machines where a memory value has changed.

Cool Use for this Report

Have you ever run across a workstation that has less memory in it now than when it was purchased? This report can be used to determine which machines have had their total amount of memory changed, and when that change took place. This includes systems where the memory has increased or decreased, allowing the administrator to be in the know when it comes to memory sticks walking away.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell