Answered by:

ConfigMgr 2012 Maintenance window report by date

Question

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.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.