---
title: "Check Agile Poker usage in Jira Server"
canonical: "https://support.appfire.com/space/SUPPORT/1522532353/Check%20Agile%20Poker%20usage%20in%20Jira%20Server"
format: markdown
---
Before migrating Agile Poker from Jira Server to Jira Cloud, it’s helpful to review app usage. This allows you to assess adoption, identify active boards, and better plan your migration.

This page shows how to check the Agile Poker app data usage in the Jira Server.

## Option 1: Use Atlassian’s App Usage extension

Atlassian provides the App Usage for Jira extension, which shows who used Agile Poker, how often the app was used, and which entry points were accessed.

You can learn more in [Atlassian’s guide](https://confluence.atlassian.com/adminjiraserver/monitor-your-apps-with-app-usage-1217301309.html).

## Option 2: Run SQL queries on the Jira database

For more detailed insights, you can execute SQL queries directly in the Jira database. You can refer to these examples:

### Sessions per board

```
SELECT BOARD_ID, COUNT(*) AS NumberOfItems
FROM AO_62850F_SESSION
GROUP BY BOARD_ID;
```

This will return all boards that have at least one session created and the number of sessions per board.

### Total boards with sessions

```
SELECT COUNT(DISTINCT BOARD_ID) AS NumberOfBoardsWithItems
FROM AO_62850F_SESSION;
```

This will return the total number of boards with at least one session created.

### Issues with votes

```
SELECT COUNT(DISTINCT ISSUE_ID) AS NumberOfIssuesWithVotes
FROM AO_62850F_ISSUE_VOTE;
```

This will return number of issues in whole instance with at least one vote in any session.