[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

need an sql query

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.

  • 3
1 Solution
where do you store your data about computers? what are the data columns that you store?

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"
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.

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.

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.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now