Eswar Koneti's Blog

All about Configmgr and its connected objects…….

  • About Author
      View eswar koneti's LinkedIn profile
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 99 other subscribers

  • Awards


  • FaceBook Updates

  • Catagories

  • Meta

  • Copyright!

    All the blog posts in this website are owned by Eswar Koneti and may not be reused in any mode without prior approval of Eswar Koneti. You may quote one paragraph from the blog posts if you link to the original blog post.
    Happy Reading!

SCCM collection for Windows 7 Computers with 64 Bit OS

Posted by Eswar Koneti on May 17th, 2011

Create New SCCM collection and paste the below query into it.

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%" and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC"

Also need report :look at here http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx

2 Responses to “SCCM collection for Windows 7 Computers with 64 Bit OS”

  1. SCCM 2007 R2 – Создаем коллекции компьютеров 32-bit/64-bit « ИТ Блог Алексея Максимова Says:

    [...] Eswar Koneti’s Blog – SCCM collection for Windows 7 Computers with 64 Bit OS [...]

  2. Охрана » Blog Archive » SCCM 2007 R2 – Создаем коллекции компьютеров 32-bit/64-bit Says:

    [...] Eswar Koneti’s Blog – SCCM collection for Windows 7 Computers with 64 Bit OS [...]

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>