
To use these queries, select Show Query Language in the Query Statement Properties dialog box.

This section contains example WQL queries that you can use in your hierarchy or modify for other purposes. The new query appears on the Queries node in the Monitoring workspace. Review the information about the query to be imported and then complete the wizard. On the MOF File Name page of the Import Objects Wizard, select Browse to select the Managed Object Format (MOF) file that contains the query that you want to import. On the Home tab, in the Create group, select Import Objects. In the Monitoring workspace, select Queries.
#Program rejected invalid policy sccm how to
For information about how to export queries, see How to manage queries. Use this procedure to import a query into Configuration Manager. The new query appears in the Queries node in the Monitoring workspace. On the General tab of the Create Query Wizard, specify that the results of the query aren't limited to the members of a collection, that they are limited to the members of a specified collection, or that a prompt for a collection appears each time the query is run.Ĭomplete the wizard to create the query. Select OK to close the Statement Properties dialog box. Always used by joins that are created automatically.ĭisplays all results for the base attribute and only the matching results for the join attribute.ĭisplays all results for the join attribute and only the matching results for the base attribute.ĭisplays all results for both the base attribute and the join attribute.įor more information about how to use join operations, see the SQL Server documentation. Configuration Manager supports these attribute classes: Join typeĭisplays only matching results. Although Configuration Manager automatically creates query joins when you choose different attributes for your query result, the Joins tab provides more advanced options. On the Joins tab of the Statement Properties dialog box, you can combine data from two different attributes into your query results. If you create a query that contains no criteria, the query will return all devices in the All Systems collection. You can configure multiple criteria for a query.
#Program rejected invalid policy sccm code
For example, you could return only resources that have a site code of XYZ. On the Criteria tab of the Statement Properties dialog box, specify criteria that are used to refine the results of the query. Select Stop if you want to stop a long running query. In the Query Statement Properties, select the green triangle to show the Query Results Preview window.

Use this procedure to create a query in Configuration Manager.

This article describes how to create and import queries in Configuration Manager. Applies to: Configuration Manager (current branch)
