Re: Send email when Invalid_Logon_Count=5

From: joel garry <joel-garry_at_home.com>
Date: Mon, 7 Oct 2013 08:43:39 -0700 (PDT)
Message-ID: <23eeacf0-c609-42e1-be9a-ec209bd91096_at_googlegroups.com>


On Monday, October 7, 2013 7:42:20 AM UTC-7, JN wrote:
> 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'

Is this an Oracle database?

jg

-- 
_at_home.com is bogus.
http://www.techrepublic.com/blog/tech-decision-maker/oracles-licensing-rules-five-common-pitfalls-to-watch-out-for/
Received on Mon Oct 07 2013 - 17:43:39 CEST

Original text of this message