-- Machine_Name | Instance_Name | Product_Version | Edition | Product_Level | Product_Version_Number | Update | Collation | Is_Hadr_Enabled | Is_Clustered | Is_Full_Text_Installed | Is_Integrated_Security_Only | License_Type | Num_Licenses

SELECT SERVERPROPERTY('MachineName') AS [Machine_Name]
,SERVERPROPERTY('ServerName') AS [Instance_Name]
,'Microsoft SQL Server ' + CASE SUBSTRING(CAST(SERVERPROPERTY('PRODUCTVERSION') AS VARCHAR(100)), 1, CHARINDEX('.', CAST(SERVERPROPERTY('productversion') AS VARCHAR(100))) + 1)
	WHEN '10.0' THEN '2008'
	WHEN '10.5' THEN '2008R2'
	WHEN '11.0' THEN '2012'
	WHEN '12.0' THEN '2014'
	WHEN '13.0' THEN '2016'
	WHEN '14.0' THEN '2017'
	WHEN '15.0' THEN '2019'
	WHEN '16.0' THEN '2022'
	ELSE 'Version Not Found'
	END AS [Product_Version]
,SERVERPROPERTY('Edition') AS [Edition]
,SERVERPROPERTY('ProductLevel') AS [Product_Level]
,SERVERPROPERTY('ProductVersion') AS [Product_Version_Number]
,CASE SERVERPROPERTY('ProductVersion')
	WHEN '10.0.6000.29' THEN 'You''re up to date'
	WHEN '10.50.6000.34' THEN 'You''re up to date'
	WHEN '11.0.7001.0' THEN 'You''re up to date'
	WHEN '12.0.6024.0' THEN 'You''re up to date'
	WHEN '13.0.6300.2' THEN 'You''re up to date'
	WHEN '14.0.3456.2' THEN 'You''re up to date'
	WHEN '15.0.4261.1' THEN 'You''re up to date'
	WHEN '16.0.950.9' THEN 'You''re up to date'
	WHEN '16.0.1000.6' THEN 'You''re up to date'
	ELSE 'Updates Available'
	END AS [Update]
,SERVERPROPERTY('Collation') AS [Collation]
,SERVERPROPERTY('IsHadrEnabled') AS [Is_Hadr_Enabled]
,SERVERPROPERTY('IsClustered') AS [Is_Clustered]
,SERVERPROPERTY('IsFullTextInstalled') AS [Is_Full_Text_Installed]
,SERVERPROPERTY('IsIntegratedSecurityOnly') AS [Is_Integrated_Security_Only]
,SERVERPROPERTY('LicenseType') AS [License_Type]
,SERVERPROPERTY('NumLicenses') AS [Num_Licenses]