Cisco Meraki
Query the whole Meraki estate in SQL — wireless, switching, security appliance, camera, sensor, cellular and MDM. Every switch port and its VLAN, the full MX firewall, NAT, VPN and WAN uplink picture, the evidence behind a Wi-Fi complaint, plus dashboard admins and 2FA, license expiry, hardware end-of-support dates and the admin audit log of who changed what.
Organizations
Retrieve and manage Organizations information.
Networks
Retrieve and manage Networks information.
Devices
Retrieve and manage Devices information.
Device Statuses
Retrieve and manage Device Statuses information.
SSID Statuses by AP (BSSIDs)
Retrieve and manage SSID Statuses by AP (BSSIDs) information.
Client Counts by AP
Retrieve and manage Client Counts by AP information.
Channel Utilization by AP
Retrieve and manage Channel Utilization by AP information.
Packet Loss by AP
Retrieve and manage Packet Loss by AP information.
Packet Loss by Client
Retrieve and manage Packet Loss by Client information.
AP Ethernet & PoE Status
Retrieve and manage AP Ethernet & PoE Status information.
RF Profile Assignments by AP
Retrieve and manage RF Profile Assignments by AP information.
Assurance Alerts
Retrieve and manage Assurance Alerts information.
Air Marshal Rules
Retrieve and manage Air Marshal Rules information.
Air Marshal Settings
Retrieve and manage Air Marshal Settings information.
Radio RRM by Network
Retrieve and manage Radio RRM by Network information.
AP CPU Load
Retrieve and manage AP CPU Load information.
Wireless Settings
Retrieve and manage Wireless Settings information.
SSIDs
Retrieve and manage SSIDs information.
RF Profiles
Retrieve and manage RF Profiles information.
Failed Connections
Retrieve and manage Failed Connections information.
Connection Stats (Network)
Retrieve and manage Connection Stats (Network) information.
Connection Stats by Client
Retrieve and manage Connection Stats by Client information.
Connection Stats by AP
Retrieve and manage Connection Stats by AP information.
Latency Stats (Network)
Retrieve and manage Latency Stats (Network) information.
Latency Stats by Client
Retrieve and manage Latency Stats by Client information.
Latency Stats by AP
Retrieve and manage Latency Stats by AP information.
Air Marshal (Rogue APs)
Retrieve and manage Air Marshal (Rogue APs) information.
Mesh Statuses
Retrieve and manage Mesh Statuses information.
Channel Utilization History
Retrieve and manage Channel Utilization History information.
Clients
Retrieve and manage Clients information.
Wireless Event Log
Retrieve and manage Wireless Event Log information.
Splash Login Attempts
Retrieve and manage Splash Login Attempts information.
Bluetooth Settings
Retrieve and manage Bluetooth Settings information.
Alternate Management Interface
Retrieve and manage Alternate Management Interface information.
AP Ethernet Port Profiles
Retrieve and manage AP Ethernet Port Profiles information.
AP Radio Settings
Retrieve and manage AP Radio Settings information.
AP Live Radio Status
Retrieve and manage AP Live Radio Status information.
SSID L3 Firewall Rules
Retrieve and manage SSID L3 Firewall Rules information.
SSID L7 Firewall Rules
Retrieve and manage SSID L7 Firewall Rules information.
SSID Traffic Shaping
Retrieve and manage SSID Traffic Shaping information.
SSID Splash Settings
Retrieve and manage SSID Splash Settings information.
SSID Identity PSKs
Retrieve and manage SSID Identity PSKs information.
SSID Availability Schedules
Retrieve and manage SSID Availability Schedules information.
SSID EAP Override
Retrieve and manage SSID EAP Override information.
SSID Device-Type Policies
Retrieve and manage SSID Device-Type Policies information.
SSID Hotspot 2.0
Retrieve and manage SSID Hotspot 2.0 information.
SSID Bonjour Forwarding
Retrieve and manage SSID Bonjour Forwarding information.
SSID VPN / Concentrator
Retrieve and manage SSID VPN / Concentrator information.
Org Admins
Every dashboard administrator with their access level, 2FA state, API-key ownership, and last-active date.
SAML SSO Enabled
Whether SAML SSO is enabled for the organization, and the SP-initiated subdomain.
SAML Identity Providers
Configured SAML identity providers with consumer and login URLs and certificate fingerprint.
SAML Roles
What each SSO-asserted role grants — org access level, scoped networks, and tags.
Login Security Policy
Dashboard password policy, lockout thresholds, idle timeout, enforced 2FA, and API-key IP restrictions.
License Overview
Licensed device count per model with overall licensing status and expiry date.
Co-term Licenses
Individual co-termination license keys with claim date, duration, and expiry state.
Inventory Devices (incl. unclaimed)
Every device the organization owns including unassigned spares, with order number and hardware end-of-sale and end-of-support dates.
Config Templates
Configuration templates and the product types they bind.
Policy Objects
Reusable CIDR, FQDN, IP, and port objects referenced by firewall rules.
Policy Object Groups
Groups of policy objects and the networks they apply to.
Adaptive Policy ACLs
Adaptive policy ACLs flattened to one row per rule.
Adaptive Policy Groups
Adaptive policy groups with their SGT value and required IP mappings.
Adaptive Policies
Source-to-destination group policies with the ACLs they apply.
Adaptive Policy Enabled Networks
Which networks have adaptive policy enabled.
Org Alert Profiles
Organization-wide alert rules with their trigger conditions and recipients.
Org SNMP Settings
Organization SNMP configuration — v2c community string state and v3 auth and privacy modes.
API Request Log
Full API request log: caller, source IP, operation, and response code.
API Response Code Counts
API response code counts over the window.
Firmware Upgrade History
Firmware upgrade history per network with from and to versions and status.
Firmware Upgrades by Device
Per-device firmware upgrade progress through download, install, and verify stages.
Device Availability (all families)
Up, down, alerting, or dormant for every device across all product families.
Device Status Rollup
Device counts rolled up by status.
Power Supply Slots
Power supply slot status per switch — model, serial, and whether the slot is populated.
Uplink Loss & Latency
Per-sample loss and latency for each WAN uplink.
Top Devices by Usage
Highest-usage devices with client counts and share of total traffic.
Top Clients by Usage
Highest-usage clients with upstream and downstream totals.
Top Client Manufacturers
Traffic and client counts grouped by device manufacturer.
Top SSIDs by Usage
Highest-usage SSIDs with client counts and share of total traffic.
Top Applications by Usage
Highest-usage applications by upstream and downstream volume.
Top Switches by Energy Usage
Switch energy consumption ranked by total draw.
Webhook Delivery Log
Webhook delivery attempts with response code and duration.
Webhook Alert Types
Every alert type the organization can subscribe a webhook to.
Action Batches
Bulk configuration changes submitted through the API, with completion and failure state.
Early Access Opt-Ins
Beta features the organization has opted into.
Early Access Features Available
Early access features available to the organization.
Branding Policies
Dashboard branding policies for MSP and multi-tenant organizations.
MX VLANs
Subnet, gateway, DHCP mode and lease time per MX VLAN, with DHCP reservation counts.
MX VLAN Mode
Whether the network runs multiple VLANs or a single flat LAN.
MX Single LAN
Subnet and gateway for networks running a single LAN instead of VLANs.
MX Static Routes
Routes configured beyond the directly-connected VLANs.
MX L3 Firewall Rules
The outbound layer-3 firewall rule set in evaluation order — source, destination, ports and policy per rule.
MX L7 Firewall Rules
Application-layer firewall rules with the application or category each one matches.
MX Port Forwarding Rules
Every inbound port-forward through the appliance, with the public port, internal host, and which source IPs are allowed.
MX 1:1 NAT Rules
Public-to-private one-to-one address mappings and their allowed inbound rules.
MX 1:Many NAT Rules
One public IP mapped to multiple internal hosts by port.
MX Cellular Firewall Rules
Firewall rules applied to traffic over the cellular uplink.
MX Inbound Firewall Rules
Inbound firewall rules with their syslog default.
MX Inbound Cellular Firewall Rules
Inbound firewall rules applied to the cellular uplink.
MX Firewalled Services
Whether ICMP, web and SNMP are reachable on the appliance WAN interface, and from which source IPs.
MX Firewall Settings
IP source guard and anti-spoofing mode.
MX Content Filtering
Blocked URL categories and patterns, and any allow-listed URLs.
MX Content Filtering Categories
The full content-filtering category list available to block against.
MX Intrusion Detection
Intrusion detection mode, ruleset, and the networks it protects.
MX Malware Protection
Malware protection mode with allow-listed URLs and file hashes.
MX Site-to-Site VPN
Hub or spoke mode with the subnets each network exports over the VPN.
MX BGP
BGP state, AS number, hold timer and neighbours.
MX Global Bandwidth Limits
Global uplink bandwidth caps for the network.
MX Traffic Shaping Rules
Shaping rules with per-client bandwidth limits, DSCP tags, priority and the traffic each matches.
MX Uplink Bandwidth Limits
Configured bandwidth limit per WAN uplink.
MX Uplink Selection / SD-WAN
Default uplink, load balancing state, and the WAN and VPN traffic preference rules.
MX Custom Performance Classes
Latency, jitter and loss thresholds referenced by SD-WAN uplink preference rules.
MX LAN Ports
Per-port access or trunk configuration on the appliance, with native and allowed VLANs.
MX Warm Spare (HA)
High-availability pairing — primary and spare serial, uplink mode, and virtual IPs.
MX Connectivity Monitoring Destinations
The probe destinations behind uplink loss and latency measurement.
MX Appliance Settings
Deployment mode, client tracking method, and the dynamic DNS hostname the appliance registers.
MX WAN Uplink Status
Live status of every WAN interface — private and public IP, gateway, DNS, and assignment method.
MX Uplink Usage by Network
Bytes sent and received per uplink per appliance over the window.
MX Uplink Status Rollup
Uplink counts grouped by status.
MX Third-Party VPN Peers
Non-Meraki IPsec VPN peers with their subnets and IKE configuration. The pre-shared key is never stored.
MX Site-to-Site VPN Firewall Rules
Organization-wide firewall rules applied to site-to-site VPN traffic.
MX VPN Status by Network
Per-network VPN state with exported subnets and peer counts.
MX VPN Peer Stats
Per-peer VPN latency, loss, jitter and usage summaries.
MX Security Events (IDS/AMP)
Intrusion and malware events with signature, disposition, and the client involved.
MX Org Intrusion Allow-list
Intrusion rules explicitly allowed — that is, suppressed organization-wide.
MX WAN Interface Config
Configured WAN interface settings per appliance — static or DHCP addressing, VLAN tagging, and PPPoE.
MX Performance Score
Appliance utilisation score.
MX DHCP Pool Utilisation
Used and free address counts per DHCP scope.
MX Delegated IPv6 Prefixes
Delegated IPv6 prefixes and their originating interface.
Switch Network Settings
Management VLAN, combined power mode, uplink selection and failback for the switching stack.
Switch STP / Bridge Priority
RSTP state and per-switch bridge priority — a priority of 0 marks the intended root bridge.
Switch Access Control Lists
Switch access control list rules in evaluation order.
Switch Access Policies (802.1X)
RADIUS-backed 802.1X port authentication policies with host mode and guest VLAN.
Switch Port Schedules
Time windows during which a switch port is enabled.
Switch QoS Rules
DSCP marking rules per VLAN, protocol and port.
Switch QoS Rule Order
The evaluation order of QoS rules, joinable to the rules themselves.
Switch Storm Control
Broadcast, multicast and unknown-unicast storm thresholds.
Switch DHCP Server Policy
Rogue DHCP server protection with allowed and blocked server lists and ARP inspection state.
Switch ARP Inspection Warnings
Switches that support dynamic ARP inspection but have no trusted port configured.
Switch ARP Inspection Trusted Servers
DHCP servers trusted by dynamic ARP inspection.
Switch DSCP to CoS Mappings
How DSCP markings map into switch class-of-service queues.
Switch Link Aggregations
Link aggregation group membership across switches.
Switch MTU
Default MTU size and any per-switch overrides.
Switch Multicast Settings
IGMP snooping and unknown-multicast flooding settings.
Switch Multicast Rendezvous Points
Multicast rendezvous points for PIM routing.
Switch OSPF
OSPF state, timers and areas for layer-3 switching, including IPv6.
Switch Stacks
Physical switch stack membership.
Switch Alternate Management Interface
Out-of-band management VLAN and protocols for switches.
Switch Port Rollup
Estate-wide switch port counts by status, media and link speed.
Switch Port Config (org-wide, 1 call)
Port configuration for every switch in the organization in a single request.
Switch Port Status (org-wide, 1 call)
Live port status for every switch in the organization in a single request.
Switch Port Config
Per-port configuration — VLAN, voice VLAN, PoE, STP guard, UDLD, ARP-inspection trust, port profile and mirroring.
Switch Port Status & Usage
Live per-port status with link speed, duplex, errors, client count, PoE draw and traffic rate.
Switch L3 Interfaces
Layer-3 switched virtual interfaces with their subnets and OSPF settings.
Switch L3 Static Routes
Static routes configured on layer-3 switches.
Switch Warm Spare
Layer-3 switch redundancy pairing.
Meraki Auth Users (local accounts)
Accounts that exist only inside Meraki — Client VPN and splash logins — with their authorized zones and expiry.
Group Policies
Group policies with bandwidth limits, VLAN tagging, scheduling and firewall rules.
Group Policy by Client
Which client has which group policy actually applied.
VLAN Profiles
Named VLAN sets with their name-to-ID mappings.
Network Alert Settings
Every alert type per network with whether it is enabled and where it routes.
Alert History
Alerts that actually fired, whether each destination was reached, and the full payload of configuration changes.
Webhook HTTP Servers
Webhook receivers configured on the network.
Webhook Payload Templates
Liquid templates that shape webhook payloads.
Syslog Servers
Configured syslog targets and the log roles each receives.
Network SNMP Settings
Per-network SNMP access mode, community string and v3 users.
NetFlow Settings
NetFlow export state, collector address and Encrypted Traffic Analytics.
Traffic Analysis Settings
Traffic analysis mode and any custom pie-chart classifications.
Network Settings
Local and remote status page exposure and whether the local page is password protected.
Firmware Status by Product
Current firmware per product type with the last and next scheduled upgrade.
Client Count & Usage Overview
Client counts and average usage per network.
Client Bandwidth History
Network-wide upstream and downstream bandwidth over time.
Topology Nodes
Devices and clients in the LLDP/CDP-derived topology, with the root gateway marked.
Topology Links
Discovered links between devices with the port identifiers on both ends — which switch port each AP is plugged into.
Floor Plans
Uploaded floor plans with dimensions, geographic anchors and placed devices.
Appliance Event Log
The MX event stream — DHCP leases, VPN, uplink transitions and client VPN authentication.
Switch Event Log
The MS event stream — port up and down, STP topology changes, PoE and 802.1X.
Event Types Reference
Every event type a network can emit with its category and description.
Configuration Change Log (admin audit)
The admin audit log — who changed what, on which page, with the old and new value.
Camera Permission Scopes
Permission scopes that camera roles are built from.
Camera Roles
Who can view which camera footage, and where each role applies.
Camera Onboarding Status
Claim and onboarding state per camera.
Camera Custom Analytics Artifacts
Custom analytics models uploaded to the organization.
Camera Boundary Areas
Configured area boundaries per camera.
Camera Boundary Lines
Configured line-crossing boundaries per camera.
Camera Quality & Retention Profiles
Footage retention days, resolution, audio recording and cloud archive per profile.
Camera Schedules
Recording schedules available to cameras.
Camera Wireless Profiles
Wireless profiles cameras connect with. The pre-shared key is never stored.
Camera Quality & Retention (per device)
Per-camera quality, resolution and retention settings.
Camera Video Settings
Whether the external RTSP stream is enabled and its URL.
Camera Sense (MV Sense)
MV Sense object detection and audio detection state.
Camera Analytics Zones
Analytics zones defined on each camera.
Camera Custom Analytics (per device)
Custom analytics model applied to each camera.
Sensor Readings (latest)
Latest reading per sensor per metric — temperature, humidity, door, water, battery, CO2, TVOC, PM2.5, noise, air quality, power and current.
Sensor Alerts (current)
Sensors currently in an alerting state, counted by metric.
Sensor Alerts Overview
Sensor alert counts by metric over the window.
Sensor Alert Profiles
Thresholds that trigger a sensor alert and who is notified.
Sensor MQTT Brokers
MQTT brokers sensor telemetry is published to.
Sensor Relationships
Which camera each sensor is paired with for livestream.
Cellular Gateway Uplink Status
Cellular uplink status with signal strength, provider, APN and ICCID.
Cellular eSIM Inventory
eSIM estate with status, assigned device and service plan.
Cellular eSIM Service Providers
Carriers available for eSIM activation.
Cellular eSIM Provider Accounts
Carrier accounts linked to the organization for eSIM billing.
Cellular Gateway DHCP
DHCP lease time and DNS servers for the cellular gateway.
Cellular Gateway Subnet Pool
Subnet pool and deployment mode for cellular gateways.
Cellular Gateway Uplink Settings
Configured bandwidth limits on the cellular uplink.
Cellular Gateway Connectivity Monitoring
Probe destinations used to test cellular connectivity.
Cellular Gateway LAN
LAN address, subnet and fixed IP assignments per cellular gateway.
Cellular Gateway Port Forwarding
Inbound port-forwarding rules on a cellular gateway.
Systems Manager APNs Certificate
The Apple Push certificate MDM depends on — when it expires, managed Apple devices stop responding.
Systems Manager VPP Accounts
Apple Volume Purchase Program accounts and their token expiry.
Systems Manager Admin Roles
Limited-scope Systems Manager admin roles.
Systems Manager Devices
Managed device inventory with OS, model, supervision state and last check-in.
Systems Manager Users
Systems Manager users with their directory group membership.
Systems Manager Profiles
Configuration profiles and the payload types each carries.
Systems Manager Target Groups
Device target groups used to scope profiles and apps.
Systems Manager Trusted Access Configs
Certificate-based network access for managed devices, with the SSID and access window.
Systems Manager User Access Devices
Devices enrolled for trusted access, with their connections.