Hey guys,
this report used to work for me and now it doesn't anymore, do any of you know why do I get "query not valid"?
Thanks
SELECT
I.InterfaceID,
N.NodeID,
N.Caption AS NodeName,
N.DetailsUrl AS NDetailsUrl,
N.VendorIcon AS Vendor,
I.Caption AS Interface_Caption,
I.InterfaceIcon AS Interface_Icon,
I.DetailsUrl AS IDetailsUrl,
AverageInboundBps90th,
AverageOutboundBps90th,
AverageInboundBps95th,
AverageOutboundBps95th,
AverageInboundBps99th,
AverageOutboundBps99th
FROM
(
SELECT
InterfaceID,
AverageInboundBps90th,
AverageOutboundBps90th,
AverageInboundBps95th,
AverageOutboundBps95th,
AverageInboundBps99th,
AverageOutboundBps99th
FROM Orion.NPM.InterfacePercentiles
WHERE [DATETIME] > AddDay(-7, GETUTCDATE())
) AS IP
JOIN Orion.NPM.Interfaces I ON I.InterfaceID = IP.InterfaceID
JOIN Orion.Nodes N ON I.NodeID = N.NodeID
