@hadron_collider As per ServiceNow, "Model categories associate CI classes with asset classes. The model category configuration determines if the ServiceNow platform creates an asset from a CI, and, if so, what class of asset.
Configuration Item (CI) in the [cmdb_ci] table have different classes (e.g. application, business application, server, application service, business service, software, etc.). Although the Software Model [cmdb_software_product_model] is under the cmdb table, this is different from a CI. It holds the software license/entitlements [alm_license] you own (entitlements based on your purchased rights).
Note about [cmdb_ci_spkg] table: This is being used by SAM to reconcile software package and versions and is updated indirectly via the 'Synch Software Package' Business Rule which is created as part of the 'Legacy Software Asset Management' and it is disabled when SAM or SAMP is installed. The software Application Management module is ONLY using cmdb_sam_sw_install data.
Helpful ServiceNow References:
Models (servicenow.com)
Model categories (servicenow.com)
Records in cmdb_ci_spkg table which are redundant to cmdb_sam_sw_install records
Asset and CI management (servicenow.com)
