Export Router Data to CSV File

[gilbert.aispuro1]

I'm looking to export my cEDGE 4331 data such as, interface(bandwidth, status) , CPU, Memory, to a CSV file so I can ultimately pull that data from PowerBi. I see going to Maintenance/Software Upgrade screen in vManage you can download a CSV manually but I would like an automated report.

Has anyone done this. Is it possible?

[bigevilbeard]

@gilbert.aispuro1 take a look at the device state and statistics API here --> https://developer.cisco.com/docs/sdwan/#!reference-device-state-and-statistics  You might get all you need from https://{{vmanage}}:{{port}}/dataservice/device?deviceId=[ip] and just write this to a CSV.

This might help https://developer.cisco.com/codeexchange/github/repo/supro200/cisco-sdwan-query-tool/