Is there a way to delete "in mass" interfaces from Nodes. I am looking to delete all Null0 and Loopback interfaces from a major chunk of my nodes and would like to figure out how to do this with SQL rather than through the GUI...
Thanks
You can do this using the Database Manager & a custom SQL query.Note you will need to stop all services using the DB before doing this change (Use the Stop NetPerfMon advanced application).
You query will look something like this:
Delete from InterfacesWhere Interface Name = 'null0'
Then restart the polling & alerting services.
I searched this forum & found the following similar request.
Excellent. I'll try and post success/failure. Thanks for the reply.
Worked like a champ. thanks
I have to say that EVERYTIME I see someone say that a 'common' task has to be performed via a SQL custom script....it makes me wonder....why doesn't solarwinds add this as a normal function in the mgmt interface.
Everyone needs to delete interfaces in mass at one time or another....and it seems like it should be easy to do without having to be a SQL programmer.
absolutely. the furhter i'm getting into looking over solarwinds, the more very very basic things just aren't possible... i can't even delete a single node via the web interface by the look of it. very strange this mismatch comapred to how good it looks elsewhere.
I can appreciate that those UI issues can be annoying. Please let us know about them as you encounter them because we do listen. Both of the issues you mention are things that we want to improve and are on our road map. I realize that some of these things seem like they should be simple because the user experience is brief, but there are technical reasons--reasons specific to Orion and its particular code history--that complicate it. Sometimes, we have to make some bigger changes under the covers to make a smaller change to the UI. Without getting into the details of the sausage-making, I can only assure you that we are making the necessary changes to deliver these kinds of features. There won't be any big bang that gives you everything you want, but we are continually improving Orion and the modules. We have updates coming soon that will address more outstanding feature requests. And more after that.
for whatever reason, your reply is blank on my screen. does anyone have this? I would like to see what he provided.
it's blank for me now as well...Network_Guru must have had image on a remote system and no longer avail.
actually looking in the source there is no content between the section tags where the normal reply goes so it much have been edited/deleted for some reason?
I don't know what was there but this is way easier in the ui than it was before. Go to Manage Nodes and change the Show: type to Interfaces. Search on Null and then click the top check box to multiselect. Click Delete and confirm the delete. If there are more than one page can hold you have the option to remove them all as well. The remove all button does not appear unless you exceed 250 interfaces.
If you want to do this in sql use:
Select * from dbo.Interfaces
Where InterfaceName like '%Null%';
Review the selected items and then reissue the query but replace Select with Delete.
Use caution. Delete * can remove all of your interfaces if you don't qualify the set with a valid Where clause.
