Maintenance window query

Question

I need a query to get all the maintenance window, I need the collection name, collection ID, MW name, schedule, duration, apply to(All deployments, Software updates, Task Sequences) .

Anyone can help me?

Answer 1

Hi, @liven stool

Thank you for posting in Microsoft Q&A forum.

Check this query:

select c.Name as CollectionName,c.CollectionID,sw.Name as SWName,sw.Description as schedule,sw.Duration,

case

when sw.ServiceWindowType=1 then 'All deployments'

when sw.ServiceWindowType=4 then 'Software updates'

when sw.ServiceWindowType=5 then 'Task sequences'

end as 'Apply to'

from v_ServiceWindow sw

join v_collection c on c.collectionid=sw.CollectionID

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Answer 2

Select c.Name, sw.*

from v_ServiceWindow sw

join v_collection c on c.collectionid=sw.CollectionID