plugin_proval_windows_update_report
Purpose
Stores the data captured by the CWM - Automate - Script - Windows Update Report [DV] script to feed into the CWM - Automate - Dataview - Windows Update Report [Script] dataview.
Dependencies
- EPM - Data Collection - Get-WindowsUpdateReport
- CWM - Automate - Solution - Windows Update Report
- CWM - Automate - Dataview - Windows Update Report [Script]
- CWM - Automate - Script - Windows Update Report [DV]
Tables
Plugin_ProVal_Windows_Update_Report
| Column | Type | Explanation |
|---|---|---|
| Computerid | int(10) | Computer ID |
| Size | varchar(15) | Size of the patch in MB |
| KB | varchar(20) | KBID of the patch |
| Title | varchar(500) | Title of the patch |
| Description | varchar(4096) | Description of the patch |
| Status | varchar(15) | Installed |
| AutoSelectOnWebSites | varchar(10) | True |
| CanRequireSource | varchar(10) | True |
| Deadline | varchar(20) | End support date of the patch |
| EulaAccepted | varchar(10) | True |
| EulaText | varchar(4096) | End User License Agreement |
| HandlerID | varchar(1024) | Handler ID of the patch |
| IsBeta | varchar(10) | True |
| IsDownloaded | varchar(10) | True |
| IsHidden | varchar(10) | True |
| IsInstalled | varchar(10) | True |
| IsMandatory | varchar(10) | True |
| IsUninstallable | varchar(10) | True |
| LastDeploymentChangeTime | varchar(50) | Last deployment change time of the patch |
| MaxDownloadSize | double | Maximum download size of the patch in MB |
| RecommendedCpuSpeed | varchar(20) | Recommended CPU speed |
| RecommendedHardDiskSpace | varchar(20) | Recommended hard disk space to install the patch |
| RecommendedMemory | varchar(20) | Recommended memory to install the patch |
| ReleaseNotes | varchar(4096) | Release notes of the patch |
| MsrcSeverity | varchar(50) | Severity of the patch: Important |
| SupportUrl | varchar(1024) | Support URL for the patch |
| Type | varchar(20) | Windows Update |
| UninstallNotes | varchar(4096) | Uninstall notes for the patch |
| RebootRequired | varchar(10) | True |
| IsPresent | varchar(10) | True |
| BrowseOnly | varchar(10) | True |
| PerUser | varchar(10) | True |
| ScriptRunTime | varchar(50) | Script run time |