Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136

    Unanswered: How to get the OS Version

    Hey guys,
    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:
    1. master..xp_msver
    or
    2. master..xp_cmdshell 'netsh diag SHOW os /p'
    or
    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:
    i.e.
    Microsoft(R) Windows(R) Server 2003, Standard Edition
    5.2.3790

    xp_msver and @@version gives me the info, but not quite in the format I would like:
    5.2 (3790)
    and
    Windows NT 5.2 (Build 3790: Service Pack 1)

    Are there any other options out there?

    Thanks,
    Reghardt

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is this a one time gathering of statistics, or an ongoing thing/ If you have SMS on your network, you can query some of their views much more effectively.

  3. #3
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    It will be an ongoing thing, and yes we do have SMS. Thanks for the advice I have to remember to sometimes think outside the box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •