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

Finding the inactive users with respective project

srrekanth

Is there any mysql for getting inactiveusers with respetive projects

Accepted answers

All comments

Nic Brough -Adaptavist-

You need to define "inactive" users somehow. I've got users who use systems for reading - they might be considered inactive because they don't contribute, but for us, definitely are NOT inactive.

Would also help if you told us which system you are looking at? Is it Jira?

Nic Brough -Adaptavist-

Repeating the same question is not helpful.

Yes, Jira, thank you. Now, again, what do you mean by "inactive"? And then "respective projects"?

srrekanth

Hi Nic,

Thanks for quick reply...

I need mysql query where we get inactive users asscosiated with respective projects data in JIRA.

srrekanth

Hi Nic,

Inactive means users who have not logine jira for a period of SIX months.Say let us assume we have 100 projects in jira in this projects we have inactive projects in this inactive projects we have inactive users.so i need a query which can get inactive project and users asscioated with this project.

Thanks,

Harsha

J. Caldwell

I would point out that Nic is correct. If the definition is "hasn't signed in in 6 months...", it is really irrelevant to be concerned about the specific projects.

Udo Brand

The query should look like this:

select user_name, ua.attribute_value LAST_LOGIN_IN_MILLIS
from cwd_user u, cwd_user_attributes ua
where u.id = ua.user_id and ua.attribute_name ='login.lastLoginMillis'
and to_number(ua.attribute_value) &lt; (select max(to_number(attribute_value))-15552000000  -- minus 180 Days
     from cwd_user_attributes
     where attribute_name ='login.lastLoginMillis')

Please note this query is for Oracle you need to adapt it to MySQL. It shows all User with last Login 180 days before today (assuming someone logged in today)

Sam Omidi

There is this KB here at https://confluence.atlassian.com/display/JIRAKB/Search+for+Inactive+Users

Cheers,

Sam smile

marshall_craig

This query looks like it only lists those who have already been formally identified as inactive.

Nic Brough -Adaptavist-

That's correct, it will only find users already as inactive.

Welcome!

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

Quick Links

Find more posts tagged with

jira

mysql

improvement