Hello All,

Thanks in advance,

Server name:  HELIC.common.com

we have 5 sql instances in the servver

HELIC01-DEV\DEV01

HELIC02-DEV\DEV02

HELIC03-DEV\DEV03 

HELIC05-TEST\Test01

HELIC06-Prod\Prod1

i want to disable the below two instances 

HELIC01-DEV\DEV01

HELIC02-DEV\DEV02

Hi,

Find "Discover SQL Server 200x Database  Engines" and add your instances to the Exclude List via override.

1) using override to disable the discovery of this two instances
2) using powershell, Remove-SCOMDisabledClassInstance, to remove disabled instance
Roger

Hi,

Please refer to the method in Kevins blog:

Stop monitoring SQL Express and Windows Internal Database
http://blogs.technet.com/b/kevinholman/archive/2010/02/13/stop-monitoring-sql-express-and-windows-internal-database.aspx

Hope this helps.

Hello,

Thanks for your reply,

i tried to override it from object discoveries, which option i need to choose,can you help me.

Regards...

Nikhilgs

Hello Alexey,

Thanks for your reply

The instance name re not unique,the same instances are present in another system,so i think its not possible to exclude it.

Regards..

Nikhil GS

Hi 

This is also an option http://www.ms-opsmgr.eu/?p=1330

Greetings Roel Knippen

Hello Alexey,

Thanks for your reply

The instance name re not unique,the same instances are present in another system,so i think its not possible to exclude it.

Regards..

Nikhil GS

Create an override for the one server, not for all. This exclusion will work for the one server only.

Take SQL Server 2012 DB Engine as an example

1) Using overrides --> Overrides the object Discovery --> For a specific object of class: SQL server 2012 Installation seed

2) select the object HELIC.common.com

3) In the Exclude list, type the instance name which you want to exclude by comma

Roger

Take SQL Server 2012 DB Engine as an example

1) Using overrides --> Overrides the object Discovery --> For a specific object of class: SQL server 2012 Installation seed

2) select the object HELIC.common.com

3) In the Exclude list, type the instance name which you want to exclude by comma

Roger

• Marked as answer by anunikhil 17 hours 20 minutes ago

Take SQL Server 2012 DB Engine as an example

1) Using overrides --> Overrides the object Discovery --> For a specific object of class: SQL server 2012 Installation seed

2) select the object HELIC.common.com

3) In the Exclude list, type the instance name which you want to exclude by comma

Roger

• Marked as answer by anunikhil Friday, March 27, 2015 1:48 PM

Take SQL Server 2012 DB Engine as an example

1) Using overrides --> Overrides the object Discovery --> For a specific object of class: SQL server 2012 Installation seed

2) select the object HELIC.common.com

3) In the Exclude list, type the instance name which you want to exclude by comma

Roger

• Marked as answer by anunikhil Friday, March 27, 2015 1:48 PM

Thanks for your suggestion