OverviewQuick StartUser InterfaceFAQLogicMonitor LogicModulesSupportSQL QueriesSyncing With MerakiMeraki EstateAdministratorsAP SSIDsAppliance VLANsChange HistoryClient HistoryClientsConfig TemplatesDevice HistoryDevicesFloor PlansNetworksNetwork EventsOrganizationsPortsSensor DataVPN PeersWAN UsageWireless FailuresAdminMac VendorsOrganizations
Meraki DataMagic - WAN Interface Usage
Introduction
Meraki MX Security Appliances record information about Wide Area Network (WAN) usage. Meraki DataMagic stores this information with hourly resolution, and for the retention period (typically 60 days).
To view details for a given time, you can review the table or hover the summary data (Blue = WAN1, Red = WAN2).
Table Definition
| Name | Type | Description |
|---|---|---|
| Id | uuid | Unique identifier for the entity record |
| NetworkId | uuid | Foreign key reference to the Network that this WAN usage data belongs to |
| WanInterfaceId | integer | Legacy WAN interface identifier (to be replaced by WanInterfaceName) |
| OccurredDuringHour | timestamp with time zone | Hour timestamp for which this bandwidth usage data was recorded |
| SentBytes | bigint | Total bytes transmitted through the WAN interface during this hour |
| ReceivedBytes | bigint | Total bytes received through the WAN interface during this hour |
| Created | timestamp with time zone | Timestamp when the record was initially created in the system |
| LastModified | timestamp with time zone | Timestamp when the record was last modified or updated |
| LimitDownKbps | bigint | Download bandwidth limit configured for this interface in kilobits per second |
| LimitUpKbps | bigint | Upload bandwidth limit configured for this interface in kilobits per second |
| UplinkLGoodputKb | double precision | Uplink goodput (effective throughput) in kilobits during this measurement period |
| UplinkLJitterMs | double precision | Uplink jitter in milliseconds during this measurement period |
| UplinkLatencyMs | double precision | Uplink latency in milliseconds during this measurement period |
| UplinkLossPercent | double precision | Uplink packet loss percentage during this measurement period |
| WanInterfaceName | text | WAN interface name in standard format (wan1, wan2, etc.) |
