Clear the Discovery history in the SolarWinds Platform

This article describes how to clear the Network Discovery history and ignore list.

1. Connect to the SolarWinds server.
2. Stop SolarWinds Services with the SolarWinds Platform Service Manager in the SolarWinds Platform folder of the Start menu.
3. Open Database Manager in the same folder.
4. Select Add Orion server then expand the SQL server and SolarWinds Platform database in bold.
5. Right click the database and select New query. A query window appears on the right.
6. Paste the following query into the windows and select Execute:
    

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   --
   TRUNCATE TABLE DiscoveredInterfaces
   TRUNCATE TABLE DiscoveredMACAddresses
   TRUNCATE TABLE DiscoveredNetObjectStatuses
   TRUNCATE TABLE DiscoveredNodePortMaps
   TRUNCATE TABLE DiscoveredNodes
   TRUNCATE TABLE DiscoveredNodeVlans
   TRUNCATE TABLE DiscoveredPollers
   TRUNCATE TABLE DiscoveredVolumes
   TRUNCATE TABLE DiscoveryIgnoredInterfaces
   TRUNCATE TABLE DiscoveryIgnoredNodes
   TRUNCATE TABLE DiscoveryIgnoredVolume

    
7. Restart the SolarWinds services.