How can I push any report from Solarwinds to Elasticsearch?

Orion has a RESTful Web API, which can be leveraged to extract data to use in your external application.

You would use the Query URI to pass a SWQL query in to the API and get the results in a JSON response. The following resources will help:

documentation.solarwinds.com/.../sam-api-poller-methods.htm

http://solarwinds.github.io/OrionSDK/swagger-ui/#/Query/Query

http://solarwinds.github.io/OrionSDK/2020.2/schema/index.html

I hope this helps and if you do anything with this, be sure to post about it here, so others can be inspired to do more with their platforms too!

Hi, 

I managed to write a query. but I want to be able to show only hourly values ​​according to interface name as in web reports.

SELECT TOP 10000 i.Caption, i.Name,

  t.DateTime, t.InAveragebps, t.InMinbps, t.InMaxbps, t.InTotalBytes, t.InTotalPkts, 
  
  t.InAvgUniCastPkts, t.InMinUniCastPkts, t.InMaxUniCastPkts, t.InAvgMultiCastPkts, t.InMinMultiCastPkts, t.InMaxMultiCastPkts, 
  
  t.OutAveragebps, t.OutMinbps, t.OutMaxbps, t.OutTotalBytes, t.OutTotalPkts, t.OutAvgUniCastPkts, t.OutMaxUniCastPkts, 
  
  t.OutMinUniCastPkts, t.OutAvgMultiCastPkts, t.OutMinMultiCastPkts, t.OutMaxMultiCastPkts, t.TotalBytes, t.TotalPackets, 
  
  t.Averagebps, t.OutPercentUtil, t.InPercentUtil, t.PercentUtil, e.Caption

FROM Orion.NPM.Interfaces as i

INNER JOIN Orion.NPM.InterfaceTraffic as t ON i.InterfaceID=t.InterfaceID

INNER JOIN Orion.Nodes as e ON i.NodeID=e.NodeID

WHERE (t.DateTime > ADDHOUR (-1,GETDATE()))

How can I arrange these data as 00.00 , 01.00 every hour?

Please help me.

Thank you.

Hi, 

I managed to write a query. but I want to be able to show only hourly values ​​according to interface name as in web reports.

SELECT TOP 10000 i.Caption, i.Name,

  t.DateTime, t.InAveragebps, t.InMinbps, t.InMaxbps, t.InTotalBytes, t.InTotalPkts, 
  
  t.InAvgUniCastPkts, t.InMinUniCastPkts, t.InMaxUniCastPkts, t.InAvgMultiCastPkts, t.InMinMultiCastPkts, t.InMaxMultiCastPkts, 
  
  t.OutAveragebps, t.OutMinbps, t.OutMaxbps, t.OutTotalBytes, t.OutTotalPkts, t.OutAvgUniCastPkts, t.OutMaxUniCastPkts, 
  
  t.OutMinUniCastPkts, t.OutAvgMultiCastPkts, t.OutMinMultiCastPkts, t.OutMaxMultiCastPkts, t.TotalBytes, t.TotalPackets, 
  
  t.Averagebps, t.OutPercentUtil, t.InPercentUtil, t.PercentUtil, e.Caption

FROM Orion.NPM.Interfaces as i

INNER JOIN Orion.NPM.InterfaceTraffic as t ON i.InterfaceID=t.InterfaceID

INNER JOIN Orion.Nodes as e ON i.NodeID=e.NodeID

WHERE (t.DateTime > ADDHOUR (-1,GETDATE()))

How can I arrange these data as 00.00 , 01.00 every hour?

Please help me.

Thank you.

To create a summarised by hour report output, you need to use the Group By clause. Add after the WHERE clause, which will need to be adjusted as it only loads the last hours data, the following:

Group BY DateTrunc('hour',t.DateTime)