In the following article is descripted how to find the last Login for users.
But this somhow hase an error. When i open in Confluence (5.9.12) then there are three Dates showed:
Created, Last Updated, Last Login.
With the query shown with cwd_user_attribute.attribute_name = 'lastAuthenticated' there is displayed the 'Last Updated'-Date and not the last Login-Date.
When is this field updated and whats the meaning of 'Last Updated'?
Thanks for any help.
The query I am using for this purpose doesn't look like any of the ones in that example but does seem to present consistent data that I would find on a random sampling of users. Give this one a try. If you also happen to have more than one user directory configured, it will give you that as well.
SELECT u.user_name, d.directory_name, l.successdate FROM logininfo l JOIN user_mapping m ON m.user_key = l.username JOIN cwd_user u ON m.username = u.user_name JOIN cwd_directory d ON u.directory_id = d.id ORDER BY directory_name, successdate;
Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot