As a Configuration Manager (SCCM or MEMCM) administrator, you likely know the importance of managing and organizing queries within your environment. These queries are used to gather information about devices, software, and other components within your environment, making them essential for tracking and managing your infrastructure. However, managing these queries can be time-consuming and repetitive, especially when working with many queries. This is where automation comes in.
In this blog post, we’ll look at how you can automate exporting and importing SCCM queries using PowerShell scripts. The two scripts provided below will make it easy for you to backup and restore your Configuration Manager queries, which can be useful for migrating queries between SCCM environments or for keeping a backup of the queries for future reference.
Unleash the Power of Azure Arc for Servers
Export Queries using PowerShell
#Get all queries from the Cofiguration Manager
$Queries = Get-CMQuery
foreach($Query in $Queries){
Write-Output -InputObject "Exporting $($Query.Name)"
#Export all the queries
Export-CMQuery -Name $Query.Name -ExportFilePath "C:\TEMP\$($Query.Name).mof"
}
Import Queries using PowerShell
#Get all queries from the C:\TEMP folder
$SavedQueries = Get-ChildItem -Path "C:\TEMP"
foreach($SavedQuery in $SavedQueries){
Write-Output -InputObject "Importing $($SavedQuery.FullName)"
#Import all the query
Import-CMQuery -ImportFilePath $SavedQuery.FullName
}
