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)
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.