none
Collection query for specific SCCM client version - Parameters? RRS feed

  • Question

  • Good morning,

    I need to upgrade my older clients as I recently upgraded SCCM to SP2.  I can't seem to find the parameters in query builder to populate a collection with a specific SCCM client version.  Can anyone help me out or point me in the right direction?  I can't find anything using "The Google".  You'd think lots of people would want this that there'd be a default query in SCCM already.  Thanks.
    Tuesday, December 1, 2009 1:31 PM

Answers

All replies

  • Never mind.  I think I found it.  Too tired still.
    • Marked as answer by andyjharper Tuesday, December 1, 2009 1:33 PM
    Tuesday, December 1, 2009 1:33 PM
  • Never mind.  I think I found it.  Too tired still.

    Marking that as an answer won't help others who might also find that thread. Could you please add some details?
    Wednesday, December 2, 2009 7:21 AM
    Moderator
  • Here is a query of all clients running sp1 version:

    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_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version = "4.0.6221.1000"


    JonL
    • Proposed as answer by lokjon Thursday, December 3, 2009 9:28 AM
    Thursday, December 3, 2009 9:28 AM
  • Hi,

    The previous didn´t work

    I post query for all clients running SP1 version:

    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 where SMS_R_System.ClientVersion = "4.00.6221.1000"

    This query works.

    AG
    • Proposed as answer by adrian ghelman Tuesday, December 15, 2009 8:52 PM
    Tuesday, December 15, 2009 8:52 PM
  • Try 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_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version = "5.00.7804.1000"

    Monday, April 28, 2014 9:37 AM