Disabling SQL Express Instance Discoveries

Our SQL Team doesn’t want to manage SQL Express installations. Typically SQL Express is used for Dev/Test and they don’t want to be alerted on these databases.

Turns out there is a nice override to disable discovery of these in the “SQL 200x Database Engines (Windows Server)” discovery.

All you need to do is find the SQL 200x Database Engines (Windows Server) discovery.  Create an override “For all objects of type: Windows Server”

SCOM

Then choose the Parameter Name “Exclude List” and type in “SQLEXPRESS”.

3 Responses to Disabling SQL Express Instance Discoveries

  1. Richard September 7, 2009 at 8:14 am #

    Any other way to distinguish SQL Server versions besides the instance name? Seems MS has decided that it’s a bug for the Instance Name for SQL Server 2008 Express Edition to be SQLEXPRESS.

Trackbacks/Pingbacks

  1. Disabling SQL Server Discovery « System Center Operations Manager 2007 R2 - July 27, 2009

    […] http://www.scom2k7.com/disabling-sql-express-instance-discoveries/ […]

  2. Fjern SQL Management Pack støj på SQL Express i SCOM - Flemming Riis - IT-experts.dk - February 13, 2010

    […] http://www.scom2k7.com/disabling-sql-express-instance-discoveries/ […]

Leave a Reply