locked
Create a query for Windows Server 2008 System. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am new to sccm 2007. Sccm 2007 has some preconfigured queries for Windows Xp, Windows Server 2003, etc. I would like to create my own queries for Windows Vista and Windows 2008. However, to my supprise, both Vista and Windows 2008 has the same OS version: 6.0.6001. I don't know how to create queries to show Windows Vista and Windows Server 2008. I create a query for OS Version 6.0.6001 and query shows all of my Vista systems.
    My questions is what are the proper query statements (other than OS Version) to properly display Windows Vista and Windows Server 2008.
    Thanks.  Stephen
    Wednesday, March 4, 2009 2:50 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    For this, I use the "Operating System - Caption" attribute. You could build an expression for CAPTION LIKE '%2008%'. The exact query looks like this:

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%2008%"

    -joe c
    Wednesday, March 4, 2009 4:15 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
     Possibility #1: Using http://myitforum.com/cs2/blogs/skissinger/archive/2008/09/27/win32-servercomponent-what-is-it.aspx, edit (on your primary sites) inboxes\clifiles.src\hinv, the sms_def.mof contained in that folder per the link above.

    When your Server08 boxes next run a Hardware Inventory, they'll report a new class (create a new view, called v_gs_server_feature).  You could use that view to differentiate a server from a workstation.

    Possibility #2:  Check the view for ComputerSystem.  If you have a column for DomainRole, that might also work.  (see http://msdn.microsoft.com/en-us/library/aa394102(VS.85).aspx, the domain role area where the values of 2, 3, 4, or 5 are server types.

    If you don't have DomainRole available.. go into sms_def.mof, find the win32_computerSystem area, find DomainRole.  It's likely FALSE.  Change it to TRUE, wait for your hardware inventory cycles to complete enterprise-wide; and you'll have that data then.
    Standardize. Simplify. Automate.
    Wednesday, March 4, 2009 3:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    For this, I use the "Operating System - Caption" attribute. You could build an expression for CAPTION LIKE '%2008%'. The exact query looks like this:

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%2008%"

    -joe c
    Wednesday, March 4, 2009 4:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Joe. Using Caption fixed the problem. OS Version 6.0 will result both Vista and Windows Server 2008. Using captions can display Vista and Windows Server 2008 separately.
    Thanks again.
    Wednesday, March 4, 2009 6:42 PM