Version 2

    Simple query that shows downtime for interfaces this month, with information such as Bandwidth and a custom interface property also included. Status information based on values courtesy of sean.martinez post Orion Platform SWQL, Thwack! Now I got it.


    SELECT N.CAption as Device, I.Caption as Interface, INOD.DateTimeFrom, INOD.DateTimeUntilNow,

    INOD.State, INOD.TotalDurationMin, I.CustomProperties.Comments, I.InterfaceSpeed as Bandwidth

    FROM Orion.NPM.InterfaceNetObjectDowntime INOD left join Orion.NPM.Interfaces I on INOD.EntityID = I.InterfaceID left join Orion.nodes N on I.NodeID = N.Nodeid

    where INOD.entitytype = 'Orion.NPM.Interfaces'

    and INOD.State in (2,3,4,5,6,7,8,9,10)

    and month(INOD.DateTimeFrom) = MONTH(GETUTCDATE()) and year(INOD.DateTimeFrom) = year(GETUTCDATE())

    order by Device, Interface, Inod.DateTimeFrom


    Interface Downtime.jpg