My team supports databases on about 75 different servers. I would like to know what OS Version is running on those server. I have done some research and I know I can use the following three methods:
2. master..xp_cmdshell 'netsh diag SHOW os /p'
3. select right(@@version, 44)
are there any other options out there? Option 2 gives me the output I would like, but takes a long time to return the result:
Microsoft(R) Windows(R) Server 2003, Standard Edition
xp_msver and @@version gives me the info, but not quite in the format I would like:
Windows NT 5.2 (Build 3790: Service Pack 1)