Но если очень хочется и есть мощности на сервере мониторинга и БД, то можно проверять при помощи PowerShell.
Например, Sample Management Pack - Wizard to Create Powershell-based Monitors - https://gallery.technet.microsoft.com/Sample-Management-Pack-17b76379
Example of setting up a custom monitor in SCOM with a Powershell Script – Monitor NIC teams in SCOM - http://blog.ctglobalservices.com/powershell/clm/example-of-setting-up-a-custom-monitor-in-scom-with-a-powershell-script-monitor-nic-teams-in-scom/