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.

Instructions

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

SELECT P.name as ProjectName, R.slug as RepoSlug
FROM sta_repo_hook as H
         LEFT JOIN repository AS R on H.repository_id = R.id
         LEFT JOIN project AS P on R.project_id = P.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.