Send email when Invalid_Logon_Count=5
From: JN <jnarverud_at_gmail.com>
Date: Mon, 7 Oct 2013 07:42:20 -0700 (PDT)
Message-ID: <441c930b-c642-4192-95a3-bc8db66a0e2c_at_googlegroups.com>
What is the best best way to send an email if a certain table gets to the number 5.
Date: Mon, 7 Oct 2013 07:42:20 -0700 (PDT)
Message-ID: <441c930b-c642-4192-95a3-bc8db66a0e2c_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.
Use CABINET select name, Invalid_Logon_Count, userinstanceid from USERS (nolock) where NAME = 'dex' Received on Mon Oct 07 2013 - 16:42:20 CEST