Uploading statistics on user authorizations

Question

Hello!

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?

Kurt Klinner · Answer

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

Hello

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

The sql statements listed at

https://confluence.atlassian.com/confkb/how-to-identify-inactive-users-in-confluence-214335880.html

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

Cheers

Kurt