Hello,

When I run the query:

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 
Order by SP.ProductName, SP.ProductVersion

I am getting only HP product .... is it normal?

is there another view/table where I could cross check any issue?

I noticed from the Design view of the v_GS_SoftwareProduct it is pointing to the view vSMS_G_System_SoftwareProduct which is like this:

SELECT DISTINCT sp.NewProductId AS ProductId, sp.CompanyName, sp.ProductName, sp.ProductVersion, sp.ProductLanguage, si.ClientId
FROM         dbo.SoftwareProductMap AS sp INNER JOIN
                      dbo.SoftwareInventory AS si ON sp.OldProductId = si.ProductId
WHERE     (sp.ProductName LIKE 'HP%')

effectively this view is blocked to HP... Why? should it be an issue from a query done by a tech?

Any way to trace when it was modified and by who?

Thanks,

This is SW inventory data, and therefor will only show you what SW inv. is looking for.