You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
The only way to do this is to edit it from the DB itself.
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.
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
the correct command is without
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"