Maintenance Window
SELECT v_Collection.Name, v_Collection.Comment,v_ServiceWindow.Description, v_ServiceWindow.StartTime, v_ServiceWindow.Duration
FROM v_ServiceWindow
JOIN v_Collection ON v_Collection.CollectionID = v_ServiceWindow.CollectionID
ORDER BY v_Collection.Name
Maintenance Window with Server Details
SELECT sw.Name AS [MW Name], sw.Description,
coll.Name as [Collection Name],
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 v_Collection as coll on fcm.CollectionID = coll.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
No comments:
Post a Comment