cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Regarding fetching WAN1 , WAN2 status in Excel using any script

Highlighted

Regarding fetching WAN1 , WAN2 status in Excel using any script

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.

1 REPLY 1
Highlighted
Meraki Employee
Meraki Employee

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. 

 

Screen Shot 2020-05-13 at 3.00.50 PM.png

 

Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.