<< Click to Display Table of Contents >> Navigation:  Technical Guide > Monitoring and Collecting > SQL Monitor

Using SQL Monitors, you may periodically execute SQL queries against a database and generate a variety of notification options. SQL Monitors support default and named instances, and Windows and SQL Server authentication, making it easy to fit into your existing SQL security environment.

Properties

 

Instance Name: ELM gets the SQL server name from the agent where the monitor is assigned.  If an instance name is used, enter it in this box.

Query: Enter a SQL query to be executed by the monitor. An event will be triggered if the results are different from the last time the query was run.

Use Integrated Logon check box:  The SQL Monitor supports SQL Authentication and Mixed Mode Authentication.  By default this box is check and will use the credentials the ELM server service is using.  If you are using SQL authentication, un-check the Use Integrated Logon checkbox, and enter the username and password ELM will use when executing the Query.

Actions

Warning 5538 - The SQL query results are different from the results the last time the query ran.

 

Monitor Assignments

Assign the writer to a group of servers by selecting a monitoring category.

Scheduling

 

Specify the interval at which the monitoring, polling or action is to occur. Depending on the Monitor Item type, Items can be scheduled in interval increments of Seconds, Minutes, Hours and Days. The Scheduled Interval is relative to the top of the hour or top of the minute. For example, if a Scheduled Interval is configured for 10 minutes, the Monitor Item will execute at hh:10:00, hh:20:00, hh:30:00, hh:40:00, hh:50:00, h1:00:00, etc. If a Scheduled Interval is configured for 15 seconds, the Monitor Item will execute at hh:00:15, hh:00:30, hh:00:45, hh:01:00, hh:01:15, etc.

 

 

Exclusion Configuration

 

Specify day(s) of week when you do not what the scheduled item to run.

 

 

Naming

 

Enter the name of the item and give it a description.

 

Event Category

This allows you to assign a custom category for the Action event.  This custom category may then be used in filtering and notifying later.

 

Enabled

Use this check box to enable/disable a monitor item.