Create custom indexes for WSUS Database
The following steps should be used to create custom indexes in the SUSDB database. This is a one-time process, which is optional but recommended, as doing so will greatly improve performance during subsequent cleanup operations.
The WSUS engine had crashed and it turns out the problem is it runs out of memory. Make sure your WSUS server had at least 8GB of memory then perform the following:
I had a situation when windows clients are not reporting in WSUS server. To fix it I’ve used this small script at the clients.