Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Update Node Description

Hi All

I'm new to using API's so having a few issues figuring out how to use the SWIS API. So far I've been able to get my python script connected, obtaining IP subnet and node data and quickly tested the get next available IP function.

I'm trying to migrate some IP data into our SW IPAM system, but the data is from spreadsheet data is not reliable enough to be used as DNS information. I'd like to add the data I have to the IP node description or comment field. How can I do this this using SWIS? can you run an "Update"?

Below is my function for obtaining the IP Node info.

def get_ip_node_info():
    counter = 0
    nodeinfo = swis.query("SELECT TOP 500 IpNodeId, SubnetId, IPOrdinal, IPAddress, Alias, Description, Comments FROM IPAM.IPNode'")
    #print(nodeinfo)

    for node in nodeinfo['results']:
        node_id = nodeinfo['results'][counter]['IpNodeId']
        node_ip = nodeinfo['results'][counter]['IPAddress']
        node_alias = nodeinfo['results'][counter]['Alias']
        node_description = nodeinfo['results'][counter]['Description']
        node_comments = nodeinfo['results'][counter]['Comments']
        print(str(counter) + " *-* " + str(node_id ) + " *-* " + str(node_ip) + " *-* " + str(node_alias) + " *-* " + str(node_description) + " *-* " + str(node_comments))
        counter = counter + 1

Find more posts tagged with

Accepted answers

tony.johnson

As you only need the URI you could simplify the select query to remove the 'TOP 500' or consider using swis.bulkupdate if you have a list of uri's to update. Interestingly the sample for update_node_Info is not working for me. I simplified it down to

def get_ip_node_info():
counter = 0
nodeinfo = swis.query("SELECT TOP 10 IpNodeId, SubnetId, IPOrdinal, IPAddress, Alias, Description, Comments FROM IPAM.IPNode'")
#print(nodeinfo)
t = PrettyTable()
t.field_names = ["Counter","IpNodeId","IPAddress","Alias","Description","Comments" ]
counter=1
for node in nodeinfo['results']:
t.add_row([counter,node['IpNodeId'], node['IPAddress'], node['Alias'], node['Description'], node['Comments']])
counter += 1
print(t)

def update_node_Info(ip_address, new_desc):
nodeinfo = swis.query("SELECT Uri FROM IPAM.IPNode WHERE IPAddress=@IP", IP = ip_address)
node_uri = nodeinfo['results'][0]['Uri']
update_repsonse = swis.update(node_uri,comments=new_desc )
print(update_repsonse)

As a tip for posting on thwack try using the Insert -> Code option in the editor to help with the layout.

All comments

Pyhton_Noob

I've managed to get it working with this, not sure if this is correct or not.

def update_node_Info(ip_address, new_desc):

nodeinfo = swis.query("\

SELECT TOP 500 IpNodeId, SubnetId, IPOrdinal, IPAddress, Alias, Description, Comments, Uri FROM IPAM.IPNode \

WHERE IPAddress=@IP", IP = ip_address)

node_id = nodeinfo['results'][0]['IpNodeId']

node_uri = nodeinfo['results'][0]['Uri']

print("\nNode ID: " + str(node_id))

print("\nNode URI: " + str(node_uri))

#print(nodeinfo)

update_repsonse = swis.update(node_uri, Comments=new_desc)

print(update_repsonse)

tony.johnson

As a tip for posting on thwack try using the Insert -> Code option in the editor to help with the layout.

Pyhton_Noob

Thanks Tony - I knew there would be a better way to add code :-)

Thanks for the tips around the query. I am assuming an IP address record would be unique?

tony.johnson

I.P address alone may not be unique, is update_node_info working as expected for you?