Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > Determine the products and corresponding versions on the Orion database

Determine the products and corresponding versions on the Orion database

Table of contents

Updated March 11th, 2016

Overview

This article describes how to determine the versions of each product that was previously used with the Orion database. This may be useful when you suffer complete loss of the Orion Server but have a healthy Orion database.  

Environment

All Orion products

Steps

Open SQL Server Management Studio and check the following functions to display the version for each product. Refer to View User-defined Functions (© 2017 Microsoft, available at https://docs.microsoft.com, obtained on June 2, 2017.)

  • NPM- GetNpmDbVersion
  • IPAM-  IPAM_GetDbVersion
  • SAM- GetApmDbVersion
  • QOE- GetDpiDbVersion
  • NTA- GetNetflowDbVersion
  • WPM- GetSEUMDbVersion
  • Toolset- GetToolsetDbVersion
  • IVIM- GetVimDbVersion
  • VNQM- GetVoipDbVersion

 

Here is an example result:  

The returned value is 13, which is associated with v11.5 as listed above.  

 

Run the following query for NCM to display versions earlier than 7.3 due to the database being integrated with Orion:

--Begin
 Select * FROM WebSettings  WHERE SettingName='NCMDatabaseVersion'
--End

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any. 

 

Last modified
14:42, 2 Jun 2017

Tags

Classifications

Public