Software Asset Management by Location

[TravisRay]

Background:

• We are currently undertaking data discovery for what applications are used at a specific site.

Question:

• Can you report Discovered Models with a count of how many software installations for each location?

Using SQL the statement would be similar to:

Select 

     cmdb_sam_sw_discovery_model.Display Name              "Discovery Model details

     cmdb_sam_sw_discovery_model.Discovered Product   

     cmdb_sam_sw_discovery_model.Discovered Publisher   

     cmdb_sam_sw_discovery_model.Discovered Version   

     cmdb_ci_hardware.location                         " Hardware location

     cmdb_sam_sw_install.Display Name (Count of installs)   "Software installations count

where

     cmdb_sam_sw_install.Discovery Model = cmdb_sam_sw_discovery_model.Primary Key     

     cmdb_ci_hardware.name = cmdb_sam_sw_install. Installed On     

     cmdb_sam_sw_install.Active Install = Yes

     cmdb_ci_hardware.install status = Installed

I've tried to use CMDB Query Builder however it is limited where it cannot retrieve the Discovery Model or summarise records as a count. I'm also concerned about the size of the tables involved so want to use an efficient method. I'm hoping this ability may help others to prioritise software model creation, etc. 

[dreinhardt · Accepted solution]

Hi @TravisRay 

Your approach is heading in the right direction. Unfortunately, the count at the discovery model level is a summary of all matching software installations. I would recommend that you start directly in the software installation table, set your necessary CI filters (e.g. location) and then group by discovery model. Try to get all the data per scripted solution, export into a custom table and include this table into a report, is more flexible than the query builder.

You could also create software models directly for all products in the scope (if necessary, onboard entitlements) and group the results of the Recons by location. For all Discovery Models with the product type “licensable”, the workspace already displays the tile without a software model and provides insights into the associated installations. Perhaps this way is a little more convenient?

Best, Dennis

[TravisRay]

Thanks Dennis. Very helpful