In theory yes. In practice it is more difficult.
Once you import the SQL MP, it will automatically discover all SQL servers. You can't stop it because you can't override the discovery until the discovery exists (has been imported) and once it is imported it is already discoverying.
You can undiscover objects .. what you can do is look at the target of the discovery (it isn't always a server object). Then create a group of those objects. Then override the discovery. This isn't enough in itself ... you then need to run a different PShell
command depending on the version of SCOM:
SCOM 2007 R2 -
http://blogs.technet.com/b/jonathanalmquist/archive/2008/09/14/remove-disabledmonitoringobject.aspx
SCOM 2012 -
http://om2012.wordpress.com/2011/12/21/om-12-rc-powershell-cmdlet-remove-scomdisabledclassinstance/
It is also possible to create an overrides MP that disables all the discoveries and import that at the same time as you import the base monitoring MP. Alexey did post something like this for SQL some time ago.
Cheers
Graham
Regards Graham New System Center 2012 Blog! -
http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at
http://systemcentersolutions.wordpress.com/
