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 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 application.Experience 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 Now Assist - Proactive Engagement - Actions initiated by service desk agents |
| 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. |
Parent Topic:Digital End-User Experience reference