Hi, I'm afraid the MySQL database is not the right place to work on as alarms are not stored there. If the alarms are not user-clearable, there is no way to actually delete them unless
- you restart your SpectroServer - if and only if the alarms' cause is no longer present (i.e. e.g. a non-reachable device can now be contacted), the alarms should become "stale" and thus can be deleted or - you define events that clear these alarms and create the events on the affected model(s) Freundliche Grüße / Best regards Christian Fieres Mainova AG Planung und Betrieb Infrastruktur (M3-ON2) Service Operation Center Solmsstraße 38 60623 Frankfurt Telefon / Phone (069) 2 13-2 36 17 Mobil / Mobile (0170) 5 60 15 63 Telefax / Facsimile (069) 2 13-9 62 36 17 E-Mail [email protected] Von: [email protected] An: "spectrum" <[email protected]>, Datum: 30.01.2013 12:25 Betreff: [spectrum] query for alarm deletion from back end Hi Team, I have some non-user clearable alarms in the one click. Please tell me in which table i should look for deleting those alarms from mysql database With Regards, Nilam Unicenter Support Wipro Infotech TEL: +91-22-3075-3943/3944 Mail to: [email protected] ?Kindly log a call on http://usdprdweb2/CAisd/pdmweb.exe for any USD related assistance" Calls logged in USD would be prioritized Know more about us on www.hdfcbank.com. Connect with us on Facebook at www.facebook.com/hdfcbank _________________________ ___________________ Disclaimer: "The information contained herein (including any accompanying documents) is confidential and is intended solely for the addressee(s). If you have erroneously received this message, please immediately delete it and notify the sender. Also, if you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this message or any accompanying document is strictly prohibited and is unlawful. The organization is not responsible for any damage caused by a virus or alteration of the e-mail by a third party or otherwise. The contents of this message may not necessarily represent the views or policies of HDFC Bank Ltd." --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] Mainova Aktiengesellschaft Solmsstraße 38 D-60623 Frankfurt am Main Vorsitzende des Aufsichtsrates: Dr. h. c. Petra Roth, Oberbürgermeisterin a. D. Vorstand: Dr. Constantin H. Alsheimer (Vorsitzender), Dr. Peter Birkner, Lothar Herbst, Dr. Marie-Luise Wolff-Hertwig Sitz der Aktiengesellschaft: Frankfurt am Main Amtsgericht Frankfurt HRB 7173 USt-ID-Nr. DE 114184034 Mainova steht für besten Service, faire Verträge und top Preise für Ihre Energie - mit Auszeichnung! Mehr Infos unter: http://www.mainova.de/auszeichnung --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
