Direct SQL Server Queries

Hi,

I would not use SQL directly as Flow Storage DB is does not include information like node or interface names. Instead I would recommend to use SWQL (https://github.com/solarwinds/OrionSDK/tree/master/Samples). This is similar to SQL and it will automatically merge data from multiple databases together. To get familiar with it I would recommend to use SWQL Studio, which is part of OrionSDK. You will also see there the schema with all information that are available to you.

Example of simple NetFlow query:

SELECT TimeStamp, flows.Node.Caption, SUM(IngressBytes) AS IngressBytes, SUM(EgressBytes) AS EgressBytes
FROM Orion.NetFlow.Flows AS flows
WHERE TimeStamp > AddMinute(-10, GETUTCDATE())
GROUP BY TimeStamp, flows.Node.Caption
ORDER BY TimeStamp DESC

Hi,

I would not use SQL directly as Flow Storage DB is does not include information like node or interface names. Instead I would recommend to use SWQL (https://github.com/solarwinds/OrionSDK/tree/master/Samples). This is similar to SQL and it will automatically merge data from multiple databases together. To get familiar with it I would recommend to use SWQL Studio, which is part of OrionSDK. You will also see there the schema with all information that are available to you.

Example of simple NetFlow query:

SELECT TimeStamp, flows.Node.Caption, SUM(IngressBytes) AS IngressBytes, SUM(EgressBytes) AS EgressBytes
FROM Orion.NetFlow.Flows AS flows
WHERE TimeStamp > AddMinute(-10, GETUTCDATE())
GROUP BY TimeStamp, flows.Node.Caption
ORDER BY TimeStamp DESC

How do I use this as a data source in Grafana? If I can't use SWQL, which I've looked, how do I do the queries directly in SQL Server since it can be used as a data source

Does anyone have this information?

Is it the certificate thing stopping you from doing SWQL to Grafana?

There is no datasource that works with Grafana currently

https://orangematter.solarwinds.com/2018/06/19/solarwinds-grafana-better-together/
https://github.com/etichy/grafana-swis-datasource 
https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/63029/grafana-npm-datasource

SWIS data source stopped working after Grafana 9

Code hasn't been maintained for several years

Hi, I believe that it's still functional. Just that this plugin is not signed and you have to add exception for it. 

I did. Still threw errors

ok, let me try it. It's my repo so in case it's not working I'll fix it.  Thanks for reporting.