How to Hide Custom Pollers from Universal Device Poller Status resource...or create a similar view

Did you ever have any luck with this?

Nope

Did you manage to come up with an alternative solution at all?

Nope .  The only thing I came up was:

Make up a prefix to put in front of all the metric names I *don't* want to see so all of those metrics get grouped together and drop to the bottom of the table. I used something like 'z_raw_'.  From the screenshot above, I did something like:

ReceivePower -42.8

VectorError -35.4

...

z_raw_ReceivePower  -428

z_raw_VectorError -354

I also figure once the day comes I can hide these, it will be easier to hunt them down.

Another thought: I have 0 knowledge of how to do this, but there are Orion resources that allow you to create custom queries into Orion, and some that let you generate custom HTML.  Maybe create a custom resource that queries Orion ( via the published SWIS API) for the metrics I wanted and spit them out in some basic format (hopefully a table).  If it was an HTML resource it opens up more possibilities (jQuery, CSS, javascript, logic...)  than just spitting out the query data.  The issues I see is it might be hard to figure out how to make the queries to find the data, it may be slower than the built in "universal device poller status" resource, and it's more complexity to maintain.

Another idea, and it was only a thought, was to write some sort of small javascript code to inject/add to into the Orion node pages that would "hide" the data rows containing 'z_raw_' fields.  This goes outside of what I am willing to do for this, but it seemed like an interesting idea.  If I were willing to go this far I'd probably do similar things to implement some of the small "feature requests" I have submitted that deal with formatting data/etc. that don't have a lot of upvotes.

You can do this with a Custom Query resource:

This was generated with the following SWQL query:

SELECT cp.UniqueName, cpsn.Status, TOSTRING(HOUR(TOLOCAL(DateTime))) + ':' + TOSTRING(MINUTE(DateTime)) AS [Last Poll Time]

FROM Orion.NPM.CustomPollers cp

JOIN Orion.NPM.CustomPollerStatusOnNodeScalar cpsn

ON cp.CustomPollerID = cpsn.CustomPollerID

WHERE NodeID = ${NodeID}

GROUP BY cp.UniqueName, cpsn.Status, DateTime

If you want to disregard certain UnDPs, you could just exclude them in the WHERE statement as such (this example excludes the battery temperate in Celsius):

SELECT cp.UniqueName, cpsn.Status, TOSTRING(HOUR(TOLOCAL(DateTime))) + ':' + TOSTRING(MINUTE(DateTime)) AS [Last Poll Time]

FROM Orion.NPM.CustomPollers cp

JOIN Orion.NPM.CustomPollerStatusOnNodeScalar cpsn

ON cp.CustomPollerID = cpsn.CustomPollerID

WHERE NodeID = ${NodeID} AND cp.UniqueName <> 'APCSmartUPSAdvBatteryTemperature'

GROUP BY cp.UniqueName, cpsn.Status, DateTime

Which yields:

- blsanner

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Awesome. Thanks!

That's awesome.  Can you rename the table from "Custom Query" to something useful such as "UPS Stats"?

Yes, when you are editing the Custom Query resource to enter the query, simply change the title to whatever you would like: