I unmanage nodes or interfaces before I take them down to service them. It makes my uptime reports look better. Need help forming the SQL to filter unmanaged nodes OR nodes that have unmanaged interfaces, respectively, from NPM elements. Thanks.
hit edit in the upper right corner of the web part like "nodes with problems" then in the filter part place this
UnManaged<>1 will drop all the unmanaged devices
for the interface issues in web parts like "down interfaces" i use
Nodes.Status=1 to get interface data on up nodes only
and Interfaces.Status<>0 will drop all the unmanaged interfaces
when you use both together then just put "AND" between them and you are set
let me know if this helps
need clarification on this are you trying to write a report that shows the unmanaged devices or are you trying to filter them off the webpage on your orion server? Need to know this cause it drives to two completely separate answers.
I'm trying to filter them off of a web element.
Interfaces.Unmanaged<>1 did the trick in the web views. Thanks!
