SQL QUERY: How to get a list of users that had a failed login in during a certain period?

[Meriem Amdouni]

We are using Jira and Confluence Data Center and we want to find the list of Users that have a failed login in a certain time period (For exp: from 01-12-2020 to 20.02.2024)

I found this query that lists all attempted logins, but not during the time period that was required:

select U.user_name,U.email_address,A.attribute_name, A.attribute_value
from cwd_user_attributes A
inner join cwd_user U
on A.user_id= U.ID
where A.attribute_name = 'login.totalFailedCount'
order by 1;

[Aaron Pavez [ServiceRocket]]

Hi @Meriem Amdouni 

Check this post, there you can find how to add the DATE to the query:

https://community.atlassian.com/t5/Jira-Software-questions/To-extract-all-JIRA-users-and-their-last-access-date/qaq-p/1613347

Regards