UIM - restore Operator Console Groups

book

Article ID: 224492

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

We have accidentally deleted an important OC Group container and all child (Dynamic or Container Group) with many OC Metric View configured.

What are tables in the DB to restore from a backup to recover the configuration?

Cause

Accidentally deleted group from OC. 

(When a group is deleted, the correspondent metric views that are linked to the deleted group id will also be deleted)

Environment

Release : 20.3

Component :

Resolution

The groups information is stored in the following tables:  


CM_GROUP
CM_GROUP_MEMBER
CM_GROUP_AUTOMATIC
CM_GROUP_AUTOMATIC_RESULT
CM_GROUP_DYNAMIC
CM_GROUP_DYNAMIC_RESULT
CM_GROUP_MASTER_MEMBER
CM_GROUP_PRECONFIGURED
CM_GROUP_PRECONFIGURED_DEF
CM_GROUP_PRECONFIGURED_PROFILE

 

The Metric Viewer views are stored in the table below:

OCMETRICNAMEDVIEW