Identifying Licenced software from installed software table and appling cost

andynewey
Tera Expert

17 hours ago

I am looking at highlighting software spend to management.  As part of the solution I need to provide a list of all installed software on a device.  I only want to return licenced software.  Then I want to apply the cost spent on each line of licenced software.

 

I can easily see how link tables for device and installed software.  What tables do I need to see if the software is licenced? 

 

Then what tables do I need to extract the cost.  That is held in the entitlement table ALM_ENTITLEMENT but how do I link that back to installed softwware. 

 

Do I have to use discovery map, discovery model and software model to link all this data together or is there another way to achieve this? 

0 Helpfuls
  • 100 Views
1 REPLY 1

mikew_samexpert
Mega Guru

7 hours ago

There is a field on the cmdb_sam_sw_install table called "Unlicensed Install" - if this is 'true' then this means the installation is unlicensed.

 

Pulling the cost isn't straight forward if you are using the alm_license table, because entitlements could have different costs. My recommendation is to add the cost to the software model and link this back to the install via the "Software Model Result" field in the cmdb_sam_sw_install table.

0 Helpfuls