Inventory PC installed with SQL Server does not report the version of sql

[Fray]

Hello friends.

I'm generating a query for all computers that have SQL installed, but the result is not as expected, I want the SQL and see, someone can help me with any questions.

I want the installed version, not all components as shown in the image ..

[GarthMJ]

There are several way to inventory this, which method did you use?

What does your query look like?

Have you looked at those PCs to find out why, you are not getting the results that you expect?

[Fray]

hi

 

 

 

SELECT distinct dbo.v_R_System.Name0, dbo.v_R_System.AD_Site_Name0 as "Site",dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],

arp.DisplayName0 as "Software",arp.Version0

FROM dbo.v_Add_Remove_Programs AS arp INNER JOIN

dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID INNER JOIN

dbo.v_RA_System_SMSInstalledSites AS ASSG ON dbo.v_R_System.ResourceID = ASSG.ResourceID INNER JOIN

dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID

WHERE (arp.DisplayName0 LIKE 'Microsoft SQL Server 2005%')OR

(arp.DisplayName0 LIKE 'Microsoft SQL Server 2008%')OR

(arp.DisplayName0 LIKE 'Microsoft SQL Server 2012%') ORDER BY dbo.v_R_System.Name0, arp.DisplayName0, arp.Version0

[GarthMJ]

Remember that the version number is an option item for Add/Remove programs. Therefore in this case it is not the best option for this.

[Fray]

hanks friend.

Excuse my ignorance, I suggest? please help, have a question? something I orient