How can get a report of old/unused user accounts

Pedro Colon August 13, 2012

How can get a report of old/unused user accounts

2 answers

0 votes
David Chan
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 13, 2012

Similar to what Nik mentioned, it may be easier to go through the database

Something like this would give you a list of usernames and their user login attributes:

select u.user_name,a.* from cwd_user_attributes a join cwd_user u on a.user_id=u.id where a.attribute_name = 'lastAuthenticated';

You should also notice that there's an attribute for last login time (in milliseconds). The value is stored in Unix Time, so you'll need to translate it to human readable.

edit: it should be noted that this would of course just be for standalone and EAR/WAR instances of JIRA

Pedro Colon August 13, 2012

Lets say I wanted to run a report or a query to see all users that had logged in, in the last 45 days, how would I go about it?

0 votes
NikE
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 13, 2012

There is no way to generate a report in OnDemand that will show you this information, however you can access the last time (and how many times) the user has logged in from the users page under administration...you can then begin disabling the old accounts right there.

Suggest an answer

Log in or Sign up to answer