Comments
3 comments
-
Okay,
the first question is answered as we tried it yesterday:
If the machine (host) is in a alert suppression window, the instances will not raise any alerts.
The second question on how to add a machine as a target for the update-sqlmonitoralertsuppressionwindow cmdlet is still open.
Kind Regards,
Borru -
Second Question is also answered. I was finally able to find out how to update the targets. For anyone interested, this is how you do it:
$alertSuppressionWindow = Get-SqlMonitorAlertSuppressionWindow -Name $WindowName $alertSuppressionWindow.Targets += $machine[0] $alertSupressionWindow | Update-SqlMonitorAlertSuppressionWindow$machine = Get-SqlMonitorMachine
Kind Regards,
Borru -
Hi Borru,
Apologies we didn't respond to you sooner, looks like there was a brief issue with the mechanism that generates tickets internally from our forum. Glad you were able to resolve this, please let us know if you require any further assistance with SQL Monitor.
Add comment
Please sign in to leave a comment.
I have two questions which are connected:
1. If the host machine (which may run several instances) is in a downtime window and the instances are not, will the instances still raise alerts or are they suppressed as the host machine is already in a downtime window?
2. How can I update the Targets of a configured Alert Suppression Window with the help of the Powershell API:
We have patch days here and a subset of machines machines are in different patch day groups.
I have configured to suppress alerts based on tags for the instances, but since only instances can be tagged and host machines not, I want to update the alert suppression windows with the help of the powershell API to include the host machine.
I have tried the following:
Kind Regards,
Borru