Patching and Cumulative Update Compliance Report

Purpose

The purpose of the dataviews included in this solution is to present the patching and cumulative update compliance score for the supported Windows computers with managed patch policies, which have been online in Automate within the past 30 days and are part of production patching groups for the whole environment and client filtered separately.

Associated Content

Auditing

Content	Type	Function
Script - MySQL - View - Create (pvl_patch_cu_compliance)	Script	Imports the associated views.
View - pvl_patch_cu_compliance	Custom View	Stores and executes the SQL query utilized by the 'Patching and CU Compliance Metrics' dataview.
View - pvl_patch_cu_compliance_clients	Custom View	Stores and executes the SQL query utilized by the 'Patching and CU Compliance Metrics - Clients' dataview.
Dataview - Patching and CU Compliance Metrics	Dataview	Displays the global data.
Dataview - Patching and CU Compliance Metrics - Clients	Dataview	Displays the client-filtered data.

Dependencies

Content	Type	Function
Custom Table - plugin_proval_windows_os_support	Custom Table	Stores the support date of different versions of the Operating System
Script - MySQL - Table - Create (plugin_proval_windows_os_support)	Script	Creates the 'Plugin_ProVal_Windows_OS_Support' table.
Solution - Latest Installed Cumulative Update	Solution	Fetches and stores the information of the latest installed Cumulative Update on Windows 10 and 11 computers.

Implementation

1. Import the following scripts from the ProSync plugin:

   • MySQL - Table - Create (plugin_proval_windows_os_support)
   • MySQL - View - Create (pvl_patch_cu_compliance)

2. Import the following dataviews from the ProSync plugin:

   • Patching and CU Compliance Metrics
   • Patching and CU Compliance Metrics - Clients

3. Follow the implementation steps provided in the Latest Installed Cumulative Update solution's document and ensure that at least the Auditing portion of the solution is installed in the environment.

4. Reload the System Cache
   

5. Execute the MySQL - Table - Create (plugin_proval_windows_os_support) script against any computer to create/update the plugin_proval_windows_os_support custom table if it is not available in the environment.

6. Execute the MySQL - View - Create (pvl_patch_cu_compliance) script against any computer to create/update the following views:

   • View - pvl_patch_cu_compliance
   • View - pvl_patch_cu_compliance_clients

7. Validate the presence of data in the following dataviews:

   • Patching and CU Compliance Metrics
   • Patching and CU Compliance Metrics - Clients

8. Remove/delete the following scripts:

   • MySQL - Table - Create (plugin_proval_windows_os_support)
   • MySQL - View - Create (pvl_patch_cu_compliance)