topic Export Wireless Data to CSV File in Wireless

Export Wireless Data to CSV File

gilbert.aispuro1 — Mon, 05 Jul 2021 20:11:59 GMT

I'm looking to export my C9120AXI-B AP data such as, interface(bandwidth, status) , CPU, Memory, to a CSV so I can ultimately pull that data from PowerBi. I would like this to be automated everyday if possible. My APs are managed by 9800WLC.

Has anyone done this. Is it possible?

Re: Export Wireless Data to CSV File

Scott Fella — Fri, 05 Feb 2021 19:13:42 GMT

If you want this data, you need an NMS platform that pulls information from the controller into a db in which you can access via API. I don't know how you would get this information just from the controller, you would need to do an snmp walk, pull that data, time stamp that and store it somewhere. Unless I do not understand your question correctly.

Let me ask... what command are you using to get this info right now?

Re: Export Wireless Data to CSV File

Leo Laohoo — Fri, 05 Feb 2021 23:19:59 GMT

Exactly what kind of data are you trying to pull?

Re: Export Wireless Data to CSV File

gilbert.aispuro1 — Fri, 12 Feb 2021 06:17:24 GMT

Actually, I found out that IOS-XE has a feature called Model-Driven Telemetry. With this, I'm able to throw this raw data over to a local DB or over to a PowerBI Data Set.