Admin - Patching Metrics Overview
Summary
This document presents the fundamental patching-related statistics for the patch-managed Windows computers in the environment. Data is displayed with respect to the Approval Age of the patches. It will show five rows, with one row per approval age category.
The approval age is divided into five categories:
- Less than 7 Days (≤ 7)
- Between 8 to 14 Days (8-14)
- Between 15 to 21 Days (15-21)
- Between 22 to 30 Days (22-30)
- More than 30 Days (> 30)
The SQL query filters the results for the patch-managed computers only. Removing j.Patching Policy = 'Managed' from the SQLWhere dataview will also show data for the unmanaged Windows machines.
Dependencies
plugin_proval_v_patching_metrics_overview
Columns
| Column | Description |
|---|---|
| Approval Age | Approval age of the patches in days ('≤ 7', '8-14', '15-21', '22-30', '> 30') |
| Total Approved | Number of patches approved within the respective approval age for the whole environment |
| Total Missing | Number of approved patches that aren't installed |
| Total Approved Servers | Number of patches approved within the respective approval age for all the servers |
| Total Missing Servers | Number of approved patches that aren't installed for the servers |
| Missing Per Server | Average number of missing patches per server |
| Total Approved Workstations | Number of patches approved within the respective approval age for the workstations |
| Total Missing Workstations | Number of approved patches that aren't installed for the workstations |
| Missing Per Workstation | Average number of missing patches per workstation |
| Patching Policy | Patching Policy (Managed |
| Sort | A custom column to sort the dataview in proper order (Hidden) |