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
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events