Identify and remove MCS Legacy templates and migrate to Enhanced templates

Products

DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

This Article contains a list of Questions and Answers about Monitoring Configuration Services (MCS) Legacy and Enhanced Templates.

Why do I have 2 types of Templates Legacy and Enhanced? Should I remove the legacy templates?
How do I identify MCS Legacy templates in my environments and how do I migrate them all to Enhanced Templates?
How can I delete MCS profiles from OC that have been created with MCS Legacy templates?
I want only MCS Enhanced Templates to be deployed and displayed, how I can I prevent the OC to offer / display Legacy templates when creating them?
Is there a query to identify Legacy Templates and groups related to it?
If I want to migrate my MCS probe templates to the latest version, what do I do with Legacy templates?
What is the supported way to delete profiles that are deployed as Legacy Templates and migrate to Enhanced Templates?

Environment

DX UIM 23.4.*

Cause

Guidance on Legacy MCS Templates
MCS Legacy profiles are no longer supported in DX UIM 23.4.*

Resolution

Background on MCS Legacy Templates:

Since DX UIM (UIM 9.02 and later), MCS offers Enhanced Templates that provide compatibility with central Alarm Policy management.
In the UI, enhanced profiles are displayed with the term "(Enhanced)" added to the profile name; for example, CPU Monitor (Enhanced).
MCS Legacy profiles (non-enhanced) are also provided within the template packages and can be used. However, they are no longer fully supported in DX UIM 23.4.* and if used, they may cause issues similar to what described in this KB: Performance Data not shown for some servers after deploying Profiles with MCS on DX UIM 23.4. and they don't support alarm policies.
Even though Legacy templates are not supported in DX UIM 23.4, they may still be offered in the MCS UI, as an option - opposed to MCS Enhanced Templates, to create MCS Monitoring Profiles.
It is highly recommended to use MCS Enhanced profiles when setting up any new monitoring profile in DX UIM 23.4.*
On DX UIM 23.4.4 (CU4) and later, Legacy Templates no longer display in the MCS UI

Environments with Active Monitoring Profiles that based mixed Legacy and Enhanced Templates

Legacy and Enhanced based MCS Profiles can co-exist in a production environment. The profiles that are based on legacy templates will be limited in functions (Example, not possibility of using Alarm Policies)
If migration to the latest version of a template is needed, e.g., CDM (Enhanced) templates, it is recommended that the legacy templates are undeployed (deleted from OC) and then recreated with Enhanced Templates before triggering the migration.

Identify MCS Legacy Templates and remove them

There is no direct way of identifying the non-enhanced templates rather than the word "Enhanced" in the templates. If the legacy MCS profile is generating issues and needs to me removed, the following query can help identify the groups that have profiles that have legacy templates deployed to it. After reviewing them and evaluating, those can be deleted from OC and then recreated manually as enhanced profiles.

--This query returns the groups on which there may be non-enhanced profiles deployed

SELECT

cg.name as 'OC Group Name',

cg.grp_id as 'CM_GROUP id',

dg.id as 'SSRv2Devicegroup id',

t.templatename,

t.version

FROM CM_GROUP cg

JOIN ssrv2Devicegroup dg

ON cg.grp_id = dg.cm_group_id

JOIN ssrv2profile s

ON s.group_id = dg.id

JOIN SSRV2Template t

ON s.template = t.templateid

WHERE t.type = 'device'

AND t.production = 1

AND t.templatename NOT LIKE '%Enhanced%'

AND t.probe NOT LIKE '%restmon%'

AND EXISTS (

SELECT 1

FROM cm_group_member gm

WHERE gm.grp_id = cg.grp_id

);
Once the list of Groups having MCS templates deployed to it, examine the groups and delete manually if relevant. and plan on recreating the templates as Enhanced Templates:

Example output with group name list:

Prevent MCS Templates to be visible/offered in OC

On DX UIM 23.4.4 (CU4) and later the Legacy templates no longer display in the MCS UI when adding new profiles/templates
If you want to avoid Legacy templates from being used/access and/or displaying in the MCS UI, upgrade to DX UIM 23.4CU4.
Broadcom support strongly recommends upgrading to CU4 for the best and most reliable use of MCS without Legacy templates.
- Download and info on DX UIM 23.4.4 (CU4) can be obtained at the links below:
  
  UIM Server 23.4 - Cumulative Update 4
  Operator Console 23.4 - Cumulative Update 4

Additional Information

Important notes:

Update statements/sql queries that will modify fields in the DB. Use this with caution, and ensure you have a recent Snapshot/backup of your production DB in case of any issues that can affect operations in the production environment.
Most of the probes support Enhanced Profiles. Some probes support only legacy profiles. For those, keep using Legacy templates.
If by accidentally altering a certain template to Production = 0, whcih turns it invisible in the MCS UI, this can be reverted reverting the change setting Production = 1 for the affected rows.
In DX UIM 23.4.4 and later, even though "production = 1" on Legacy templates, they will still not show.
The following tech doc contains a list of probes that support Enhanced Profiles: Configuring Alarm Thresholds in MCS. Some probes are missing from this list such as "Nutanix, Docker Monitor, Openstack, postgreSQL, Xendesktop,... )