Active users working on JIRA at any time

Question

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 · Answer

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

Sunil Pothiredd2 · Answer

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

Sunil Pothiredd2 · Answer

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.