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?
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.
Have the management pack discovered any computers with that role? Check if you see the objects under discovered inventory, change your target to Sql Server Role or what ever the target is
Ehrnst - I have changed the scope to “SQL Server Computers” and as you can see I get the result however when i change the scope to “SQL Computers” I get not monitored?