The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

DB query of the last login in jira independent of Confluence?

Timo
September 13, 2020

Hi,

I'm trying to find out how to get the last login for all users in jira. On the following page:

https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

this is explained very well. The problem is that our jira is connected to confluence and crowd. Accordingly, the last login that is displayed to me as the result is falsified (confluence last logins are considered last logins in the query of the jira db)

Does anyone have any idea how I can output a user last login independently of confluence?

Thanks for help.

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Michael March
Contributor
September 13, 2020

You might want to re-verify this on your end.

If you are using Crowd as your you use directory for Jira and Confluence, Confluence logins should no impact the results of that query you linked to.

Timo
September 14, 2020

Hi Michael, thanks for your answer. 

That's exactly the problem I'm asking about. The special thing about our instances is that we not only use the directory via crowd but also have a direct connection from jira via the AD. I checked the last logins through live testing and have definitely been corrupted by confluence.

Michael March
Contributor
September 14, 2020

Is the AD directory 'higher' than the Crowd dir?

Timo
September 14, 2020

At the first is the crowd directory, then the AD.