Patching Metrics
Purpose
To granularly present the fundamental patching-related statistics for the whole environment, clients, and computers scattered throughout various patch approval ages.
Minimum Requirement: MySQL 5.7.7
Associated Content
| Content | Type | Function |
|---|---|---|
| MYSQL - View - Create - Plugin_ProVal_v_Patching_Metrics_Overview* | Script | Imports the plugin_proval_v_patching_metrics_overview view. |
| plugin_proval_v_patching_metrics_overview | View | Baseline for the dataviews. |
| Patching Metrics Overview | Dataview | Displays the consolidated statistics for the whole environment. |
| Patching Metrics Overview - Client Filter | Dataview | Displays the statistics for each client. |
| Patching Metrics Overview - Computer Filter | Dataview | Displays the statistics for each computer. |
Implementation
- Import the MYSQL - View - Create - Plugin_ProVal_v_Patching_Metrics_Overview* script.
- Import the Patching Metrics Overview dataview.
- Import the Patching Metrics Overview - Client Filter dataview.
- Import the Patching Metrics Overview - Computer Filter dataview.
- Debug the MYSQL - View - Create - Plugin_ProVal_v_Patching_Metrics_Overview* script against any computer and ensure that the dataviews are populated with the data.
FAQ
Q: The MYSQL - View - Create - Plugin_ProVal_v_Patching_Metrics_Overview* script is failing.
A: Please ensure that the minimum requirement is met and that the MySQL version is at least 5.7.7.
You can check the database version from the Server Status in Control Center.
