search

imajaydwivedi / SQLDBATools

Powershell Module containing cmdlets for carrying out SQL DBA activities.
https://ajaydwivedi.com
MIT License
13 stars 6 forks source link

Enhancements - Alert Sdt-DiskSpace by Client, Severity #45

Closed imajaydwivedi closed 2 years ago

imajaydwivedi commented 2 years ago

Raise Alert for all servers group by Client, Severity. Take minimum value of $DelayMinutes from AlertRules table.

Add alert clearing for Wrapper-SdtDiskSpace Failed.

Create a separate job to clear all the alerts on timely basic. Maybe this can check dbo.sdt_alert table, fetch alert_key, state, severity, email_to, id.

imajaydwivedi commented 2 years ago

Added Alerting by Alert Key, Severity, & Client.

Also, details like client, severity, delay, emails etc can be defined in dbo.sdt_alert_rules.

image