Invoke-CMWmiQuery

Invoke-CMWmiQuery
    [-Query] <String>
    [-Context <Hashtable>]
    [-Option <QueryOptions>]
    [-DisableWildcardHandling]
    [-ForceWildcardHandling]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Invoke-CMWmiQuery
    -ClassName <String>
    -Search <SmsProviderSearch>
    [-Context <Hashtable>]
    [-Option <QueryOptions>]
    [-DisableWildcardHandling]
    [-ForceWildcardHandling]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

The Invoke-CMWmiQuery cmdlet runs a Windows Management Instrumentation (WMI) query. Unlike other query cmdlets or tools, with this cmdlet the connection and namespace is already set up for you.

You can also use this cmdlet to create a query with WMI Query Language (WQL). Configuration Manager uses WQL for queries in collections. WQL is similar to SQL, but still uses the SMS Provider, thus abides by role-based access controls.

The first command creates a WQL query and stores it in the $WQL variable. The second command runs the query stored in the variable.

$WQL = @"
SELECT app.* FROM SMS_ApplicationLatest AS app
INNER JOIN SMS_CIContentPackage AS con ON app.CI_ID=con.CI_ID
INNER JOIN SMS_DistributionPoint AS srv ON con.PackageID=srv.PackageID
WHERE app.IsHidden = 0
"@

Invoke-CMWmiQuery -Query $WQL -Option Lazy

The first command creates a search object and stores the object in the $Search variable.

The second command specifies that the search order is ascending by CollectionID.

The third command adds search parameters to the $Search object. In this case, the query searches for device collections.

The last command runs the query stored in $Search. It specifies SMS_Collection as the class that contains the CollectionID property.

$Search = [Microsoft.ConfigurationManagement.PowerShell.Provider.SmsProviderSearch]::new()
$Search.AddOrder("CollectionID", [Microsoft.ConfigurationManagement.PowerShell.Provider.SearchParameterOrderBy]::Asc)
$Search.Add("Name","DeviceCol*", $True)

Invoke-CMWmiQuery -Search $Search -ClassName "SMS_Collection" -Option Lazy

The first command clears the search parameters from any existing search object.

The second command adds search parameters to the $Search object. In this case, the query searches for sites.

The last command runs the query stored in $Search. It specifies SMS_Site as the class that contains the site Status property.

$Search.Clear()
$Search.Add("Status", $True)

Invoke-CMWmiQuery -ClassName "SMS_Site" -Search $Search

The first command clears the search parameters from any existing search object.

The second command adds search parameters to the $Search object. In this case, the query searches for sites.

The last command runs the query stored in $Search. It specifies SMS_Site as the class that contains the SiteName property.

$Search.Clear()
$Search.Add("SiteName", $null, [Microsoft.ConfigurationManagement.PowerShell.Provider.SearchParameterOperator]::NotEquals)

Invoke-CMWmiQuery -ClassName "SMS_Site" -Search $Search

The first command clears the search parameters from any existing search object.

The second command adds search parameters to the $Search object. In this case, the query searches for applications.

The last command runs the query stored in $Search. It specifies SMS_Application as the class that contains the site CI_ID property.

$Search.Clear()
$Search.AddAdhoc("CI_ID > 0")

Invoke-CMWmiQuery -ClassName "SMS_Application" -Search $Search -Option Lazy

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.