Wsus last status report not updating
If you quickly want to find out if a particular update has been installed on all of your machines, the built-in reporting of Windows Server Update Services (WSUS) is not really helpful.However, you can use Power Shell to create a WSUS update report.I added the transcript file, so when the script ran via the Task Scheduler, I could see the number of declined updates. To do that, I'm using this SQL query from the Microsoft Script Center.And after I ran the script the first time, I changed the update scope. You can use the sqlcmd utility you find there to run the SQL query.
After approving all updates, I only need to update the log file and send this file by email to myself.
To check the state of all of our computers, I tried to use WSUS reporting.
However, I quickly found out that the tool is not very flexible.
This provides all update objects that have the particular KB number in the title.
Inside the second loop, I'm using the update object's property, which is a unique GUID associated with each computer object.
Search for wsus last status report not updating:
After the loops execute, I filter the $report variable to remove all records where At the end of the script, I added three arrays with the KB numbers that are critical for mitigating the vulnerabilities used for the recent Wanna Cry ransomware outbreak.