Query Windows Version

Question

I am putting together a table with server names and their properties such as Number of CPUs, Cores, memory, OS version, etc. I am trying to find an easy way to get the windows OS version number in SSMS. Does anyone know of a query that I can use to return the Windows OS version in SSMS.

Answer 1

This information should be available in the sys.dm_os_windows_info table:

SELECT windows_release
FROM   sys.dm_os_windows_info;