help on modern dashboard swql query

Hello fellow people

Can someone help me on a query please I am trying to build for our modern dashboard

The query I am running is as below but I want the 2nd column returned to be what is displayed in the KPI widget

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

WHERE (InterfaceID = 286)

This returns.

Column1 Column 2

Interface Desc bandwidth in mbps

In the KPI widget only column one desc appears but I would like the result of column 2 to be displayed.

Thank you in advance.

Find more posts tagged with

kpi widgets

npm

KPI widget can show only one value, you can use table instead of KPI widget

But if you're looking for download and upload speed, here you go

-Download-

SELECT Inbps/1000000 as Download FROM Orion.NPM.Interfaces WHERE InterfaceID=178

-Upload-
SELECT Outbps/1000000 as Upload FROM Orion.NPM.Interfaces WHERE InterfaceID=178

KPI widget can show only one value, you can use table instead of KPI widget

But if you're looking for download and upload speed, here you go

-Download-

SELECT Inbps/1000000 as Download FROM Orion.NPM.Interfaces WHERE InterfaceID=178

-Upload-
SELECT Outbps/1000000 as Upload FROM Orion.NPM.Interfaces WHERE InterfaceID=178

Did you manage to solve your problem because I have the same problem.

Hello

yes i did i used the following

---------

SELECT Round((n.Inbps / 1000000),2) as InMbps
FROM Orion.NPM.Interfaces n

WHERE (InterfaceID = 286)

----------

SELECT Round((n.Outbps / 1000000),2) as OutMbps
FROM Orion.NPM.Interfaces n

WHERE (InterfaceID = 286)