Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to locate SQL table/column containing a specific Universal value.

Hi:

I created a Universal Poller to capture time on battery statistics (upsBasicBatteryTimeOnBattery). The poller is functioning and creating values... I'm not able to find the table/column containing the value though. I checked all the CustomPoller* tables, and just about any table that looked like it might have the value.

Anyone have ideas where I might look or how I might find the container with the value?

My reason for wanting this is to add the value in the alert email.

Thanks in advance,

Glenn.

Find more posts tagged with

Accepted answers

All comments

qle

I'm almost certain the CustomPollerStatistics* tables hold the information you're looking for. If you're looking to include the value in an e-mail by way of an SQL query, you'll want the CustomPollerStatistics_Detail table. The column you're looking for will probably be RawStatus or Status.

gbutler

I suspect you are correct. The reason its not working for me might be due to an on-going issues we have been experiencing.

The database shows that this table stopped getting updates on the 12th of this month. We have an on-going problem with Orion missing data... I'm wondering if this is one more of our symptoms. I'll bring this up with support and see.

Thanks.

Glenn.