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

[RichardA]

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 !!

[Rodrigo Nunes]

you can user active use: 

Current User Sessions in Jira

secure/admin/CurrentUsersList.jspa

[RichardA]

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.

[RichardA]

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

Thanks.