Clearing Notifications on CMC

Products

• Security Analytics

Issue/Introduction

In the user interface the bell icon at the top right indicates the number of Notifications from the sensors and the CMC.  This cannot be cleared from the UI of the CMC.

This is an example with no Notifications

Environment

Once all of the notifications on the sensors and CMC have been identified and resolved, then the CMC notifications have no value.

Resolution

If it's a low number of notifications, clicking on the icon to open the notifications list and clicking on each notification will clear out the notification one by one.  With a larger amount of notifications this may be a lengthy process. 

NOTE:  this process is irreversible and cannot be undone.

To clear out all notifications:

Log into the CLI with root (using SSH)
Run:

echo "truncate notifications" | su - postgres -c 'psql dsweb'

The output should look like this:

stdin: is not a tty
stdin: is not a tty
TRUNCATE TABLE

Additional Information

Another form of the truncate command can be run like this as well:

/sbin/runuser -l postgres -c "/usr/bin/psql -d dsweb -c \"TRUNCATE notifications CASCADE\""