nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Marc -Devoteam-

Hi @nad

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

See this article viewing-user-sessions

All comments

Marc -Devoteam-

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-data-center

prtg

jira-db