Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

inactivate alerts with powershell

232 views
Skip to first unread message

smg

unread,
Nov 12, 2008, 5:47:00 AM11/12/08
to
hi,
due to some errors on my dpm server I have nearly 400 alerts to do with
backu jons.
The error is now fixed but I want to inactivate the alerts. As the ability
to select more than one alert at a time seems to be omitted by Microsoft how
do I dismiss all the alerts without having to click on each one and then
choose inactivate alert?

can this be done via powershell?

thanks

Marco Shaw [MVP]

unread,
Nov 12, 2008, 3:13:50 PM11/12/08
to

(I'm not a DPM expert, but will try to help.)

Seems like something pretty useful. I checked a listing of cmdlets that
I have from DPM, and don't see anything relevant.

Sorry, I don't think PowerShell can do this...

PowerShell could possibly automate keystrokes though.

Marco

--
*Microsoft MVP - Admin Frameworks
https://mvp.support.microsoft.com/profile/Marco.Shaw
*PowerShell Co-Community Director - http://www.powershellcommunity.org
*Blog - http://marcoshaw.blogspot.com

Madhan S [MSFT]

unread,
Nov 15, 2008, 9:25:33 AM11/15/08
to
Marco is right. There is no support for inactivating alerts through
Powershell. We will definitely consider this feature for our future releases
(including the multiselection in DPM Console)

--
--
Thanks
Madhan S

This posting is provided "AS IS" with no warranties, and confers no rights
"Marco Shaw [MVP]" <marco.shaw@_NO_SPAM_gmail.com> wrote in message
news:eQN7wNQ...@TK2MSFTNGP04.phx.gbl...

philipgray

unread,
Feb 1, 2010, 8:36:47 AM2/1/10
to
OK, firstly a disclaimer: I don't support this approach and neither will anybody else. Backup your databases, snapshot your servers before trying this etc etc. and don't come crying if it does something terrible.

I like DPM and I hate having to do this but the UI and powershell support in this area is a joke - even on just a few servers, a bad tape or a network issue can give you hundreds of events in the space of a weekend and no support for inactivating events en-masse is not just silly, its dangerous - you end up just ignoring alerts which just isn't good.

Thats the situation I found myself in and I wasn't prepared to just sit there with hundreds of unresolved events forever. So, I traced the DPM database while inactivating a couple of alerts through the DPM UI.

I then pulled apart the stored procedures that were called from DPM and looked at the tables that were being altered.

After a morning spent doing that I backed up my DBs etc. and ran the following script:

UPDATE dbo.tbl_AHP_Alerts
SET
ResolvedTime = getdate(),
Resolution = 2,
EmIntegration = 1
WHERE
Resolution <> 2

Obvioulsy, this is brutal and may yet come back to haunt me, but it worked. It works in exactly the same way as the prc_ahp_alert_resolve stored proc and it inactivated all of my alerts. Admittedly, there are a couple of other procs that this misses out but the end result seems solid.

As I said at the start, I hate this as much as anyone, but I like DPM and I now have a nice, healthy list of protection groups again.

Use it at your own risk though.

Madhan S [MSFT] wrote:

Marco is right. There is no support for inactivating alerts through Powershell.

15-Nov-08

Marco is right. There is no support for inactivating alerts through
Powershell. We will definitely consider this feature for our future releases
(including the multiselection in DPM Console)

--
--
Thanks
Madhan S

This posting is provided "AS IS" with no warranties, and confers no rights
"Marco Shaw [MVP]" <marco.shaw@_NO_SPAM_gmail.com> wrote in message
news:eQN7wNQ...@TK2MSFTNGP04.phx.gbl...

Previous Posts In This Thread:

On Wednesday, November 12, 2008 5:47 AM
sm wrote:

inactivate alerts with powershell


hi,
due to some errors on my dpm server I have nearly 400 alerts to do with
backu jons.
The error is now fixed but I want to inactivate the alerts. As the ability
to select more than one alert at a time seems to be omitted by Microsoft how
do I dismiss all the alerts without having to click on each one and then
choose inactivate alert?

can this be done via powershell?

thanks

On Wednesday, November 12, 2008 3:13 PM
Marco Shaw [MVP] wrote:

Re: inactivate alerts with powershell
smg wrote:

(I'm not a DPM expert, but will try to help.)

Seems like something pretty useful. I checked a listing of cmdlets that
I have from DPM, and don't see anything relevant.

Sorry, I don't think PowerShell can do this...

PowerShell could possibly automate keystrokes though.

Marco

--
*Microsoft MVP - Admin Frameworks
https://mvp.support.microsoft.com/profile/Marco.Shaw
*PowerShell Co-Community Director - http://www.powershellcommunity.org
*Blog - http://marcoshaw.blogspot.com

On Saturday, November 15, 2008 9:25 AM
Madhan S [MSFT] wrote:

Marco is right. There is no support for inactivating alerts through Powershell.
Marco is right. There is no support for inactivating alerts through
Powershell. We will definitely consider this feature for our future releases
(including the multiselection in DPM Console)

--
--
Thanks
Madhan S

This posting is provided "AS IS" with no warranties, and confers no rights
"Marco Shaw [MVP]" <marco.shaw@_NO_SPAM_gmail.com> wrote in message
news:eQN7wNQ...@TK2MSFTNGP04.phx.gbl...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Converting a Collection into a DataTable using Generics
http://www.eggheadcafe.com/tutorials/aspnet/a0beac5f-c952-4ef9-b192-f919f2bd6a46/converting-a-collection-i.aspx

0 new messages