[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opennms-discuss
Subject:    Re: [opennms-discuss] Alarms archiving
From:       Ken Eshelby <eshelbyk () gmail ! com>
Date:       2011-07-28 0:20:02
Message-ID: CAEHh3RTEOBAiWc1gy6UEioV6rDNnz65vwHUz4XN-YhRn+P7ZcA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


I should add my use case is to keep nodeDown alarms up to 45 days.

On Wed, Jul 27, 2011 at 5:18 PM, Ken Eshelby <eshelbyk@gmail.com> wrote:

> I asked this recently.  Jeff indicated this was the place in vacuumd, but
> it doesn't appear to work as expected and I haven't put more time into
> monkeying with it.
>
>
>  (vacuumd config)
>
>     <action name="fullGarbageCollect" >
>       <statement>
>         DELETE FROM alarms
>          WHERE GREATEST(lastautomationtime, lasteventtime) &lt; now() -
> interval '45 days'
>       </statement>
>     </action>
>
>

[Attachment #5 (text/html)]

I should add my use case is to keep nodeDown alarms up to 45 days.<br><br><div \
class="gmail_quote">On Wed, Jul 27, 2011 at 5:18 PM, Ken Eshelby <span \
dir="ltr">&lt;<a href="mailto:eshelbyk@gmail.com">eshelbyk@gmail.com</a>&gt;</span> \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;">I asked this recently.  Jeff indicated this was the \
place in vacuumd, but it doesn&#39;t appear to work as expected and I haven&#39;t put \
more time into monkeying with it.<br> <br><br> (vacuumd config)<br><br>    &lt;action \
name=&quot;fullGarbageCollect&quot; &gt;<br>  &lt;statement&gt;<br>        DELETE \
FROM alarms<br>         WHERE GREATEST(lastautomationtime, lasteventtime) &amp;lt; \
now() - interval &#39;45 days&#39;<br>      &lt;/statement&gt;<br>    \
&lt;/action&gt;<br><br> </blockquote></div><br>



------------------------------------------------------------------------------
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

[prev in list] [next in list] [prev in thread] [next in thread]