Windows Update Report DV

Summary

Get a detailed list of patches that are installed or available on the local machine and store it in the plugin_proval_windows_update_report custom table.

Sample Run

Dependencies

• EPM - Data Collection - Get-WindowsUpdateReport
• CWM - Automate - Solution - Windows Update Report
• CWM - Automate - Dataview - Windows Update Report [Script]
• CWM - Automate - Custom Table - plugin_proval_windows_update_report
• CWM - Automate - Script - OverFlowedVariable - SQL Insert - Execute

Variables

Name	Description
InsertStatement	Result of the PowerShell script that attempts to retrieve the Windows Update Report

Process

1. Creating the plugin_proval_windows_update_report table if it does not already exist.
2. Changing the structure of the table if the partner is still using the older structure. This step also removes duplicate entries from the table.
3. Running the PowerShell script to retrieve the Windows Update Report.
4. Verifying the outcome.
5. Parsing the outcome to ensure SQL compatibility.
6. Inserting the data into the plugin_proval_windows_update_report table.
7. Logging any failures.

Output

• Script Log
• Custom Table
• Dataview