In SolarWinds DPA, is it possible to create an alert/report of when a Microsoft SQL Server needs patching?
Hi
No DPA does not contain that type of feature out of the box.
Potentially, you can create something yourself as you can build custom metrics. Where you can ask any queries against the db instances. But how you can get information about latest versions available into that query I don't know.
That is a shame. RedGate has a product which does that and can assist with the patching too.
SolarWinds have a separate tool for that, Patch manager. It's just not built into DPA.