Software installtion table (cmdb_sam_sw_install)

Ariman
Kilo Contributor

What Software installation Table (cmdb_sam_sw_install)? Who populates the table? And why it is important from Sam perpective? Will my discovery model get normalized if i dont have software model for specfic publisher?

 

Thanks in advance!!

1 ACCEPTED SOLUTION

Alex Panzarella
ServiceNow Employee
ServiceNow Employee

The Software Install table (cmdb_sam_sw_install) is the base table SAM Pro is built on. The Software Install table is a 1:1 from your discovery sources. For example, if you have SCCM or ServiceNow Discovery identifying software it would be loaded into this table with the same values as the source.

The next step is the SAM module looks at your raw Software Install data and normalizes and enriches it in the Discovery Model table (cmdb_sam_sw_discovery_model). This normalization happens automatically when new software install data is populated (software model is not a requirement for normalization).

After everything is normalized we come to the software model table (cmdb_software_product_model). The software model references what discovery models we want in scope.

View solution in original post

4 REPLIES 4

Alex Panzarella
ServiceNow Employee
ServiceNow Employee

The Software Install table (cmdb_sam_sw_install) is the base table SAM Pro is built on. The Software Install table is a 1:1 from your discovery sources. For example, if you have SCCM or ServiceNow Discovery identifying software it would be loaded into this table with the same values as the source.

The next step is the SAM module looks at your raw Software Install data and normalizes and enriches it in the Discovery Model table (cmdb_sam_sw_discovery_model). This normalization happens automatically when new software install data is populated (software model is not a requirement for normalization).

After everything is normalized we come to the software model table (cmdb_software_product_model). The software model references what discovery models we want in scope.

Hi @Alex Panzarella ,

 

During Azure discovery, iam expecting there to be Windows Server (cmdb_ci_win_server) and IIS Virtual Directory (cmdb_ci_iisdirectory) records created/updated. iam noticing that although the Windows Server records have Software Installations (cmdb_sam_sw_install records) associated with them were updated  in cmdb_sam_sw_install (software installations)under window server(cmdb_ci_win_server), but iam  not seeing Software Installations associated with IIS Virtual Directory records.please refer screenshot for details.

anitha0887_0-1713708097421.png

anitha0887_1-1713708118290.png

 

Runjay Patel
Giga Sage

Software Asset Management (SAM - Pro)

 

Check out this video, it will clear all your doubts and help you to understand Software Asset Management (SAM - Pro) in details.

Link: https://www.youtube.com/playlist?list=PLIGcZxQaeEoh0bObsaDpMeYk2N2QXAtBK

It will help you resolve below queries:

  • SAM Offers / Challenges
  • Deep Understanding about SAM Terminology
  • IT Assets & Configuration Items
  • IT And Software Asset Lifecycle
  • SAM Optimization Checklist
  • Plugins For Software Asset Management
  • Software Entitlement
    • Software Entitlement Import
    • Benefits of using software entitlements
    • To download to entitlement import template
    • Entitlement Import Process
    • Entitlement Import Errors
    • Entitlement Review and Clear Errors
  • Software Asset Management (SAM) Lab
    • Play with SAM Roles
    • Upload Software Model/ Product Catalog
    • Various way to do Normalization
    • Creating a Custom Products
    • Reconciliation
    • Understand Entitlement Metrics
    • Software Usage
    • Reclamation

Link is invalid/ broken.