Regarding fetching WAN1 , WAN2 status in Excel using any script

[PrithvirajChava]

Hello Techies, 

I need to Fetch reports for WAN1 WAN2 status for more than 1600 locations of MX65W device.

Its much manual work to check visiting with each location, Is there any other way to fetch the status for all locations in excel as below:

Location    MX65W WAN1 WAN2 AP1 AP2 SW1 SW2 SW3
location1 up up down up up down down up
location2 up down up up up up up up
location3 up up up up up up up up
location4 up down up up down up up up
location5 up up up up up down up up
location6 up up up up up up up up
location7 up up up up down up up down
location8 DNS Error down down down down down down down

Is there any way to fetch the status using API/Report?

Kindly help me with this.

[CN]

I recommend you checkout this thread: Meraki Tools for Google Sheets add-on. The add on will allow Google sheets to run API commands. The report that will get you most of the information will be "Organization Device Statuses." While it won't be in the exact format that you want, then you can use other tools to get more data about other networks.