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,
    Right(@@Version, len(@@Version) - Charindex('on', @@version) -6) as OperatingSystem;