We are trying to retrieve network bandwidth information from orion db to influxdb . which table from orion db will help us to achieve this.?

mthampi

we were trying to integrate solarwind to our influxdb - grafana module using orionsdk. Is there any other we could achieve this so that we can push in live data from solarwind db to influxdb?

lbsoulliere

You can fetch directly from MSSQL

SELECT

  $__timeEpoch(InterfaceTraffic_Detail.DateTime),

  InterfaceTraffic_Detail.out_maxbps as OUT,

  InterfaceTraffic_Detail.in_maxbps as IN,

  interfaces.InBandwidth as CAPACITY

FROM

  InterfaceTraffic_Detail

INNER JOIN interfaces

ON interfaces.InterfaceID = InterfaceTraffic_Detail.InterfaceID

WHERE

  $__timeFilter(InterfaceTraffic_Detail.DateTime) AND interfaces.FullName = $NO_SITE

UNION

SELECT

  $__timeEpoch(InterfaceTraffic_Hourly.DateTime),

  InterfaceTraffic_Hourly.out_maxbps as OUT,

  InterfaceTraffic_Hourly.in_maxbps as IN,

  interfaces.InterfaceSpeed as CAPACITY

FROM

  InterfaceTraffic_Hourly

INNER JOIN interfaces

ON interfaces.InterfaceID = InterfaceTraffic_Hourly.InterfaceID

WHERE

  $__timeFilter(InterfaceTraffic_Hourly.DateTime) AND interfaces.FullName = $NO_SITE

  UNION

SELECT

  $__timeEpoch(InterfaceTraffic_Daily.DateTime),

  InterfaceTraffic_Daily.out_maxbps as OUT,

  InterfaceTraffic_Daily.in_maxbps as IN,

  interfaces.InterfaceSpeed as CAPACITY

FROM

  InterfaceTraffic_Daily

INNER JOIN interfaces

ON interfaces.InterfaceID = InterfaceTraffic_Daily.InterfaceID

WHERE

  $__timeFilter(InterfaceTraffic_Daily.DateTime) AND interfaces.FullName = $NO_SITE

Then add a Variable name "NO_SITE" with this query :

SELECT FullName FROM Interfaces INNER JOIN Nodes ON Nodes.NodeID = Interfaces.NodeID