Active users working on JIRA at any time

Is there any sql or script to figure active users working on JIRA instance any time, I mean something like data populated on User Sessions present under System (Admin Console).

Can we also figure out the type of activities these users are performing during that time like (number of users editing issue or creating issues or Viewing Dashboards etc)

Any help you be appreciated as I need information to write performance testing scripts.

Note : My question doesn't mean JIRA active users counted towards License.

1 answer

There is nothing directly available in vanilla JIRA AFAIK. The whoislooking add-on does something similar, but unfortunately the source code is not public :( (this would have been an ideal starting point to build a new add-on). The REST end point can additionally collect the page details to identify the kind of operation being performed.

Another crude method is to parse the security log of JIRA to track the logins, but again, it will only be an approximation.

Thanks Renjith, Do you have any idea like from where User Sessions Data is being getting populated ? (like which Tables or from which files )

Fetching Data from JIRA access logs or using screen scraping methods on User Sessions are my backup options.

Renjith & others,

Command to figure out JIRA active users during any particular hour.....

Can anyone please suggest a better approach or point out any flaws with my below approach....

On Unix Server :

grep "2014:00:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

grep "2014:01:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

grep "2014:02:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

grep "2014:03:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

..... so on......

grep "2014:22:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

grep "2014:23:" access_log.2014-01-12 | awk '{ print $3 }' | sort | uniq | wc -l;

or

grep "12\/Jan\/2014:23:" access_log.2014-01-12 | awk '{ print $3 }' | grep -v "-" | sort | uniq | wc -l; (to be precise)

Thanks,

Sunil Pothireddy

I don't think user sessions are stored in any tables. Only the last login time is being stored in the property tables.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

22,199 views 2 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you