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

[Mahendar Daripalli]

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. 

[Tinker Fadoua]

@Mahendar Daripalli

Can you please elaborate little bit more about the issue you are having so that we can assist you?

Best,

[Mahendar Daripalli]

Thank you for responding.

@Tinker Fadoua

here am using mysql databse for jira software. but i want to take out one text file or CSV for how many users are active in jira and conf but am not able to do this.

from Shell am getting the users details but not able dump one csv file.

so pls give me one mysql query for user text file.

to filter ou user am using this query.

  
>>type: SELECT * FROM cwd_user; // all users will display //

>>type: Select * from cwd_user where active = '1' ; // only active users will dispaly//

but needed one query to make one csv or text file on shell terminal.

[Tinker Fadoua]

Hi @Mahendar Daripalli

Please click here so that you can see the query to provide you a list of active users.

Once you get the result, you only can do a copy/paste, I don't think there is a way to import it as a CSV file.

Best,

[Mahendar Daripalli]

i want to save the results from shell side how to do after applying the querys

[Tinker Fadoua]

@Mahendar DaripalliI do a copy and paste to an Excel Sheet as my convenient option.