Steve Thompson nous propose une requête pour créer un rapport contenant la liste des fenêtres de maintenance, leur description, les serveurs rattachés avec leur système d’exploitation.
Voici cette requête :
[pastacode lang= »sql » message= » » highlight= » » provider= »manual »]
-- List Computers with Maintenance Window
SELECT sw.Name AS [MW Name], sw.Description,
sw.StartTime,
sw.Duration AS 'Duration Minutes',
sw.IsEnabled AS 'MW Enabled',
sys.Name0 AS ServerName,
sys.Operating_System_Name_and0 AS OperatingSystem
FROM dbo.v_ServiceWindow AS sw INNER JOIN
dbo.v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionID
INNER JOIN dbo.v_R_System sys ON fcm.ResourceID = sys.ResourceID
WHERE (sys.Operating_System_Name_and0 LIKE '%server%')
ORDER BY [MW Name], sys.Name0
[/pastacode]