Patch Config Audit
Summary
This dataview displays the patch audit data stored in the pvl_patch_config table.
A red cell in the dataview indicates that the values available on that computer do not match the settings defined by the Patch Manager - WUA Settings Validation script.
Dependencies
Columns
| Column | Explanation | 
|---|---|
| clientid | clientid (Hidden) | 
| locationid | locationid (Hidden) | 
| Client | Client Name | 
| Location | Location Name | 
| Computer | Computer Name | 
| Operating System | Operating System | 
| Last Contact | Last Contact with RMM | 
| Last Logged In User | Last Logged In User on the Computer | 
| Form Factor | Form Factor (Virtual Server/Physical Server/HyperV Host/Laptop/Desktop/Virtual Workstation) | 
| Wuauserv | Startup type of the Wuauservservice. | 
| Cryptsvc | Startup type of the Cryptsvcservice. | 
| Bits | Startup type of the Bitsservice. | 
| TrustedInstaller | Startup type of the TrustedInstallerservice. | 
| BranchReadinessLevelAllowedValues | Possible values for the branch readiness level. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Microsoft\PolicyManager\default\Update\BranchReadinessLevelName:AllowedValuesPossible values:  -16(Semi-Annual Channel)  -8(Semi-Annual Channel (Targeted))  -32(Release Preview)  -48(Insider Fast)  -64(Insider Slow)  Example:16, 8, 32, 48, 64 | 
| BranchReadinessLevelValue | The current value of the branch readiness level. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Microsoft\PolicyManager\default\Update\BranchReadinessLevelName:AllowedValuesPossible values:  -16(Semi-Annual Channel)  -8(Semi-Annual Channel (Targeted))  -32(Release Preview)  -48(Insider Fast)  -64(Insider Slow)  Example:16 | 
| UxSettingsBranchReadinessLevel | The current branch readiness level as stored in UX Settings. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Microsoft\WindowsUpdate\UX\SettingsName:BranchReadinessLevelPossible values:  -16(Semi-Annual Channel)  -8(Semi-Annual Channel (Targeted))  -32(Release Preview)  -48(Insider Fast)  -64(Insider Slow)  Example:16 | 
| UxSettingsActiveHoursStart | The start time for active hours. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Microsoft\WindowsUpdate\UX\SettingsName:ActiveHoursStartPossible values:0-23Example:6 | 
| UxSettingsActiveHoursEnd | The end time for active hours. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Microsoft\WindowsUpdate\UX\SettingsName:ActiveHoursEndPossible values:0-23Example:18 | 
| WindowsUpdateBranchReadinessLevel | The current branch readiness level as stored in Windows Update Settings. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:BranchReadinessLevelPossible values:  -16(Semi-Annual Channel)  -8(Semi-Annual Channel (Targeted))  -32(Release Preview)  -48(Insider Fast)  -64(Insider Slow)  Example:16 | 
| WindowsUpdateDeferFeatureUpdates | Whether feature updates are deferred. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:DeferFeatureUpdatesPossible values:0 (not deferred), 1 (deferred).Example:1 | 
| WindowsUpdateDeferFeatureUpdatesPeriodInDays | Number of days to defer feature updates. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:DeferFeatureUpdatesPeriodInDaysPossible values:0-365(days).Example:60 | 
| WindowsUpdateDeferQualityUpdates | Whether quality updates are deferred. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:DeferQualityUpdatesPossible values:0 (not deferred), 1 (deferred).Example:0 | 
| WindowsUpdateDeferQualityUpdatesPeriodInDays | Number of days to defer quality updates. Data is gathered from the registry.  Path: HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:DeferQualityUpdatesPeriodInDaysPossible values:0-365(days).Example:0 | 
| UpgradeRestricted | Indicates whether Windows upgrades or feature updates are restricted from the registry key for Windows 10 and 11. 0--> Not restricted1--> Restricted  Data is gathered from the registry.  Path:HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdateName:DisableOSUpgradePossible values:0 (upgrade not disabled), 1 (upgrade disabled).Example:0Name:TargetReleaseVersionPossible values:0 (Feature update not restricted), 1 (Feature update disabled).Example:1Path:HKLM:\SOFTWARE\Microsoft\Windows\WindowsUpdateName:TargetReleaseVersionInfoPossible values:22H2, 23H2, 24H2, etc.Example:22H2 | 
| DataCollectionTime | Data Collection Time | 
| Needs Adjustment | Indicates if any column mentioned in the Format Control section is colored red. | 
Format Control
| Column | Operator | Comparator | Color | 
|---|---|---|---|
| wuauserv | Equals | Disabled | Red | 
| Cryptsvc | Equals | Disabled | Red | 
| Bits | Equals | Disabled | Red | 
| TrustedInstaller | Equals | Disabled | Red | 
| BranchReadinessLevelAllowedValues | Not Contains | 16 | Red | 
| BranchReadinessLevelValue | Not Equal | 16 | Red | 
| UxSettingsBranchReadinessLevel | Not Equal | 16 | Red | 
| UxSettingsActiveHoursStart | Not Equal | 5 | Red | 
| UxSettingsActiveHoursEnd | Not Equal | 23 | Red | 
| WindowsUpdateBranchReadinessLevel | Not Equal | 16 | Red | 
| WindowsUpdateDeferFeatureUpdates | Not Equal | 0 | Red | 
| WindowsUpdateDeferFeatureUpdatesPeriodInDays | Not Equal | 0 | Red | 
| WindowsUpdateDeferQualityUpdates | Not Equal | 0 | Red | 
| WindowsUpdateDeferQualityUpdatesPeriodInDays | Not Equal | 0 | Red | 
| UpgradeDisabled | Not Equal | 0 | Red | 
| Needs Adjustment | Equals | 1 | Red |