nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List users with initial password

andrea schneider

Is there a way to get a list of users who have never changed their initial password? It can also be a database query. Would be for Jira server on Version 6.4.11.

Thanks...

Accepted answers

Nir Haimov

One way that i think of.

By SQL,

Find all users with attribute "login.count", will give you all users that ever logged in.

SELECT * FROM public.cwd_user_attributes
WHERE attribute_name = 'login.count'

No get all users from

select * from cwd_user

Now, remove all users with attribute "login.count" from the list of all users, you will get a list of all users that never logged in, which means, they never changed they initial password (changing the initial password is when you first time log in)

All comments

Nir Haimov

One way that i think of.

By SQL,

Find all users with attribute "login.count", will give you all users that ever logged in.

SELECT * FROM public.cwd_user_attributes
WHERE attribute_name = 'login.count'

No get all users from

select * from cwd_user

andrea schneider

Hi Nir

Thanks for you reply. The problem is, the users aren't forced to change their password on first login, so this wouldn't work.

Nir Haimov

Than do the same with attribute "passwordLastChanged" instead of "login.count"

and you will get all users who have changed they password (at list one time in their life).

remove this list from all users you will get all users who never changed their password

andrea schneider

Hi Nir

This makes more sense - perfect - thanks a lot!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server