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 > Netflow Traffic Analyzer (NTA) > Remove stale data from the Orion database after upgrading to NTA 4 and later versions

Remove stale data from the Orion database after upgrading to NTA 4 and later versions

Table of contents
Created by Michael Perez, last modified by MindTouch on Jun 23, 2016

Views: 697 Votes: 2 Revisions: 4

Overview

When upgrading to NTA 4 and later versions, Orion makes use of the FlowStorage Database and will not add new Netflow data in the Orion database. If you chose to retain the previous data during migration, this article will describe how to remove it after the migration.  

Environment

NTA 4 and later versions

Steps

  1. Take a full backup of the Orion database.  
  2. Run the following query against the Orion Database:
    --Start--
    UPDATE NetFlowGlobalSettings
    SET Value = 2
    WHERE Keyname = 'MigrateSqlFlows.MigrationOption'
    --End--
  3. Restart the Netflow service on the Orion server, followed by all additional polling engines.

 

When the Netflow service sees that the setting changed in the database, it will trigger the removal of the stale information from the Orion database. This will cause no changes on the FlowStorage Database.  

 

 

 

Last modified
20:58, 22 Jun 2016

Tags

Classifications

Public