List all boards owned by a specific user

[Calvin Senteza]

Is there a way, either within Jira or via a database query, to find all the boards owned by a specific user?

[Kian Stack Mumo Systems · Accepted solution]

select * from AO_60DB71_RAPIDVIEW where owner_user_name = 'USER_NAME';

[Alexey Matveev · Accepted solution]

Hello,

The problem is that if the filter of a board is not shared with you, then you will not see it. 

I always execute sql to get this info.

You can find sql here:

https://community.atlassian.com/t5/Questions/sql-query-to-get-all-board-id-s-srum-kanban-which-are-associated/qaq-p/226611