Search 97,742 posts and 786 resources contributed by 57,092 members or post a topic.

Already Joined? Sign in
Filter All Applications list using custom poller values?

Page 1 of 1 (5 items) | RSS

rated by 0 users
Not Answered This post has 0 verified answers | 4 Replies | 2 Followers | 353 Views


275 Posts
Points 789
freemen replied on Mon, Oct 26 2009 6:59 PM
rated by 0 users

Is it possible to filter the All Applications list in APM using the current value of a custom poller assigned to a node?

For example, would I be able to use CustomPollerStatus.Status ="XXX" as a filter?

  • | Post Points: 3

All Replies


3 Posts
Points 11
mtcole replied on Tue, Oct 27 2009 11:28 AM
rated by 0 users

That's a great question.  Could someone please answer this?

  • | Post Points: 3

1,099 Posts
Points 2,151
Moderator
SolarWinds Employee
MarieB replied on Tue, Oct 27 2009 4:55 PM
rated by 0 users

Hi Freeman--

You should definitely be able to do this--there's not inherent limitation that would prevent you.

M

Marie Black
thwack moderator

  • | Post Points: 3

275 Posts
Points 789
freemen replied on Tue, Oct 27 2009 6:36 PM
rated by 0 users

Thank you Marie, but can you suggest the filter syntax that will do this? What variable will correctly designate the custom poller?

  • | Post Points: 3

1,099 Posts
Points 2,151
Moderator
SolarWinds Employee
MarieB replied on Wed, Oct 28 2009 11:59 AM
rated by 0 users

Hi Freemen--

I checked with our brilliant developer, Karlo and here are his suggestions:

NOTE: This is an advanced feature and you will be manipulating your database. Loss of data could occur.

Phew, glad that disclaimer's done.

The SQL statement would look something like this:

select * from APM_Application

WHERE NodeID IN (

select NodeID from CustomPollerAssignment where CustomPollerAssignmentID IN (

select CustomPollerAssignmentID from CustomPollerStatus where [Status] = NULL))

Let me know if this works for you--

Marie

 

Marie Black
thwack moderator

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

© 2003 - 2010 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