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; } } }

Last login date in Confluence

Nariman Riahi1

Is there a way I can tell the last login date of all users in one screen? I know I can see it by clicking on the user name. I just need to look at 500 users and see who has not logged in for a while.

Thanks

Accepted answers

All comments

Remo Siegwart

I wrote a user macro to display all users and their last successful login date here: https://answers.atlassian.com/questions/33385/macro-that-produces-a-list-of-users-last-login-date

Nariman Riahi1

Thanks for your quick reply. how do I use this ? I only know how to use the existing Macros when I am writing a wiki page.

Remo Siegwart

You need to put the code in a User Macro. Andrew Frayling wrote a great blogpost about this here: http://blog.networkedcollaboration.com/2012/02/11/confluence-last-login-user-macro/

Nariman Riahi1

I did all the steps and get NEVER for all the users. Something is not right. It even shows I never logged in.

Kjell Lauren1

I tried this on 3.5.17 and it only lists ~20 users out of 1500, what might be the problem?

Andrew Frayling

Hi, See a modified version posted in the comments of a post at http://blog.networkedcollaboration.com/2012/02/11/confluence-last-login-user-macro/ and an alternative at https://answers.atlassian.com/questions/33385/macro-that-produces-a-list-of-users-last-login-date?page=1 Crowd and/or external LDAP can affect how the macros return details on users. Hope one of those help? Andrew

Kjell Lauren1

Hi,

Thanks for the links!

The one on http://blog.networkedcollaboration.com/2012/02/11/confluence-last-login-user-macro/ results in 20 users out of 1500 with NEVER as last login date.

The one on https://answers.atlassian.com/questions/37178/last-login-date-in-confluence results in 20 users out of 1500 with the correct date in the last login date.

The ones from https://answers.atlassian.com/questions/33385/macro-that-produces-a-list-of-users-last-login-date?page=1 results in all users but no date for last login. Date for account created is correct.

We are using LDAP, so maybe this could be a problem?

So something strange that I can't figure out...any good hints and suggestions that would make it work? OR how to troubleshoot and fix the problem?

Really need something to ease up the cleaning old users.

///Kjell

Ket Tintinger

If you have access to the repository database, you can use the following query. You can modify the bucket sizes how you wish. We are using LDAP for external authentication, so I needed add the 'EXT_' on the join.

SELECT
case when days_since_last_login = 0 then '0'
when days_since_last_login < 7 then 'Last Week'
when days_since_last_login < 30 then 'Last 30 Days'
when days_since_last_login < 90 then 'Last 90 Days'
when days_since_last_login < 180 then 'Last 180 Days'
when days_since_last_login < 360 then 'Last 360 Days'
when days_since_last_login < 999999 then 'Over 360 Days'
else 'No Login Data' end Last_Login_Grouping
, entity_group
, count(*) User_Qty
FROM
EXTERNAL_ENTITIES exm
LEFT JOIN
(
SELECT
entity_name
, substr(entity_name, 0,3) entity_group
, entity_key
, date_val
, case when date_val IS NULL then 999999 else trunc(sysdate - date_val) end days_since_last_login
, 1 user_qty
FROM
os_propertyentry
WHERE
entity_key = 'confluence.user.last.login.date'
) osp
ON
concat('EXT_', EXM.name) = osp.entity_name
GROUP BY
case when days_since_last_login = 0 then '0'
when days_since_last_login < 7 then 'Last Week'
when days_since_last_login < 30 then 'Last 30 Days'
when days_since_last_login < 90 then 'Last 90 Days'
when days_since_last_login < 180 then 'Last 180 Days'
when days_since_last_login < 360 then 'Last 360 Days'
when days_since_last_login < 999999 then 'Over 360 Days'
else 'No Login Data' end
, entity_group

Nelson Jimenez Manio

Does all the macros mentioned would work in
Confluence v5.8.x ?

Welcome!

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

Quick Links

Find more posts tagged with

confluence