---
title: "Identify Flow Board app macro usage with a SQL query"
canonical: "https://support.appfire.com/space/SUPPORT/1310163073/Identify%20Flow%20Board%20app%20macro%20usage%20with%20a%20SQL%20query"
format: markdown
---
This document provides a SQL query to identify macro usage for the Flow Board app.

## Instructions

To find a list of pages, or the count of pages, where the Flow Board macros are used, you can:

- Select :cog-icon:*  >  ****Administration **** >  ****Macro usage*** to navigate to the Macro usage page.
- Use Confluence Advanced Search to find pages where a particular macro is used.
- Run SQL queries, like the one listed below, in your Confluence database to find macro app usage:

```
SELECT CONTENT.contentid, CONTENT.contenttype, CONTENT.title, CONTENT.spaceid
FROM CONTENT
JOIN BODYCONTENT ON CONTENT.contentid = BODYCONTENT.contentid
WHERE PREVVER IS NULL
  AND (CONTENT.contenttype = 'PAGE' OR CONTENT.contenttype = 'BLOGPOST')
  AND BODYCONTENT.body LIKE '%<ac:structured-macro ac:name="flow-board"%';
```


A sample result from the query above is displayed below.

![image](media://8b8c4b2e-992e-48cb-bdf0-47cdec445fe4)