OverviewQuick StartUser InterfaceFAQLogicMonitor LogicModulesSupportSQL QueriesSyncing With MerakiMeraki EstateAdministratorsAP SSIDsAppliance VLANsChange HistoryClient HistoryClientsConfig TemplatesDevice HistoryDevicesFloor PlansNetworksNetwork EventsOrganizationsPortsSensor DataVPN PeersWAN UsageWireless FailuresAdminMac VendorsOrganizations
Merkai DataMagic - Devices
Introduction
The Devices page shows details for all devices within the selected Estate node. Note that the devices table has a large number of columns and many of the columns are only populated if relevant to a particular type of device.
Available metrics
The following metrics groups are available for the following device types:
MT devices have varying capabilities, so different sensor data will be available depending on the exact model:
Table definition
| 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) | Unique serial number of the Meraki device |
| 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 configured on the device |
| ProductType | character varying(20) | Product type category of the device (e.g. appliance, wireless, switch, camera) |
| SecondaryDnsIp | character varying(20) | Secondary DNS server IP address configured on the device |
| Status | character varying(20) | Current operational status of the device (online, offline, alerting, etc.) |
| Tags | character varying(200) | Comma-separated list of tags assigned to the device for categorization |
| UsingCellularFailover | boolean | Indicates whether the device is currently using cellular as failover connection |
| 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 for the device's network connection |
| IpType | character varying(20) | Type of IP addressing used by the device (static, dhcp) |
| 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 utilization percentage for 802.11 wireless traffic |
| Channel0UtilizationNon80211 | double precision | Channel 0 utilization percentage for non-802.11 wireless traffic |
| Channel0UtilizationTotal | double precision | Channel 0 total utilization percentage combining all wireless traffic |
| Channel1Utilization80211 | double precision | Channel 1 utilization percentage for 802.11 wireless traffic |
| Channel1UtilizationNon80211 | double precision | Channel 1 utilization percentage for non-802.11 wireless traffic |
| Channel1UtilizationTotal | double precision | Channel 1 total utilization 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 wireless ethernet aggregation is enabled on the device |
| WirelessEthernetStatusAggregationSpeedMbps | integer | Aggregation speed in Mbps for wireless ethernet connections |
| 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 | Expiration date for the device license |
| 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 meter |
| 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 | Timestamp when the device was last observed as unreachable or offline |
| FirmwareVersion | character varying(32) | Current firmware version installed on the device |
| IsMagicSuiteLicensed | boolean | Indicates whether this device is licensed for use within MagicSuite platform |
| 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 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 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 utilization percentage for 802.11 wireless traffic |
| Channel2UtilizationNon80211 | double precision | Channel 2 utilization percentage for non-802.11 wireless traffic |
| Channel2UtilizationTotal | double precision | Channel 2 total utilization percentage combining all wireless traffic |
