ZENworks Reporting does not list all the expected workstations

ZENworks Reporting does not list all the expected workstations
Novell Client Component by Machine, Novell Client Installation Count and Novell Client by Machine does not list all the expected workstations

None, Working as Designed.
Workaround:

For agents versions older than 6.5, the query below can be used to find the current installed Novell client version for all the imported workstations.

"select ucs.name, nw.version from cim.unitarycomputersystem ucs, zenworks.netwareclient nw, cim.installedsoftwareelement ise where ise.system=ucs.id$ and ise.software = nw.id$ and nw.version is not null"

To be able to run this query towards the ZENworks database you can use the Sybase database probe utility that can be found in theTID 2967126 "ZENworks Sybase Database Probe utility".

For agents version 6.5 and above, the reports provided within ConsoleOne can be successfully used.

Only the workstations running with at least the Novell Client 4.90 SP1a and the ZfD Management Agent 6.5 will appear in the mentioned reports.
Agent older than 6.5 are not aware of the software schema changes were made introducing ZENworks 6.5, therefore does not populate properly the database as the 6.5 agents does. The mentioned reports gets data from the new software schema.

In order to have full functionality using a ZENworks 6.5 environment, the minimum required version of the Novell Client is the 4.90 SP1a or above; as reported into the section "User Workstation Requirements" of the "Novell ZENworks 6.5 Desktop Management Installation Guide".

Formerly known as TID# 10097929