Jira V7.1.6 How to export the following user data ( Username, Full Name, Login Detail, Proyect with roles for user) to a Microsoft Office Excel? - What would be the query in Database (PostGres 9.5.3)?

[Nic Brough -Adaptavist- · Accepted solution]

For most of the user information, you'll need to read cwd_user.  For their groups, read cwd_membership.  Then for their roles, read projectroleactor, remembering that their groups could also be used in roles.

Why do you want to do this though?  It's probably a dreadfully complex way to achieve what you're trying to do.