Hi Okik,
You can use the following sql queries to clear all alerts:
NOTE: This you can run only in dire situation. My suggestion would be to open a case with support first, have them take a look at the problem at hand then decide if the following needs to be run or not.
- Backup your current DB
- Stop all SOI services on all machine. Stop the connectors as well
- Make sure you have selected SAMStore DB when running the following queries
- First set the clearedtime in alerts table using the following query
update Alerts set ClearedTime=getdate() where AlertID in (select AlertID from Alerts where Active=1)
- Then set the alert active value to 0 using the following query
update Alerts set Active=0 where Active=1
- Start the SOI services on the SOI manager, make sure it is up and running, the Triage test in sam debug page should show completed. Start the connectors.
Thanks
Shaheen