Modern Dashboard - Convert BPS to MBPS

Question

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 '% interface monitoring %') 
 SELECT TOP 10 n.Outbps,n.FullName 
FROM Orion.NPM.Interfaces n 
 
WHERE (FullName LIKE '% interface monitoring %') 
 Any help would be appreciated

stevenstadel · Answer

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%')

Modern Dashboard - Convert BPS to MBPS

Top Replies