Close Menu
    Facebook X (Twitter) Instagram
    Monday, November 3
    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, 8:52 pm1 Min Read Collections 618 Views
    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 05, 12:04 pm

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

    October 15, 11:22 pm

    SCCM Collection for AAD joined devices (co-managed)

    February 05, 11:34 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

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

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