question

AUddin-8478 avatar image
0 Votes"
AUddin-8478 asked RitaHu-MSFT edited

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?

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-update-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It seems there is no update for a couple of days. May we know the current status of the problem? Is there any other assistance we can provide?

If you have any questions, please keep us in touch.

0 Votes 0 ·

1 Answer

RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered RitaHu-MSFT edited

@AUddin-8478
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.


27.png (21.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.