mgmohiuddin
asked on
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.
tigin44
where do you store your data about computers? what are the data columns that you store?
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.AMTFullVersio
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.AMTFullVersio
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
Copy-existing-query.png
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.