Send email when Invalid_Logon_Count=5

From: JN <jnarverud_at_gmail.com>
Date: Mon, 7 Oct 2013 07:38:55 -0700 (PDT)
Message-ID: <eb90c5f2-f08a-425c-ae0d-056ab30298e4_at_googlegroups.com>

What is the best best way to send an email if a certain table gets to the number 5.

Any thoughts would be greatly appreciated.

Below is the query I run to check on the Dex account: It’s the Invalid_Logon_Count that holds the 0-6 value I’m looking for. 0 is good and 6 is locked out. Let me know what you think, thanks, Andy use CABINET select name, Invalid_Logon_Count, userinstanceid from USERS (nolock) where NAME = 'dex' Received on Mon Oct 07 2013 - 16:38:55 CEST