Re: [ovirt-users] Alerts

2015-01-12 Thread Koen Vanoppen
Thanks!!! Just what I needed!

2015-01-07 14:19 GMT+01:00 Juan Hernández jhern...@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 emes...@redhat.com
  mailto:emes...@redhat.com:
 
 
 
  - Original Message -
   From: Koen Vanoppen vanoppen.k...@gmail.com
  mailto:vanoppen.k...@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.

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


Re: [ovirt-users] Alerts

2015-01-07 Thread Juan Hernández
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 emes...@redhat.com
 mailto:emes...@redhat.com:
 
 
 
 - Original Message -
  From: Koen Vanoppen vanoppen.k...@gmail.com
 mailto:vanoppen.k...@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.
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Alerts

2015-01-07 Thread Eli Mesika


- Original Message -
 From: Koen Vanoppen vanoppen.k...@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
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


Re: [ovirt-users] Alerts

2015-01-07 Thread Koen Vanoppen
Thanks. But, is there no other way, besides screwing around in the database?

2015-01-07 13:07 GMT+01:00 Eli Mesika emes...@redhat.com:



 - Original Message -
  From: Koen Vanoppen vanoppen.k...@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
 

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


[ovirt-users] Alerts

2015-01-06 Thread Koen Vanoppen
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... :-).

Kind regards,

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