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

0 vote
Renjith Pillai Community Champion Jan 07, 2014

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

Renjith Pillai Community Champion Jan 25, 2014

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,268 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot