How to get the YACC app usage details in Bitbucket

This article helps to get the list of projects and repositories where the Yet Another Commit Checker app is used within your Bitbucket instance that is hosted on the Server or Datacentre.


Execute the below SQL query in the database to get the list of projects and repositories:

SELECT as ProjectName, R.slug as RepoSlug FROM sta_repo_hook as H LEFT JOIN repository AS R on H.repository_id = LEFT JOIN project AS P on R.project_id = WHERE H.hook_key = 'com.isroot.stash.plugin.yacc:yaccHook' AND H.is_enabled;

The output result is displayed as follows:



The above workaround is applicable only for Bitbucket Server and Data Center, but not for the Cloud instances.