Cumulative Update Compliance - Report

Purpose

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

Associated Content

Auditing

Content	Type	Function
Script - MySQL - View - Create (pvl_cu_compliance)	Script	Imports the associated views.
View - pvl_cu_compliance	Custom View	Stores and executes the SQL query utilized by the 'CU Compliance Metrics' dataview.
View - pvl_cu_compliance_clients	Custom View	Stores and executes the SQL query utilized by the 'CU Compliance Metrics - Clients' dataview.
Dataview - CU Compliance Metrics	Dataview	Displays the global data.
Dataview - 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_cu_compliance)

2. Import the following dataviews from the ProSync plugin:

   • CU Compliance Metrics
   • CU Compliance Metrics - Clients

3. Follow the implementation steps provided in the Latest Installed Cumulative Update solution 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_cu_compliance) script against any computer to create/update the following views:

   • pvl_cu_compliance
   • pvl_cu_compliance_clients

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

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

8. Remove the following scripts:

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