Structure Boards with Inactive Owners

[Jeff Stack]

How can I find all Structure Boards that have an Inactive Owner?  We've recently lost some team members across the enterprise who owned a number of Structure Boards and I would like to find all Structure Boards with Inactive Owners so I can update them.

Thx,
Jeff

[Yulia Barbash _ALM Works_]

Hello @Jeff Stack !

Yulia from ALM Works here!

You can query your DB to get all structures and their owners, matching the user key from the Structure table with the username:

SELECT s."ID", s."C_OWNER", s."C_NAME", ap.lower_user_name FROM "AO_8BAD1B_STRUCTURE" s INNER JOIN app_user ap on ap.user_key = s."C_OWNER"

The easy way is to go to Structure> Manage Structure you can see a column with the owner.

Please let me know if this helps.  I look forward to your feedback.

Best regards
Yulia Barbash

[Jeff Stack]

Thanks Yulia.  The Owner column for Structures does not show an owner as inactive if they no longer have an active account in Jira.

I don't have access to our DB so, unfortunately, I can't query it.