Access Keys:
Skip to content (Access Key - 0)

SCCM - Creating Queries

Queries are used to find a group of computers based on a set of criteria.

Build a Query

Queries can be built using the dropdown menus in the SCCM Administrative Console or by directly editing the raw WQL code. The easiest mode is to create a query via the dropdown menus. You may come across raw SQL queries while searching the web and you can paste the SQL into the WQL (SQL for WMI) box.

  1. In the SCCM Administrative Console go to Monitoring and click Queries.

  2. Right-click Queries and and select Create Query.

  3. Give you query a name, choose to a collection to limit your query, and then click Edit Query Statement...
  4. Click the Criteria tab and then click the yellow star which will open up the Criterion Properties window.

  5. Click the Select... button.

  6. You need to choose an Attribute class and Attribute.

  7. Select an Operator. Then choose a value by clicking the Value... button and select a value from the list. If you already know the value, you can manually enter it. Click the OK button and now you'll see your query with a criterion added.

    You need to add an attribute to display for your query. Typically this is the computer name. Click the General Tab and then click the yellow starburst. Select the Attribute class - System Resource and the Attribute - NetBIOS Name.

  8. You may also want to add other columns, such as the software name you are querying, the version, etc. Click OK and choose to sort Ascending.
  9. Click OK twice and you'll be back at the Create Query Wizard. Click Next> and you'll see a summary showing the WQL code. Click Next> and then Close.
  10. Run your query by double-clicking the query from the query list. You'll a see a list of computers that fit the criteria that you specified.

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

April 28, 2016

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
sccm sccm Delete
endpoint endpoint Delete
management management Delete
query query Delete
queries queries Delete
c-sccm c-sccm Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki