How can we help you today? How can we help you today?

SQL Account Lockout

Hi,

I would like to get an alert notification if there's a SQL account lockout occurred.  How can I do it or is there an existing matrix for this?  I tried the customized one but it doesn't get into the value of 1, as the value has min -0.001 or max 0.001

SELECT IIF(COUNT(*) > 0, 0.0001,0.0000)
 FROM master.sys.sql_logins
 WHERE LOGINPROPERTY(name, N'isLocked') = 1

Ferdinand
0

Comments

1 comment

Sort by
  • Eddie D
    Hi Ferdinand,
    Thank you for your forum post.

    SQL Monitor does not have an alert to notify when a SQL account is locked out.

    It maybe possible to create a custom metric on this.  Advice on creating custom metric can be found here.

    There is also a web site available for Custom Metric's, where users have posted example custom metric for others to use.  Maybe this one will be of help to you.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.