Monitor SQL Database Free space

This example will show a way to customize monitoring of SQL servers for database free space on VM's in Azure. Note this is example will be with VM's hosted on Azure. If you want to simulate with on prem servers see hybrid runbook worker overview: Azure Automation Hybrid Runbook Worker overview | Microsoft Docs First … Continue reading Monitor SQL Database Free space →

Set SCOM maintenance mode when all servers in a list are down

I had a customer request where they had relatively consistent errors with a give network and they wanted to suppress alerting when they had this issue arise. I wrote a PowerShell script that would ping the servers in a file and if all failed would set maintenance mode for a SCOM group of servers. Below … Continue reading Set SCOM maintenance mode when all servers in a list are down →

Infrastructure – System Center Operations Manager – SQL Query for SCOM Maintenance mode schedules

SCOM maintenance schedules list views only display names and comments. In order to view affected objects you are required to open the schedules to see the server list. This SQL query will display semicolon delimited list of the affects objects for each schedule. Below is a SQL query you can utilize to see all SCOM … Continue reading Infrastructure – System Center Operations Manager – SQL Query for SCOM Maintenance mode schedules →