MySQL - View - Create (pvl_patch_cu_compliance)

Summary

The script aims to generate views named pvl_patch_cu_compliance and pvl_patch_cu_compliance_clients, and subsequently grant access permissions to all currently active Automate users.

Run the script on any computer to create the views, and afterward, remove the script from the environment.

Sample Run

Dependencies

• Custom Table - pvl_win_latest_installed_cu
• Script - Get Latest Installed Cumulative Update
• Solution - Latest Installed Cumulative Update
• Custom Table - plugin_proval_windows_os_support
• Script - MySQL - Table - Create (plugin_proval_windows_os_support)

Output

• Custom Views

Changelog

2025-04-10

• Initial version of the document