How can I make a report showing 'scheduled maintenance' windows?

wknaap

When maintenance is planned for some nodes/interfaces.

We want a view to get the overview instead of using the list under 'manage node'

When using the reportwiter only active windows are shown

wknaap

Script made with report-writer.    Use this report to display the list.

######################################################################

select 

        Nodes.NodeID,

        NULL InterfaceID,   Nodes.Caption as NodeName,   Nodes.IP_Address as IP_Address,   null InterfaceName,

        DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Nodes.UnmanageFrom) as UnmanageFromLocal,

        DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Nodes.UnmanageUntil) as UnmanageUntilLocal

from Nodes where   UNMANAGEuntil  >  (getdate())    or  Nodes.Unmanaged   = 1

union

select

        Interfaces.NodeID,    Interfaces.InterfaceID,   Nodes.Caption as NodeName,   Nodes.IP_Address as IP_Address,

        Interfaces.InterfaceName as InterfaceName,  

         DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Interfaces.UnManageFrom) as UnManageFrom,

         DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Interfaces.UnManageUntil) as UnManageUntil

from Interfaces join Nodes

         on Interfaces.NodeID = Nodes.NodeID

where  interfaces.unmanageuntil > (Getdate())   or Interfaces.UnManaged  = 1 and Nodes.Unmanaged !  = 1

order by 2 asc  -- interface

######################################################################