This script will use your Configuration Manager Powershell module to search out and change the refresh type on collections that do not have queries so that they are Manually refreshed only.
Credits:
- Authored by Chris Kibble (www.ChristopherKibble.com)
With Assistance From: