Active users working on JIRA at any time

[Sunil Pothireddy [Intel]]

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.

[Renjith Pillai]

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.

[Sunil Pothireddy [Intel]]

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.

[Sunil Pothireddy [Intel]]

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]

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