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.
Changelog
2025-04-10
- Initial version of the document