Bulk Deleting Specific interfaces from a Node

jmonjackson

Hi All, I'm exploring the ability to bulk delete interfaces from a node. I keep getting a 500 error using the following script. Any help or suggestions would be greatly appreciated. I am using the latest version of the SDK (0.4.0) and Orion is 2024.2.

import requests
from pprint import pprint
from orionsdk import SwisClient
from dotenv import load_dotenv
import os

load_dotenv()


def sw_query(instance, pssWord, pssKey):
    requests.packages.urllib3.disable_warnings()
    swis = SwisClient(os.getenv(instance), os.getenv(pssWord), os.getenv(pssKey))

    swis_query = swis.query("""SELECT i.NodeID, i.InterfaceID, i.InterfaceName, i.Uri
    FROM Orion.NPM.Interfaces i
    WHERE i.InterfaceID = XXX 
    """)

    results = swis_query['results']
    # pprint(results)
    uris_to_delete = []
    for result in results:
        # pprint(result)
        node_id = result['NodeID']
        interface_id = result['InterfaceID']
        node_uri = result['Uri']
        uris_to_delete.append(node_uri)

    for uris in uris_to_delete:
        # pprint(uri)
        try:
            swis.bulkdelete(uris)
            pprint(f'Successfully deleted interface: {uris}')
        except Exception as e:
            pprint(f'Error deleting interface {uris}: {e}')


sw_query('solarwinds-url', 'api-username', 'api-password')

Error Message Returned

('Error deleting interface '
 'swis://INSTANCE-URL/Orion/Orion.Nodes/NodeID=XXX/Interfaces/InterfaceID=XXX: '
 '500 Server Error: Internal Server Error for url: '
 'https://INSTANCE-URL:17774/SolarWinds/InformationService/v3/Json/BulkDelete')

Best,

Jay Jackson

antoniokozar

Hello @jmonjackson ,

I hope you are well and having a wonderful day!

Are you required to use SDK, or are you able to use T-SQL? Here is a query that you can use something like Custom Property on Interfaces to identify the ones you want to remove and then specify it in Line 15 so this would remove the interfaces that have the set condition. 

Please keep in mind that this approach will clear the historical data from the database while the database maintenance runs.

DECLARE @IID INT;
DECLARE @interface_to_remove TABLE 
(
  interface_id INT
);

INSERT INTO @interface_to_remove 
(
  interface_id
)
SELECT
  I.InterfaceID
FROM Interfaces I
WHERE 
  I.InterfaceTest1 IS NOT NULL

DECLARE @RowCount INT = (SELECT COUNT(interface_id) FROM @interface_to_remove);  

WHILE @RowCount > 0 BEGIN  
  SELECT @IID=interface_id
  FROM @interface_to_remove
  ORDER BY interface_id DESC OFFSET @RowCount - 1 ROWS FETCH NEXT 1 ROWS ONLY;  
  EXEC [dbo].[swsp_DeleteInterface] @id = @IID
  SET @RowCount -= 1;  
END 

Hope it helps

All the best!