Support Tips:Push of installed software creates duplicate software records in Asset Manager (AM)

[Liu_Jun]

Issue:

When pushing software data from UCMDB to AM multiple times, duplicate software records are created.

Workaround/resolution

please modify the reconciliation rule in the am-push-mapping.xml as below:

----------------
<am-mapping ci-type="Complete_amSoftInstall" primary-key="lSoftInstId" operation-type="update_else_insert" target-ci-type="amSoftInstall" parallel-push-allowed="true">
< reconciliation>
< reconciliation-advanced>1=${if(vInventoryKeyValid==true){return 1} else {return 0}} AND Folder='${mappings.scripts.AMReconciliationAdvanced.getSqlTextConst(vFolder)}' AND ParentPortfolio.Computer.lComputerId = '${vParentId}' AND seType = 0 AND InventModel.InventoryKey='${vInventoryKey}'</reconciliation-advanced>
< reconciliation-advanced>Folder='${mappings.scripts.AMReconciliationAdvanced.getSqlTextConst(vFolder)}' AND ParentPortfolio.Computer.lComputerId = '${vParentId}' AND seType = 0 AND InventModel.InventoryName='${mappings.scripts.AMReconciliationAdvanced.getSqlTextConst(vSWName)}' AND InventModel.Version='${vVersion}' AND InventModel.BrandName='${vBrandName}'</reconciliation-advanced>
< /reconciliation>
< reference-attribute ci-name="Complete_amInventModel" datatype="STRING" name="lInventModelId" reference-direction="child"/>
< reference-attribute ci-name="Complete_amPortfolio" datatype="STRING" name="lParentPortfolioId" reference-direction="child"/>
< attribute-reconciliation attribute-name="lModelId"
insert-script="mappings.scripts.AMReconciliationAdvanced.getModelFromInstalledSoftwareCI(OutputCI)"
update-script="mappings.scripts.AMReconciliationAdvanced.getModelFromInstalledSoftwareCI(OutputCI)"/>
< action-on-delete>
< set-attribute-value name="bMissing" datatype="BOOLEAN" value="1"/>
< /action-on-delete>
< /am-mapping>
------------------------

[nocserve]

what of duplicates of Computer Assets especially if you are trying to use Serial # and HostNames as unique attributes for reconciliation?

[John Goldstein]

Which content packs are affected?

Is this only if you are using the AMPushAdapter or is the AMGenericAdapter affected as well?

[Liu_Jun]

hi,

This is an old issue in ampush adapter

[Liu_Jun]

this sounds like a customization question. you need to refer to tailoring document then modify this part accordingly.