Custom reporting on DEX tables
You can use the following listed tables to generate a report for the required metrics on DEX.
| 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 |
| 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 Health Proactive 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 application. Experience issues have the following sources:
|
| Device Pending Updates | dex_ci_device_pending_update | Daily | DEX | Pending updates are software patches, security fixes, feature upgrades, or driver updates that is released by the OS vendor (Microsoft/Apple) but are not installed on the device yet. |
| Device User Profiles | dex_ci_device_user_profile | Daily | DEX | A Windows user profile is the 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 | Logged-in user activity refers to tracking list of currently authenticated user on a device either through console or terminal. |
| Device Metrics | dex_ci_device_metrics | Daily | DEX | Device metrics provide details on memory usage, virtual memory, and device stability, including antivirus status, firewall status, system uptime, and power plan configuration. |
| Experience Issue | sn_pren_experience_issue | Proactive Engagement | ||
| Experience Issue alert | sn_pren_experience_issue_m2m_alert | Proactive Engagement | ||
| DEX Remedial Action execution | dex_remedial_action_execution | DEX Application and Device Health | ||
| Alert Impacted Users | dex_alert_impacted_users | DEX Application and Device Health | ||
| DEX MCM Metrics Data | dex_app_sccm_metric_data | DEX Application and Device Health | ||
| Check definition execution | dex_check_definition_execution | DEX Application and Device Health | ||
| Browser Extension Data | dex_ci_browser_extension | DEX Application and Device Health | ||
| Call Details | call_details | DEX for Microsoft 365 | ||
| Device system compliances | device_system_compliances | DEX Application and Device Health | ||
| Device system time reports | device_system_time_reports | DEX Application and Device Health | ||
| Device Wi-Fi Status | device_wifi_status | DEX Application and Device Health | ||
| CI Health Data | ci_health_data | DEX Application and Device Health | ||
| Device App Monitoring Data | device_app_monitoring_data | DEX Application and Device Health | ||
| Application Score All Agents Monthly | dex_score_application_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Application SLA Score All Agents Monthly | dex_score_application_sla_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Application SLA Score All Agents Weekly | dex_score_application_score_all_agents_weekly | Weekly | Digital Experience Score | |
| Application Survey Score All Agents Monthly | dex_score_application_survey_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Application Survey Score All Agents Weekly | dex_score_application_survey_score_all_agents_weekly | Weekly | Digital Experience Score | |
| Application Survey Submission Scores | dex_score_application_survey_submission_scores | - | Digital Experience Score | |
| Application Survey Topic Count All Agents Monthly | dex_score_application_survey_topic_count_all_agents_monthly | Monthly | Digital Experience Score | |
| Application Survey Topic Count All Agents Weekly | dex_score_application_survey_topic_count_all_agents_weekly | Weekly | Digital Experience Score | |
| Device ADH Metric Each Agent Monthly | dex_score_device_adh_metric_each_agent_monthly | Monthly | Digital Experience Score | |
| Device ADH Metric Each Agent Weekly | dex_score_device_adh_metric_each_agent_weekly | Weekly | Digital Experience Score | |
| Device ADH Score All Agents Daily | dex_score_device_adh_score_all_agents_daily | Daily | Digital Experience Score | |
| Device ADH Score All Agents Monthly | dex_score_device_adh_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Device ADH Score All Agents Weekly | dex_score_device_adh_score_all_agents_weekly | Weekly | Digital Experience Score | |
| Device Score All Agents Monthly | dex_score_device_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Device Score All Agents Weekly | dex_score_device_score_all_agents_weekly | Weekly | Digital Experience Score | |
| Device SLA Score All Agents Monthly | dex_score_device_sla_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Device SLA Score All Agents Weekly | dex_score_device_sla_score_all_agents_weekly | Weekly | Digital Experience Score | |
| Device Survey Score All Agents Monthly | dex_score_device_survey_score_all_agents_monthly | Monthly | Digital Experience Score | |
| Device Survey Score All Agents Weekly | dex_score_device_survey_score_all_agents_weekly | Weekly | Digital Experience Score |