SCCM 2007 SQL Query Code - Help Needed
Oops, I forgot to put the code I used, sorry about that. Here is the code that worked for me:


  SELECT 


v_FullCollectionMembership.Name as [Computername],
v_Collection.Name as [Collections With Maintenance Windows], 
v_ServiceWindow.Description as [Maintenance Description], 
v_ServiceWindow.StartTime as [Maintenance Window Start Time], 
v_ServiceWindow.Duration as [Maintenance Window Duration],
v_GS_OPERATING_SYSTEM.Caption0 as [Operating System]


FROM 

v_ServiceWindow  
Join 
v_Collection on v_Collection.CollectionID = v_ServiceWindow.CollectionID
Join
v_FullCollectionMembership on v_FullCollectionMembership.CollectionID = v_ServiceWindow.CollectionID
Join
v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_FullCollectionMembership.ResourceID
Join
v_R_System on v_R_System.ResourceID = v_FullCollectionMembership.ResourceID


WHERE

(v_GS_OPERATING_SYSTEM.Caption0 Like '%Server%')
or
(v_FullCollectionMembership.Name Like 'WN%')


ORDER BY 

[Computername]