I was search the internet a while back and found the below code for getting all the information on the Cellular interfaces. I am looking for some help to be able to also narrow this query down to 7 days or one month if possible. I am also looking for something a bit more punchy for the boss. If someone / anyone can help me please i beg you.
SELECT
intf.Node.NodeName AS Node,
'/Orion/images/StatusIcons/Small-' + intf.StatusIcon AS [_IconFor_Node],
intf.DetailsUrl AS [_LinkFor_Node],
'' AS [RX],
'/Orion/images/ForecastingIcons/trenddown.png' AS [_IconFor_RX],
(TOSTRING(CEILING(intf.Inbps * 10) / 10) + ' bps') AS [bps↓],
(TOSTRING(CEILING(intf.InPps * 10) / 10) + ' pps / ' + TOSTRING(CEILING(intf.InPktSize * 10) / 10) + ' bytes') AS [pps/packet↓],
CASE WHEN intf.InPps > 0
THEN
(TOSTRING(intf.InUcastPps / intf.InPps * 100) + '% / ' +
TOSTRING(intf.InMcastPps / intf.InPps * 100) + '%')
ELSE '0% / 0%'
END AS [Ucast/Mcast↓],
CASE WHEN intf.InPps > 0
THEN
(TOSTRING(((intf.InErrorsThisHour) / intf.InPps * 100)) + '% / ' +
TOSTRING(((intf.InDiscardsThisHour) / intf.InPps * 100)) + '%')
ELSE '0% / 0%'
END AS [Error/Discard↓],
'' AS [TX],
'/Orion/images/ForecastingIcons/trend.png' as [_IconFor_TX],
(TOSTRING(CEILING(intf.Outbps * 10) / 10) + ' bps') AS [bps↑],
(TOSTRING(CEILING(intf.OutPps * 10) / 10) + ' pps / ' + TOSTRING(CEILING(intf.OutPktSize)) + ' bytes') as [pps/packet↑],
CASE WHEN intf.OutPps > 0
THEN
(TOSTRING(intf.OutUcastPps / intf.OutPps * 100) + '% / ' +
TOSTRING(intf.OutMcastPps / intf.OutPps * 100) + '%')
ELSE '0% / 0%'
END AS [Ucast/Mcast↑],
CASE WHEN intf.OutPps > 0
THEN
(TOSTRING(((intf.OutErrorsThisHour) / intf.OutPps * 100)) + '% / ' +
TOSTRING(((intf.OutDiscardsThisHour) / intf.OutPps * 100)) + '%')
ELSE '0% / 0%'
END AS [Error/Discard↑]
FROM Orion.NPM.Interfaces intf
WHERE intf.InterfaceName LIKE 'Ce%'
ORDER BY (intf.Inbps + intf.Outbps) DESC
