NPM Hello All-
I need to remove interface monitoring from 500+ nodes in NPM. Other than going into LIST RESOURCES and unchecking the boxes, is there a way to automate this?
Thanks,
Jerry
You could delete them from the database. It would be a pain though. You would need to get a list of nodes first from the nodes table, and from that get a list of nodeids to filter the interfaces table. Then once you are SURE that those are the right ones to delete, Delete them from the database. Make sure to do a select statement first to verify though. You don't want to go deleting other stuff. I would recommend running a discovery on those nodes after deleting their interfaces to make sure that they disappear from the web console. Just beware though that you could see hiccups from this, that you would have to resolve. We have done this before and had a hiccup where we ended up having to unmanage and then remanage those nodes again in order to get them to show correctly in the web interface.
Be VERY cautious when altering the database, and make sure that you have a recent backup just in case.
***EDIT*** Beware of doing this. It was brought to my attention that in my haste I did not mention a few things. There are several different tables that you would need to go through and delete from in order to effectively remove the interface from Orion trying to poll it through UnDP etc. So, it would be easier to do it Orion's way. I would like to point out that you do not have to do everything from list resources. You can expand out your nodes in the manage nodes area and delete them that way or you can change the property to interface (also Manage Nodes) and multi select and delete them that way.
Chrystal Taylor
http://www.loop1systems.com
if you are trying to delete, there are a LOT of back end processes that run to clean everything up when deleting... not sure if quick and easy "clean" way.
depending on your ultimate goal, you might be able to unmanage the interfaces using a sql query. This stops data collection (still counted in licensing)ALWAYS BACK UP YOUR DATABASE PRIOR TO DOING ANY SQL SCRIPTING
You'd have to identify the interfaces by some common means that translates to database columns.
example:
I want to stop managing the interfaces on all routers with "atlanta" in the name...
select nodeid from nodes where caption like '%atlanta%' <- you can run this separate just to get idea of nodes results set.
This will unmanage all interfaces from the node list above.
--<begin SQL>
update Interfaces
set UnManaged=1,
UnManageFrom=GETDATE(),
UnManageUntil='2012-07-13 14:33:00.000' -- EDIT THIS TO DATE YOU WANT
-- select status, interfacename, * /* highlight from after the dashes in SQL enterprise manager to the end to see resultset of interface list */
from Interfaces
where nodeid in (select nodeid from nodes where caption like '%atlanta%')
--<end SQL>
you will need to change the line "unmanageuntil" to be a date you want...
it will take a minute where they will show up as unknown.
How database savvy are you? If you're comfortable with things like temporary tables and stored procedures I may have a faster way for you but it's not for folks new to T-SQL.
I would agree with the Manage Nodes suggestion from Chrystal - Use the dropdown box to Show Interfaces instead of Nodes, select the interfaces to delete, and click Delete.
