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

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. 

I'm on Grafana 10.0.1

And yeah this is what I added:

allow_loading_unsigned_plugins = solarwinds-swis-datasource = solarwinds-swis-datasource

Currently commented out

In the log:

logger=plugin.loader t=2023-09-06T15:45:50.432983262Z level=error msg="Could not start plugin" pluginId=solarwinds-swis-datasource err="fork/exec /usr/share/grafana/public/app/plugins/datasource/solarwinds/grafana-swis-datasource-develop/dist/_linux_amd64: exec format error"

Hi,

you are right :/ The issue is there and it's caused by enabling background query support. I disabled that in default configuration just now. Please try last sources from repo or navigate to /dist/plugin.json and set  "backend": false. 

Thanks
ET;

Still get the same thing:

What path on Red Hat 8 should this plugin be installed? The ones in the docs are different

Fetch error: 404 Not Found Instantiating server:3000/.../module Loading app/plugins/datasource/dist/module