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

Cisco Model Swap SWIS API Updates

Hello Twack community,

We are in the process of replacing old switches with new switches and have some questions regarding moving away from the WebUI. The goal is to utilize SWIS is the following:

Identify all interfaces monitored for a particular switch IP.
Delete all interfaces monitored for a particular switch IP.
Update the IP of the switch if it has changed.
Rediscover interfaces and specify those that need to be monitored.
Update customer fields with appropriate values.

Is it safe to delete the interfaces via the URI fetched using the following SWQL? I want to ensure that I am not breaking any types of dependencies and introducing problems. The idea is to run the SQL command below via Python and then loop through the URIs returned and remove them via swis.delete(interface_uri). Thanks in advance.

SELECT [Nodes].Caption AS [Node]
, [Nodes].IPAddress
, [Nodes].Vendor
, [Nodes].Interfaces.Caption AS [Interface]
, [Nodes].Interfaces.uri
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].IPAddress = '10.70.35.150' AND [Nodes].Vendor = 'Cisco'

Find more posts tagged with

Accepted answers

All comments

nitsotech

It is generally safe to delete interfaces via the SWIS API, provided that you are certain that you want to delete the interfaces and that there are no dependencies or other considerations that would make deleting the interfaces a problem. When you delete an interface via the SWIS API, it will be removed from the database and will no longer be monitored or displayed in the Orion Web Console.

Before you delete the interfaces, you may want to consider the following:

Make sure that you have a backup of the database, in case something goes wrong and you need to restore the data.
Test the delete operation on a staging or test environment before running it in production, to ensure that it works as expected and does not cause any unintended consequences.
Review the dependencies of the interfaces to be deleted, to ensure that deleting the interfaces will not cause any issues with other objects in the database. For example, if an interface is being used as a component of a volume or aggregate, deleting the interface may cause problems with those objects.

Overall, it is important to be careful and deliberate when working with the SWIS API, especially when making changes to the database. By following best practices and thoroughly testing your code, you can minimize the risk of introducing problems when working with the API.

marcrobinson

I believe that an old catch phrase applies to the API, any API for that matter. "To err is human, to really foul things up, automation is required." Ditto to the above advice - SWIS API is good to use, just be careful in how you use it.

MR_EM

Thanks Nitsotech for taking the time to respond to my post. Unfortunately, we are a very large company and doubt a backup would be provided to me but will ask. Restoring a backup would also be a massive undertaking. A couple of more questions if you don't mind:

Is there any documentation on how to best identify active dependencies for components using the SWQL studio?
I was advised that there are no requirements to keep historic Cisco interface data. Seems like the safest approach would be to delete the node object specific to the switch and simply proceed to re-create it which I am permitted to do. We have NPM for monitoring, NCM for configurations and IPAM for IP tracking. My assumptions at this point would be that deleting a switch node from NPM via its URI would break links for the specific NCM backup configurations and IPAM entry. What are your thoughts? Do you have any experience with deleting Cisco node objects via API?

Regards.

-Evan