1 of 1 people found this helpful
Your best bet is going to be a report that you can export. I don't see an out-of-the-box report right off, but the SQL to create one is below (New > Advanced SQL Report). Getting the information back into an install is going to be less straightforward. You can use the IP address from the report to do a targeted (list of IP addresses) discovery but at that point you're left with either a) no interfaces, or b) a large groups of interface based on the import criteria (all non-loopback interfaces that are operationally up, for example). You can either select too many interfaces and then remove them from each device or select no interfaces and add them as needed. Yes, it's as boring as it sounds.
SELECT n.caption, n.ip_address, i.caption
FROM nodes n
JOIN interfaces i ON n.nodeid = i.nodeid
Acknowledging you're not SQL savvy is important, but for something like this you may want to put your hands on someone who is to avoid the mind-numbing tedium above. Assuming you did, these would be my instructions for them:
- Do a targetted discovery of all nodes in the list provided.
- When prompted, import EVERY interface (operationally up, down, and admin down) of EVERY type.
- Query the database for all interfaces that don't match the node/interface pairs from your export.
- Gather the interfaceid values from step #3 (it's the unique identifier).
- Iterate over these IDs, passing them to the swsp_deleteinterface stored procedure.
- Confirm that the right number of interfaces made it into the 'deletedinterfaces' table.
- Run the database maintenance (All Programs > SolarWinds Orion > Advanced > Database Maintenance).
All that being said, there's also the API. I don't suppose you're proficient in any of the supported languages?