Windows 10 + 11 Version Metrics
Purpose
This solution displays well-calculated version metrics with multiple filters.
Associated Content
| Content | Type | Function |
|---|---|---|
| View - (pvl_v_windows_version_metrics) | Script | To import SEC - Windows Patching - MySQL View - pvl_v_windows_version_metrics view. |
| Table - (plugin_proval_windows_os_support) | Script | To insert the latest version of SEC - Windows Patching - Custom Table - plugin_proval_windows_os_support table. |
| View - pvl_v_windows_version_metrics | View | The purpose of this view is to serve the SEC - Windows Patching - Dataview - Windows 10 - 11 Version Metrics (Clientid = 0) and SEC - Windows Patching - Dataview - Windows 10 - 11 Version Metrics - Client Filter (Clientid > 0) dataviews. |
| Table - plugin_proval_windows_os_support | Custom Table | This table is a manually updated table that displays Windows operating systems support end dates, build numbers, and their respective releases, if any. |
| Dataview - Windows 10 - 11 Version Metrics | Dataview | Displays the number of Windows 10 and Windows 11 machines by the build number (ReleaseID) as well as a calculated percentage of machines on that version against the total number of Windows 10 and Windows 11 devices. Several filters are available for this data. |
| Dataview - Windows 10 - 11 Version Metrics - Client Filter | Dataview | Displays the number of Windows 10 and Windows 11 machines by the build number (ReleaseID) as well as a calculated percentage of machines on that version against the total number of Windows 10 and Windows 11 devices for each client. Several filters are available for this data. |
Implementation
- Import the CWM - Automate - Script - MySQL - View - Create (pvl_v_windows_version_metrics) script.
- Execute the script against any machine in the environment. This will create the SEC - Windows Patching - MySQL View - pvl_v_windows_version_metrics and update the SEC - Windows Patching - Custom Table - plugin_proval_windows_os_support table.
- Import the SEC - Windows Patching - Dataview - Windows 10 - 11 Version Metrics dataview.
- Import the SEC - Windows Patching - Dataview - Windows 10 - 11 Version Metrics - Client Filter dataview.
- Verify the presence of data in the dataview.
- Remove CWM - Automate - Script - MySQL - View - Create (pvl_v_windows_version_metrics) and CWM - Automate - Script - MySQL - Table - Create (plugin_proval_windows_os_support) as they are no longer needed.
FAQ
Q: What should I do if the dataviews are not displaying any data?
A: Open a RAWSQL monitor set and execute the following queries one after another to find your answer:
SELECT * FROM [pvl_v_windows_version_metrics](/docs/baeb3063-b28b-4eae-975d-e55af60c0466);SELECT * FROM [plugin_proval_windows_os_support](/docs/938cd822-f6a3-4ee3-add2-62b407e45622);