Records are being in cmdb_ci_spkg table which are redundant to cmdb_sam_sw_install records


Description

Records are being in cmdb_ci_spkg table which are redundant to cmdb_sam_sw_install records. It this intended behaviour? 

There is data in cmdb_ci_spkg table which are ??redundant to cmdb_sam_sw_install records still after installing SAM plug in.

Release or Environment

All Releases

Instructions

The software Application Management module is ONLY using cmdb_sam_sw_install data.

The cmdb_ci_spkg table is being used by SAM to reconcile software package and versions.
The difference is that cmdb_ci_spkg is updated indirectly via the Synch Software Package Business Rule rather than by Discovery directly.


The 'cmdb_ci_spkg' table is still necessary for other functionalities on the system (like other Business Rules that uses the 'cmdb_ci_spkg' table).
The is also why the business rule: 'Sync Software Package' is necessary to make sure the 'cmdb_ci_spkg' is sync and updated for other use.

Additional Information

When SAM is installed and when it runs, Discovery populates the Software Installation [cmdb_sam_sw_install] table. The appropriate configuration item (CI) references the software data. A business rule on this table runs, searching for a matching record on the Software Discovery Model [cmdb_sam_sw_discovery_model] table. If a record exists in the Software Discovery Model table, then the Software Installation table updates the record. If no record exists in the Software Discovery Model table, then one is created. Data from this table is then passed to the Software [cmdb_ci_spkg] table to preserve backward compatibility. The Software Model [cmdb_software_product_model] table is not populated or used by Discovery.

Sync Software Package business rule Creates a row in the package table to reflect the row in the discovery model table. (Software Discovery Model [cmdb_sam_sw_discovery_model])

business rule : https://docs.servicenow.com/csh?topicname=r_InstalledWithSoftwareAssetMgmt.html&version=latest

Discovery populates the Software Installation [cmdb_sam_sw_install] table. The appropriate configuration item (CI) references the software data. A business rule on this table runs, searching for a matching record on the Software Discovery Model [cmdb_sam_sw_discovery_model] table. If a record exists in the Software Discovery Model table, then the Software Installation table updates the record. If no record exists in the Software Discovery Model table, then one is created.

https://docs.servicenow.com/csh?topicname=c_DiscoSWAssetMgmtTableSchema.html&version=latest