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

Products

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

Issue/Introduction

You see 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.

You 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 you look at the Asset info for those machines, the Serial Number is not present.

Environment

ITMS 8.x

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 improved this in the 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

Troubleshooting the CMDB task "Inventory to Asset Synchronization"