UIM - How to verify a successful MCS template migration

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This technical document provides an overview of how to confirm a successful MCS template migration. 

In this document we will use the ntevl as an example. 

Environment

Release : 20.3

Component : UIM - MON_CONFIG_SERVICE

Resolution

1). Review the Operator Console MCS UI tab. 

a). Access the Group and / or Device level MCS profiles and confirm they are in green status, visible and not locked. 
-- During the profile migration based on the number of profiles and devices, this may take some time. During the migration the profiles will be in a locked state, this is to prevent users from modifying profiles that are being migrated. During this time the "status" field will display "migrating" using the following query: select * from ssrv2probetemplatespackage where probe_name = '<probe_name>'  

2). Review the SSRV2* MCS Related DB tables. 

a). select * from ssrv2probetemplatespackage where probe_name = 'ntevl' 
-- This will provide a status of the migration. The column "final_message" should return the value "All templates and profiles migrated successfully" and the "status" should display "migrated". 

b). select * from ssrv2template where probe='ntevl' and production  = 1
-- This will return the probe template version activated. 

c). select * from ssrv2profile where template in (select  templateid from ssrv2template where probe='ntevl' and production  = 1 )   
-- This will return all migrated profiles.

d). Select * from ssrv2profile where template in (select  templateid    from ssrv2template where probe='ntevl' and production  = 0) 
-- This will return zero results for enhanced profiles.

3). For probes such as the ntevl, logmon etc you can check in the IM GUI to confirm the expected profiles and variables are visible as per the MCS profile configuration.