How to Create a Report sql installed?, Not Including NATIVE CLIENT (installed on some computers) or production versions only and express

[Fray]

Hello, I need help friends.

I want to issue a report of all computers that have installed sql server production, in its different versions, but I have not succeeded, provided no information appears correct., There is a table that I see? done not show much information and only as needed, see image and transaq sql

 

 

 

================

 

 

query:

 

 

Select distinct

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedName as [Product Name],

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedPublisher as [Publisher],

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedVersion as [Version],

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.FamilyName as [Family Name],

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.CategoryName as [Category Name],

count(v_GS_INSTALLED_SOFTWARE_CATEGORIZED.ResourceID) as [instance Count],

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.SoftwareID as [software ID], v_GS_INSTALLED_SOFTWARE_CATEGORIZED.SoftwarePropertiesHash0 as [software Properties Hash]

--@CollectionID as [Collection ID]

from v_GS_INSTALLED_SOFTWARE_CATEGORIZED

where (v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedPublisher like '%Micros%')

and ProductName0 like '%SQL%'

--and v_GS_INSTALLED_SOFTWARE_CATEGORIZED.ResourceID IN

--(select distinct v_FullCollectionMembership.ResourceID from v_FullCollectionMembership inner join v_R_System_Valid ON v_R_System_Valid.ResourceID = v_FullCollectionMembership.ResourceID where CollectionID= @CollectionID )

group by v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedName,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedPublisher,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.NormalizedVersion,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.FamilyName,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.CategoryName,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.SoftwareID,

v_GS_INSTALLED_SOFTWARE_CATEGORIZED.SoftwarePropertiesHash0

order by [instance Count] desc

even including% sql%, the information is still not correct, where I can find this data.

If a laptop client computer has the sql client, it takes like a setup. and this is not right