I would like to remove SQL DB's that were discovered before we added overrides. Things like the AdventureWorks DB for example. Ive tried running the Remove-DisabledMonitoringObject cmd but I still see the discovered objects. any thoughts as to what im doing wrong? Thanks

Hi Shetaug. First you need to override and disable the Discovery, in this case its probably named Discover Databases for a Database Engine and when that is done you run the Remove-DisabledMonitoringObject in your OpsMgr-shell..mats.w | www.opsmode.com

they should be gone after the SQL DBEngine Discovery has been run which is set to run by default every 4 hours, unless you have overriden this.- sorry I thought you were asking about removing instances, not databases. my bad.. have you cleared the console cache? Scott Moss MVP (Operations Manager) | President - System Center Virtual Users Group | Vice President - Atlanta Southeast Management Users Group (ATL SMUG) Please remember to click “Mark as Answer” on the post that helps you!

Hmmm....thats exactly what I tried. Let me review my work but, it seems starightforward Thanks

ok, so I've added the override, ran the Remove-DisabledMonitoringObject, the SQL DBEngine Discovery has run and I have deleted the console cache. Still see AdventureWorks in the console.....am I forever going to see these or is there something im missing/can be done?

There is an option (override) on the SQL 200X DB discovery to exclude certain databases. Have you tried that?View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi, I think you can try overrides and I would like to share the following with you for your reference: Objects the Management Pack Discovers http://technet.microsoft.com/en-us/library/dd767419.aspx 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 Remove-DisabledMonitoringObject http://blogs.technet.com/b/jonathanalmquist/archive/2008/09/14/remove-disabledmonitoringobject.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.