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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

196 views 3 0
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