how to make a text file for jira users from mysql jiradb database?

Mahendar_45vewy

pls help me out from this i am new to this .i got no of active users but do not know how to make a file in with this users. 

Andy Heinzer

Hi Mahendar,

What utility or tool are you using in order to query your mysql database?  I understand you're looking to create a file with your users listed in it.  The steps to do this will be different among the different tools, such as MySQL Workbench, or possibly mysqldump.

There is some built in support for doing this with MySQL.  If you are just looking for a list of the usernames, you could run a query such as

<span>SELECT</span><span> lower_user_name</span> 
<span>INTO</span><span> OUTFILE </span><span>'/tmp/jirausers.txt'<br>FROM cwd_user WHERE active=1;</span>

This would create a txt file with a list of all the active user accounts in Jira.

I hope this helps.

Andy