Meraki DataMagic - Devices
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 |