In ConfigMgr, we use the Lenovo third party software updates catalog (v3) for driver/BIOS updates. I've then use a saved search for Vendor=Lenovo, Not Expired or Superseded, and Required by 1 or more machines, and right click on the results and select Publish Third-Party Software Update Content. After the next Software Update Point sync, I can deploy those to a software update group and download them to a deployment package which gets distributed to distribution points. Easy enough.
What I didn't realize until now was that simply publishing an update not only downloads additional publishing information about the updates, it also downloads the actual update payload to WsusContent and UpdateServicesPackages folders on the WSUS server. Further, the annoying thing about the Lenovo third party catalog is that newly added models are checked by default, meaning if I haven't looked at the list in a couple months, I might be syncing in 5 or 6 new models worth of updates into the WSUS database that we'll never use.
What I also didn't realize until now was that if I simply remove the "Required by 1 or more machines" filter from my search, I have over 8000 Lenovo updates, instead of the ~250 that are actually required. I do have all 3 automatic WSUS maintenance tasks enabled in ConfigMgr's Software Update Point settings, but when the Lenovo updates are rarely superseded or expired, nothing actually gets removed via those maintenance tasks.
I see we can use Patch My PC's Modify Published Updates tool without a license, but this would still be a problem because the tool doesn't have any way of knowing A, which machine model a third party update is for, or B, whether or not that update is required by any devices. So without comparing update IDs and doing them one at a time, I don't have any way of knowing which Lenovo updates are still needed from within the Modify Published Updates wizard.
So... how is everyone keeping the WSUS database and their list of third party drivers (from either Lenovo, or Dell/HP) clean? Are you still using this and enjoying the visibility of the which machines need which updates, the centralized control and monitoring of deployments, and saving your WAN links because the updates are on DPs instead of pulling from the internet? Or have you said "nope, this is a pain" and gone to Lenovo Commercial Vantage/GPOs (or other vendor direct tool) and are dealing with not having the visibility of when updates are performed and WAN links being slightly saturated?