Hello,

Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion 
FROM v_GS_SoftwareProduct SP 
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID 
WHERE ProductName like 'HP System Management Homepage'  
AND SYS.Netbios_Name0 like 'CONFIGMGRDB'
Order by SYS.Netbios_Name0, SP.ProductName, SP.ProductVersion

I am getting two lines

CONFIGMGRDB	NULL	HP System Management Homepage	Hewlett-Packard Development Company, L.P.	7.2.5
CONFIGMGRDB	NULL	HP System Management Homepage	Hewlett-Packard Development Company, L.P.	7.5.0

my issue is I have only one version of the product installed, why and how the inventory is detecting this two items? where are the files/registries which is giving the information for the second item?

Thanks,

Dom

You query clearly show that there are two installed.. You need to look at the resource explorer and find out where the second one is installed.

Hello,

I found something in the resource explorer:

File Path: C:\Windows\Temp\{3E5F6326-3D9B-403A-977B-4A6F14EFA024}

File Name: Setup.exe

a file setup.exe corresponding to the version 7.5.0 but does the setup file presence force the inventory to say the version is installed!!

On one server I delete the file and then run the inventory and now the version displayed is unique !!!

strange behavior... why the presence of a setup file will make the onventory thinks the product is installed..

Thanks,
Dom

That is the way software inventory works, hence why I never use it. I only use hardware inventory.

Hello,

But are able to do everything with the hardware inventory?

I could do this as well if I am able to trace the software I am looking for.

Thanks,
Dom

But are able to do everything with the hardware inventory?

I could do this as well if I am able to trace the software I am looking for.

IMO, yes but you will have to look for yourself.