none
WSUS Query

    Frage

  • Would need some help in writing a .vbs script to be able to ;
    1) List the number and names of microsoft patches approved for installation on a list of servers which comprise of Windows 2003 and Windows 2008 (Approx 600 servers). Ex serverlist.txt
    The approved updated are authorised by our WSUS server.

    2) List the names of patches that had been installed for the particular month. Display the date of installation.

    3) To be able to do a comparison and list out the patches not installed.

    We need this for our compliance and audit purposes. As such, if a .html report can be generated, it would be simply great ! Pls advise if there are any tools that can be used as well. Thks

    Sonntag, 7. April 2013 12:44

Antworten

  • Would need some help in writing a .vbs script to be able to ;
    1) List the number and names of microsoft patches approved for installation on a list of servers which comprise of Windows 2003 and Windows 2008 (Approx 600 servers). Ex serverlist.txt
    The approved updated are authorised by our WSUS server.

    This is available from native WSUS reporting.
    2) List the names of patches that had been installed for the particular month. Display the date of installation.
    This is not available via WSUS at all. WSUS does not store installation dates for updates. That information is contained in the client-side datastore. You would need to query each individual client to get installation dates. Alternatively you can run a Computer Status report from the WSUS server on a daily basis and note the entries that have changed state (from Needed to Installed) or formulate a query based on the PUBLIC_VIEWS, attach the current date, and push that into a separate reporting database.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2013)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    Dienstag, 9. April 2013 17:00
    Moderator