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; } } }

SQL query with "JIRA user login count"

Jörg Geraldy

Hi all,

we want to create a JIRA user management report with the following fields:

username, Full name, login counts, last login

Is it possible to get this report with a SQl query ?

Let me know.

Thanks a lot in advance

bye and best regards

Jörg

Accepted answers

Alexey Matveev

Hello,

It would be something like this

SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.count'
and a.id = b.user_id

All comments

Alexey Matveev

Hello,

It would be something like this

SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.count'
and a.id = b.user_id

Jörg Geraldy

Hi Alexey,

your SQL-query works well; I tested it yesterday.

Good job !

Well done !

Bye and best regards

Jörg

vinod vaddi_6f4cod

Hi Alexey ,

That also worked for me .

Thanks !!!!

RichardA_iqxvt3

Hi @Alexey Matveev , We need information to get number of users logged on particular time interval in jira application.

for example today 27-09-2021 from 9am to 10am.

we are using Oracle DB.

Pls suggest

Thanks !!

Welcome!

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

Quick Links

Find more posts tagged with

jira