Thanks. But, is there no other way, besides screwing around in the database? 2015-01-07 13:07 GMT+01:00 Eli Mesika <emesika@redhat.com>:

----- Original Message -----

...

From: "Koen Vanoppen" <vanoppen.koen@gmail.com> To: users@ovirt.org Sent: Wednesday, January 7, 2015 7:42:25 AM Subject: [ovirt-users] Alerts

Hi All,

We recently had a major crash on our ovirt environment due a strange bug (has been reported in the meanwhile).

But now we are left we a bunch of aerts (+100) that are still standing there... Is there a way I can flush them manually from command line or so? Because the right click+clear all, doesn't seem to work that good... :-).

If you want to remove ALL alerts run from command line

psql -U engine -c "delete from audit_log where severity = 10;" engine

NOTE: Keep in mind that before any manual operation on your database you should backup it first.

...

Kind regards,

Koen

_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

Thanks!!! Just what I needed! 2015-01-07 14:19 GMT+01:00 Juan Hernández <jhernand@redhat.com>:

On 01/07/2015 02:05 PM, Koen Vanoppen wrote:

...

Thanks. But, is there no other way, besides screwing around in the database?

You can use the Python SDK:

#!/usr/bin/python

import ovirtsdk.api import ovirtsdk.xml

api = ovirtsdk.api.API( url="https://engine.example.com/ovirt-engine/api", username="admin@internal", password="******", ca_file="/etc/pki/ovirt-engine/ca.pem" )

alerts = api.events.list(query="severity=alert") for alert in alerts: alert.delete()

api.disconnect()

...

2015-01-07 13:07 GMT+01:00 Eli Mesika <emesika@redhat.com <mailto:emesika@redhat.com>>:

----- Original Message ----- > From: "Koen Vanoppen" <vanoppen.koen@gmail.com <mailto:vanoppen.koen@gmail.com>> > To: users@ovirt.org <mailto:users@ovirt.org> > Sent: Wednesday, January 7, 2015 7:42:25 AM > Subject: [ovirt-users] Alerts > > Hi All, > > We recently had a major crash on our ovirt environment due a strange bug (has > been reported in the meanwhile). > > But now we are left we a bunch of aerts (+100) that are still standing > there... Is there a way I can flush them manually from command line or so? > Because the right click+clear all, doesn't seem to work that good... :-).

If you want to remove ALL alerts run from command line

psql -U engine -c "delete from audit_log where severity = 10;" engine

NOTE: Keep in mind that before any manual operation on your database you should backup it first.

> > Kind regards, > > Koen > > _______________________________________________ > Users mailing list > Users@ovirt.org <mailto:Users@ovirt.org> > http://lists.ovirt.org/mailman/listinfo/users >

_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

-- Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 3ºD, 28016 Madrid, Spain Inscrita en el Reg. Mercantil de Madrid – C.I.F. B82657941 - Red Hat S.L.