Introduction

In Meraki DataMagic Ports can be:

• Physical Ports (eg WAN1, Switch port 05, AP LAN port)
• Wifi Channels (e.g. wifi0, wifi1, wifi2)

Much information can be obtained about ports.  If you have configured SNMP access for an organization, Meraki DataMagic will attempt to collect usage data with high frequency (once every 5 minutes).

Because there are so many columns of data, two screenshots are shown here of the same rows:

Second set of columns

Note that different ports have different information available.  This is down to the information available via the Meraki API and SNMP MIB.

Table Definition

Schema for Table: "Ports"

Name	Type	Description
Id	uuid	Unique identifier for the entity record
DeviceId	uuid	Foreign key reference to the Device that contains this port
PortId	text	Port identifier or number on the device
ClientCount	integer	Number of clients currently connected to this port
Duplex	text	Duplex mode of the port connection (full, half)
Errors	text	Error messages or codes detected on this port
IsEnabled	boolean	Indicates whether the port is administratively enabled
PowerUsageWh	double precision	Power usage in watt-hours for Power over Ethernet
Status	text	Current operational status of the port
TrafficSentKbps	double precision	Traffic transmission rate in kilobits per second
TrafficRecvKbps	double precision	Traffic reception rate in kilobits per second
TrafficTotalKbps	double precision	Total traffic rate (sent + received) in kilobits per second
UsageSentKb	double precision	Total data transmitted through the port in kilobytes
UsageRecvKb	double precision	Total data received through the port in kilobytes
UsageTotalKb	double precision	Total data usage (sent + received) in kilobytes
Warnings	text	Warning messages or conditions detected on this port
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
CdpAddress	text	CDP address of connected device
CdpCapabilities	text	CDP capabilities of connected device
CdpDeviceId	text	CDP device identifier of connected device
CdpPlatform	text	CDP platform information of connected device
CdpVersion	text	CDP version information of connected device
IsUplink	boolean	Indicates whether this port is configured as an uplink port
LldpManagementAddress	text	LLDP management address of connected device
LldpPortDescription	text	LLDP port description reported by connected device
LldpSystemCapabilities	text	LLDP system capabilities of connected device
LldpSystemDescription	text	LLDP system description of connected device
LldpSystemName	text	LLDP system name of connected device
PoeStandard	text	Power over Ethernet standard supported by this port (802.3af, 802.3at, etc.)
SourceMac	text	Source MAC address for discovery protocols
SpeedMbps	integer	Link speed in megabits per second
MacVendorId	uuid	Foreign key reference to the MAC vendor information for devices connected to this port
AccessPolicyNumber	integer	Access policy number applied to this port
AccessPolicyType	text	Type of access policy applied to this port
AdaptivePolicyGroupId	text	Adaptive policy group identifier applied to this port
AllowedVlans	text	List of allowed VLANs for this port
IsDaiTrusted	boolean	Indicates whether Dynamic ARP Inspection (DAI) is trusted on this port
IsFlexibleStackingEnabled	boolean	Indicates whether flexible stacking is enabled on this port
IsIsolationEnabled	boolean	Indicates whether port isolation is enabled
IsPeerSgtCapable	boolean	Indicates whether the port is capable of Security Group Tag (SGT) peering
IsPoeEnabled	boolean	Indicates whether Power over Ethernet is enabled on this port
IsRstpEnabled	boolean	Indicates whether Rapid Spanning Tree Protocol is enabled
LinkNegotiation	text	Link negotiation settings for the port
LinkNegotiationCapabilities	text	Available link negotiation capabilities for the port
MacAllowList	text	List of MAC addresses allowed on this port
MirrorMode	text	Port mirroring mode configuration
Name	text	Human-readable name assigned to the port
PortScheduleId	text	Port schedule identifier for time-based access control
ProfileId	text	Profile identifier applied to this port
ProfileIname	text	Profile name applied to this port
ProfileIsEnabled	boolean	Indicates whether the applied profile is enabled
StpGuard	text	Spanning Tree Protocol guard settings
Tags	text	Tags or labels applied to this port for categorization
Udld	text	UniDirectional Link Detection (UDLD) configuration
Vlan	integer	VLAN ID assigned to this port
VoiceVlan	integer	Voice VLAN ID for VoIP traffic on this port
Utilization80211	double precision	802.11 wireless utilization percentage for wireless ports
UtilizationNon80211	double precision	Non-802.11 wireless utilization percentage for wireless ports
CellularGatewayApn	text	Cellular Access Point Name (APN) configuration
CellularGatewayConnectionType	text	Cellular connection type (LTE, 5G, etc.)
CellularGatewayModel	text	Cellular gateway model information
CellularGatewayProvider	text	Cellular gateway provider name for cellular interfaces
CellularGatewayRoamingStatus	text	Cellular roaming status (home, roaming, etc.)
CellularGatewaySignalStatRsrp	text	Cellular signal power indicator (RSRP) in dBm
CellularGatewaySignalStatRsrq	text	Cellular signal quality indicator (RSRQ) in dB
CellularGatewaySignalType	text	Cellular signal type or technology used
UplinkLatencyMs	double precision	Uplink latency in milliseconds for this port
UplinkLossPercent	double precision	Uplink packet loss percentage for this port
TrafficRecvPktsps	double precision	Traffic reception rate in packets per second
TrafficSentPktsps	double precision	Traffic transmission rate in packets per second
TrafficTotalPktsps	double precision	Total traffic rate (sent + received) in packets per second