locked
WSUS Report RRS feed

  • Question

  • Hello,

    What will be the best WSUS canned report(s) to show:

    - Summary 

    . Total Computers under WSUS Patching

    . Total Computers up-to-date with patching

    - Details

    . Computer Name

    . Last patching date

    . Last patch(es) applied

    . Status (failed, successful, waiting reboot, waiting maintenance window,...etc...)

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Saturday, February 22, 2020 8:19 PM

Answers

  • Hi Dom,
       

    You can customize WSUS reports in different ways:
       

    • Use the WSUS APIs to create a custom report
      For more information about WSUS APIs, see the Windows Server Update Services SDK on MSDN. You can use these APIs to create reports for updates, approvals, installation information, and such.
         
    • Use WSUS public views to create and extend custom reports
      For more information about public views, in addition to sample queries, see the WSUS SDK conceptual documentation on MSDN. If you are using SQL Server as the WSUS database, you can use the SQL Server Report Builder to generate custom reports by using these views, or you can access the views from the command line.
      If you are using Windows Internal Database as the WSUS database, you can access it through the command line if you download the Microsoft SQL Server Command Line Query Utility and the SQL Server Native Client. To download and install packages, seethe Feature Pack for Microsoft SQL Server 2005 in the Microsoft Download Center.
         

    Hope the above can help you.
       

    Regards,
    Yic

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

    • Marked as answer by Felyjos Tuesday, February 25, 2020 2:42 PM
    Sunday, February 23, 2020 11:46 AM