Custom reporting on DEX tables

reference brazil Updated Oct 22, 2026 4 min read custom-reporting-dex-tables.md
Raw file servicenow.com

DEX tables store metrics data that you can use to generate custom reports.

Table

Name

Update frequency

Base functionality

Data

DEX Device Metrics Daily Average Metrics

dex_device_metrics_daily_avg

Daily

DEX Score

Daily averages for Battery health, CPU usage, Disk read/sec, Disk usage, memory usage, energy consumption, IO usage read, IO usage write, memory usage, Wifi RSSI, Wifi receive rate, Wifi transmit rate

Device ADH Metric Each Agent Weekly

dex_score_device_adh_metric_each_agent_weekly

Weekly

DEX Score

Weekly averages for Battery health, CPU usage, Disk read/sec, Disk usage, memory usage, energy consumption, IO usage read, IO usage write, memory usage, Wifi RSSI, Wifi receive rate, Wifi transmit rate

Device ADH Metric Each Agent Monthly

dex_score_device_adh_metric_each_agent_monthly

Monthly

DEX Score

Monthly averages for Battery health, CPU usage, Disk read/sec, Disk usage, memory usage, energy consumption, IO usage read, IO usage write, memory usage, Wifi RSSI, Wifi receive rate, Wifi transmit rate

DEX Installed Application Metrics Daily Average Metrics

dex_installed_app_metrics_daily_avg

Daily

DEX Score

Daily averages of installed application performance

Installed Application ADH Metric Each Agent Weekly

dex_score_installed_application_adh_metric_each_agent_weekly

Weekly

DEX Score

App crashes, app usage, CPU usage, memory usage

Installed Application ADH Metric Each Agent Monthly

dex_score_installed_application_adh_metric_each_agent_monthly

Monthly

DEX Score

App crashes, app usage, CPU usage, memory usage

DEX Web Application Metrics Daily Average Metrics

dex_web_app_metrics_daily_avg

Daily

DEX Score

App usage, DNS lookup time, Failed web requests, Page load time, response time

Web Application ADH Metric Each Agent Weekly

dex_score_web_application_adh_metric_each_agent_weekly

Weekly

DEX Score

App usage, DNS lookup time, Failed web requests, Page load time, response time

Web Application ADH Metric Each Agent Monthly

dex_score_web_application_adh_metric_each_agent_monthly

Monthly

DEX Score

App usage, DNS lookup time, Failed web requests, Page load time, response time

Device System Compliance

dex_ci_device_system_compliance

Daily

Insights - System compliance

Compliance rating %, non-compliant application list, non-compliant policy metrics list

Device Battery Health

dex_ci_device_battery_health

Insights - Battery health

Battery health, designed capacity, full charge capacity, percentage of designed capacity, battery condition, battery serial number, battery status, chemistry, cycle count, design voltage, installed batteries, estimated runtime, and charge percentageStores multiple records for each device.

Device System Time Report

dex_ci_device_system_time_report

Insights - System time

Up time, boot time, last reboot time, device age

Remedial Action Execution

sn_reacf_remedial_action_execution

DEX Application and Device HealthProactive Engagement

Remedial action name, parent record from where the action was executed, action execution record or description, target record or device name on which the action is executed, execution state, and origin or source application of the remedial action

Experience Issues

sn_pren_experience_issue

Proactive Engagement

Experience issue ID, issue registry numbers, state, reason for end state, fallback result, origin or source applicationExperience issues have the following sources:

  • DEX Self-service for employees
  • Employee self-service from Desktop Assistant
  • Device actions from DEX Self-service
  • Device actions from Desktop Assistant
  • Self-service using ServiceNow Otto
  • Proactive Engagement
  • Actions initiated by service desk agents

Device Pending Updates

dex_ci_device_pending_update

Daily

DEX

Software patches, security fixes, feature upgrades, or driver updates released by the OS vendor (Microsoft/Apple) but not installed on the device

Device User Profiles

dex_ci_device_user_profile

Daily

DEX

Collection of settings, files, and configuration data that defines a user's environment

Device Logged In User Activities

dex_ci_device_logged_in_user_activity

Daily

DEX

List of users currently authenticated on a device, through either the console or a terminal

Device Metrics

dex_ci_device_metrics

Daily

DEX

Details on memory usage, virtual memory, and device stability, including antivirus status, firewall status, system uptime, current clock speed, and power plan configurationStores one record for each device.

Device BIOS details

dex_ci_device_bios_details

Daily

DEX

Configuration item, SMBIOS BIOS version, name, serial number, version, manufacturer, and computer status. Stores one record for each device

Device Peripherals

dex_ci_device_peripheral

Daily

DEX

Configuration item, name, status, description, manufacturer, service, and device class of peripherals connected to a device. Stores multiple records for each device

Device BSOD

dex_ci_device_bsod

Daily

DEX

Configuration item, count of blue screen of death (BSOD) events, and event detailsStores one record for each device.

Device Network Profile

dex_ci_device_network_profile

Daily

DEX

Configuration item and VPN profile fieldsStores one record for each device.

Device Network Adapters

dex_ci_device_network_adapter

Daily

DEX

Configuration item, name, interface description, interface index, status, MAC address, link speed, and additional fieldsStores multiple records for each device.

Device BitLocker

dex_ci_device_bitlocker

Daily

DEX

Configuration item, volume type, mount point, capacity, volume status, encryption percentage, protection status, encryption method, and key protectorStores multiple records for each device.

Device OS Details

dex_ci_device_os_details

Daily

DEX

Configuration item, platform, locale, status, code set, country code, system device, system directory, build number, build type, service pack major version, service pack minor versionStores one record for each device.

Device Hard Drives

dex_ci_device_hard_drive

Daily

DEX

Configuration item, media loaded, size, and additional fields. Stores multiple records for each deviceThis table doesn't contain CMDB fields.

Device Wi-Fi Status

dex_ci_device_wifi_status

Daily

DEX

SSID, channel, physical address, state, authentication, radio type, profile, description, and driver dateStores one record for each device.

Search documentation
Search document titles and file paths on the brazil branch