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

Meriem Amdouni February 20, 2024

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;

1 answer

0 votes
Aaron Pavez _ServiceRocket_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events