ConfigMgr 2012 Maintenance window report by date


  • The "Maintenance windows available to a specified client" report is helpful if I want to check on maintenance windows scheduled for 1 machine. 

    I'd like to create a report that lists the specific date, time and duration of maintenance windows available to a computer in a collection for a given date range.

    It looks like I'll need to calculate the intersection of the specified date range and the information from the Description, StartTime, and Duration fields in the ConfigMgr database views by parsing the text in the description field and doing a calculation to determine if "the second Thursday of every month" (from the description field) is part of my chosen date range.  Is there a better way to do that other than parsing the description field?

    Ultimately, I'd like to produce a report that allows me to select a date range and computer(s) and I get back a calendar type table with dates and computers that have matching maintenance windows. 

    Thursday, May 23, 2013 10:32 PM


All replies