Microsoft SQL Server *EDITION* report
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
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'
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
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!
Be the first to answer this question