locked
schedule WSUS report RRS feed

  • Question

  • Hi, 

    I wonder if there is a way to schedule to run WSUS report and send it to an email address?

    Thanks in advance!


    Grace

    Thursday, October 26, 2017 2:19 AM

All replies

  • Hi Grace,

    >>I wonder if there is a way to schedule to run WSUS report and send it to an email address?

    Unfortunately , there is no build-in feature to send report to email address.

    But , it is feasible to do that using script and windows task scheduler .

    I'd suggest you to involve DBA to write SQL query and generate report file .

    (If you use WID , after you installed SSMS , there will be a command "sqlcmd.exe" which can be used to execute SQL query and generate html file )

    Also , the views within following article might be useful to you:

    https://msdn.microsoft.com/en-us/library/bb410149%28v=vs.85%29.aspx?f=255&MSPPError=-2147217396

    Best Regards,

    Elton


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, October 27, 2017 6:47 AM
  • Hi Elton,

    Thank you very much for your reply! I found the link below which uses Powershell.

    https://social.technet.microsoft.com/wiki/contents/articles/34635.powershell-generating-wsus-reports.aspx 

    I am working on it.

    Thanks,


    Grace

    • Proposed as answer by Elton_Ji Saturday, October 28, 2017 4:41 AM
    Friday, October 27, 2017 5:37 PM
  • Hi,

    Yes, using powershell may get lots of useful information .

    If that PS covers your need , congratulations ! 

    Best Regards,

    Elton


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Saturday, October 28, 2017 4:47 AM