SCCM Windows 7 collection query


Aşağıdaki Query ile SCCM üzerinde bulunan Windows 7 clientlarınızı collection oluşturarak gruplayabilirsiniz..

[cc lang=’powershell’ ]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 “Microsoft Windows 7%”[/cc]


  1. cheap windows 7 key

    My family always say that I am killing my time here at net, however I know I am getting experience daily by reading
    thes good content.

  2. Irene

    Hi Dude,This is really iensrnetitg take on the concept. I never thought of it that way. I came across this site recently which I think it will be a great use of new ideas and informations about Microsoft system center.Thank you for sharing it with us.Keep up the great work!


Leave a Comment

Your email address will not be published. Required fields are marked *