UIM 20.x SQL query to verify that your environment is ready for the upgrade

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Upgrade UIM instructions Upgrade Step 1: Evaluate the Existing Environment (broadcom.com) state "As part of the upgrade process, the installer runs an SQL query to verify that your environment is ready for the upgrade. This query is run by the installer whether you are an MCS user or not."

What is the query run? 

We would like to run the query before starting the upgrade 

Environment

Release : UIM 20.x 

Component : UIM Upgrade

Resolution

The query executed by the installer script is:

select profile, field, count(*) from SSRV2ConfigValue  group by profile, field having count(*) > 1;

If there are results of this query then it's "not safe" to upgrade.

If there are no results, you are good to upgrade.