Check out thwack Ambassador, Derek Schauland's newest post on Storage Arrays.
Also, don't forget to update your email address in your profile!
Search 140,365 posts and 1,367 resources contributed by 129,118 members or post a topic.

Already Joined? Sign in
custom sql query to filter the "Top XX Errors & Discards This Hour"?

Page 1 of 1 (3 items) | RSS

rated by 0 users
Answered (Verified) This post has 1 verified answer | 2 Replies | 1 Follower | 116 Views


2 Posts
Points 4
ian105 replied on Fri, Jan 27 2012 12:24 PM
rated by 0 users

I am trying to create 2 separate views

One containing all devices that are on the WAN
Other containing all devices that are not on the wan

I wrote the below sql query, and it returns all interfaces that are a member of a node, with the custom property of WAN_Router in the DeviceType column in the nodes table.

select * from interfaces where NodeID  in (select NodeID from nodes where DeviceType = 'WAN_Router')

I cannot seem to figure out how to apply this query into the filter interfaces box, I keep getting Custom SQL filter is incorrectly formated.

 

Are nested statements such as the above not allowed? If not how would I go about filtering the interface list, based on a value in the nodes table

  • | Post Points: 3

Answered (Verified) Verified Answer


316 Posts
Points 2,227
SolarWinds Certified Professional
SolarWinds Employee
Answered (Verified) sean.martinez replied on Fri, Jan 27 2012 1:23 PM
rated by 0 users
Verified by ian105

The SQL Filter will need to be:

Nodes.DeviceType = 'WAN_Router'

Federal Sales Engineer
SolarWinds  |  IT Management, Inspired By You

  • | Post Points: 23

All Replies


316 Posts
Points 2,227
SolarWinds Certified Professional
SolarWinds Employee
Answered (Verified) sean.martinez replied on Fri, Jan 27 2012 1:23 PM
rated by 0 users
Verified by ian105

The SQL Filter will need to be:

Nodes.DeviceType = 'WAN_Router'

Federal Sales Engineer
SolarWinds  |  IT Management, Inspired By You

  • | Post Points: 23

2 Posts
Points 4
ian105 replied on Fri, Jan 27 2012 2:19 PM
rated by 0 users

Appreciated

  • | Post Points: 1
Page 1 of 1 (3 items) | RSS

© 2003 - 2012 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products