Regarding fetching WAN1 , WAN2 status in Excel using any script
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?
Re: Regarding fetching WAN1 , WAN2 status in Excel using any script
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.