Meraki DataMagic - Devices

The Devices page

The Devices page lists every device in the part of the Estate selected in the tree, one row per device. Double-click a device to see its details.

A Meraki icon beside a device's name or network opens it in the Meraki Dashboard. The Type column shows an icon for the type of device: hover over it to see which.

Columns

Name is always shown. Org, Group and Network are shown only when the selection is above that level. For example, selecting an organisation hides Org, and selecting a network hides all three.

The other columns are in groups. In the Columns row above the table, choose a group to show only its columns, or All to show every column. Most groups apply to one type of device, so their columns are blank for other devices. Any column is blank when Meraki has not provided a value.

Group Columns Applies to
Identity Serial, Catalyst Serial, Network Meraki Id, Type, Mac, OUI, Model, Firmware, Tags, Order Number Every device. Catalyst Serial is only for Meraki-managed Catalyst devices
Health Status, Not Observed Since, Wireless Client Count, Downstream Packet Loss, Upstream Packet Loss, PerfScore Status and Not Observed Since apply to every device, Wireless Client Count and the packet loss columns to access points, and PerfScore to the primary appliance in a network
Traffic Down Packets, Up Packets, Down Packets Lost, Up Packets Lost Access points, covering the last hour
Addressing Internal IP, Public IP, WAN1 IP, WAN2 IP, Gateway IP, Primary DNS, Secondary DNS, IP Type, Cellular Failover Most devices. WAN1 IP, WAN2 IP and Cellular Failover are for appliances
Eth uplink Aggregation Enabled, Aggregation Speed (Mbps), A/C Connected, PoE Connected, PoE Standard, Duplex, Speed/Mbps Access points
RF BSS Count, then 802.11 %, Non-802.11 % and Total % for each radio (Ch0, Ch1 and Ch2) Access points
Wireless Latency Stats Capable, then Background, Best-effort, Video and Voice ms for each radio Access points that report latency statistics
HA HA Enabled, HA Primary, HA Spare Appliances
Sensors Apparent Power Draw, Battery %, Button press, Current Draw, Door Open, E CO2 Concentration, Frequency, Humidity %, Air Quality, Noise dBm, PM 25 conc., Power Factor %, Real Power, Remote Lockout, Downstream Power, Temp °C, TVOC, Voltage, Water Present Sensors, depending on the model
Camera Video Objects, Video Entrances Cameras
Lifecycle Claimed At, License Expiration, Effective License Expiry, End of Sale, End of Support, End of Sale Url Every device
Reporting Config Updated, Last Reported Every device
Geo Address, Latitude, Longitude Every device

Serial is the device's Meraki serial, also called its Cloud ID. For a Meraki-managed Catalyst device, Catalyst Serial shows the Cisco hardware serial that Meraki reports, which is the serial on Cisco's own records. It is blank for other devices.

Sensor readings by model

Each sensor model reports only the readings its hardware supports, so most Sensors columns are blank for any one sensor. Battery-powered sensors also report Battery %.

Model Readings
MT10 Temp °C and Humidity %
MT11 Temp °C, from a probe
MT12 Water Present
MT14 Temp °C, Humidity %, Air Quality, TVOC, PM 25 conc. and Noise dBm
MT15 The same as MT14
MT20 Door Open
MT30 Button press
MT40 Real Power, Apparent Power Draw, Current Draw, Voltage, Frequency, Power Factor %, Downstream Power and Remote Lockout

Status and warnings

Status shows an icon for Meraki's own status for the device: online, alerting, offline or dormant. Hover over the icon to see which. A device that is no longer in its organisation's Meraki inventory shows as decommissioned, and Not Observed Since shows when it was first missing. If it returns to the inventory, it takes its Meraki status again.

License Expiration, Effective License Expiry, End of Sale and End of Support show a warning icon: red when the date has passed, and amber when it is less than six months away. Once a warning shows, the End of Sale and End of Support dates link to Cisco's end-of-sale notice. Effective License Expiry shows the device's own licence expiry or, for a device without one, the organisation's co-term expiry, marked org-wide.

Device details

Double-click a device to open its details. Identity & placement, Networking and Lifecycle are always shown. Health & performance, Wireless radio, Ethernet uplink, High availability, Sensor readings and Camera appear only when the device has those details. The serial numbers and MAC address have copy buttons, and the location opens in Google Maps.

Table definition

For anyone querying a Tenant's DataMagic database directly, the Devices table has these columns, in this order:

Tip: Column names are case-sensitive, so put them in double quotes in SQL, for example SELECT "Name", "Serial" FROM "Devices".

Name Type Description
Id uuid Unique identifier for the entity record
NetworkId uuid Foreign key reference to the Network that contains this device
Serial character varying(64) Meraki serial number of the device, also called its Cloud ID
Name character varying(64) Human-readable name assigned to the device
PublicIp character varying(64) Public IP address of the device as seen from the internet
PrimaryDnsIp character varying(20) Primary DNS server IP address. Reported per device for access points and switches. For appliances it comes from the preferred WAN uplink, WAN1 where available, because MX hardware reports DNS per uplink rather than per device
ProductType character varying(20) Type of device, for example Appliance, Camera, CellularGateway, Sensor, Switch or Wireless
SecondaryDnsIp character varying(20) Secondary DNS server IP address, taken from the same source as PrimaryDnsIp so the pair always describes one interface. Null when no secondary server is configured
Status character varying(20) Current status of the device: online, alerting, offline or dormant as Meraki reports it, or decommissioned when it is no longer in the Meraki inventory
Tags character varying(200) Comma-separated list of tags assigned to the device for categorisation
UsingCellularFailover boolean Indicates whether the device is currently failing over to cellular
Wan1Ip character varying(20) IP address assigned to the primary WAN interface
Wan2Ip character varying(20) IP address assigned to the secondary WAN interface
ConfigurationUpdatedAt timestamp with time zone Timestamp when the device configuration was last updated
GatewayIp character varying(20) Gateway IP address. Reported per device for access points and switches. For appliances it comes from the preferred WAN uplink, WAN1 where available, because MX hardware reports its gateway per uplink rather than per device
IpType character varying(20) How the IP address was assigned (static, dhcp). Reported per device for access points and switches. For appliances it describes the same WAN uplink as GatewayIp and the two DNS columns, so all four always describe one interface
LanIp character varying(20) Local area network IP address assigned to the device
LastReportedAt timestamp with time zone Timestamp when the device last reported its status to the Meraki cloud
Mac character varying(20) MAC address of the device
Model character varying(20) Device model number or identifier
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
Channel0Utilization80211 double precision Channel 0 utilisation percentage for 802.11 wireless traffic
Channel0UtilizationNon80211 double precision Channel 0 utilisation percentage for non-802.11 wireless traffic
Channel0UtilizationTotal double precision Channel 0 total utilisation percentage combining all wireless traffic
Channel1Utilization80211 double precision Channel 1 utilisation percentage for 802.11 wireless traffic
Channel1UtilizationNon80211 double precision Channel 1 utilisation percentage for non-802.11 wireless traffic
Channel1UtilizationTotal double precision Channel 1 total utilisation percentage combining all wireless traffic
Channel0LatencyBackgroundTrafficMeanMs double precision Channel 0 mean latency in milliseconds for background traffic
Channel0LatencyBestEffortTrafficMeanMs double precision Channel 0 mean latency in milliseconds for best-effort traffic
Channel0LatencyVideoTrafficMeanMs double precision Channel 0 mean latency in milliseconds for video traffic
Channel0LatencyVoiceTrafficMeanMs double precision Channel 0 mean latency in milliseconds for voice traffic
Channel1LatencyBackgroundTrafficMeanMs double precision Channel 1 mean latency in milliseconds for background traffic
Channel1LatencyBestEffortTrafficMeanMs double precision Channel 1 mean latency in milliseconds for best-effort traffic
Channel1LatencyVideoTrafficMeanMs double precision Channel 1 mean latency in milliseconds for video traffic
Channel1LatencyVoiceTrafficMeanMs double precision Channel 1 mean latency in milliseconds for voice traffic
IsWirelessLatencyStatsCapable boolean Indicates whether the device is capable of providing wireless latency statistics
BasicServiceSetCount integer Number of Basic Service Sets (BSS) configured on the wireless device
WirelessEthernetStatusAggregationEnabled boolean Indicates whether Ethernet link aggregation is enabled on the wireless device
WirelessEthernetStatusAggregationSpeedMbps integer Ethernet link aggregation speed in Mbps for the wireless device
WirelessEthernetStatusPowerAcIsConnected boolean Indicates whether AC power is connected to the wireless device
WirelessEthernetStatusPowerPoeIsConnected boolean Indicates whether Power over Ethernet (PoE) is connected to the wireless device
ClaimedAt timestamp with time zone Timestamp when the device was claimed to a network
LicenseExpirationDate timestamp with time zone Expiry date of the device's own licence, where it has one
OrderNumber character varying(20) Order number for device purchase tracking
WirelessEthernetStatusPort0LinkNegotiationDuplex character varying(20) Link negotiation duplex mode for port 0 (full, half)
WirelessEthernetStatusPort0LinkNegotiationSpeedMbps integer Link negotiation speed in Mbps for port 0
WirelessEthernetStatusPort0PoeStandard character varying(20) Power over Ethernet standard used on port 0 (802.3af, 802.3at, etc.)
EndOfSale timestamp with time zone End of sale date for the device model
EndOfSaleNoticeUrl character varying(256) URL to the end of sale notice document
EndOfSupport timestamp with time zone End of support date for the device model
SensorBatteryPercentage integer Battery charge level percentage for battery-powered sensors
SensorButtonPressType character varying(20) Type of button press detected by sensor (single, double, long)
SensorDoorOpen boolean Indicates whether a door sensor detects an open door
SensorHumidityRelativePercentage integer Relative humidity percentage measured by environmental sensor
SensorIndoorAirQualityScore integer Indoor air quality score calculated from environmental sensors (0-500 scale)
SensorNoiseAmbientLevel integer Ambient noise level measured by sensor in decibels
SensorPm25Concentration integer PM2.5 particulate matter concentration in micrograms per cubic metre
SensorTemperatureCelsius double precision Temperature measured by environmental sensor in degrees Celsius
SensorTvocConcentration integer Total Volatile Organic Compounds concentration in parts per billion
SensorWaterPresent boolean Indicates whether water presence sensor detects water
CameraEntranceCount integer Number of entrance events detected by camera analytics
CameraObjectCount double precision Number of objects detected by camera analytics
SensorRemoteLockoutSwitchLocked boolean Indicates whether remote lockout switch is in locked position
SensorDownstreamPowerStateIsEnabled boolean Indicates whether downstream power state is enabled
SensorApparentPowerDraw double precision Apparent power draw measured by sensor in watts
SensorCurrentDraw double precision Current draw measured by sensor in amperes
SensorPowerFactorPercentage integer Power factor percentage measured by electrical sensor
SensorFrequencyLevel double precision Frequency level measured by sensor in hertz
SensorRealPowerDraw double precision Real power draw measured by sensor in watts
SensorVoltageLevel double precision Voltage level measured by electrical sensor in volts
SensorEco2Concentration integer eCO2 concentration measured by air quality sensor in parts per million
NotObservedSince timestamp with time zone When the device was first found missing from the Meraki inventory. Null while it is in the inventory
FirmwareVersion character varying(32) Current firmware version installed on the device
IsMagicSuiteLicensed boolean Indicates whether this device is licensed for use in Magic Suite
WirelessClientCountLastHour integer Number of wireless clients connected to the device in the last hour
AppliancePerformanceScoreLastHour double precision Overall performance score for the appliance in the last hour (0-100 scale)
DownPacketLossPercentLastHour double precision Downstream packet loss percentage in the last hour
IsApplianceHighAvailabilityEnabled boolean Indicates whether high availability is enabled for this appliance
IsApplianceHighAvailabilityPrimary boolean Indicates whether this appliance is configured as the primary in its HA pair
UpPacketLossPercentLastHour double precision Upstream packet loss percentage in the last hour
IsApplianceHighAvailabilitySpare boolean Indicates whether this appliance is configured as the spare in its HA pair
DownPacketLostLastHour bigint Number of packets lost in downstream direction in the last hour
DownPacketTotalLastHour bigint Total number of packets received (downstream) in the last hour
UpPacketLostLastHour bigint Number of packets lost in upstream direction in the last hour
UpPacketTotalLastHour bigint Total number of packets transmitted (upstream) in the last hour
Channel2LatencyBackgroundTrafficMeanMs double precision Channel 2 mean latency in milliseconds for background traffic
Channel2LatencyBestEffortTrafficMeanMs double precision Channel 2 mean latency in milliseconds for best-effort traffic
Channel2LatencyVideoTrafficMeanMs double precision Channel 2 mean latency in milliseconds for video traffic
Channel2LatencyVoiceTrafficMeanMs double precision Channel 2 mean latency in milliseconds for voice traffic
Channel2Utilization80211 double precision Channel 2 utilisation percentage for 802.11 wireless traffic
Channel2UtilizationNon80211 double precision Channel 2 utilisation percentage for non-802.11 wireless traffic
Channel2UtilizationTotal double precision Channel 2 total utilisation percentage combining all wireless traffic
Latitude double precision Latitude coordinate of the device physical location
Longitude double precision Longitude coordinate of the device physical location
LastNotifiedStatus character varying(20) The device status as of the most recent AlertMagic up/down notification sent for this device. Compared against Status to detect online/offline transitions. Null until a baseline is established
Address text Street address of the device's location, as reported by Meraki. Null when Meraki has no address
Url text Direct URL to the device's page in the Meraki Dashboard. Null until the device has been synced
CatalystSerial character varying(32) Cisco hardware serial that Meraki reports for a Meraki-managed Catalyst device. Null for other devices

Reconnection

Reconnection

Reconnection

timed out

timed out

Attempt of

Reload
An unhandled error has occurred. Reload 🗙