1. After you register to the Community Forums, please check your Inbox/Spam folder for email verification message. If you are still unable to receive the verification email, contact me here - https://prajwaldesai.com/contact-me/
    Dismiss Notice
  2. Post your questions in the correct category. Do not post/add a different question under already posted thread. For troubleshooting purpose, attach the relevant log files, screenshots etc.
    Dismiss Notice

SOLVED SCCM device collection query for windows 8.1

Discussion in 'System Center Configuration Manager' started by Dineshyadav, Mar 23, 2015.

Thread Status:
Not open for further replies.
  1. Dineshyadav

    Dineshyadav Active Member

    Joined:
    Mar 23, 2015
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Hi, I have grouped Windows 7 computers into a collection using a query. Can anyone tell me SCCM device collection query for windows 8.1 ?.
     
  2. Prajwal Desai

    Prajwal Desai Well-Known Member

    Joined:
    Mar 18, 2015
    Messages:
    1,943
    Likes Received:
    84
    Trophy Points:
    48
    Hi Dinesh,

    You can use the following query to create a collection of Windows 8.1 computers –
    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.OperatingSystemNameandVersion like “Microsoft Windows NT Workstation 6.3%

    Try this and let me know if it doesn't work.
     
    RajivH likes this.
  3. Dineshyadav

    Dineshyadav Active Member

    Joined:
    Mar 23, 2015
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Thanks Prajwal. I will try the query and will let you know if it doesn't work.
     
  4. Dineshyadav

    Dineshyadav Active Member

    Joined:
    Mar 23, 2015
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Hi, the collection query worked fine. Thanks.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

  • About Us

    Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.
  • Quick Navigation

  • Like us on Facebook

  • Donate to Us

    The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. Care to donate us? We'd really appreciate it!

    Donate to us!