Send email when Invalid_Logon_Count=5

From: JN <>
Date: Mon, 7 Oct 2013 07:38:55 -0700 (PDT)
Message-ID: <>

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

Original text of this message