need an sql query

Posted on 2009-12-31
Last Modified: 2013-11-21
we are in the process of implementing intel vpro using sccm sp1. i need to create a collection of all computers with amt bios version of 3.2.1 and above and another collection of computers with amt bios version less than 3.2.1. in order to create a collection i need an sql query that can be used as a criteria to make the collection i am not an sql guy and need help from sql gurus.

Question by:mgmohiuddin
    LVL 26

    Expert Comment

    where do you store your data about computers? what are the data columns that you store?
    LVL 8

    Expert Comment


    I'm not able to verify it on my SCCM server right now but I belive this should work

    select *  from  SMS_R_System where SMS_R_System.AMTFullVersion = "3.2.1"
    LVL 33

    Expert Comment

    1) go into queries and find a query that works today..,., like All systems..  Edit the query and choose Edit Query and then select Show SQL Query.

    LVL 33

    Expert Comment

    2) Now create new query - give it a name
    3) edit Query -  Show query Language -  Now paste the abve into the Query Statement  (you've just duplicated the working query.

    4) Now customize it for you need...  Click the CRITERIA tab.. and click the STAR (yellow) to add new criteria

    You will want to limit the query to the PC BIOS version.  So select PC Bios version and you will be able to taylor the version number to what you need.

    LVL 33

    Accepted Solution

    5) once you query works the way you want, you can base a collection from the query..

    You don't need to be a SQL expert to do it this way, you can just play around for a while and learn to create the basic queries you want by experimenting through this GUI.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
    This video is a brief demonstration on how to use security groups and Network Access Control Lists (ACLs) in Amazon Web Services.  Security groups and Network ACLs are mechanisms you can use in AWS to control network traffic.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now