Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 39 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

Tags

Classifications

Public