Unable to browse for criteria in Network Discovery report

  • 7001565
  • 08-Oct-2008
  • 27-Apr-2012

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5

Situation

When creating a custom report in the Network Discovery tab, if the criteria is set to IP Address Contains or IP Address Starts with , then the browse button is seleted the following error is returned.
 
The data you requested is not available.  Details: [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Resolution

Fixed in ZENWorks Asset Management Interim Release 16 or newer.

Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com .   The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section for details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 16 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.