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