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

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

1 answer

0 votes

you can user active use:

Current User Sessions in Jira

secure/admin/CurrentUsersList.jspa

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

Thanks.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.