WSUS Deep Dive - Too much information!

I'm just using this as a "notepad" of sorts.
Just took over a site with many downstream WSUS and trying fix the existing issues.
Don't expect a complete solution here!
This will be updated as I go along but then again, maybe not!

WSUS Tips & Tricks:
https://community.spiceworks.com/topic/1677852-how-to-administer-wsus

No update files downloaded in WSUS Content folder:
http://clintboessen.blogspot.sg/2013/09/windows-server-2012-wsus-server-not.html
https://thwack.solarwinds.com/thread/54281
https://social.technet.microsoft.com/Forums/windowsserver/en-US/97e1170e-0506-4cf1-918c-6d472b352ff6/wsus-not-downloading-the-updates?forum=winserverwsus
https://serverfault.com/questions/754267/wsus-upstream-server-is-not-showing-current-downstream-server-status

SQL Script to clean WSUS:
https://community.spiceworks.com/scripts/show/2998-adamj-clean-wsus

WSUS Error Codes:
8024401F - Equivalent to a HTTP 500 error; IIS had an internal server error while processing download request; check your default ports on WSUS if they match GPO settings. If that's not the issue see this:- http://kaustubhghanekar.blogspot.sg/2011/05/advanced-wsus-troubleshooting-for-error.html

WSUS Error Codes Database:
http://inetexplorer.mvps.org/archive/windows_update_codes.htm

Script for WSUS cleanup:
https://docs.microsoft.com/en-us/powershell/module/wsus/invoke-wsusservercleanup?view=win10-ps

Troubleshooting:
IIS Logs C:\inetpub\logs\LogFiles

Alternative method of deploying drivers from WSUS:
https://decentsecurity.com/drivers-through-wsus/

Downloading Drivers using WSUS:
http://www.runonazure.com/downloading-drivers-into-wsus-bad-idea/
https://blogs.technet.microsoft.com/sus/2008/08/20/a-large-number-of-driver-updates-showing-up-in-wsus/
http://www.runonazure.com/downloading-drivers-into-wsus-bad-idea/

Deleting WID:
https://systemspecialist.net/2013/05/15/move-or-delete-a-wsus-4-windows-internal-database-wid-on-windows-server-2012/

WSUS 3.0 SP2 on Windows Web Server 2008 R2

To install IIS 7.0 on Windows Server 2008

1. Start the Server Manager (click Start, click Run, and then type CompMgmtLauncher).
2. In the tree view, select Roles, then in the Roles pane click Add Roles.
3. In the Add Roles Wizard, click Select Server Roles, select the Web Service (IIS) check box, click Next, and then click Next again.
   At this time you may see a message box Add features required for Web Server (IIS)? Click Add Required Features.
4. In the Select Role Services window, make sure that the following services are selected:
   • Common HTTP Features (including Static Content)
   • ASP.NET, ISAPI Extensions, and ISAPI Features (under Application Development)
   • Windows Authentication (under Security)
   • IIS Metabase Compatibility (under Management Tools, expand IIS 6 Management Compatibility)
5. Click Next, and then review your selections.
6. Click Install.