Answered by:
How to Scale Back Updates?

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 WangPlease 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/HomeTuesday, 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 WangPlease 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/HomeWednesday, 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.orgThursday, May 25, 2017 2:41 AM