"Inventory To Asset Synchronization" task is not bringing Serial Number info

Products

• Asset Management Solution
• Asset Management Suite
• IT Management Suite

Issue/Introduction

The customer reported that the "Duplicate Computer Merge" task (under Manage>Jobs and Tasks>System Jobs and Tasks>Service and Asset Management) was not merging computer records that contain the same Serial Number.

The customer informed that they are running the "Inventory To Asset Synchronization" task in order to bring the inventory information into the set tables but it runs too quickly.

When they look at the Asset info for those machines, the Serial Number is not present.

 

 

Environment

ITMS 8.5 RU4 and before

Cause

While we were troubleshooting the issue we noticed that "spAssetInventorySync" stored procedure should be grabbing the Serial Number info.

 

 

but when we profiled the process, we noticed that the "@includeCollectionGuid" parameter was passing nothing

 

 

causing basically the process to no bring anything besides 0's.

Resolution

This issue has been reported to the Symantec Development team. They are planning to improve this process with our ITMS 8.6 Release.

1. You need to have a "Filter" selected in order to pass the missing value for this parameter. In this case you can select "All Computers" for example.

 

 

Also, another workaround can be the following:

There is something that you can do easily without fixes in assemblies:

The fix to use ALL (asset) computers might be quite easy to deploy for "sync" task - only SQL Stored Procedure to be changed - replace the bold lines, which is originally is like this ( @ spAssetInventorySync ):

select @excludeCollectionGuidFixed = case when @excludeCollectionGuid = '' then '00000000-0000-0000-0000-0000000000000000' else @excludeCollectionGuid end
– generate a table of resource guids for update.
create table #ToChange(ResourceGuid uniqueidentifier)
if (len(@includeCollectionGuid) > 0)

to be like this:

select @excludeCollectionGuidFixed = case when @excludeCollectionGuid = '' then '00000000-0000-0000-0000-000000000000' else @excludeCollectionGuid end
– generate a table of resource guids for update.
create table #ToChange(ResourceGuid uniqueidentifier)
if (@includeCollectionGuid != '' and @includeCollectionGuid != '00000000-0000-0000-0000-000000000000')

After the change, if no filters were selected - all the computers from view "vAsset" will be used for the sync (as we pass '000...' string for in/ex collections).

Additional Information

159075

How to troubleshoot the CMDB task "Inventory to Asset Synchronization"