We are attempting to import software licenses to reconcile our licenses within asset intelligence and we have ran into the following issue.

Issue: If I import a license for an application in SCCM and then run report "License 15A - Third Party Software Reconciliation Report" the inventory count remains blank.

The .csv file is imported correctly.

The pattern that we have identified is if the field "Product Version" in resource explorer -> Installed Software is not populated then the inventory count doesn't accurately reflect the correct count of installed licenses.

IE: In resource explorer I have a machine where Cognos Series 7 Version 2, verbatim, is displayed under the "Product Name" field. The product version field for Cognos is blank. When I import software licenses for this application my .csv file essentially looks like header line as line 1, line 2 is Cognos Series 7 Version 2,,,English,,,etc.

The file imports correctly however the inventory count doesn't change. I have tested that if I manually create a reg_sz called DisplayVersion in the registry under the uninstall key for the corresponding product code that after the next software inventory scan the inventory count will change.

It seems like I am missing the wildcard for having a blank Product Version field. If anyone can help please let me know. Adding the Displayversion registry entry is not solution.

I am trying to convince others that SCCM and Asset Intelligence are the correct solution to replace our current inventory solution.

I'm not the best report writer, but as a starting point, could you right-click Clone that report (call the new one Licence 15B ...) and remove all of the ProductVersion stuff, does the report work then?

Untested, but something like...

select t1.Name as [Product Name], t1.EffectiveQuantity as [Licensed Quantity],
isnull( t2.InventoryCount,0) as [Inventory Count], t1.EffectiveQuantity - isnull(t2.InventoryCount,0) as [Difference], @CollectionID as [Collection]
from
(

(select Name, EffectiveQuantity
from v_AI_NON_MS_LICENSE) t1

left outer join

(select s1.ProductName0, count(*) as [InventoryCount]
from
(select ProductName0
from
v_GS_INSTALLED_SOFTWARE
where ResourceID in
(select ResourceID from v_FullCollectionMembership
where CollectionID = @CollectionID)
) s1

group by s1.ProductName0) t2

on t1.Name = t2.ProductName0

)

I have tested, this is working, thanks!

Hi Sherry,

i am having same situation what mamson_pr having .. can you please bit more elaborate on how to place your script on the server to get the report..

thanks.. please help me..