Network Management

Remove stale interfaces from the database and criteria before interface become stale in Orion

When no data is polled for an interface for a specified time, you can configure Orion Platform to delete the interface and all data connected with it.

First published date

10/30/2018 6:57 PM

Last published date

12/5/2024 4:55 PM

Overview

When no data is polled for an interface for a specified time, this interface is considered to be "stale". You can configure Orion Platform to delete the interface and all data connected with it. Stale interfaces are deleted one hour before the scheduled maintenance.

Deleting stale interfaces saves space in the database, improves the polling performance, and saves interface elements in your database. 

Product section

Network Performance Monitor

Cause

When no data is polled for an interface for a specified time, this interface is considered to be "stale".

Resolution

  1. Log in to the Orion Web Console using an account with administrator privileges.
  2. Click Settings > All Settings and click Polling Settings.
  3. Select the Delete stale interfaces box, and specify how long stale interfaces should be kept in the database (Stale interface retention).
  4. Restart the Business Layer(Solarwinds Orion Module Engine).

    If you change the settings for removing stale interfaces, or if you change the DB Maintenance start time, you need to restart the Business Layer(Solarwinds Orion Module Engine).

Stale interfaces will regularly be deleted according to your settings.

Criteria before the interface become a stale 

  • Check InterfaceIndex = -1
  • Check Interfaces.NextPoll Column is older than 7 days
  • Check Interface is not unmanaged
  • Check the node is not unmanaged

Useful query to check stale interface candidates:

-- 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.

select nodeid, interfaceid, interfaceindex, caption, unmanagefrom, unmanageuntil, adminstatus, operstatus, status, nextpoll, lastsync
From Interfaces order by interfaceindex asc

SELECT TOP 1000 * FROM [dbo].[Nodes]
where unmanaged = 1