Modern Dashboard - Convert BPS to MBPS

grichmond34

I am attempting to set up KPI Widgets for inBPS and outBPS of some of our uplink ports. I have configured a SWQL query that can retrieve this but I don't know how to convert the data from BPS to MBPS. Can anyone advise? Below are the queries in use.

 

SELECT TOP 10 n.Inbps,n.FullName FROM Orion.NPM.Interfaces n  WHERE (FullName LIKE &#39;%<strong><em>interface monitoring</em></strong>%&#39;)<br /><br /><br />

SELECT TOP 10 n.Outbps,n.FullName FROM Orion.NPM.Interfaces n  WHERE (FullName LIKE &#39;%<em><strong>interface monitoring</strong></em>%&#39;)

<br />Any help would be appreciated

stevenstadel

Try something like this

SELECT TOP 10 n.FullName, round((n.Outbps / 1000000),2) as OutMbps
FROM Orion.NPM.Interfaces n 

ORDER BY n.Outbps DESC

WHERE (n.FullName LIKE '%Interface Monitoring%')


--------------
SELECT TOP 10 n.FullName, round((n.Inbps / 1000000),2) as InMbps
FROM Orion.NPM.Interfaces n 

ORDER BY n.Inbps DESC

WHERE (n.FullName LIKE '%Interface Monitoring%')