Is it possible to find a list of the currently logged in users? I've seen some SQL that use the cwd_user_attributes table - but this seems to return bad data (it shows users as having logged in today when I know they have never logged in)
I've also seen a suggestion of using the atlassian-jira-user-logging.log, but this is also time consuming.
I mostly want this to see how active the system is at certain times of the day, and also so I can find the optimum time to do restarts and reindexes etc.
I, too, want to know the best time for maintenance. I haven't found any reference to atlassian-jira-user-logging.log. I'm using splunk so this may be a workable solultion for me. Can you point me to where you saw this referenced? And if you have any other solutions I'd love to hear them. THanks.
Thanks for pointing to this!! Very handy. I noticed a few "Not Available" under the "Session Id" and "User" columns in my list. They have IP Addresses and all the rest of the column for those entries (Last Accessed and Session Creation, for instance) have actual data, so I'm not sure why the Session Id and User info would be "Not Available".
Are these possibly some scheduled sessions that occur as part of some built-in process? I'm just asking because I want to make sure these aren't some sort of hacking attempt. I plan on checking the IP Addresses listed with my CTS folks, but thought I should check here for a rational explanation.
Thanks again for the tip!!
It's been 4 years since this post, and several full revisions later. I have the same question, and it is a security issue to have to log into the server every time I need to check current user count. Has anyone provided a web interface solution to this question ?
Again, this issue appears to have no clear solution built-in to JIRA. The answer to this question (as with many others) appears to be: BYOF (Bring Your Own Fix)
@Rahulmentions that you could look at the user sessions, but this doesn't help you identify which users have simply left work for the day with the browser window open on your JIRA instance.
The best way I've found to be sure of activity is to look at the access_log file (which may be what @DI2E was hinting at) , because it will show the individual requests and their time. This makes it possible to see how many people are actually active in the system.
I enabled logging of http events. (https://confluence.atlassian.com/display/JIRA061/Logging+and+Profiling) If you have splunk, extracting activity from atlassian-jira-http-access.log is very straightforward. Even without splunk, it can't be that difficult. If your http access drops to nothing, then you have your answer.
At least that's my current plan to answer the same question you have re. maintenance windows.
Hope this helps.
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