Different between these two tables in SAM (cmdb_sam_sw_usage and samp_sw_usage)

[antony4007]

Hi Expert,

Could you please share what is the different between these two tables in SAM (cmdb_sam_sw_usage and  samp_sw_usage).

1. samp_sw_usage => I hope this table is for software usage records which is created from SCCM or Tanium. We will use this records for the reclamation rule creation. Is this correct?

2. cmdb_sam_sw_usage => What is the use of this??

Thanks,

Antony

[Community Alums]

Hi @antony4007 ,

ACC-V can capture the last accessed time for the software or applications that are installed on the target via push-based Discovery. This information along with the target CI reference, is added to the Software Update [samp_sw_usage] table.

AND

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.

[antony4007]

Hi Sandeep,

Thank you for the prompt response. I am good for the table "cmdb_sam_sw_usage". I was not asking about software install table.

I was asking about another table cmdb_sam_sw_usage similar to software usage table. Do you know the usage on this?