find-server-product-version-server-name.sql

SELECT
        SERVERPROPERTY('MachineName') AS [ServerName], 
			  SERVERPROPERTY('ServerName') AS [ServerInstanceName], 
        SERVERPROPERTY('InstanceName') AS [Instance], 
        SERVERPROPERTY('Edition') AS [Edition],
        SERVERPROPERTY('ProductVersion') AS [ProductVersion], 
			  Left(@@Version, Charindex('-', @@version) - 2) As VersionName,
			  SERVERPROPERTY('LicenseType') as LicenseType, SERVERPROPERTY('NumLicenses') as NumLicenses