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
SELECT lower_user_name
INTO OUTFILE '/tmp/jirausers.txt'
FROM cwd_user WHERE active=1;
This would create a txt file with a list of all the active user accounts in Jira.
I hope this helps.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.