This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Edit Resource: Exclude specific nodes

I need help!  I'm SW Filter/SQL challenged.

I'm trying to filter out all of the interfaces from 2 nodes in the Top XX Interfaces by Traffic resource.  I can't seem to find the right syntax to exclude interfaces on specific nodes.  Does anyone have something on had that I could use?

Parents
  • I use the following syntax to just show me certain interfaces on certain devices.

    sysname like 'SWITCH1%' and interfacealias like '%Core%' or sysname like 'SWITCH1%' and interfacealias like '%Dist%'

    So in this case if will show interfaces on SWITCH1 that have either Core or Dist in the interface description. The % sign is just like using the wildcard *. This helps if the device is listed in Solarwinds something like SWITCH1.net.com.

Reply
  • I use the following syntax to just show me certain interfaces on certain devices.

    sysname like 'SWITCH1%' and interfacealias like '%Core%' or sysname like 'SWITCH1%' and interfacealias like '%Dist%'

    So in this case if will show interfaces on SWITCH1 that have either Core or Dist in the interface description. The % sign is just like using the wildcard *. This helps if the device is listed in Solarwinds something like SWITCH1.net.com.

Children