schedule WSUS report

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  1

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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