Hello -
My post from 2 weeks ago is gone in the whirl of new THWACK so let's try this again.
A THWACK user was able to help me with the account lockout script which is working great.
SELECT
CASE
WHEN LOGINPROPERTY(name, N'IsLocked') = 1 THEN
'The login ' + name + ' was locked out at ' +
CAST(LOGINPROPERTY(name, N'LockoutTime') AS NVARCHAR(50)) +
'. The is_disabled flag is set to ' + CAST(is_disabled AS NVARCHAR(1))
ELSE 'No accounts locked'
END AS LockoutMessage,
LOGINPROPERTY(name, N'IsLocked') AS is_locked
FROM sys.sql_logins
WHERE LOGINPROPERTY(name, N'IsLocked') = 1;
Is there some way we can also find out the IP or node or what caused the lockout?
I am going over the DPA alerting information to get my knowledge up on DPA alerting. Thanks!
