Can we run report from WSUS which will link to Excel sheet. Is the excel sheet can be updated when any change occurs in WSUS?

A Uddin 1 Reputation point
2021-05-27T04:42:27.34+00:00

Can we run report from WSUS which will link to Excel sheet.
Is the excel sheet can be updated when any change occurs in WSUS?
Is there any power shell cmdlets that generate report and then update excel data accordingly?

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,200 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rita Hu -MSFT 9,626 Reputation points
    2021-05-27T07:08:53.327+00:00

    @A Uddin
    Thanks for your posting on Q&A.

    In my opinion, the build-in WSUS report could help. Please refer to the below picture to export the WSUS report to the Excel:
    100161-27.png

    You know, we have to enter the specified condition(Any classification/Any product/Any computer group/Needed, failed, No Status) and click Run Report option to filter the specified report. I don't know the PowerShell scripts to filter out all the updates in the WSUS, include Update Status and Computer status and export to the Excel. Please consider sharing your specific needs and I will research further to see whether there are any PowerShell scripts could achieve.

    Hope the above will helpful.

    Thanks for your time.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments