MySQL - View - Create (pvl_cu_compliance)

Summary

The script aims to generate views named pvl_cu_compliance and pvl_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

• CWM - Automate - Custom Table - pvl_win_latest_installed_cu
• SEC - Windows Patching - Custom Table - plugin_proval_windows_os_support

Output

• Custom Views