SCOM - SQL Computers Group doesn't display my SQL Server

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:-

<Expression>
<Contains>
<MonitoringClass>$MPElement[Name=”Microsoft.SQLServer.ServerRole”]$</MonitoringClass>
</Contains>
</Expression>

SQL Computers

2016-04-05_16-16-11.jpg

SQL Server Computers

2016-04-05_16-13-51.jpg

1 Like

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:

2016-06-22-18_43_29-MS-EUN-EUNOWPOPSMMS01-EUNOWPOPSMMS01-Remote-Desktop-Connection-Manager-v2..png

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.

1 Like

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 :slight_smile:

As long has you have distributed the Run as accounts and have setup the run as profiles correctly, it should just work.

Takes time.

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?

Am i right in thinking that “SQL Computers” will only populate if SQL is installed on a “Computer” rather than a “Server”

For me, both groups are populated with roughly the same amount of machines (hundreds)

When you say it is not listed in one, can you screen shot the actual results of ‘view members’ of both?