Xerox printers are not being discovered

  • 7003512
  • 11-Jun-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2

Situation

Xerox printers are not showing up in the report for Network Discovery.  The logs show the IP address of the Xerox printers being discovered, but the Xerox printer never gets loaded into the discovery data.

Resolution

The fix is to run the script below to increase the column length for the Firmware revision column in the database.
 
Query to change the column size : (sybase database)

alter table NC_NetworkPrinter modify FirmwareRevision nvarchar(60);


Query to change the column size : (mssql database)

alter table NC_NetworkPrinter alter column FirmwareRevision nvarchar(60)
 

Additional Information

The problem is that some models of Xerox printers have a date and time stamp for the Firmware revision date.  The firmware revision column in the database has a length of 25, but the date and time stamp that the Xerox printer is returning is longer than 25 characters.