Hi. I have JIRA 6.4, soon to upgrade to 7.6, in test .... I think this works to identify JIRA accounts:
select * from cwd_user where
ID not in (select user_id from cwd_user_attributes where attribute_name = 'login.lastLoginMillis')
and created_date < SYSDATE - 90
and active = 1;
...but am - scratch that - was unsure how to make those accounts inactive.
This was for an Oracle back-end, but I assume it'd work in other platforms.
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG