plugin_proval_h_msp_metrics
Purpose
This custom table serves as a data repository for MSP metrics. It is populated and created by the MSP Automation Metrics - plugin_proval_h_msp_metrics script.
Dependencies
CWM - Automate - Script - MSP Automation Metrics - plugin_proval_h_msp_metrics
Tables
plugin_proval_h_msp_metrics
| Column | Type | Explanation |
|---|---|---|
| DateTime | timestamp | Date the metrics were gathered |
| Agents | int(10) | Total Agent Count |
| Agents_Online_30_Days | int(10) | Total Agent Count online in the last 30 days |
| Servers | int(10) | Total Servers Count |
| Workstations | int(10) | Total Workstations Count |
| Windows | int(10) | Total Windows Count |
| Non_Windows | int(10) | Total Non-Windows Count |
| Servers_Patching | int(10) | Total Servers in Patching |
| Workstations_Patching | int(10) | Total Workstations in Patching |
| Servers_Missing_Patches | int(10) | Total Missing Patches for Servers in Patching |
| Workstations_Missing_Patches | int(10) | Total Missing Patches for Workstations in Patching |
| Tickets_30_Days | int(10) | Total Tickets generated by the RMM in the last 30 days |
| Time_Saved_All_Scripts | mediumint(20) | Total time saved by automation in the last 30 days - All Scripts (in minutes) |
| Time_Saved_ProVal_Scripts | mediumint(20) | Total time saved by automation in the last 30 days - ProVal scripts (in minutes) |