SQLMonitor Powershell Change Custom Metric Alert Name and descriptions

brenttempleton

Searching the Powershell API documentation and I don't see anywhere that we can create/update/delete custom metrics and alerts.   Is this possible?

Ben_P

Hi @brenttempleton, thank you for your post. 

You may be able to modify existing alerts for custom metrics, but you wouldn't be able to set up the custom metric itself. 

To modify the Custom metric alert you can use the Custom Types: https://documentation.red-gate.com/sm/api/powershell-api/custom-types

Also see https://documentation.red-gate.com/sm/api/powershell-api/powershell-cmdlet-reference/update-sqlmonitoralertspecificsettings for the syntax