does anyone have the SQL to run to set all templates back to the preferred polling method?
Do you mean applications or templates? As far as I know, only applications have fallback mechanism which can switch them to different method...
You can check if this is what you would like to reset:
SELECT * FROM APM_ApplicationSetting WHERE [Key] = 'CounterFetchingMethod'
And then reset simply by:
DELETE FROM APM_ApplicationSetting WHERE [Key] = 'CounterFetchingMethod'
Making database backup before such changes is always good idea.
Thank you that was it