The Monitor Applications Using SQL Queries contains a Management Pack that helps quickly deploy monitors based on SQL Queries.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.

README.md

OleDB query monitor

A Management Pack created by Uretzky Zvi for easily create monitors based SQL queries using System Center Operations Manager.

If you use this and you like it, invite me to a coffee :-)

Bitcoin Address: 1HPXi5M38F9zCtp1nciaGc15JdR48DrgVv

Ethereum Address: 0x6a34dab1c1e655bb1fab6279204c3eb4ea840e48

License

License

Features

  • Easy Authoring template to create and delete queries.
  • New! Support for SQL Authentication.
  • Dedicated views in SCOM console.
  • Performance data collection.
  • Monitor using consecutive samples condition and schedule filter.
  • Grouping multiple queries into a group.

Quick Start - Usage

Please always test new management packs in a test environment before importing to production!

Requirements

  • SCOM 2012 R2 (earlier versions are untested)
  • Microsoft SQL Management Packs.
  • SCOM Admin rights (only Administrators can import management packs)

Quick Start - Install

  1. Download QueryOleDbMonitorSetup.msi
  2. Run As Administrator the MSI file.
  3. Import the management packs into SCOM. All the MPs are in C:\Program Files (x86)\QueryOleDbMonitoring\ManagmentPasks MPs in folder
  4. Open Authoring find "OleDB Query Monitoring", click Add Monitoring Wizard Authoring tempaltes wizard step 1
  5. Follow the wizard instruction wizard step 2 wizard step 3 wizard step 4 Or with SQL Authentication wizard step 8 wizard step 5 wizard step 6 wizard step 7

The Alert ex. wizard step 10 Performace ex. wizard step 11 State ex. wizard step 12

  1. Enjoy!!!! :-)