Sometimes it is useful to get a list of users exported to CSV for various purposes. JIRA doesn't currently have this functionality but you can leverage various database functionalities to do this.
Run one of the following queries specific to your database. The output will consist of the id, username, first, and last name of the users.
this will not include headers
this will include the headers.