SQL Always On Availability Group Listener monitoring management pack
Requirements: Note: This is specifically for AOAG Listeners and does not include DNN at this time. Discovery This MP contains a single discovery workflow which targets the MSSQL on Windows: Local DB Engine class and uses two PowerShell modules. The first module will query the SQL instance to obtain information about all known SQL Availability …. Read More
Configure default schema for SCOM management pack fragments in Visual Studio / VSAE
If you’ve ever used Visual Studio with the Visual Studio Authoring Extensions (VSAE) for authoring a management pack for SCOM you have likely run into the annoying problem where VS forgets how to identify the schema for SCOM stuff which causes Intellisense to fail. I can’t explain why it sometimes will or won’t auto load …. Read More
Reset SCOM Object Health and Alerts Task
Newly added to the SCOMAgentHelper management pack is a task that is capable of: In the example below you can see the Exchange Online service object has alerts generated from both a rule and a monitor. The task parameter, “ResetMontitorHealth”, is true and therefore will reset the health of the eligible monitors for the instance. …. Read More
SCOM Console Web Page View: index of all rules and monitors with knowledge articles
Required: Create a new Rule. Create a new MP with name: “IndexOfWorkflowKnowledge” Rule Name: GenerateWorkflowIndex Timed PowerShell Script RuleRule Target: Management ServerRule is not enabled. Override: ENABLE for one specific mgmt server to start with, the one you connect to with your Console. Add additional mgmt servers if needed. Create a new Web Page View …. Read More
Microsoft.SQLServer.Windows.Monitoring SQL Queries (v7.0.42.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Microsoft.SQLServer.Windows.Discovery SQL Queries (v7.0.42.0)
Now that the SQL maagement packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Microsoft.SQLServer.Windows.Monitoring SQL Queries (v7.0.38.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Microsoft.SQLServer.Windows.Discovery SQL Queries (v7.0.34.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
On Demand Assessments for Unified Support Customers – A SCOM Example with gMSA
Unified Support includes free on-demand assessments.