Can you please tell me which table contains Confluence users' login information?

[Diana Mendoza]

I would like to know which users have accessed Confluence within the past 30 days. Which tables can I use?

Thank you!

[Steven Behnke · Accepted solution]

This KB article should help: https://confluence.atlassian.com/confkb/how-to-identify-inactive-users-in-confluence-214335880.html

[Diana Mendoza]

Thank you very much, these queries worked great!

[Steven Behnke]

Happy to help out

[Fabienne Gerhard · Accepted solution]

Hi @Diana Mendoza

you can use a user macro as mentioned here.
Creates a table, sorted by groups and their last login date.

Have a look on the problem mentioned by Doods Perea who got help with a users that haven't logged in for the last 30 days.
You may only change the if-clause.

Hope that helps.

[Diana Mendoza]

Thank you very much!