Scripting

Hello, Kace newbie here.

I have been tasked with finding which servers have SQL Server 20xx *Edition* installed. By edition, I mean Standard, Express, Enterprise, etc

It looks like edition is only shown in Software Catalog.

I am looking for the best way to get the listing on the SQL servers EDITIONS. I have made a poor SQL query which gives some results, but I am not sure if that is actually what I need since it is also giving me SQL servers without the Edition

SELECT 

SAM_CATALOG.NAME as "Software", 

MACHINE.NAME as "Computer Name",

 MACHINE.System_Description as 'Description',

 MACHINE.IP as 'IP Address',

 MACHINE.USER_FULLNAME as 'Last User',

 MACHINE.OS_NAME as 'OS',

 MACHINE.Virtual as 'Virtual'

FROM CATALOG.SAM_CATALOG

JOIN ORG6.SAM_MACHINE_JT on SAM_MACHINE_JT.SAM_CATALOG_ID = SAM_CATALOG.ID

JOIN ORG6.MACHINE on MACHINE.ID = SAM_MACHINE_JT.MACHINE_ID

WHERE 

SAM_CATALOG.NAME like '%SQL Server 20%' and

CATALOG.SAM_CATALOG.NAME not Like '%Update%' And

/*

you can insert any name here to filter out the bad results, my list here is huge after %Update% it has around 20 more not like statements :(

*/

ORDER BY MACHINE.NAME

So this query is looking into the catalog. I have another SQL query which properly reports which servers have SQL server installed, but that one looks into Software.Name, and that is why it does not show SQL Edition.

If anyone could provide some insight into this, I would greatly appreciate it. Thanks!