Not able to delete a node using Python API

I am able to read data from solarncm but I am not able to delete the node using the following code

self.node_uri = self.con.query("SELECT IPAddress, Caption, Uri FROM Orion.Nodes WHERE IPAddress = @ip_addr", ip_addr = ip_addr)

print (self.node_uri)

if self.node_uri is not False:

self.con.delete(self.node_uri['results'][0]['Uri']) #not able to delete node

Could somebody please help?

Find more posts tagged with

Accepted answers

All comments

dexter234

I figure this guide could be useful, give it a look. https://www.networkmanagementsoftware.com/solarwinds-orion-api-sdk-scripting-with-python-part-3/

saloni.rane

This is the error i receive

requests.exceptions.HTTPError: 400 Client Error: Access to Orion.Nodes denied.

I am able to querry NCM but i am not able to delete the node

This is my script

import requests

from orionsdk import SwisClient

from requests.packages.urllib3.exceptions import InsecureRequestWarning

import re

import datetime

# setup swis params

npm_server = '10.81.0.2'

username = '*****'

password = '******'

# disable SSL warnings

requests.packages.urllib3.disable_warnings(InsecureRequestWarning)

# Setup the swis connection

swis = SwisClient(npm_server, username, password)

# Find the Uri you want to delete based on a SWQL query

results = swis.query("SELECT IPAddress, Caption, Uri FROM Orion.Nodes WHERE IPAddress = @ip_addr", ip_addr='10.84.23.240')

print (results)

# Use as needed

if len(results['results']) > 1:

print('refine your search. Found more than one node matching that criteria.')

elif len(results['results']) == 1:

print("Deleting {}".format(results['results'][0]['IPAddress']))

response = swis.delete(results['results'][0]['Uri'])

print("Done")

else:

print("Nothing to delete")

mesverrum

Given the error that access to orion.nodes is denied it makes me wonder, are the credentials you are passing for your script full admin or at least do they have manage nodes? Is there any kind of account limitation at play?

saloni.rane

I can add or delete a node with the same credentials manually. When I try doing it with this program it throws an error.