Getting Current User Sessions in Jira

[Nadir Jabbarli]

Hi,

I need to get the 'Current User Sessions' section in Jira from the database, and display this data in PRTG Tool. The data I need is in the form of a count. I want to see how many people are currently in the system. Can you help me with this?

Thanks in advance!

[Marc - Devoteam · Accepted solution]

Hi @nad 

This is not stored in the DB, but in a log.

See this article viewing-user-sessions 

[Nadir Jabbarli]

I want to extract the data mentioned in the image from the database and display it in PRTG.

Actually, the PostgreSQL script mentioned in the link works for me, but I need to filter out the active users. For that, I need the corresponding SQL query.

Link 

Please help me

[Marc - Devoteam]

Hi @Nadir Jabbarli 

I don't have that query and if none one does, you need to figure it out.

Here you can find the DB schemas, based on version, find the right schema and tables you need to get data from.

database-schema 

Still this is bad practice as if you make a mistake and break something your Jira is down with a broken DB.

Best practice is to use the GUI or the access log.

[Nadir Jabbarli]

It’s polite and appreciative