How can I get the number of log in attempts from crowd for a user?

[Tim]

Does anyone know how to get this information from crowd? I'm on crowd version 2.3.4

[Justin Koke]

Use the REST end point:

https://developer.atlassian.com/display/CROWDDEV/Crowd+REST+Resources#CrowdRESTResources-UserResource

specifically:

/user?username=USERNAME&expand=attributes

This will return the attributes for the user, has failed login attempts they are stored as an attribute against them.

[Septa Cahyadiputra [Atlassian]]

From database

SELECT u.user_name, a.attribute_value as FailedLogin FROM cwd_user_attribute a join cwd_user u ON a.user_id=u.id WHERE attribute_name='invalidPasswordAttempts';

This will return the username and how many failed login attempt registered on the database.

Hope it helps.

Cheers,
Septa Cahyadiputra