Close Menu
    Facebook X (Twitter) Instagram
    Thursday, October 22
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»Collections for Windows 7 and Server 2008 OS

    Collections for Windows 7 and Server 2008 OS

    Eswar KonetiBy Eswar KonetiAugust 10, 20101 Min Read Collections
    Share
    Facebook Twitter LinkedIn Reddit

    By default in SCCM,you do not have separate collections for Windows 7 or server 2008 OS as like you have in Windows XP and server 2003.You can create a query based collection using the following method/ query.

    collection for windows 7:

    Right click on collections and say new collection ,go to query based collection and paste the below syntax.

    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 OperatingSystemNameandVersion like "%Workstation 6.1%"

    collection for Windows server 2008 or server 2008 R2:

     

    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 OperatingSystemNameandVersion like "%Server 6.0%"

    If you looking for server 2008 R2 ,the version will be server 6.1.Replace this in above criteria to get all computers listed.

    A picture shown below using the Criteria based if you want to do it.

    OS 7

    Collections
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM report list collections with no deployments

    December 5, 2022

    Investigating SCCM Client Policy Request and Communication Status with a Collection Specific Report

    October 15, 2022

    SCCM Collection for AAD joined devices (co-managed)

    February 5, 2021
    Leave A Reply Cancel Reply

    Support

    Awards

    Archives
    • Home

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.