How to clean out all of alarms from UIM system?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I would like to clean out all of my alarms from UIM system. I do not care about the alarms any longer and want to bring the alarm database content back to a zero state.

Environment

UIM 9.x, 20.x

Resolution

1- Deactivate nas probe;

2- Issue the following queries in this order one at a time using the SLM portlet (recommended) in UMP or SQL Management Studio / SQL Workbench / database query tool of choice: 

TRUNCATE TABLE NAS_ALARMS;
TRUNCATE TABLE NAS_TRANSACTION_SUMMARY;
TRUNCATE TABLE NAS_TRANSACTION_LOG;

3- Rename the following in the nas probe directory: 

database.db
nisQueue.db
transactionlog.db

4- Activate nas probe;