This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Grafana: NPM datasource

analogfire over 7 years ago

Has anyone looked into integrating solarwinds as a datasource with grafana?

In our company we have a lot of different monitoring systems and data sources that can be merged together and correlated together with Grafana (i.e. Elasticsearch, zabbix, etc). We would really like to access the NPM stats via the API but there doesn't appear to be any Grafana datasources built for solarwinds yet. The Grafana dashboard is similar to the new Perfstack but allows for correlation with additional data which can be useful in troubleshooting certain problems. For example, our NPM instance has all of the network routers/switches monitored but in elastic search we have AAA records and in zabbix some radio network nodes and servers which can all be displayed together through a Grafana dashboard.

Parents

0 ET over 5 years ago

Hi,
I was playing now a bit with Grafana and I created what you need. Grafana DataSource for SWIS. Feel free to use it and extend.
GitHub - etichy/grafana-swis-datasource: DataSource plugin for grafana to access SolarWinds data via SWIS REST API
Cancel
Vote Up 0 Vote Down

Cancel
0 mrkuwait over 5 years ago in reply to ET

Hi,
When you sum 2 interfaces the graph does not show accurate data. or maybe im doing something wrong. can you advise on how do you SUM 2 interfaces to make gauge view, thanks
Cancel
Vote Up 0 Vote Down

Cancel
0 ET over 5 years ago in reply to mrkuwait

Hi,
not sure what are you exactly trying to achieve. But grafana always need 3 columns metric name, value and time column. So in case you group more records into 2, there needs to be still 3 columns
SELECT
    GETDATE() as time,                                  -- fake time
    'My 2 Interfaces' as metricName,                -- metric name
    SUM(TotalBytes) as Value                         -- value for gauge
FROM Orion.NPM.InterfaceTraffic
WHERE InterfaceID IN (1,2) and DateTime BETWEEN $from AND $to
Regarding interface utilization. You can either work with current value PercentUtil in entity Orion.NPM.Interfaces (Last poller value), or with historical from Orion.NPM.InterfaceTraffic and play with it more.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 ET over 5 years ago in reply to mrkuwait

Hi,
not sure what are you exactly trying to achieve. But grafana always need 3 columns metric name, value and time column. So in case you group more records into 2, there needs to be still 3 columns
SELECT
    GETDATE() as time,                                  -- fake time
    'My 2 Interfaces' as metricName,                -- metric name
    SUM(TotalBytes) as Value                         -- value for gauge
FROM Orion.NPM.InterfaceTraffic
WHERE InterfaceID IN (1,2) and DateTime BETWEEN $from AND $to
Regarding interface utilization. You can either work with current value PercentUtil in entity Orion.NPM.Interfaces (Last poller value), or with historical from Orion.NPM.InterfaceTraffic and play with it more.
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 srnlfk over 4 years ago in reply to ET

Could you share your Graph Query?
Cancel
Vote Up 0 Vote Down

Cancel