View Limitation and Custom Mib Poller Summary

Question

I have a Node Summary view that I have created to show all of our UPS devices.  I have a view limitation using a Node Name Pattern *-UPS*.

This works perfectly.  The view is limited to just our UPS' and shows only the node list, the last 50 events and the last 100 syslog messages from our UPS devices.  This is especially important because Last 50 events DOES NOT support the filtering feature found on many of the web components.

My problem is that I wanted to include the battery status for each device using a custom mib poller.  The poller works fine in the configuration,  it displays fine on the node details for each UPS, but, on the above summary view I get the error SQL Open Error: Incorrect syntaxt near the keyword 'Where'

If I take the view limitation out it works fine but all of my nodes are in the view which defeats the purpose.

Anybody else seen this or have a resolution?

ewattnem · Answer

You're not the only one

Check this out 
http://www4.solarwinds.net/SolarWindsForum/topic.asp?TOPIC_ID=3325&SearchTerms=SQL,Open,Error

It's a bug.

What I did was made a seperate UPS login that only displays the UPS custom pollers.  It's a pain but works for me.