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

APM Component Monitor for tracking Full SQL query and publishing in Table

How can we create a Compnent monitor for SQL/Oracle database which can be published as a Table on the web.

Scenario:

There is one query which returns multiple values for multiple database instances hosted on one Database Server in form of table.

e.g. db_name Perc

xyz 95.67

abc 97.22

and so on.....

Find more posts tagged with

Accepted answers

All comments

ShamChauthani

Nizar,

APM supports out of the box SQL Queries that can be deduced down to a single statistic value. This is done to allow APM to appropriately evaluate the up/down/critical status of the component based on that stat. So if you can somehow deduce the data in the table to a relevant stat (like number of rows or some other calculation) then you can use the SQL user experience monitor.

However if you do want to capture the output of the table then you may want to consider creating a script component that runs the query using ADO or another method and stores the results of the query in the Message component of the script results.

HTH
Sham

Nizar

Hi Sham,

Thank you very much for your input.

Regards,

Nizar

saby

Hi Sham,

I have the same query from one of our clients. Client wants to run queries on Sybase\Oracle\SQL databases which provide multiple values. I am able to run queries which returns single values but queries which returns multiple values fails. How to get multiple values on APM (specially database size and table size) ? I couldn't understand your answer in this post. Please explain.

KenKasmar

Using a Script component rather than a User Experience SQL Query component can return two bits of infomration to APM, one Statistic and a text field designed to contain a Message relating to the poll (Query Succeeded, Operation Timed Out, etc). Sham is suggesting using this Message field to jam your multiple values into as it is the only other way an APM component can return data.

Of course once it's in the Message field, I don't know if that is stored historically so you would probably only have the data from the last poll. Also I'm not sure how you would get the data out and reformated in a meaningful way within the available Orion resources.