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

Custom Query Statement help.

I am by far not an expert SQL person, so I am hoping someone here can help me.

I want to create a table of all our UPS's and display certain stats in it. These stats are collected from Universal device pollers which I already have created.

What I am looking for is something like this:

Node Input V Output V Current Battery % Status

ups1 123 123 10 100 onLine

ups2 123 123 15 100 onLine

Can someone help me get started on this. I know there is a way, I just cant figure it out.

Thank You!

Find more posts tagged with

Accepted answers

chrkov

This is exactly what I needed.

modify SWQL query to include node names

All comments

d09h

Are these stats from a universal device poller? If so, put the pollers in a group. Helps immensely and makes it less of a SQL exercise.

d09h

Re: Combine two UDPs on a line in a report

Group creation can help:

How to Set Up Multi-Column Table With Custom Device Poller

d09h

I have also handled this by matching the common part of the OIDs....as many digits as are common. Before I knew about sticking pollers in groups.

chrkov

This is exactly what I needed.

modify SWQL query to include node names

d09h

Do you have the SAM module? The red dot icon next to the out of range temp was a big hit where I used it. Hint--set a low threshold temporarily for test purposes.