Query to find content with “enable for on-demand distribution” option set

If you need to determine which of your ConfigMgr packages, applications or update deployment packages has the “enable for on-demand distribution” option enabled, this query will help.  Run it in SQL studio against the ConfigMgr database.  You can adjust the where statement to also look for other configuration settings, like where the persist in cache…

0

Mass delete management packs

You can individually delete MPs from the SCOM console or you can delete multiples via Powershell with this command.  Replace msdtc in my example with the name/partial name of the MPs you want to mass delete. get-scommanagementpack | ?{ $_.name -match “msdtc” } | remove-scommanagementpack

0