SQL query to get number of users logged on particular time interval in jira

Question

Hi Team, We need information to get number of users logged on particular time interval in jira application.

for example today 27-09-2021 from 9am to 10am.

we are using Oracle DB.

Pls suggest

Thanks !!

RichardA_iqxvt3 · Answer

Hi @Rodrigo Nunes : Is there any way to find the user statistics(how many users logged in) on last December 2022?

Thanks.

RichardA_iqxvt3 · Answer

Hi @Rodrigo Nunes Thanks for the update.

I wanted to update this information into confluence page so, can you pls suggest how to update.

Thanks.

Rodrigo Nunes_dfk3qy · Answer

you can user active use:

Current User Sessions in Jira

secure/admin/CurrentUsersList.jspa