Failed Windows Update report.
Mario Uribe
Can I generate a report with PDQ Inventory to Report on servers that have failed windows updates? Something similar to this:
Computer Name: Failed Patch Name: Date Attempted:
0
Comments
I did some research, and came up with this:
SELECT Message, ProductName, TimeGenerated FROM Win32_ReliabilityRecords WHERE SourceName = 'Microsoft-Windows-WindowsUpdateClient' AND Message LIKE '%failure%'Create a Basic Report with these Columns:
Computer | Name | Computer Name WMI (Failed Updates) | ProductName | Failed Patch Name WMI (Failed Updates) | TimeGenerated | Date Attempted
Add the Message column if you'd like to see the full error message.
Add this filter if you want to narrow down the results to the last X days:
WMI (Failed Upates) | TimeGenerated | After | 7 days agoHere is my Scan Profile and Basic Report, if you want to import them instead: https://gist.github.com/Colby-PDQ/48b172b1a2afb12368ac212dad641870