This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

WSUS report

Question
0

Sign in to vote

Hi All,

I have WSUS installed on Windows 2016 with SQL Database.

I am looking for a report from WSUS database in below format.

KB Article - Installed / Failed - with list of computers

Could you please share any powershell or sql or any query to fetch this report .

Thanks

Thursday, July 26, 2018 3:40 PM

Answers

1

Sign in to vote
Thanks Ray for your reply .

I am able to fetch report using script as mentioned in the below article.

https://4sysops.com/archives/wsus-reporting-with-powershell/
- Marked as answer by It's Vin Friday, July 27, 2018 3:57 PM
Friday, July 27, 2018 3:56 PM

All replies

0

Sign in to vote

Hello Vin,

Refer to this:

Get Installed, Failed,Windows Updates Status - Remote Servers or Computer

https://gallery.technet.microsoft.com/scriptcenter/Get-Installed-FailedWindows-9f28742a

Hope that is what you want.

Best Regards,

Ray Jia
Please remember to mark the replies as answers if they help.

If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Friday, July 27, 2018 12:32 AM
1

Sign in to vote
Thanks Ray for your reply .

I am able to fetch report using script as mentioned in the below article.

https://4sysops.com/archives/wsus-reporting-with-powershell/
- Marked as answer by It's Vin Friday, July 27, 2018 3:57 PM
Friday, July 27, 2018 3:56 PM