OverviewQuick StartUser InterfaceFAQLogicMonitor LogicModulesSupportSQL QueriesSyncing With MerakiMeraki EstateAdministratorsAP SSIDsAppliance VLANsChange HistoryClient HistoryClientsConfig TemplatesDevice HistoryDevicesFloor PlansNetworksNetwork EventsOrganizationsPortsSensor DataVPN PeersWAN UsageWireless FailuresAdminMac VendorsOrganizations
Meraki DataMagic - Clients
Introduction
A Network may contain clients, such as laptops and phones, connecting directly to switches via ethernet ports or via Wifi / Access Points.
The information on this page represents clients that have been seen at any time during the data retention period and can be searched, filtered, sorted, viewed, and downloaded.
Table definition
| Name | Type | Description |
|---|---|---|
| Id | uuid | Unique identifier for the entity record |
| NetworkId | uuid | Foreign key reference to the Network containing this client |
| ClientVpnConnectionsCount | integer | Number of active VPN connections for this client |
| Description | text | User-provided description or notes about the client device |
| FirstSeen | timestamp with time zone | Timestamp when the client was first observed on the network |
| GroupPolicy8021x | text | 802.1x group policy applied to this client |
| Ip | text | IPv4 address assigned to the client |
| Ip6 | text | IPv6 address assigned to the client |
| Ip6Local | text | IPv6 link-local address of the client |
| LastSeen | timestamp with time zone | Timestamp when the client was last observed on the network |
| Mac | text | MAC address of the client device (may be hashed depending on privacy settings) |
| Manufacturer | text | Manufacturer name derived from MAC address OUI |
| MerakiId | text | Unique Meraki identifier for this client |
| Notes | text | Administrative notes about this client |
| Os | text | Operating system detected on the client device |
| SmInstalled | boolean | Indicates whether Systems Manager is installed on this client device |
| Ssid | text | SSID name of the wireless network the client is connected to |
| SwitchPort | text | Switch port number where the client is physically connected |
| Status | text | Current connection status of the client (online, offline, etc.) |
| User | text | Username associated with the client device |
| UsageSentKb | double precision | Data transmitted by the client in kilobytes |
| UsageReceivedKb | double precision | Data received by the client in kilobytes |
| UsageTotalKb | double precision | Total data usage (sent + received) by the client in kilobytes |
| Vlan | integer | VLAN ID assigned to the client |
| WirelessCapabilities | text | Wireless capabilities supported by the client device |
| 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 |
| MacVendorId | uuid | Foreign key reference to the MAC vendor information for this client |
| RecentDeviceId | uuid | Foreign key reference to the Device that the client was most recently connected to |
| AdaptivePolicyGroup | text | Adaptive policy group assigned to the client |
| DeviceTypePrediction | text | Predicted device type based on behavior analysis |
| NamedVlan | text | Named VLAN assigned to the client |
| PskGroup | text | Pre-shared key group for wireless authentication |
