This seems like a poor workaround IMO as you will forever be needing to modify SQL tables as ports change state to and from "unused" or you add new devices. Do you not put a suitable description in your unused interfaces that you could use as an additional check in your alert? ie "ifName notmatch AVAILABLE" AND "ifOperStatus eq down".

On Thu, Oct 23, 2014 at 1:13 PM, Zhenhui Liang <ZhenhuiLiang@eharmony.com> wrote:
It looks like to be in the alert_table table.

mysql> select * from alert_table where ignore_until_ok!='0’;

I might just directly turn that bit to 1 for all ports currently in down
state.

On 10/22/14, 6:49 PM, "Zhenhui Liang" <ZhenhuiLiang@eharmony.com> wrote:

>I found an option to do ignore until ok on the interface settings. But it
>is really unrealistic to do this manually for hundreds of ports. Any
>easier way to achieve this? I do want to monitor ports status, but I don¹t
>want to get a flood of alerts every 24 hours. Thanks a lot.
>
>On 10/22/14, 6:40 PM, "Zhenhui Liang" <ZhenhuiLiang@eharmony.com> wrote:
>
>>Hi,
>>
>>We have some switches with thousands of ports. I know, we don¹t have
>>administrative down for unused ports. So I set up port down alerts for
>>all ports, so that the initial alert of the down ports, I just ignore so
>>I know those are ports already down. So the theory is that for any
>>following alerts, I will look into them.
>>
>>But I found out observium will send out the massive port down alerts
>>exactly in 24 hours frequency. How do I disable the persistent alerting?
>>I want observium only alert me once for an event period.
>>
>>Thanks a lot.
>>
>>
>>‹Zhenhui
>>_______________________________________________
>>observium mailing list
>>observium@observium.org
>>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
>
>_______________________________________________
>observium mailing list
>observium@observium.org
>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium