Export CSV or JSON data from solarwinds | router netflow | snmp from window server question

Dear All,

Would like to seek for your help on generating the following date to CSV or JSON, since we have powerBI, we want to import these data from file formate CSV or JSON, so that we can import to powerBI for reporting, as i already

enabled snmp for one of the file server, and added this server to solarwinds, but i dont know how to export below data i want to gather to CSV or JSON format, also i added router with netflow, how do i export the data field in the following ? any

help would be appreicated,

by Server

storage / server usage and availability

by router

Infrastructure / applications: downtime, number of incidents per app or type, wifi incidents, network speed / usage…

Keith

Find more posts tagged with

Accepted answers

All comments

Lofstrand

Hi
I suggest you create a report using the built in reporting tool, with the information you would like. Then you can schedule that report so be sent to you in CSV format. Either by email or stored on a file share.

Can that work?

bobmarley

I have used a similar method to what @Lofstrand suggested. Once you set up your report you can schedule it to run at any interval you wish. As a Save option if you chose to write to disk you can save the data out to a network share that the PowerBI can also access to import. Another option is to write your query in SWQL and then embed that query within a Powershell script to pull the data and set up a scheduled task.