Compartilhar via

Outages and Maintenance Report

  • Artigo

<!--[if lt IE 9]>

<![endif]-->

Comments

  • Anonymous
    January 01, 2003
    did you see this has been re-posted to http://www.systemcentercentral.com/Downloads/DownloadsDetails/tabid/144/IndexID/19769/Default.aspx

    • Anonymous
      July 20, 2016
      I get a 404 Page Not Found for the linkhttp://www.systemcentercentral.com/Downloads/DownloadsDetails/tabid/144/IndexID/19769/Default.aspx

  • Anonymous
    January 01, 2003
    Each data set references my custom data source.... so you would need to edit your modified RDL and change each dataset section to reference your datasource name. Sorry about that.... I totally didnt think to make this work directly on import.... using the built in warehouse data source.  I will fix it if I get some time.

    • Anonymous
      February 09, 2017
      Can you help me to get the server count in Maintenance Mode older than 7 days in SCOM 2012 using powershell command.

  • Anonymous
    January 01, 2003
    How would i modify the query to return data for the last 24 hours so i can schedule this report? Many Thanks!

  • Anonymous
    January 01, 2003
    That is correct Ravi.  I wrote this originally for a customer request, and I was having them add data into Custom frield 2,3, and 4: adv.CustomField2 as OutageType, adv.CustomField3 as RootCause, adv.CustomField4 as Reason, This way - when they got a computer down alert that was unexpected - their business process was to fill the data into these custom fields on those alerts, then.... if the server once investigates was going to be down for an extended period - they would place the server into unplanned maintenance mode if desired.

  • Anonymous
    January 01, 2003
    Who can edit it for SCOM 2012? The Maitenance window table i think was changed. I do not get any maitenance window report.

  • Anonymous
    June 12, 2009
    The comment has been removed

  • Anonymous
    July 30, 2009
    Thanks.  This report works like a charm and the bean-counters love it!

  • Anonymous
    August 13, 2009
    The comment has been removed

  • Anonymous
    August 13, 2009
    Kevin, Thank you so much for the rapid response. That was exacly my issue - thought I entered the correct data set and data source strings, but found a typo with the initial catalog portion of the string. Once I corrected the issue the report runs great. Your blog is great and your depth of knowledge of all things OpsMgr is amazing.

  • Anonymous
    September 23, 2009
    Sorry, probably stupid question. How import this report to SCOM ?

  • Anonymous
    September 24, 2009
    Question revoke. Nice report, thanks.

  • Anonymous
    October 02, 2009
    This report would be extremely helpful. Can you please tell me how to run this report? I dont mind doing the research I just need to have access to documentation. Point me in the direction and I will find it.

  • Anonymous
    December 01, 2009
    Great report!!  One question, how can I tailor it so I can exlcude weekends and only core hours?? Thanks  

  • Anonymous
    January 19, 2010
    The Custom Fields from The AlertDetail table are comming up as NULL, how can I set this up to show outageType, Reasaon, etc.?

  • Anonymous
    August 01, 2010
    Report works beautifully! Only issue i've found is that it only works for windows devices. I can't see the maintenance mode for SNMP devices. Can anyone think of a way to get it to work for SNMP devices aswell?

  • Anonymous
    August 11, 2010
    Just to add that; The entries (we have in the report, in the snapshot above as well) where Outage,Root Cause and Reason is BLANK and UserID is 'System' are the entries which shows the grayed out period of that agent. This is not exactly a maintenance windows of the agent instaed it is the time when agent was not communicating to RMS/MS. Kevin: could u pl. confirm this? Regards, Ravi

  • Anonymous
    August 11, 2010
    Sorry !! I didn't read the query completely. Blank rows are showing the outage only. Ravi

  • Anonymous
    February 27, 2012
    The comment has been removed

  • Anonymous
    March 04, 2012
    Sorry to ask.. Can some one please let me know how to run this query? I am new to this and in learning process.

  • Anonymous
    June 29, 2012
    Hello, I was able to change the query to use the "Today's date " - 42 by using SET @startdate =(Select Dateadd(day, -42, Getdate())) /* Today minus 6 wekks = 42 days */ but when running the report from the SCOM Console > reporting > Scheduled Reports > it still refers to a fix date in 2009??? Anyway toc change this? Thanks, Dom

  • Anonymous
    November 07, 2012
    Hi Kevin . I would like to thank you for this wonderful work for getting the Outage & maintenance report , however it seem that the dynamic group created in the SCOM Console are not visible in this reports. do you have anything on top of your mind which can add that in this report.

  • Anonymous
    October 25, 2014
    The comment has been removed

  • Anonymous
    June 09, 2017
    You actually make it seem so easy with your presentation however I find this matter to be really one thing which I believe I'd never understand. It kind of feels too complicated and extremely huge for me.I'm having a look ahead for your subsequent submit, I will attempt to get the grasp of it!