SEC - Windows Patching - MySQL View - pvl_v_windows_version_metrics
Summary
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.
Unsupported for MySQL version < 5.7
Dependencies
- SEC - Windows Patching - Custom Table - plugin_proval_windows_os_support
- CWM - Automate - Script - MySQL - View - Create (pvl_v_windows_version_metrics)*
| Column | Type | Explanation |
|---|---|---|
| ReleaseID | mediumtext | The feature update version of Windows 10/11. Enterprise is a separate entry due to differing support dates. Examples: W10 - 1709, W10 - 21H1, W10 - 1803 - LTSC, W10 - 1809 - Enterprise, W11 - 22H1, W11 - 22H2 - Enterprise. Summary Rows: The generalized OS version (Windows 10, Windows 11, Windows 10 + 11) |
| Build | VarChar(50) | The full build number of the ReleaseID. Summary Rows: The generalized OS version (Windows 10, Windows 11, Windows 10 + 11). |
| Total Machines Unfiltered | decimal(23,0) | The count of machines on the ReleaseID. Summary Rows: The number of machines reporting the generalized OS version (Windows 10, Windows 11, Windows 10 + 11). |
| % Total Unfiltered | varchar(27) | The percentage of Windows 10+ machines that are on the ReleaseID. Example: Windows 10/11 Total Machines: 100, W10 - 1709 Total Machines: 10, W11 - 22H2 Total Machines: 10, W10 - 1709 % Total Unfiltered: 10.0%, W11 - 22H2 % Total Unfiltered: 10.0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11. Windows 11 + 10 - Should always be 100. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 % Total Unfiltered: 80.0%, Windows 11 % Total Unfiltered: 20.0%, Windows 11 + 10 % Total Unfiltered: 100% |
| % Total Unfiltered - OS | varchar(27) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 1709 Total Machines: 10, W11 - 22H2 Total Machines: 10, W10 - 1709 % Total Unfiltered - OS: 25.0%, W11 - 22H2 % Total Unfiltered - OS: 16.7%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10. Should always be 100. Windows 11 - The percentage of Windows 11 machines that are on Windows 11. Should always be 100. Windows 11 + 10 - Should always be 100. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 % Total Unfiltered - OS: 100.0%, Windows 11 % Total Unfiltered - OS: 100.0%, Windows 11 + 10 % Total Unfiltered - OS: 100% |
| Count Machines Online | decimal(23,0) | The count of machines on the ReleaseID that have checked into CWA within 30 days. Summary Rows: The count of machines reporting the generalized OS version (Windows 10, Windows 11, etc.) that have checked into CWA within 30 days. |
| % Total Online | decimal(28,1) | The percentage of Windows 10+ machines that are on the ReleaseID and have checked into Automate within 30 days. Example: Windows 10/11 Total Machines: 100, W10 - 1709 Online Machines: 5, W11 - 22H2 Online Machines: 7, W10 - 1709 % Total Online: 5.0%, W11 - 22H2 % Total Online: 7.0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10 and have checked into Automate within 30 days. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11 and have checked into Automate within 30 days. Windows 11 + 10 - The percentage of Windows 10+ machines that have checked into Automate within 30 days. Example: Windows 10/11 Total Machines: 100, Windows 10 Online Machines: 66, Windows 11 Online Machines: 12, Windows 10 + 11 Online Machines: 78, Windows 10 % Total Online: 66.0%, Windows 11 % Total Online: 12.0%, Windows 11 + 10 % Total Online: 78.0% |
| % Total Online - OS | decimal(28,1) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID and have checked into Automate within 30 days. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 1709 Online Machines: 35, W11 - 22H2 Online Machines: 55, W10 - 1709 % Total Online - OS: 87.5%, W11 - 22H2 % Total Online - OS: 91.7%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10 and have checked into Automate within 30 days. Windows 11 - The percentage of Windows 11 machines that are on Windows 11 and have checked into Automate within 30 days. Windows 11 + 10 - The percentage of Windows 10+ machines that have checked into Automate within 30 days. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 Online Machines: 66, Windows 11 Online Machines: 12, Windows 10 + 11 Online Machines: 78, Windows 10 % Total Online - OS: 82.5%, Windows 11 % Total Online - OS: 60.0%, Windows 11 + 10 % Total Online - OS: 78.0% |
| Machines W/ Patch Policy | decimal(23,0) | The count of machines on the ReleaseID that have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Summary Rows: The count of machines reporting the generalized OS version (Windows 10, Windows 11, Windows 10 + 11) that have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. |
| % Total W/ Patch Policy | decimal(28,1) | The percentage of Windows 10+ machines that are on the ReleaseID and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, W10 - 22H1 With Managed Patch Policy: 23, W11 - 22H2 With Managed Patch Policy: 27, W10 - 22H1 % Total W/ Patch Policy: 23.0%, W11 - 22H2 % Total W/ Patch Policy: 27.0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10 and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11 and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 + 10 - The percentage of Windows 10+ machines that have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 With Managed Patch Policy: 43, Windows 11 With Managed Patch Policy: 48, Windows 10 + 11 With Managed Patch Policy: 91, Windows 10 % Total W/ Patch Policy: 43.0%, Windows 11 % Total W/ Patch Policy: 48.0%, Windows 11 + 10 % Total W/ Patch Policy: 91.0% |
| % Total W/ Patch Policy - OS | decimal(28,1) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 1709 With Managed Patch Policy: 35, W11 - 22H2 With Managed Patch Policy: 55, W10 - 1709 % Total W/ Patch Policy - OS: 87.5%, W11 - 22H2 % Total W/ Patch Policy - OS: 91.7%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10 and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 - The percentage of Windows 11 machines that are on Windows 11 and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 + 10 - The percentage of Windows 10+ machines that have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 With Managed Patch Policy: 66, Windows 11 With Managed Patch Policy: 12, Windows 10 + 11 With Managed Patch Policy: 78, Windows 10 % Total W/ Patch Policy - OS: 82.5%, Windows 11 % Total W/ Patch Policy - OS: 60.0%, Windows 11 + 10 % Total W/ Patch Policy - OS: 78.0% |
| Online Machines W/ Patch Policy | decimal(23,0) | The count of machines on the ReleaseID that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Summary Rows: The count of machines reporting the generalized OS version (Windows 10, Windows 11, Windows 10 + 11) that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. |
| % Total Online W/ Patch Policy | decimal(28,1) | The percentage of Windows 10+ machines that are on the ReleaseID that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, W10 - 22H1 Online Machines With Managed Patch Policy: 20, W11 - 22H2 Online Machines With Managed Patch Policy: 24, W10 - 22H1 % Total Online W/ Patch Policy: 20.0%, W11 - 22H2 % Total Online W/ Patch Policy: 24.0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10 that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11 that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 + 10 - The percentage of Windows 10+ machines that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 Online Machines With Managed Patch Policy: 40, Windows 11 Online Machines With Managed Patch Policy: 45, Windows 10 + 11 With Managed Patch Policy: 85, Windows 10 % Total Online W/ Patch Policy: 40.0%, Windows 11 % Total Online W/ Patch Policy: 45.0%, Windows 11 + 10 % Total Online W/ Patch Policy: 85.0% |
| % Total Online W/ Patch Policy - OS | decimal(28,1) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 22H1 Online Machines With Managed Patch Policy: 30, W11 - 22H2 Online Machines With Managed Patch Policy: 50, W10 - 22H1 % Total Online W/ Patch Policy - OS: 75.0%, W11 - 22H2 % Total Online W/ Patch Policy - OS: 83.3%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10 that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 - The percentage of Windows 11 machines that are on Windows 11 that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Windows 11 + 10 - The percentage of Windows 10+ machines that have checked into CWA within 30 days and have a patch policy with "Managed Mode" or "Managed Mode UI Disabled" as their patch install method. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 Online Machines With Managed Patch Policy: 60, Windows 11 Online Machines With Managed Patch Policy: 10, Windows 10 + 11 Online With Managed Patch Policy: 78, Windows 10 % Total Online W/ Patch Policy - OS: 75.0%, Windows 11 % Total Online W/ Patch Policy - OS: 50.0%, Windows 11 + 10 % Total Online W/ Patch Policy - OS: 70.0% |
| Support End Date | varchar(10) | The Microsoft support end date for the ReleaseID. Summary Rows: N/A |
| Count Supported Machines | varchar(21) | The count of machines on the ReleaseID that are within their Microsoft support window. Summary Rows: The count of machines reporting the generalized OS version (Windows 10, Windows 11, Windows 10 + 11) that are within their Microsoft support window. |
| Count Unsupported Machines | varchar(25) | The count of machines on the ReleaseID that are outside their Microsoft support window. Summary Rows: The count of machines reporting the generalized OS version (Windows 10, Windows 11, Windows 10 + 11) that are outside their Microsoft support window. |
| % Supported Machines | varchar(27) | The percentage of Windows 10+ machines that are on the ReleaseID and are within their Microsoft support window. Example: Windows 10/11 Total Machines: 100, W10 - 22H1 Supported Machines: 20, W11 - 22H2 Supported Machines: 24, W10 - 22H1 % Total Online W/ Patch Policy: 20.0%, W11 - 22H2 % Total Online W/ Patch Policy: 24.0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10 and are within their Microsoft support window. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11 and are within their Microsoft support window. Windows 11 + 10 - The percentage of Windows 10+ machines that are within their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Supported Machines: 40, Windows 11 Supported Machines: 45, Windows 10 + 11 Supported Machines: 85, Windows 10 % Supported Machines: 40.0%, Windows 11 % Supported Machines: 45.0%, Windows 11 + 10 % Supported Machines: 85.0% |
| % Supported Machines - OS | varchar(27) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID and are within their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 22H1 Supported Machines: 30, W11 - 22H2 Supported Machines: 50, W10 - 22H1 % Supported Machines - OS: 75.0%, W11 - 22H2 % Supported Machines - OS: 83.3%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10 and are within their Microsoft support window. Windows 11 - The percentage of Windows 11 machines that are on Windows 11 and are within their Microsoft support window. Windows 11 + 10 - The percentage of Windows 10+ machines that are within their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 Supported Machines: 60, Windows 11 Supported Machines: 10, Windows 10 + 11 Supported Machines: 78, Windows 10 % Supported Machines - OS: 75.0%, Windows 11 % Supported Machines - OS: 50.0%, Windows 11 + 10 % Supported Machines - OS: 70.0% |
| % Unsupported Machines | varchar(31) | The percentage of Windows 10+ machines that are on the ReleaseID and are outside their Microsoft support window. Example: Windows 10/11 Total Machines: 100, W10 - 1809 Unsupported Machines: 7, W11 - 22H2 Unsupported Machines: 0, W10 - 22H1 % Total Online W/ Patch Policy: 7.0%, W11 - 22H2 % Total Online W/ Patch Policy: 0%. Summary Rows: Windows 10 - The percentage of Windows 10+ machines that are on Windows 10 and are outside their Microsoft support window. Windows 11 - The percentage of Windows 10+ machines that are on Windows 11 and are outside their Microsoft support window. Windows 11 + 10 - The percentage of Windows 10+ machines that are outside their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Unsupported Machines: 14, Windows 11 Unsupported Machines: 0, Windows 10 + 11 Unsupported Machines: 14, Windows 10 % Unsupported Machines: 14.0%, Windows 11 % Unsupported Machines: 0%, Windows 11 + 10 % Unsupported Machines: 14.0% |
| % Unsupported Machines - OS | varchar(27) | The percentage of Windows 10+ machines out of the same base OS that are on the ReleaseID and are outside their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 40, Windows 11 Total Machines: 60, W10 - 1803 Unsupported Machines: 5, W11 - 22H2 Unsupported Machines: 0, W10 - 22H1 % Unsupported Machines - OS: 12.5%, W11 - 22H2 % Unsupported Machines - OS: 0%. Summary Rows: Windows 10 - The percentage of Windows 10 machines that are on Windows 10 and are outside their Microsoft support window. Windows 11 - The percentage of Windows 11 machines that are on Windows 11 and are outside their Microsoft support window. Windows 11 + 10 - The percentage of Windows 10+ machines that are outside their Microsoft support window. Example: Windows 10/11 Total Machines: 100, Windows 10 Total Machines: 80, Windows 11 Total Machines: 20, Windows 10 Unsupported Machines: 8, Windows 11 Unsupported Machines: 0, Windows 10 + 11 Unsupported Machines: 8, Windows 10 % Unsupported Machines - OS: 10.0%, Windows 11 % Unsupported Machines - OS: 0%, Windows 11 + 10 % Unsupported Machines - OS: 8.0% |
| Client_Name | Varchar(50) | Name of the client where clientid > 0 and 'Environmental Calculation' for the global calculation. |