Discussion:
Microsoft SQL Server 2005 Service Discovery computer group
(too old to reply)
NeilO
2006-08-22 12:31:02 UTC
Permalink
We've just installed the SQL 2000, 2005 Management pack. When I try to look
at a (filter) Alert view in the Operator console to only see SQL Alerts
(using the Microsoft SQL Server computer view) I see all open Alerts from all
computers (whether they are SQL or not)

I believe this issue is realted to one of the computer groups automatically
created, the 'Microsoft SQL Server 2005 Service Discovery' computer group.
This computer group uses a formula of AttributeValue(Microsoft Windows
Current Version)>="5.0", therefore pretty much all computer (whether they are
SQL servers or not) automatically become members of this group.

In itself this is not a problem, however, the Microsoft SQL Server computer
view in the Operator Console is configured to include all computers in the
'Microsoft SQL *' computer group, therefore, it includes computers in the
'Microsoft SQL Server 2005 Service Discovery' computer group which, based
upon the computer group formula, is all computers with an OS version of>=5.0,
which is all of our servers - not just SQL Servers.

Is there a way to change the configuration of SQL Server / computers view to
include all computers groups with the exception of the 'Microsoft SQL Server
2005 Service Discovery' - I could see a means of doing this?

Alternatively would there be an issues with renaming the 'Microsoft SQL
Server 2005 Service' Discovery group so that it doesn't match the 'Micrsoft
SQL *' computer group string, i.e. call it 'SQL Server 2005 Service
Discover'?

Thanks

Neil
new2momworld
2007-10-30 23:03:53 UTC
Permalink
I am having the same problem. I cannot figure it out. The group does no
seem to be a part of the new SQL management pack. I inherited this MO
infrastructure so I'm not sure how this group got there. Can it b
disabled or deleted safely

Message sent by new2momworld from mombu the microsoft forum http://www.mombu.com/microsoft

-----------------------------------------------------------------------
new2momworld's Profile: http://www.mombu.com/microsoft/member.php?u=368
View this thread: http://www.mombu.com/microsoft/MOM-Management-Pack-SQL-Server/t-Microsoft-SQL-Server-2005-Service-Discovery-computer-group-391907.htm
new2momworld
2007-10-30 23:03:53 UTC
Permalink
I am having the same problem. I cannot figure it out. The group does no
seem to be a part of the new SQL management pack. I inherited this MO
infrastructure so I'm not sure how this group got there. Can it b
disabled or deleted safely

Message sent by new2momworld from mombu the microsoft forum http://www.mombu.com/microsoft

-----------------------------------------------------------------------
new2momworld's Profile: http://www.mombu.com/microsoft/member.php?u=368
View this thread: http://www.mombu.com/microsoft/MOM-Management-Pack-SQL-Server/t-Microsoft-SQL-Server-2005-Service-Discovery-computer-group-391907.htm
Loading...