Delete escalation policies from SAMStore tables in SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Need to delete escalation policies manually from the SAMStore DB in SOI to clean up the DB. 

What are the tables affected, that need to be removed for cleanly wipe out the escalation policies 

Environment

Service Operations Insight (SOI) 4.2 CU5, 4.3 CU*

Cause

Requirement for specific database schema knowledge to perform manual cleanup or verification of tables that store escalation configurations. 

Resolution

The following database tables in the SAMStore store Escalation Policies and Actions. If you need to verify or clean up these configurations manually, address these specific tables.

Identify and verify tables The core tables involved in storing escalation data are:

• AlertActions
• AlertEscalationActions
• AlertEscalationPolicy
• EscalationPolicyRelationship
• EscalationScheduleRelationship

Manual cleanup procedure If a manual cleanup of existing policies and actions is required before a fresh import, use the following SQL commands. 

Note: Back up your database before performing any delete operations.

1. Clear the escalation policies and associated relationships:
   
   
   DELETE FROM AlertActions;DELETE FROM AlertEscalationActions;DELETE FROM AlertEscalationPolicy;DELETE FROM EscalationPolicyRelationship;DELETE FROM EscalationScheduleRelationship;
2. Restart the SOI Manager service. Changes made directly in the database will not be visible in the Operations Console until the manager is restarted.