Summary
When users try to link a computer from the inventory list to an existing asset, error message is returned saying "1 of the selected computers failed to link to the matched asset"
1 of the selected computers failed to link to the matched asset
Symptoms
When users try to link a computer from the inventory list to an exsiting asset, the following pop up error may appear:
1 of the selected computers failed to link to the matched asset
Cause
This error could be caused by assets existing in the ECM database without their placeholder inventory records (dummy records).
These assets can be identified by running the following query against the FNMP database. Any computers returned from this query will raise this error:
----------------
SELECT a.*
FROM Asset AS a
INNER JOIN AssetType AS at ON at.AssetTypeID = a.AssetTypeID
LEFT OUTER JOIN ComplianceComputer AS cc ON cc.AssetID = a.AssetID
WHERE cc.ComplianceComputerID IS NULL
AND at.ManagedType = 1
-----------------
Resolution
If the computer in question is indeed in the returned list of the SQL query above, the following query will create a dummy record for each asset that do not have an entry in compliancecomputer table associate with it.
------------------
INSERT INTO ComplianceComputer (AssetID, SerialNo, ComputerName, ComplianceComputerTypeID, ComplianceComputerStatusID, AssetComplianceStatusID)
SELECT
a.AssetID,
a.SerialNumber,
a.ShortDescription,
1,
4,
NULL
FROM
dbo.Asset AS a
INNER JOIN dbo.AssetType AS ast
ON ast.AssetTypeID = a.AssetTypeID
WHERE
ast.ManagedType = 1
AND NOT EXISTS (
SELECT '1' FROM dbo.ComplianceComputer AS cc
WHERE cc.AssetID = a.AssetID
)
------------------