1 Reply Latest reply on Nov 14, 2018 10:21 AM by lbsoulliere

    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?

        • Re: We are trying to retrieve network bandwidth information from orion db to influxdb . which table from orion db will help us to achieve this.?
          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