This tool is a Google Apps Script-based solution designed to streamline the management and configuration of Meraki devices within an organization. It allows network administrators to efficiently retrieve device status, check configurations, and apply bulk static IP configurations using a Google Sheets interface. By interacting with the Meraki API, this tool saves time and reduces manual effort.
Meraki.Bulk.Provisioning_Demo.mp4
Prerequisites:
A Google account with access to Google Sheets and Google Apps Script.
A valid Meraki Organization ID (OrgID) and API Key.
Basic knowledge of Meraki device management and IP configurations.
Setup and Usage:
Getting Started:
Input your Meraki OrgID and API Key in the "Getting Started" sheet of "Meraki Bulk provisioning_1.1.xlsx".
Step 1: Pre-Status Check
Purpose: Retrieve the current status of all devices.
Action: Click "Pre Status Check" in the "Getting Started" sheet.
Result: View device statuses (Online, Offline, etc.) in the "Pre Status Check" sheet.
Step 2: Pre-Config Check
Purpose: Retrieve current device configurations.
Action: Click "Pre Config Check" in the "Getting Started" sheet.
Result: View configuration details like IP address, subnet mask, and DNS in the "Pre Config Check" sheet.
Step 3: Bulk Provisioning
Purpose: Apply static IP configurations to devices in bulk.
Action: Fill in device details in the "Bulk Provisioning" sheet and click "Bulk Provisioning" in the "Getting Started" sheet.
Result: Static IP configurations are applied via the Meraki API.
Step 4: Post-Status Check
Purpose: Verify device statuses after provisioning.
Action: Click "Post Status Check" in the "Getting Started" sheet.
Result: View updated device statuses in the "Post Status Check" sheet.
Step 5: Post-Config Check
Purpose: Confirm correct application of static IP configurations.
Action: Click "Post Config Check" in the "Getting Started" sheet.
Result: Verify updated configuration details in the "Post Config Check" sheet.
Notes:
Ensure the Meraki API key has necessary permissions.
Double-check entries in the "Bulk Provisioning" sheet to avoid misconfigurations.
Review the status of any devices that fail to update.
License
This project is licensed under the MIT License - see the LICENSEfile for details.
Get help, share code, and collaborate with other developers in the Code Exchange community.View Community
Disclaimer: Cisco provides Code Exchange for convenience and informational purposes only, with no support of any kind. This page contains information and links from third-party websites that are governed by their own separate terms. Reference to a project or contributor on this page does not imply any affiliation with or endorsement by Cisco.