Is there a way to create a printable list of all the users in my JIRA database? There are a number of users that have left the company and I want to do cleanup.
thanks.
Eric Sebian
Easiest way IMHO go to database backend fire a sql query take the results in csv and print.
yes mysql database in your case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is the DB you are refering to the "jiradb"? that I created in mysql. (may be different for you)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
CWD_USER more details here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks. I'll try to figure it out and only bug you if I get stuck. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok. I'm back. I tried to do a select on the table CWD_USER but there was nothing in there. Though I did find user data in userbase. Is that a valid table?
select * from userbase;
Also, is this the best way to get my list in printable form?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what version of jira you are running ? Not sure about the best way but that's the easiest and fastest way IMHO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looking at this article it seems to be best way as well
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I thought so for jira 4.2 please refer this article
SELECT u.id, u.username, ps.propertyvalue INTO OUTFILE '/path/to/userlist.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM userbase u JOIN propertyentry pe ON pe.entity_id = u.id JOIN propertystring ps ON ps.id = pe.id WHERE property_key = 'fullName' ORDER BY propertyvalue ASC;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.