WSUS - How do I reset it to before the initial sync

I am playing around with WSUS on S2012 R2. Its in a test environement.

I have installed it and (for now) disabled the windows firewall on all of the devices.

Firstly I have performed an initial sync with the MS servers and it now says there are 8000+ updates that need approval. Many of these updates are not relevent to the PCs/Servers I have.

What I should have done first is narrow down exactlt what OSs I want the updates for.

I dont want to have to manually go though the list approving all the updates I need.

Is there a way I can reset WSUS to before i did this sync?

Also the devices on my LAN that need to look to WSUS for their updates where not detected. I onky gave it a few hours but in the end I ran wuauclt.exe /detectnow which did the trick. Will I need to run that on all devices to get them into the WSUS console or would that happen anyway if I gave it enough time?

I have configured all devices to look to WSUS using GPO.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Cliff GaliherCommented:
For the first, the only supported method is uninstall and reinstall the role.
For the second, as you said, you only give it a few hours. Machines will get the new group policy and check in on their own if given time.
DonNetwork AdministratorCommented:
What I should have done first is narrow down exactlt what OSs I want the updates for.

Yes, deselect what's not in your environment

I dont want to have to manually go though the list approving all the updates I need.

Use automatic approval rules

You might want to look over best practices as well
roy_battyDirectorAuthor Commented:
OK I just removed WSUS....rebooted..........then reinstalled and all the settings from the previous install are still there. This includes the list of 8000+ updates that were there previously.

Do I need to do anything else as well as uninstall?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Cliff GaliherCommented:
You didn't remove the database, which is a subselectiom under the role. You want to remove the *entire* role, including the database.
roy_battyDirectorAuthor Commented:
OK I tried again this time ensuring that the WID was removed as part of the removal. On re-install its still seeing the 8000 updates.

Any more suggestions?
roy_battyDirectorAuthor Commented:
Think I might have sussed it. I need to also remove the feature :Windows Internal Database.

Will try this and post the results.
Hypercat (Deb)Commented:
First go into the Products and Classifications Settings and make sure that ONLY the products and classifications you want are selected.

Then go to the Server Cleanup wizard, leave everything selected and run the wizard.  This make take quite some time, but will probably remove all of the extra stuff that you've downloaded.  It's better to wait to run this process until after your computers have all (or pretty much all) checked in with WSUS. However, if some updates get deleted that you end up needing, they'll be redownloaded automatically so there's not too much of a downside to it.
Hypercat (Deb)Commented:
Another approach is not to worry too much about having extra updates in the database unless you are running into a space crunch.  Once your computers have checked in to WSUS, if you customize your view in the Updates section so that you see only the updates that are needed by the computers who've checked in, then you won't have an issue with seeing a lot of unnecessary updates that you then have to decline.  The cleanup wizard will help, however, with superceded updates if you've gotten a lot of these downloaded into the database.
DonNetwork AdministratorCommented:
Server Cleanup wizard will have no effect on a fresh install of WSUS
roy_battyDirectorAuthor Commented:
OK I have tried all of the above and none seem to work.

I am always left with 8000+ updates needing approval.

Some refer to XP which I have deselected in Products and Classifications Settings. After running the cleanup wizard I am left with virtually the same thing - it only removed 25 updates, still leaving many unneeded updates.
Hypercat (Deb)Commented:
It's not unusual to have thousands of updates downloaded to a database but normally once your workstations/servers start checking in the ones needing approval will drop down considerably.  If you're looking at the dashboard page in the WSUS console, under Update Status, does it say that many updates are actually needed by computers?
DonNetwork AdministratorCommented:

You are most likely looking under the "To Do"  where it will always say an inordinate amount of updates are waiting to be approved

Go to the Updates>>All Updates(On left hand side) then on right side under "Approval" select "Any Except Declined" and for "Status" select "Needed". There you will get a more accurate count of updates to approve

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
roy_battyDirectorAuthor Commented:
I didn't manage to reset WSUS as I hoped. I did get help with an alternative approach.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.