The Configuration Assessment has alerted me to a number of SQL server issues, most of them are resolved by SQL CU updates. I would like a way of telling what SQL versions I have deployed and what is available indicating I need to update the servers. At the moment i cannot see an easy, clear method to show what I have and the fact it is out of date.
There is a ‘System Update Assessment’ Intelligence Packs for the updates that are offered thru Microsoft Update / WSUS.
Once the intelligence pack is enabled and data is collected, a query like the following gives you SQL server updates and the servers they need to be applied to:
Type=RequiredUpdate Product=“Microsoft SQL Server 2012” | select UpdateTitle,KBID,UpdateClassification,UpdateSeverity,PublishDate,Server
Check the other sample searches here to slice and dice that data differently http://blogs.msdn.com/b/dmuscett/archive/2014/10/19/advisor-searches-collection.aspx
Some of the other patches suggested in ‘Alerts’ and ‘Recommendations’ are not mandatory critical or security updates, just recommended ones from our support teams and/or generated by scanning KB articles thru machine learning algorithms.
We have also introduced a new ‘SQL Assessment’ Intelligence Pack specifically, which presents the information in a much more actionable AND prioritized way – check it out if you haven’t done so already! http://blogs.technet.com/b/momteam/archive/2014/10/23/new-sql-server-assessment-intelligence-pack-in-advisor.aspx
We think this new format of ‘Configuration Assessment’ is much more effective!