locked
How to Scale Back Updates? RRS feed

  • Question

  • Hey All,

    I enabled a WSUS server and I am trying to configure it now. I have come to realise that I enabled to many products initially and now I have over 7000 updates to sift through. I am wondering how I can scale that back so it only shows the updates for the products I want.

    I have already changed the product settings and re synced. I have also reinstalled the role.

    Any thoughts?

    Tuesday, May 23, 2017 7:33 PM

Answers

  • Hi,

    >Where is the WSUS-database located
    In general, you can delete files which are stored on below location, which name includes “SUSDB” in the file name:
    C:\Windows\WID\Data\

    Besides, you can install SQL Server, connect it to your WSUS DB, to delete WSUS DB. Also, it is recommended to use SQL Server to have an identification – whether WSUS DB is exactly deleted when you manually delete the SUSDB files mentioned above.

    Reference blog - Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based WSUS computer - for detail information:
    https://blogs.technet.microsoft.com/sus/2016/10/18/recreating-the-susdb-and-wsus-content-folder-for-a-windows-server-2012-based-wsus-computer/

    Best Regards,
    Eve Wang

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

    • Marked as answer by TimHirt_1 Wednesday, May 24, 2017 7:12 PM
    Wednesday, May 24, 2017 11:52 AM

All replies

  • Am 23.05.2017 schrieb TimHirt_1:

    Hey All,

    I enabled a WSUS server and I am trying to configure it now. I have come to realise that I enabled to many products initially and now I have over 7000 updates to sift through. I am wondering how I can scale that back so it only shows the updates for the products I want.

    If you have too much Products selected and there are too much updates,
    reinstall WSUS Role. Delete WSUS-Content and WSUS-Database.

    Winfried


    WSUS Package Publisher: http://wsuspackagepublisher.codeplex.com/
    http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
    http://www.wsuswiki.com/Home

    Tuesday, May 23, 2017 7:56 PM
  • Where is the WSUS-database located?

    Wednesday, May 24, 2017 11:19 AM
  • Hi,

    >Where is the WSUS-database located
    In general, you can delete files which are stored on below location, which name includes “SUSDB” in the file name:
    C:\Windows\WID\Data\

    Besides, you can install SQL Server, connect it to your WSUS DB, to delete WSUS DB. Also, it is recommended to use SQL Server to have an identification – whether WSUS DB is exactly deleted when you manually delete the SUSDB files mentioned above.

    Reference blog - Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based WSUS computer - for detail information:
    https://blogs.technet.microsoft.com/sus/2016/10/18/recreating-the-susdb-and-wsus-content-folder-for-a-windows-server-2012-based-wsus-computer/

    Best Regards,
    Eve Wang

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

    • Marked as answer by TimHirt_1 Wednesday, May 24, 2017 7:12 PM
    Wednesday, May 24, 2017 11:52 AM
  • Take a look at the Adamj Clean-WSUS script

    https://community.spiceworks.com/scripts/show/2998-adamj-clean-wsus

    The documentation is very good with lots of explanations and links.

    After going through and setting up the script, I cleaned out over 100 GB of unnecessary files.
    • Proposed as answer by AJTek.caMVP Thursday, May 25, 2017 2:39 AM
    Wednesday, May 24, 2017 12:23 PM
  • Am 24.05.2017 schrieb TimHirt_1:

    Where is the WSUS-database located?

    The Wizard will ask you for delete Content and Database.

    Winfried


    WSUS Package Publisher: http://wsuspackagepublisher.codeplex.com/
    http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
    http://www.wsuswiki.com/Home

    Wednesday, May 24, 2017 4:06 PM
  • Take a look at the Adamj Clean-WSUS script

    https://community.spiceworks.com/scripts/show/2998-adamj-clean-wsus

    The documentation is very good with lots of explanations and links.

    After going through and setting up the script, I cleaned out over 100 GB of unnecessary files.

    Thanks for the mention.

    My script does a whole boatload to maintain WSUS. It is the last WSUS Script you will ever need.

    What it does:

    1. Remove all Drivers from the WSUS Database.
    2. Shrink your WSUSContent folder's size by declining superseded updates.
    3. Remove declined updates from the WSUS Database.
    4. Clean out all the synchronization logs that have built up over time (configurable, with the default keeping the last 14 days of logs).
    5. Compress Update Revisions.
    6. Remove Obsolete Updates.
    7. Computer Object Cleanup (configurable, with the default of deleting computer objects that have not synced within 30 days).
    8. Application Pool Memory Configuration to display the current private memory limit and easily increase it by any configurable amount.
    9. Run the Recommended SQL database Maintenance script on the actual SQL database.
    10. Run the Server Cleanup Wizard.

    It will email the report out to you or save it to a file, or both.

    Although the script is lengthy, it has been made to be super easy to setup and use. There are some prerequisites and instructions at the top of the script. After installing the prerequisites and configuring the variables for your environment, simply run:

    .\Clean-WSUS.ps1 -FirstRun

    and then

    .\Clean-WSUS.ps1 -InstallTask

    If you wish to view or increase the Application Pool Memory Configuration, you must run it with the required switch. See Get-Help .\Clean-WSUS.ps1 -Examples

    If you're having trouble, there's also a -HelpMe option that will create a log so you can send it to me for support.


    Adam Marshall, MCSE: Security
    http://www.adamj.org

    Thursday, May 25, 2017 2:41 AM