Getting Current User Sessions in Jira

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

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.

It’s polite and appreciative