When the Inventory to Asset Synchronization task is run, it fails to copy the Inventory Solution data classes of Manufacturer, Model, Serial Number or System Number to CMDB's counterpart data classes.
Review the following information to determine what the issue and solution are. Note: It is assumed that the user is using the out of box default task. If there is a cloned task or a custom task that is being used that has the same functionality that isn't working, first verify that the default task does or does not work. If it does, then the sole issue is with the clone/custom task, which would need to be troubleshot separately.
Issue: The task isn't running.
Solution: The task is not set to run automatically by default. Ensure that the task is scheduled to run or run manually.
Issue: The task, when ran, results in errors, such as ones seen in the Console or in the Altiris Log Viewer on the server.
Solution: Review the error and the Symantec Knowledge Base to provide specific troubleshooting based on why the error is occurring.
Issue: The task runs, but doesn't appear to do anything. In the logs, there are no errors and there are entries for the task starting and finishing, presumably successfully.
Solution: Either the filter used does not have the expected computers, Inventory Solution data for Manufacturer, Model, Serial Number or System Number are not populated in the database or CMDB's counterpart data classes are not empty. Note: The CMDB Manufacturer, Model, Serial Number and System Number data classes will only be updated by the Inventory to Asset Synchronization task if the following two statements are true: (1) A record for the computer resource does not exist in the target CMDB data class or the data class in the target CMDB record is an empty string or NULL, and (2) The data class in the source Inventory Solution record has a non-empty, non-NULL value.
Note: For the last two bullets, a SQL script can be run in the SQL Server Management Studio to also verify the Inventory Solution and CMDB Solution Manufacturer, Model, Serial Number and System Number data. This can be useful for verifying either or both sets of data classes. Run the attached SQL script, "Find Inventory and CMDB Sync data.txt" to display this data.
Issue: Inventory Solution isn't populating Manufacturer, Model, Serial Number or System Number.
Solution: Ensure that the Inventory Solution plug-in is installed on the affected computers and that an Inventory Solution Hardware policy has been applied and working successfully. If either of these is not working, please contact the Inventory Solution Technical Support team for additional assistance, as it is outside of this CMDB article's scope to provide in-depth troubleshooting for Inventory Solution issues.
Issue: The CMDB System Number isn't populating but other data classes are.
Solution: This is a known issue for the sync. By default, the Inventory to Asset Synchronization only checks the Inventory Solution table and data class of Inv_SW_BIOS_Element.[Identification Code]. Depending on the manufacturer, however, Inventory Solution may populate alternate table and data classes with the System Number. If so, the stored procedure that the task uses must be manually modified to account for this. The following article describes how to do this:
CMDB task "Inventory to Asset Synchronization" does not sync the System Number
While Notification Server 6, CMDB Solution 6.x and Inventory Solution 6.x are no longer supported, the following table and data class information is provided as a courtesy to help troubleshoot the Inventory to Asset Synchronization if it is failing on these older products.
Inventory Solution 6.x Tables and Data Classes
Manufacturer: Inv_AeX_HW_Serial_Number.[System Manufacturer]
Model: Inv_AeX_HW_Serial_Number.[Computer Model]
Serial Number: Inv_AeX_HW_Serial_Number.[Serial Number]
System Number: Inv_AeX_HW_Serial_Number.[Asset Tag]
CMDB Solution 6.x Tables and Data Classes (same as for 7.x)
Serial Number: Inv_Serial_Number.[Serial Number]
System Number: Inv_Identity.[System Number]
How does the CMDB task "Inventory to Asset Synchronization" work?