Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Uploading statistics on user authorizations


Previously, at our Confluence booth, users worked through local accounts, and now we are switching to Active Directory accounts. Is it possible to somehow download statistics on user authorizations from local accounts (Internal directory), for example, for the last 2-3 months. Ie need to determine which users used local accounts and get a list of these users?

1 answer

@Дмитрий Пересекин 




you could query the database to get the last login data for your users.

The sql statements listed at

should give you an idea, you might want to tweak them and add the directory_id for your local directory in addition.


Let me know if that helps




Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence Cloud

Please tell us how you use Confluence space settings

Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with impro...

274 views 8 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you