Report: unlicensed software product installs with associated hardware asset ID

[DominionA007]

Trying to generate an "unlicensed installs" software report. Report needs to ID the asset ID to address the unlicensed record. Basic columns in the report would be:

Column Name	Example Report Data
Publisher	Citrix
Product	Premier Rush
Serial Number	10-12932913092b12321
Asset Tag	59282
Assigned To	Ann Marie Dominion

That said, I tried using the Table: Product Result [samp_product_result] but am unable to generate the basic columns needed and need assistance. Thanks in Advance. 

[Engelica Adalia · Accepted solution]

Hi @DominionA007, 

[samp_product_result] table is for reconciliation results at the software product level. I suggest you use the software installations table [cmdb_sam_sw_install], you can filter the results to show the "Unlicensed install = true".  Then edit the columns to include the following: Product result > Product, Publisher, Installed on > Serial number, Installed on > Asset tag, Installed on > Assigned to.

Note that if you check the "Reconciliation result" per Publisher, there is a summary that shows you both the Software model statistics" and "Progress indicators (this is where you would see the "Unlicensed installs" as well).