Skip to content
IMPORTANT NOTE: The latest version of the management pack is now available for free download at
C#
Branch: master
Clone or download
Latest commit 3de42b6 Apr 25, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Images
ManageQueryOleDbMonitorUI
ManagementPacks
QueryOleDbMonitor
QueryOleDbMonitorLibrary
QueryOleDbMonitorSetup v 2.1 Oct 22, 2017
QueryOleDbMonitorTemplate
.gitattributes
.gitignore Initial commit May 28, 2017
LICENSE
QueryOleDbMonitor.sln
QueryOleDbMonitorSetup.msi
README.md Update README.md Apr 25, 2019
_config.yml

README.md

Database Query Result Monitoring Management Pack for SCOM

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

IMPORTANT NOTE: The latest version of the management pack is now available for free download at Free Management Packs - Savision

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 (Deprecated! For a new version click here)

  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!!!! :-)
You can’t perform that action at this time.