locked
WSUS Custom Reports RRS feed

  • Question

  • Hello,

    If anyone can show me a way to get WSUS report to get installed and not installed pcs separately for specific KB number or numbers.

    I tried varies ways. but not succeeded.

    It's better if anyone can provide SQL query, because i connected WID from SQL.

    but I don't know relevant query to fulfill my requirement.

    Monday, May 22, 2017 2:47 PM

All replies

  • Hi,
    As far as I know, the Report option in the WSUS console could offer the updates detail report based on KB number, have you tried that ton see if it could meet your request?
    In addition, if you need to do that by query SQL database, in my opinion, you might need a consultant to help writing the query based on your database.
    Best regards, 
    Wendy

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

    • Proposed as answer by Wendy Jiang Monday, May 29, 2017 11:50 AM
    Tuesday, May 23, 2017 6:41 AM
  • I connected to DB by using SQL and tried to find suitable query...

    Although I found these articles, those queries are not clear for me and not fulfill my requirement.

    http://www.geeklee.co.uk/query-wsus-database/

    http://www.ericcsinger.com/sql-query-microsoft-wsus-computers-update-status/

    Tuesday, May 23, 2017 11:29 AM
  • Hi,
    Yes, I know, so I suggest that it is better to contact a consultant who is good at on SQL database for help on the detail query based on your database, it is hard to find the ready query command.
    Best regards, 
    Wendy

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

    • Proposed as answer by Wendy Jiang Monday, May 29, 2017 11:50 AM
    Friday, May 26, 2017 5:39 AM