sp_FormatOSName

BEGIN

DECLARE originalOSName VARCHAR(255) DEFAULT '';

DECLARE hyperV VARCHAR(10) DEFAULT '';

DECLARE R2 VARCHAR(5) DEFAULT '';

DECLARE x64 VARCHAR(5) DEFAULT '';

#Add a space to the end of the OS name to help with the matching

set originalOSName = concat(osName, ' ');

#####Check Hyper-V

IF originalOSName LIKE '%Hyper-V%' THEN SET hyperV = ' Hyper-V';

END IF;

#####Check R2

IF originalOSName LIKE '% R2 %' THEN SET R2 = ' R2';

END IF;

#####Check x64

IF originalOSName LIKE '% x64 %' THEN SET x64 = ' x64';

END IF;

CASE 

#Server OSs

WHEN originalOSName LIKE '% 2012 %' THEN SET formattedOSName = CONCAT('Windows', hyperV, ' Server 2012', R2, x64);

WHEN originalOSName LIKE '% 2011 %' THEN SET formattedOSName =  CONCAT('Windows 2011', x64);

WHEN originalOSName LIKE '% 2008 %' THEN SET formattedOSName =  CONCAT('Windows', hyperV, ' Server 2008', R2, x64);

#The next case will cover 'Server 2008 Hyper-V', as the OS returns the value without the '2008'

WHEN originalOSName LIKE '%Hyper-V%' THEN SET formattedOSName =  CONCAT('Windows Hyper-V Server', x64);

WHEN originalOSName LIKE '% 2003 %' THEN SET formattedOSName =  CONCAT('Windows 2003', x64);

#Workstation OSs

WHEN originalOSName LIKE '% 10 %' THEN SET formattedOSName =  CONCAT('Windows 10', x64);

WHEN originalOSName LIKE '%Microsoft Windows Technical Preview%' THEN SET formattedOSName =  CONCAT('Windows 10', x64);

WHEN originalOSName LIKE '% 8.1 %' THEN SET formattedOSName =  CONCAT('Windows 8.1', x64);

WHEN originalOSName LIKE '% 8 %' THEN SET formattedOSName =  CONCAT('Windows 8', x64);

WHEN originalOSName LIKE '%Windows Developer Preview%' THEN SET formattedOSName =  CONCAT('Windows 8', x64);

WHEN originalOSName LIKE '% 7 %' THEN SET formattedOSName =  CONCAT('Windows 7', x64);

WHEN originalOSName LIKE '%Vista%' THEN SET formattedOSName =  CONCAT('Windows Vista', x64);

WHEN originalOSName LIKE '% XP %' THEN SET formattedOSName =  CONCAT('Windows XP', x64);

WHEN originalOSName LIKE '% 2000 %' THEN SET formattedOSName =  'Windows 2000';

WHEN originalOSName LIKE '% NT %' THEN SET formattedOSName =  'Windows NT';

#New Computer

WHEN originalOSName LIKE '%NewComputer%' THEN SET formattedOSName =  '';

#If any string does not match these cases, just return the string

ELSE SET formattedOSName = originalOSName;

END CASE;

END