Get Server properties

SELECT SERVERPROPERTY('MachineName') val ,'Machine Name' Descr 
UNION ALL select SERVERPROPERTY('ServerName') ,'Server Name' 
UNION ALL select SERVERPROPERTY('InstanceName') , 'Instance' 
UNION ALL select SERVERPROPERTY('IsClustered') , 'IsClustered' 
UNION ALL select SERVERPROPERTY('ComputerNamePhysicalNetBIOS') , 'Computer Name Physical NetBIOS' 
UNION ALL select SERVERPROPERTY('Edition') , 'Edition' 
UNION ALL select SERVERPROPERTY('ProductLevel') , 'Product Level (What servicing branch (RTM/SP/CU))'				
UNION ALL select SERVERPROPERTY('ProductUpdateLevel') , 'Product Update Level (Within a servicing branch, what CU# is applied)'	
UNION ALL select SERVERPROPERTY('ProductVersion') , 'Product Version'
UNION ALL select SERVERPROPERTY('ProductMajorVersion') , 'Product Major Version' 
UNION ALL select SERVERPROPERTY('ProductMinorVersion') , 'Product Minor Version' 
UNION ALL select SERVERPROPERTY('ProductBuild') , 'Product Build' 
UNION ALL select SERVERPROPERTY('ProductBuildType') , 'Product Build Type ( Is this a GDR or OD hotfix (NULL if on a CU build))'			  
UNION ALL select SERVERPROPERTY('ProductUpdateReference') , 'Product Update Reference (KB article number that is applicable for this build)' 
UNION ALL select SERVERPROPERTY('ProcessID') , 'ProcessID'
UNION ALL select SERVERPROPERTY('Collation') , 'Collation' 
UNION ALL select SERVERPROPERTY('IsFullTextInstalled') , 'IsFullTextInstalled' 
UNION ALL select SERVERPROPERTY('IsIntegratedSecurityOnly') , 'IsIntegratedSecurityOnly'
UNION ALL select SERVERPROPERTY('FilestreamConfiguredLevel') , 'FilestreamConfiguredLevel'
UNION ALL select SERVERPROPERTY('IsHadrEnabled') , 'IsHadrEnabled' 
UNION ALL select SERVERPROPERTY('HadrManagerStatus') , 'HadrManagerStatus'
UNION ALL select SERVERPROPERTY('InstanceDefaultDataPath') , 'InstanceDefaultDataPath'
UNION ALL select SERVERPROPERTY('InstanceDefaultLogPath') , 'InstanceDefaultLogPath'
UNION ALL select SERVERPROPERTY('BuildClrVersion') , 'Build CLR Version'
UNION ALL select SERVERPROPERTY('IsXTPSupported') , 'IsXTPSupported'
UNION ALL select SERVERPROPERTY('IsPolybaseInstalled') , 'IsPolybaseInstalled'				
UNION ALL select SERVERPROPERTY('IsAdvancedAnalyticsInstalled') , 'IsRServicesInstalled'	

Microsoft Help