---
title: "How to get the YACC app usage details in Bitbucket"
canonical: "https://support.appfire.com/space/SUPPORT/152797885/How%20to%20get%20the%20YACC%20app%20usage%20details%20in%20Bitbucket"
format: markdown
---
This article helps to get the list of projects and repositories where the [Yet Another Commit Checker](https://marketplace.atlassian.com/apps/1211854/yet-another-commit-checker?hosting=server&tab=overview) 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:

```sql
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:

![image](media://e2bbfa32-8860-444b-947c-867b7652c759)

 


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