For larger enterprises it's possible to reach the maximum amount of API calls allowed for an account for either GitHub or Bitbucket due to the amount of repositories that are syncing ( 2,000+ ).

This request is for the Jira DVCS connector to be able to identify repositories that haven't been updated at an interval defined by the user ( last commit 3 months ago, 6 months, a year, etc ) and provide an option to unlink all of them.

Workaround

This SQL query will identify all repositories that have not been updated in a year:

select om."HOST_URL", om."NAME", rm."SLUG",rm."LAST_COMMIT_DATE" from "AO_E8B6CC_REPOSITORY_MAPPING" as rm, "AO_E8B6CC_ORGANIZATION_MAPPING" as om where om."ID" = rm."ORGANIZATION_ID" and rm."LAST_COMMIT_DATE" <= now() - interval '1 year';
 

This SQL query will unlink all repositories that have not been updated in a year:

update "AO_E8B6CC_REPOSITORY_MAPPING" set "LINKED" = 'f' where "LAST_COMMIT_DATE" <= now() - interval '1 year';

Notes

• Unlinked repositories can be added back in the user interface at any time.