Support Centre

Find articles, help and advice.

 
Welcome, Guest Login

Support Center

Bulk Closing Alerts in a Time Period

Last Updated: May 12, 2017 10:43AM UTC
Problem:
You have had a flood of Alerts. You need to close all of these alerts.

Solution:
You are able to close groups of alerts from the database command line. From here you will be able to define the time period for the alerts to be closed.

NOTE: You will need to decide the start time and the end time of the Alerts group to be closed

1. Connect to BES via SSH, and log in as user "ppadmin"
2. Run the command: DBcon
3. It is a good idea to know how many alerts you are going to be closing. You can do this by running a SELECT statement in the Database first. You can use this example below:

SELECT COUNT(*) FROM ISS_PP_Alerts_Table WHERE (timeReceived Between '2017-03-20 00:00:00' AND '2017-03-27 00:00:00');

NOTE: The time and date need to be in the following format:
yyyy-mm-dd hh:mm:ss
For Example
2017-03-28 14:32:49

4. Once you have run the select statement it will return a number. The number returned is the number of Alerts that will be closed. If you are happy. you can continue.
5. Once you are happy with the number of Alerts to be closed, you need to stop the Alert Server by running the command: ppStop -n AlertServer
NOTE: This needs to be run as user "ppadmin"


6. Once you have stopped the AlertServer you can now close the Alerts. You can use the example below. You will need to change the time and date to suit your requirements:

UPDATE ISS_PP_Alerts_Table set state = 0 WHERE (timeReceived Between '2017-03-20 00:00:00' AND '2017-03-27 00:00:00');

7. This may take a short while if there are a lot of Alerts to be closed

8. Once complete it will return a number. This number is the number of Alerts that have been closed. Once you happy you can restart the AlertServer by running the command: ppStart -n AlertServer
NOTE: This needs to be run as user "ppadmin"

9. You can now log back into the BSD and check the number of Alerts has decreased.

Contact Us

desk.com@interlinksoftware.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete