Device Reports

How to export Device Reports using the Device menu

Device Reports

Device export functionality generates comprehensive reports of all devices within a TelemetryOS account, delivering structured data for inventory management, troubleshooting, and analytics workflows. Exports produce complete device fleet snapshots in machine-readable formats for integration with external systems.

Export Architecture

Device exports produce structured data files containing complete inventory of registered devices with operational status, configuration parameters, and performance metrics. This capability supports both human analysis and automated system integration scenarios.

Export Format Options

The export system supports two output formats optimized for different consumption patterns:

FormatStructureOptimal Use Case
CSV (Comma-Separated Values)Tabular dataSpreadsheet applications (Excel, Google Sheets), database imports
JSON (JavaScript Object Notation)Hierarchical structured dataProgrammatic consumption, automation scripts, monitoring platforms

CSV characteristics:

  • Flat rows suitable for filtering and sorting
  • Compatible with spreadsheet applications
  • Human-readable tabular format
  • Easy bulk manipulation

JSON characteristics:

  • Nested object relationships preserved
  • Data hierarchy and type information maintained
  • Direct integration with automation scripts
  • No parsing overhead for programmatic consumption

Both formats contain identical data schemas but differ in structural representation.

👍

Exported files download to the browser's default download directory, following standard browser file handling behavior.

Export Use Cases

Inventory Management

Device exports deliver complete fleet inventories in portable formats:

Applications:

  • Offline record-keeping and backup documentation
  • Compliance reporting for audits
  • Historical snapshots of fleet composition
  • Change tracking over time

Organizations can maintain historical snapshots documenting fleet composition at specific points in time, supporting audit requirements and change tracking.

Health Monitoring

Export data includes operational health indicators:

Metrics included:

  • Last seen timestamps
  • Error counts
  • Connectivity metrics
  • Uptime percentages
  • Performance indicators

Comparing exports over time reveals degradation patterns, recurring issues, or devices requiring attention before complete failures occur.

Deployment Analysis

Playlist assignment data within exports reveals content distribution patterns:

Analysis capabilities:

  • Content reach by location
  • Coverage gap identification
  • Content targeting optimization
  • Geographic deployment density

Location data supports geographic analysis of deployment density and service coverage.

Device Report Parameters

Exported CSV or JSON files include comprehensive device information organized across multiple fields:

FieldDescription
account_idUnique identifier for the device (UUID/asset tag)
nameHuman-friendly name assigned in the fleet
descriptionOptional device description
asset_idAsset identifier assigned to the device
serial_numberManufacturer serial or hardware ID
modelHardware model (e.g., Node Pro)
platformCurrent platform (e.g., TelemetryOS Edge)
regionDevice region (e.g., US)
locationAssigned location or URL
organization_idOrganization ID association
web_app_idWeb app ID association
provisioning_idProvisioning ID association
statusOperational state (Online, Offline, Inactive, Updating, Error)
last_seen_dateTimestamp when device last checked in
seen_from_dateTimestamp of first device check-in
last_seen_ipLast IP address when device was online
last_onlineTimestamp of last online status
last_player_offlineLast player when offline
last_system_onLast system when online
disabledDevice disabled status (TRUE/FALSE)
lockedDevice locked status (TRUE/FALSE)
uptime_percentPercentage of time device was running
operating_systemDevice operating system
browserBrowser used with device
playerPlayer used with device
app_versionCurrent app version
player_versionCurrent player version
connection_typeConnection type
chrome_device_idChrome device ID (if applicable)
chromecastChromecast connection status
player_channelPlayer channel status (e.g., stable)
memory_used_percentageMemory usage percentage
cpu_load_percentCurrent CPU load
cache_usage_percentCache usage percentage
cache_miss_rate_24h24-hour cache miss rate percentage
connection_countNumber of connections
reconnects_countNumber of reconnections
cache_evictionsCache eviction count
content_bandwidth_monthMonthly content bandwidth
content_bandwidthTotal content bandwidth used
playlistsPlaylists used by device
playlist_idsPlaylist IDs used by device
content_playback_modeCurrent playback mode
playing_untilTimestamp when device stopped playing
video_sync_startVideo sync start time
video_sync_endVideo sync end time
audio_volumeCurrent device audio volume
show_blank_screenBlank screen display status (TRUE/FALSE)
show_interactive_menuInteractive menu usage status (TRUE/FALSE)
playlist_schedulesCurrent playlist schedules
languageLanguage used
update_typeUpdate type
update_hour_of_dayUpdate hour of day
restart_timeCurrent restart time
active_hoursDevice active hours
api_enabledEnabled API
log_levelLog level applied to device
pause_modePause mode usage (TRUE/FALSE)
tagsIncluded tags
active_windowActive window schedule
serial_commandsSerial commands
hdmi_cecHDMI-CEC low-speed control protocol status
configDevice configuration
serial_connectionSerial connection information
physical_web_urlPhysical web URL
last_errorLast error message
errors_countError count
last_degraded_storageLast degraded storage timestamp
error_logsError logs associated with device
created_atFile creation timestamp
updated_atFile last updated timestamp

Common Integration Patterns

Spreadsheet analysis: CSV export → Excel/Google Sheets → Pivot tables and filtering

Monitoring integration: JSON export → Script parsing → Monitoring platform ingestion

Backup documentation: Periodic exports → Versioned storage → Historical fleet records

Compliance reporting: CSV export → Filter by criteria → Audit documentation

Health dashboards: JSON export → Visualization tools → Real-time health displays

Configuration Specifications

Device reports generate through Devices interface (Devices > Export button).

Export Options

  • CSV format (tabular data)
  • JSON format (structured hierarchical data)

Export Scope

  • All devices in account (no filtering during export)
  • Current state snapshot (not historical data)

Limitations

  • Export captures current state only (not time-series data)
  • No scheduling or automation (manual export only)
  • Large fleets may take 10-30 seconds to generate
  • File size scales with device count (100 devices ≈ 100KB CSV)
  • No incremental exports (always full fleet)
  • Browser download location determined by browser settings
  • No built-in encryption (files contain sensitive device data)
  • Export frequency not rate-limited (can export repeatedly)
  • No filtering during export (filter data after export in analysis tools)
  • Maximum export size: all devices in account (no hard limit, but very large exports may timeout)