Hi everyone, I'm currently building an Opalis Policy that will automatically put into maintenance mode, in Operations Manager, computers for which a service window will occur in the next x minutes. Currently, I'm simply running the following query to the SCCM DB. SELECT * FROM v_ServiceWindow That gives me the start time of each service window and that's work great, excepted for the Service windows that are recurring. I'm looking for a way to get the start time of every service window, including the ones with a recurrence type. Do you have an idea on how to retrieve that information ? Thanks ChristopherChristopher Keyaert - MVP - My SCUG.be blog : http://scug.be/blogs/christopher

This info can be found within the SDK. http://msdn.microsoft.com/en-ca/library/cc143300.aspx http://www.enhansoft.com/

Hi, Thanks for your reply, I tried the following command : get-wmiobject -class "SMS_ServiceWindow" -namespace "root\SMS\Site_xxx" which doesn't return anything. Is there something that I missed ? Thank you ChristopherChristopher Keyaert - MVP - My SCUG.be blog : http://scug.be/blogs/christopher

Hi, Thanks for your reply, I tried the following command : get-wmiobject -class "SMS_ServiceWindow" -namespace "root\SMS\Site_xxx" which doesn't return anything. Is there something that I missed ? Thank you ChristopherChristopher Keyaert - MVP - My SCUG.be blog : http://scug.be/blogs/christopher

I found an another way to get this value, Adam Weigert posted a really nice SQL query that get the ServerName and the Next scheduled Service Window : http://social.technet.microsoft.com/wiki/contents/articles/7870.sccm-2007-create-report-of-upcoming-maintenance-windows-by-client.aspx Christopher Keyaert - MVP - My SCUG.be blog : http://scug.be/blogs/christopher

I found an another way to get this value, Adam Weigert posted a really nice SQL query that get the ServerName and the Next scheduled Service Window : http://social.technet.microsoft.com/wiki/contents/articles/7870.sccm-2007-create-report-of-upcoming-maintenance-windows-by-client.aspx Christopher Keyaert - MVP - My SCUG.be blog : http://scug.be/blogs/christopher