Environment
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2
Situation
When running an Inventory report for General Hardware Components, if product asset tag and product serial number are added, the "No. of Instances" link returns no entries for any product that has asset number or serial number defined.
Also, if an admin has made an asset tag as null intentionally from editing in ZCC, the wrong value will be shown in reports: it won't be shown as 'No asset tag'. Instead, the value from asset tag column will be picked up and shown.
Resolution
This is fixed in version 11.2.1 - see KB 7010042 "ZENworks Configuration Management 11.21 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7010042
Note: After updating to 11.2.1, the assettag and serialnumber already edited in 11.2 via Editor(using zicon) will not be shown in ZCC.
Workaround to be used if the assettag and serialnumber were already edited:
update nc_component set assettagalias=assettag where (assettag!='' and assettag is not null and (assettagalias is null or assettagalias='') and producttype not in(22,21,29)); --not system,software,hotfix