I’m running SQL 2014 however when I look at the membership of the SQL Computers group that was created as part of the management pack my SQL Server isn’t listed – Does anyone know why that is?
Here is the dynamic criteria for the group:-
SQL Server Computers
In short – The SQL 2014 management pack is a little screwy and does not conform to the previous SQL monitoring MPs.
They’ve decided that unlike the previous iterations (2003, 2005, 2008 and 2012) which all roll up together, they will have their own set of classes and groups. SQL 2014 servers will not roll up into the “SQL DB Engine” class, nor will they appear in the SQL Computers group.
A SQL 2014 server will not appear in the standard SQL Computers group as with previous versions, but will however display in the SQL Server 2014 Computers group:
Hope this helps, though it’s frustrating for those of us who have a set of overrides targeted at the SQL Computers group, which now have to be replicated to the SQL Server 2014 Computers group.