• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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.

0
mgmohiuddin
Asked:
mgmohiuddin
  • 3
1 Solution
 
tigin44Commented:
where do you store your data about computers? what are the data columns that you store?
0
 
U_ManssonCommented:
Hi

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"
0
 
NJComputerNetworksCommented:
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.


Copy-existing-query.png
0
 
NJComputerNetworksCommented:
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.



bois-query.png
0
 
NJComputerNetworksCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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