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