Maintenance Mode Scheduling revealed!

Which feature was the most expected in Operations Manager? Maintenance Mode Scheduling. Which feature was given for us in SCOM Technical Preview 2? Maintenance Mode Scheduling. I thought WOW, this must something the whole admin population must be thrilling about. And as I saw on twitter – it was. So let’s see what’s all the fuss about.

After installation of Technical Preview 2 from VHD file available from my previous post I was given a nice little pop-up as always.

scomtp1   scomtp2

After launching, nothing really has changed in the main monitoring view. So my first click was an Administration panel in SCOM wunderbar (bottom left pane). So except Operational Insights (which will be described in later posts) my sight was already there – Maintenance Schedules entry.

scomtp3

Clicking it revealed a new pane for Maintenance Mode Scheduling.

scomtp4

Nothing else to do but start playing with it – thought. So let’s try doing the first schedule. Click on the right pane to Create Maintenance Schedule.

scomtp5

Because I have only one server (the MS itself) I had to choose something, that will not affect the total health of it. After thinking for a while I’ve chosen Operating System class and all objects underneath.

scomtp6

Accepting this moved us to second pane – scheduling. This is the best part as you can schedule a maintenance once, daily, weekly, monthly, set start and end date, length and expiry date of the schedule!

scomtp8

Lastly, the details of maintenance. So let’s give it a name and reason then…

scomtp9

After quick run through the wizard, I was given a proper entry in the Maintenance Schedules pane.

scomtp10

…and after few minutes…

scomtp11

… both MM was enabled and the object was properly put in MM too.

scomtp12

CONCLUSION: IT WORKS!

Backyard

It’s all there in the database. If you like to play with it, you can drill down into OperationsManager database and what will be found is:

  • VIEW: dbo.MaintenanceModeView
  • TABLES: dbo.MaintenanceMode, dbo.MaintenanceModeSchedule and dbo.MaintenanceModeHistory

Querying those give you good insight on what’s going on and what happened in the past:

scomtp16

QUERYING VIEW

scomtp14

QUERYING SCHEDULE TABLES

scomtp17

QUERYING HISTORY TABLES

scomtp18

QUERYING MAIN TABLE

scomtp15

As you see, there’s a ScheduleId column (which is not added in the view) which goes exactly to MaintenanceModeSchedule table. You can link both tables to get more info in one result set.

Whole work (adding, deleting, launching, editing etc.) is being done by stored procedures, which are added to handle schedules.

scomtp19

Happy scheduling 🙂

Advertisements

Posted on May 6, 2015, in Uncategorized. Bookmark the permalink. 2 Comments.

  1. Thank you for the detailed overview, is the configuration option only available in the Administration pane? Have you seen cmdlets that allow MaintenanceMode schedules to be created? – Thank you

  2. Hello Yannick. I’ve been looking through it, but no commandlets yet. I’m wondering that there might be some new ones in v2 of OpsMgr cmdlets (it appears that there might be some)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: