Custom ZAM Report Migration

  • 7004849
  • 24-Apr-2012
  • 06-Aug-2013


Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1 Migration
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2 Migration


Unable to migrate custom ZAM 7.5 reports that contain LastSuccessfulScanDate, DefaultGateway or SubnetMask.


This is fixed in version 11.2.1 - see KB 7010042 "ZENworks Configuration Management 11.2.1 - update information and list of fixes" which can be found at
The current workaround to this issue is about removing checks from DBConfig.xml.

1. Open the DBConfig.xml file from the ZAM migration utility installed location.(C:\Program Files\Novell\ZENworks\ZAMMigration\DBConfig.xml)
2. Remove the below 3 lines from the file.
3. Save the file and restart the utility to test the fix.

-- these three were added as columns to 7.5, but not yet to ZCM 
exec zMarkInvalidCustomReports N'NC_Workstation.LastSuccessfulScanDate__dt'; 
exec zMarkInvalidCustomReports N'NC_Workstation.DefaultGateway'; 
exec zMarkInvalidCustomReports N'NC_Workstation.SubnetMask';


Analyzing the ZAM migration code and looks like the check (which says gateway, subnetmask and lastsuccessfulscandate cannot be migrated) was added long back when these columns did not exist in ZCM. As has been found, these columns do exist in ZCM now.