Query all Core 2 due computers

All Replies

• Tuesday, October 20, 2009 4:43 PMMatthew Hudson [MVP]MVP, Moderator

   
  

  1

  Sign In to Vote
  Like this collection:
  
  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_PROCESSOR on SMS_G_System_PROCESSOR.ResourceId = SMS_R_System.ResourceId where SMS_G_System_PROCESSOR.Name Like  "%Intel(R) Core(TM)2 Duo%"
  
  
  

  ---

  http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

  • Proposed As Answer bySherry KissingerMVP, ModeratorTuesday, October 20, 2009 5:28 PM
  • Marked As Answer byKaspars_ Wednesday, October 21, 2009 5:08 AM
  •  
  • Reply
  • Quote

   
• Wednesday, October 21, 2009 5:08 AMKaspars_

   
  

  0

  Sign In to Vote
  My mistake was that I did not use "%".
  
  Thanks
  • Reply
  • Quote