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
Subscribe to:
Post Comments
(
Atom
)
Category
- Active Directory ( 4 )
- App Packaging ( 6 )
- BitLocker ( 9 )
- CrashPlan ( 7 )
- DNS ( 1 )
- DocLink ( 2 )
- Excel ( 2 )
- Exchange ( 4 )
- Group Policy ( 2 )
- Javascript ( 1 )
- OneNote ( 1 )
- Power BI ( 4 )
- PowerShell ( 30 )
- SCCM ( 21 )
- SCCM Device Collections ( 10 )
- SCCM Reports ( 12 )
- SCCM User Collection ( 2 )
- SCSM ( 2 )
- SharePoint ( 42 )
- SharePoint Design ( 19 )
- Skype for Business ( 1 )
- SQL Server ( 3 )
- SSL Certificates ( 3 )
- Teams ( 1 )
- Windows 10 ( 3 )
- Windows 7 ( 4 )
- Windows Server ( 5 )

Outstanding, Tom, this is exactly what I needed. Thank you!
ReplyDeleteHi, Could I grab that snapshot and usage it on my own web log? iphone template
ReplyDeletewhoah 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
ReplyDeletenice bLog! its interesting. thank you for sharing.... home audio video solution
ReplyDeleteIf 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