I cannot address the known synchronization issues, we get them from time to time. However, with CUPS 8.6 or higher (eg. IM&P), you can run the following SQL commands from the CUPS or IM&P CLI to check on customer account lockout status and to reset the account.
Ensure you use the explicit LDAP or CUCM account names when querying the E.userid =’<USERID>’ where the USERID is in single quotes, the examples below identify the userID of “bob.smith”. You may receive an error “A syntax error has occurred” if the formatting is not correct.
Check for Locked Account
run sql SELECT CD.hackcount, CD.timehackedlockout, CD.timelasthacked FROM credentialDynamic CD WHERE fkCredential = ( SELECT C.pkid FROM credential C INNER JOIN enduser E ON E.pkid = C.fkenduser WHERE E.userid = ‘bob.smith' AND C.tkcredential = 3)
Reset user login counts:
run sql UPDATE credentialDynamic SET hackcount = 0, timehackedlockout = 0, timelasthacked = 0 WHERE fkCredential = ( SELECT C.pkid FROM credential C INNER JOIN enduser E ON E.pkid = C.fkenduser WHERE E.userid = 'bob.smith' AND C.tkcredential = 3)
... View more