Summary

Repository polling is set per build.  Here is how to find all builds that poll the repository.

Environment

Bamboo 7 and 8

Solution

To find all of the builds with polling, here is the SQL:

SELECT build_definition_id,
       buildkey,
       title,
       full_key
FROM   build_definition bd
       JOIN build b
         ON bd.build_id = b.build_id
WHERE  bd.xml_definition_data LIKE
       '%com.atlassian.bamboo.triggers.atlassian-bamboo-triggers:poll%';

Each build will need to be visited to migrate away from polling.  To do this take full_key and put it in this url to go right to the build.

<BASEURL>/browse/<full_key>

Or use Modifying multiple plans in bulk to change to Manual.