Patching - Approved Recent Updates Audit
Summary
The dataview displays the latest approved patches and their release dates.
If any computer is over 2 months out from the last update it received, or the last update it received was in a failed state, it should be considered for review.
The dataview filters the patches that it displays based on the following requirements:
- Patches should be in the default policy.
- Patches displayed should have been released within the last two months.
- Do not display any patch that was denied.
- Do not display any patch that pertains to Windows Defender or malicious software removal.
Columns
| Column | Description |
|---|---|
| Client Name | The name of the client a computer belongs to. |
| Location Name | The name of the location that a computer belongs to. |
| ComputerID | The ID of the computer being queried. |
| Computer Name | The name of the computer. |
| KBID | The KBID for the patch last attempted. |
| Title | The title of the update that was last attempted. |
| Severity | The severity of the update. |
| Patch Approved on Date | The date the patch was approved. |
| Patch Last Attempt Date | The date the patch installation was attempted last. |
| Status | The status of the computer at this time (Up To Date or Please Review) |