/ / SCCM Device Collection - Computer Model

SCCM Device Collection - Computer Model

-
This is an SCCM device collection query to pull in computers of a specific model


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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%7370%"


and you would replace the model with the model of computer you are looking for
Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.
    Blogger Comment

7 comments:

  1. Tom SevingSeptember 12, 2019 at 11:30 AM

    Outstanding, Tom, this is exactly what I needed. Thank you!

    ReplyDelete
  2. william locasJuly 22, 2020 at 5:12 AM

    Hi, Could I grab that snapshot and usage it on my own web log? iphone template

    ReplyDelete
  3. keivi jhonsJuly 23, 2020 at 8:36 AM

    whoah this blog is excellent i love reading your posts. Stay up the good work! You realize, lots of people are looking around for this info, you can help them greatly. iphone mockup

    ReplyDelete
  4. Gerard MartinNovember 2, 2020 at 6:53 AM

    nice bLog! its interesting. thank you for sharing.... home audio video solution

    ReplyDelete
  5. Jason RoyDecember 10, 2020 at 9:19 AM

    If you haven't yet heard of Google Glass, prepare to reconsider what you think a computer is, and prepare to be amazed at what this latest innovation can do. blog de empreendedorismo

    ReplyDelete
  6. AndrewMarch 27, 2021 at 3:39 AM

    Very tech supporting approach you dropped in the effort. The SCCM device collection you delivered was indeed a good support for your users and also for the new users like me. I wanted to read through some reviews on IT support Newmarket. But I was very pleased with what you gifted here.

    ReplyDelete
  7. LoganJuly 24, 2021 at 12:29 AM

    Since there are a larger number of Windows computers sold than some other computers, CPS Test Online

    ReplyDelete

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments ( Atom )