Thanks to @John_on_API  this did the trick for me. Below is the final code. Hope its useful to others to adapt as they see fit.     # Script to retrieve Meraki AP info from all networks from all org the API key has access to #All Switches and AP devcies name are assumed to start with AP* or SW* from datetime import datetime import os import meraki import pandas as pd # Meraki API Key name that is retrieve from the OS environment variable. MERAKI_DASHBOARD_API_KEY_NAME = 'MERAKI_API_KEY' # Readonly key #Set CSV / XLXS folder path to the output folder under the script output_path = f"{os.path.dirname(__file__)}/output" def extract_ap_details(linkLayerDevices_response, site_name, org_name): """ Extract access point details from the 'links' node of the given response. Strips "Port " from portId to get only the port number, renames field to 'port_number', and includes additional parameters 'site_name' and 'org_name'. Parameters: linkLayerDevices_response (dict): The response dictionary containing 'links' node. site_name (str): The name of the site where the devices are located. org_name (str): The name of the organisation. Returns: list: A list of dictionaries containing details of switches, access points, and metadata. """ ap_details = [] # Safely get the 'links' list from the response links = linkLayerDevices_response.get("links", []) if not isinstance(links, list): return ap_details # Return empty list if 'links' is not a list # Iterate through each link in the list for link in links: ends = link.get("ends", []) if not (isinstance(ends, list) and len(ends) == 2): continue # Skip if 'ends' is not a list of exactly 2 dictionaries # Extract potential switch and access point nodes switch = ends[0] access_point = ends[1] # Validate the "SW" and "AP" naming conventions sw_device = switch.get("device", {}) ap_device = access_point.get("device", {}) sw_name = sw_device.get("name", "") ap_name = ap_device.get("name", "") if not sw_name.startswith("SW"): continue # Skip if the device name does not start with "SW" if not ap_name.startswith("AP"): continue # Skip if the second device name does not start with "AP" # Extract additional details with safe fallbacks sw_discovered = switch.get("discovered", {}) sw_lldp = sw_discovered.get("lldp") or {} # Default to empty dict if None sw_cdp = sw_discovered.get("cdp") or {} # Default to empty dict if None # Extract and clean port number port_id = sw_lldp.get("portId", "").replace("Port ", "").strip() # Append the validated data into the result list ap_details.append({ "ap_name": ap_name, "ap_serial": ap_device.get("serial", ""), # Default to empty string if missing "sw_name": sw_name, "sw_serial": sw_device.get("serial", ""), # Default to empty string if missing "sw_port_number": port_id, # Cleaned port number "sw_port_native_vlan": str(sw_cdp.get("nativeVlan", "")), # Default to empty string if missing "site_name": site_name, # Added site_name "org_name": org_name # Added org_name }) return ap_details def main(): if MERAKI_DASHBOARD_API_KEY_NAME in os.environ: print(f"API Key Environment variable [{MERAKI_DASHBOARD_API_KEY_NAME}] found.") else: print(f"API Key Environment variable [{MERAKI_DASHBOARD_API_KEY_NAME}] Does not exists!") exit(1) MERAKI_DASHBOARD_API_KEY = os.getenv(MERAKI_DASHBOARD_API_KEY_NAME) # Get the actual Meraki API Key # Start a Meraki dashboard API session try: print(f"\nTrying to connect to Meraki API Using [{MERAKI_DASHBOARD_API_KEY_NAME}]") dashboard = meraki.DashboardAPI( api_key=MERAKI_DASHBOARD_API_KEY, base_url='https://api.meraki.com/api/v1/', print_console=False, output_log=False, suppress_logging=True, wait_on_rate_limit=True, maximum_retries=100 ) except meraki.APIError as e: print("Unable to connect to Meraki API.") print(f'Meraki API error: {e}') print(f'status code = {e.status}') print(f'reason = {e.reason}') print(f'error = {e.message}') else: # Get list of organizations to which the supplied API key has access to. organizations = dashboard.organizations.getOrganizations() organizations = sorted(organizations, key=lambda x: x['name']) # Sort Org by name # Print name of the Orgs found print(f"Found: [{len(organizations)}] organisations.") for org in organizations: print(f"{org['name']}") # Iterate through list of Orgs and gather details we need all_org_ap_info = [] # Store all the networks in all orgs so we can write to a file later. for org in organizations: org_id = org['id'] # Save ID name for use later org_name = org['name'] # Save Org name for use later print(f"\nAnalysing organization {org_name}:") # Get list of networks in current organization try: org_networks = dashboard.organizations.getOrganizationNetworks(org_id) except meraki.APIError as e: print(f'Meraki API error: {e}') print(f'status code = {e.status}') print(f'reason = {e.reason}') print(f'error = {e.message}') continue except Exception as e: print(f'some other error: {e}') continue # Skip error in current Meraki network #We are only interested in neworks where there is a Switch AND wireless print(f"\n[Org:{org_name}] Filtering Meraki network type to those that has a Switch & Wireless") # Use list comprehension to filter the list networks = [ network for network in networks if "switch" in network["productTypes"] and "wireless" in network["productTypes"] ] # Sort List of network by name print(f"\n[Org:{org_name}] Sorting network list by alphabetical order") networks = sorted(networks, key=lambda x: x['name']) # Iterate through networks in current organisation total = len(networks) # count number of Meraki networks counter = 1 # Keep count of number of network as we iterate through them. print(f'Iterating through {total} networks in organization in {org["name"]} to get list of APs information') # Loop through the list of networks and retrieve the needed info for network in networks: # Create a new list of dictionaries to store AP info network_ap_info = [] network_name = network["name"] #get this Network Link Layer devices info which contains the SW LLDP & AP info we need linkLayerDevices_response = response = dashboard.networks.getNetworkTopologyLinkLayer(network["id"]) #retrieve the APs infor for this network network_ap_info = extract_ap_details(linkLayerDevices_response, network["name"], org_name) # Sort the list by the "ap_name" key using list comprehension network_ap_info = sorted(network_ap_info, key=lambda x: x["ap_name"]) #Combine the curent org network info into the all_org dict for later use all_org_ap_info = network_ap_info + all_org_ap_info print(f"Gathering AP info for Org:[{org['name']}] Network:[{network_name}] completed.") print(f"Gathering info for Org:[{org['name']}] completed.") df_all_org_ap_info_info = pd.DataFrame(all_org_ap_info) # # write the DataFrame to a CSV file current_datetime = datetime.now().strftime("%Y-%m-%d %H-%M-%S") filename = f"{output_path}/all_orgs_ap-_info--{current_datetime}.xlsx" df_all_org_ap_info_info.to_excel(filename) print(f"Exported filename: {filename}") print(f"NOTE: APs without a Switch port number are offline or dormant.") if __name__ == "__main__": # Call Main to do all the actual work. start_time = datetime.now() main() end_time = datetime.now() print(f'\nScript complete, total runtime {end_time - start_time}')     ... View more

Are we there yet..I can't see anything..I mean dark mode! ... View more

Can you paste the actual code instead of screenshot? ... View more

Please make use of all that spaces and step back on having too much wasted white spaces that can show useful info. For me seems all the re-designed pages shows less info than before. We want more info to be shown not less. Most of the graphics / icons looks fine to me. Please spend more time on showing more useful info rather than tweak the icons. If you guys want to play with graphics please look into dark mode for the Dashboard! ... View more

Client will always land on the same VLAN. I'll have to look into making it layer 2.   Thanks ... View more

Looks like I found the issue! The VLAN ID was wrong on the Meraki SSID config 😂 ... View more

As Craieggg suggested this can be done using API and export the result to Excel and filter there. ... View more

Thanks @John_on_API  I'll add that to the list to try as well. ... View more

Thank you for sharing. I will give that a try. ... View more

Thanks @RaphaelL  I'll give that a try. ... View more

Below is what I came up with a while ago. It will output an excel file with all the DHCP reservations for all networks for all orgs that the API key can access. Note API Key is retrieved from an Environment variable.   import csv from datetime import datetime import os import time import meraki import pandas as pd import json import xlsxwriter import openpyxl from collections import OrderedDict import time # This script get a list of all VLANs for All Meraki Networks in All Meraki Orgs the API Key has access to #This also grab single subnet networks and skip any networks that has a passthrough appliances as they do not have a subnet. #It then get all the DHCP reservations from each VLANs. # Meraki API Key name. Allows to switch between different keys MERAKI_DASHBOARD_API_KEY_NAME = 'MERAKI_API_KEY GOES HERE' # Readonly key #Set CSV / XLXS folder path output_path = f"{os.path.dirname(__file__)}/output" def main(): if MERAKI_DASHBOARD_API_KEY_NAME in os.environ: print(f"API Key Environment variable [{MERAKI_DASHBOARD_API_KEY_NAME}] found.") else: print(f"API Key Environment variable [{MERAKI_DASHBOARD_API_KEY_NAME}] Does not exists!") exit(1) MERAKI_DASHBOARD_API_KEY = os.getenv(MERAKI_DASHBOARD_API_KEY_NAME) # Get the actual Meraki API Key # Start a Meraki dashboard API session try: print(f"\nTrying to connect to Meraki API Using [{MERAKI_DASHBOARD_API_KEY_NAME}]") dashboard = meraki.DashboardAPI( api_key=MERAKI_DASHBOARD_API_KEY, base_url='https://api.meraki.com/api/v1/', print_console=False, output_log=False, suppress_logging=True, wait_on_rate_limit=True, maximum_retries=100 ) except meraki.APIError as e: print("Unable to connect to Meraki API.") print(f'Meraki API error: {e}') print(f'status code = {e.status}') print(f'reason = {e.reason}') print(f'error = {e.message}') else: # Get list of organizations to which the supplied API key has access to. organizations = dashboard.organizations.getOrganizations() organizations = sorted(organizations, key=lambda x: x['name']) # Sort Org by name # Print name of the Orgs found print(f"Found: [{len(organizations)}] organisations.") for org in organizations: print(f"{org['name']}") all_orgs_networks_vlans = list() #Store a list of all the org vlans all_orgs_networks_vlans_dhcp_reservations = list() # Store a list of all the org vlans reservations # Iterate through list of Orgs and gather clients details of all VLAN for each networks where there is an MX for org in organizations: all_org_networks = [] # Store all the networks in all orgs so we can write to a file later. print(f"\nAnalysing organization {org['name']}:") org_id = org['id'] # Save ID name for use later org_name = org['name'] # Save Org name for use later # Get list of networks in current organization try: org_networks = dashboard.organizations.getOrganizationNetworks(org_id) except meraki.APIError as e: print(f'Meraki API error: {e}') print(f'status code = {e.status}') print(f'reason = {e.reason}') print(f'error = {e.message}') continue except Exception as e: print(f'some other error: {e}') continue # Skip error in current Mersaki network # Sort List of network by name org_networks = sorted(org_networks, key=lambda x: x['name']) # Iterate through networks in current organisation total = len(org_networks) # count number of Meraki networks in this org counter = 1 # Keep count of number of network as we iterate through them. print(f'Iterating through {total} networks in organization in {org["name"]} to get list of VLAN information') # Create a new list networks current_org_networks_info = [] # Loop through the list of networks and retrieve the VLAN info for network in org_networks: print(f'Processing [{org["name"]}] Network: {network["name"]}') #We can check if a network has vlans by using below endpoint # https://developer.cisco.com/meraki/api/get-network-appliance-vlans-settings/ # #However to reduce the number of API calls. This will be skipped # Create a new dictionary to store the network info network_info = {} # Add the required fields to the new dictionary network_info["id"] = network["id"] network_info["organizationId"] = network["organizationId"] network_info["name"] = network["name"] network_info["productTypes"] = network["productTypes"] network_info["timeZone"] = network["timeZone"] network_info["tags"] = network["tags"] network_info["isBoundToConfigTemplate"] = network["isBoundToConfigTemplate"] network_info["url"] = network["url"] network_vlans = list() #Use to hold all the vlan or empty if no vlans vlan_details = {} #Store the vlan details for each vlan #If product type has "appliance" then it will have a vlan subnet for us to grab if 'appliance' in network['productTypes']: #Get VLAN Info try: vlans = dashboard.appliance.getNetworkApplianceVlans(network["id"]) #vlans now has the VLAN details including any DHCP reservations #Now loop through all the VLAn and get the DHCP Reservations clients MAC & IP for vlan in vlans: fixedIpAssignments = vlan['fixedIpAssignments'] for key in fixedIpAssignments: # vlan_details['organizationId'] = network['organizationId'] # vlan_details['net_name'] = network['name'] # vlan_details["vlan_name"] = vlan['name'] # vlan_details['dnsNameservers'] = vlan['dnsNameservers'] # vlan_details['reservation_name'] = fixedIpAssignments[f"{key}"]['name'] # vlan_details['reservation_mac'] = f"{key}" vlan_details['reservation_ip'] = fixedIpAssignments[f"{key}"]['ip'] all_orgs_networks_vlans_dhcp_reservations.append( {'organizationId': network['organizationId'], 'net_name': network['name'], 'vlan_name': vlan['name'], 'dnsNameservers': vlan['dnsNameservers'], 'reservation_name': fixedIpAssignments[f"{key}"]['name'], 'reservation_mac': f"{key}", 'reservation_ip': fixedIpAssignments[f"{key}"]['ip'] } ) except meraki.APIError as e: if e.status == 400: #Vlan not enable for this network as only a single subnet #Get the single VLAN subnet and assume VLAN ID of '1' #print(f'Error Network: {network["name"]}: {e.message}') #Check and skip any network & appliances in passthrough mode. #They won't have any subnet to retrieve # if 'ACM-VNET-MEL-APAS-ACM-01' in network['name']: # print('Pass through mode network') #Get the single VLAN try: single_vlan_info = dashboard.appliance.getNetworkApplianceSingleLan(network["id"]) fixedIpAssignments = single_vlan_info['fixedIpAssignments'] for key in fixedIpAssignments: vlan_details['reservation_ip'] = fixedIpAssignments[f"{key}"]['ip'] all_orgs_networks_vlans_dhcp_reservations.append( {'organizationId': network['organizationId'], 'net_name': network['name'], 'vlan_name': 'Default', 'dnsNameservers': single_vlan_info['dnsCustomNameservers'], 'reservation_name': fixedIpAssignments[f"{key}"]['name'], 'reservation_mac': f"{key}", 'reservation_ip': fixedIpAssignments[f"{key}"]['ip'] } ) # print(f"Done") except meraki.APIError as e2: if e2.status == 400: print(f"Network in Passthrough mode or some other error. Skipping!") #'Single LAN is not available for networks in passthrough mode' continue else: print(f'Some other error for network without VLANs.') continue #If we are here then there is a single subnet to grab vlan_subnet = {1, single_vlan_info['subnet']} print(f"VLAN [1]: - Subnet [{single_vlan_info['subnet']}]") network_vlans.append(vlan_subnet) # Also store the VLAN in the All Org VLAN list for later usage all_orgs_networks_vlans.append({'net_name': network["name"], 'net_id': network["id"], 'vlan_id': 1, 'vlan_subnet': single_vlan_info['subnet']}) continue elif e.status == 429: #We have hit the rate limit. Back off by sleeping for a bit print(f'Error Network: {network["name"]}: {e.message}. Sleeping for 5 seconds.') #time.sleep(int(response.headers["Retry-After"])) time.sleep(5) # Sleep for 5 seconds continue else: print(f'Error Network: {network["name"]}') print(f'Meraki API error: {e}') print(f'status code = {e.status}') print(f'reason = {e.reason}') print(f'error = {e.message}') continue #If we are here then there are some vlan subnets to process # Loop through the appliance vlan info and get all VLANs subnets for vlan in vlans: # print(f"VLAN ID: [{$vlan['id']}] Subnet: {$vlan['subnet']} ") vlan_subnet = {vlan['id'], vlan['subnet']} print(f"VLAN [{vlan['id']}]: - Subnet [{vlan['subnet']}]") network_vlans.append(vlan_subnet) #Also store the VLAN in the All Org VLAN list for later usage all_orgs_networks_vlans.append({'net_name': network["name"], 'net_id': network["id"], 'vlan_id': vlan['id'], 'vlan_subnet': vlan['subnet']}) #store the network vlans (or empty if not an appliance network network_info['vlans'] = network_vlans # Add the new dictionary to the list current_org_networks_info.append(network_info) print(f"Network info gathering for [{org['name'] }] completed.") #Combine the curen org network info into the all_org dict for later use all_org_networks = current_org_networks_info + all_org_networks #Sort the networks by name #all_orgs_networks_vlans df_all_orgs_networks_vlans = pd.DataFrame(all_orgs_networks_vlans) df_all_orgs_networks_vlans_dhcp_reservations = pd.DataFrame(all_orgs_networks_vlans_dhcp_reservations) #df_all_org_networks_info = pd.DataFrame(all_org_networks) # # write the DataFrame to a CSV file current_datetime = datetime.now().strftime("%Y-%m-%d %H-%M-%S") filename = f"{output_path}/all-orgs_networks-vlan-info--{current_datetime}.xlsx" #df_all_org_networks_info.to_excel(filename) df_all_orgs_networks_vlans.to_excel(filename) print(f"Exported[VLANS to file] filename: {filename}") #Write DHCP reservation to file current_datetime = datetime.now().strftime("%Y-%m-%d %H-%M-%S") filename = f"{output_path}/all-orgs_networks-dhcp-reservation-info--{current_datetime}.xlsx" #df_all_org_networks_info.to_excel(filename) df_all_orgs_networks_vlans_dhcp_reservations.to_excel(filename) print(f"Exported [DHCP reservation to file] filename: {filename}") if __name__ == "__main__": # Call Main to do all the actual work. start_time = datetime.now() main() end_time = datetime.now() print(f'\nScript complete, total runtime {end_time - start_time}')       ... View more

Thanks. I'll explore this route. ... View more

Thanks. That's handy to know. 150 networks otherwise I would have just done the manual route. ... View more

I tried this today and could not get it  to work ☹️   Here is the error I am getting on the Microsoft Flow Side   Action 'Send_each_adaptive_card' failed: The execution of template action 'Send_each_adaptive_card' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body']?['attachments']' is of type 'Null'. The result must be a valid array.         The Flow template that I used     Also tried   Below links are likely useful in getting this working. I will play more with this when time permit.   https://blog.rdorman.net/the-new-world-of-teams-webhooks/ https://sysrestarting.blogspot.com/2024/07/teams-incoming-webhook-deprecated-use.html https://www.reddit.com/r/MicrosoftFlow/comments/1eac9g9/meraki_webhook_alerts_to_teams_via_flow/    https://github.com/prometheus/alertmanager/issues/3920 https://learn.microsoft.com/en-us/microsoftteams/platform/webhooks-and-connectors/how-to/connectors-using?tabs=cURL%2Ctext1#send-adaptive-cards-using-an-incoming-webhook   ... View more

Make sure you are in the right section. Under Tools->manage Packages and search for Meraki API. Then install ... View more

By chance today I noticed that Meraki has finally added the uptime to the switch only. Unfortunately they have not added this to the MX! ... View more

That works perfectly. Thank you. ... View more

@BlakeRichardson  Would you mind sharing where you got the enclosure from? We have a site in NZ that needs an enclosure and we've struggling to find one locally.   Edit: Forgot to mention. Trying to fit an MR36 to install under an eaves so just looking for a bit of water / rain protection.   Thanks ... View more

Those are definitely good additions! ... View more

I've had case where it seems not to pick up the config file (in the new location). This is for when the AnyConnect Client was previously installed. ... View more

We are being sent a couple to play with. I will report back once we have done a bit of testing in a warehouse of ours. ... View more

Has anyone actually deployed the CW9166D1 in a warehouse. We have a project and Meraki are suggesting them as an option. ... View more