Reset Login count in Jira

[Hemanshu]

How to reset Login Count In JIRA for a particular user. 

We are implementing integration with Service Now with Rest APIs and the SN team is hitting JIRA application with APIs and every hit is being counted as a login attempt. Hence the login attempts have risen upto 200k in about 2 months. Please suggest.

[Timothy · Accepted solution]

The only way to do this is to edit it from the DB itself.

[True_Developer]

so there is no REST API for resetting the login count? 

[True_Developer]

can you let me know what is the db statement to reset it?

[Evan Castle]

This worked for me - don't forget to change the <schema> to your schema name and change <USERNAME> to the login name the user uses.

UPDATE <schema>.cwd_user_attributes
SET attribute_value = 1 FROM <schema>.cwd_user_attributes WHERE attribute_name = 'login.count' and user_id = (SELECT id FROM <schema>.cwd_user WHERE user_name = '<USERNAME>');

Remember, tho; Always attempt in DEV before PRODUCTION

[Francesco R]

Hi,

the correct command is without

FROM <schema>.cwd_user_attributes

so it should be:

UPDATE <schema>.cwd_user_attributes SET attribute_value = 1 WHERE attribute_name = 'login.count' and user_id = (SELECT id FROM <schema>.cwd_user WHERE user_name = '<USERNAME>');

but I've a question.
What about the "lower_attribute_value" in the "cwd_user_attributes" table ?
In my table it has the same value of attribute_value. What is it for ? I see it's increased in the same way of "attribute_value"