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 3.1 - Trying to get results of SQL query into APM

I have written a simple SQL query which looks at the number of queued emails in our Remedy system and the APM template 'seems' to work however my Statistic's data never shows anything other than 0.00. I can run the query from a command line and see a number but why can't I see this in APM?

The goal is to be able to monitor this in APM using a SQL query so I can then alert if it goes over a certain threshold.

Find more posts tagged with

Accepted answers

All comments

RogerWong

Can you post the SQL query?

FormerMember

select count(*) As Queued_Emails
from AR_System_Email_Messages
where send_message in (1,2)

jiri.tomek

Hello sotherls,
What is component status with this query? Is it Up even if statistic is 0.00? Are you sure that at the moment of poll there are some messages in queue? Try to modify your query like this:

select count(*)+10 As Queued_Emails
from AR_System_Email_Messages
where send_message in (1,2)

Now check if statistic is still 0.00 or if it goes to 10.00. If it is not zero anymore, problem would be count(*) returning zero.

FormerMember

Good idea! I tried this and yes, it increased to 10. Now the question is why doesn't the original query result in data? From the command line of the Orion server run it with the following syntax and it brings back data.

osql -S 1xx.1xx.1xx.1xx -U UserName -P Password -Q "select count(*) As Queued_Emails from AR_System_Email_Messages where send_message in (1,2)"
----------
76

Is there a log or something or any other testing I can do to see what it is doing in the background?