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

Alert on a SQL User Experience Monitor by running another SQL querry

Hi all,

I have a SQL User experience monitor that runs a query. This query looks at a database that contains messages in several message areas, does a count, and adds up values from each. It reports this value to Orion. If the total is over 15000, Orion sends an alert. This works fine, but here is what I want it to do:

When there are over 15000 messages total, I would like a second query to run. This query looks at the individual message areas to see if the count is over 750. It then returns however many rows it needs to to show all of the message areas that have over 750 messages. I would like to take these rows and send them in as part of an alert. Basically the alert should be structured something like:

Warning: There are 15,024 messages

List of inboxes with over 750 messages:

Inbox 1: 775

Inbox 2: 827

Inbox 3: 755

Any ideas on how to do this? I have the SQL query that lists the inbox names, I just have to figure out how to get that information into an alert.

Do I need a custom application monitor to run this query on a regular basis to store the data in Orion? Can I have a trigger set off a SQL query on a SQL server that isn't the Orion DB?

Thanks for any advice you can give. pm

Find more posts tagged with

query

sql

apm

Accepted answers

All comments

aLTeReGo

Your best bet would be to trigger an alert when the total number of messages is over 15000 as you're doing now, but then define the Trigger Condition within the Advanced Alert Manager to execute a script that gathers the additional information you need as part of the alert. You can then populate that information into the Alert notes field using the Orion SDK, or simply pass the information directly via email as part of the same script using Blat.

mjbehrendt

Here is what I ended up doing:

I created a SQL query that totals up the messages in all mailboxes. If it is under 15,000, it exits, returning a result of 1. If it is over 15,000, it checks a specific mailbox for the number of messages and returns that number as a result. I then duplicated this 35 times for each mailbox I need to monitor and set the queries as SQL user experience components in a new Application. It's obviously not the most efficient way of doing things; I have to use 35 licenses where I should only have to use one, but it gets the job done.

aLTeReGo

I'm glad you were able to get it working. If you think it might be useful for others you might want to consider posting your template to the Content Exchange.