how to remove a SCOM CI Connector from Service Manager (not supported by Microsoft)

so this is by no means microsoft supported but after doing this and then using the environment for 6+ months i can safely say that we have had no negative side effects of this.

this procedure removed the "stale" SCOM CI Connector from the SCSM console.

first i found the BaseManagedEntityId that is associated with the connector.  in my case this ended in 1558D.  so my delete SQL queries included where [tablename] like '%1558D%'.

these are the tables where the SCOM CI Connector resides:

Dbo.MT_Connector - deleted SCOM Alert Connector  (1558D)

Dbo.connector - deleted BaseManagedEntityId ending in 1558D

Dbo.recursiveMembership - deleted ContainedEntityID ending in 1558D

Dbo.BaseManagedEntity - deleted BaseManagedEntityId ending in 1558D

i think there's a stored proc you can run after this which will clean things up, but i don't know it off the stop of my head.  you can also just wait 24 hours i believe...

happy deleting!

Add Business Services and Configuration Items from SCOM to SCSM

1. Import same SEALED version of MP to both SCOM and SCSM (same version is critical)
2. Launch PowerShell on SCSM MS and add-pssnapin smcmdletsnapin (more info here http://technet.microsoft.com/en-us/library/ff461183.aspx)
3. add-scsmallowlistclass -ClassName (insert class name here)
1. Class names for DAs created in SCOM begin with Service_ such as Service_705e85be9b0442fbb6dee387258ac789
1. You won't need to explicitly add DA's created in SCOM to the allow-list since they are sub-classes of System.Entity which is in the allow-list by default.  Just make sure both MPs in SCOM and SCSM are sealed.
2. Class names for Microsoft created MPs are Microsoft.SQL or Microsoft.Exchange
3. Class names for MPs created in the Authoring Tool can be pretty much anything but should follow some sort of nomenclature such as CompanyName.Application
4. Once the classes are added to the allow list then open the SCOM CI Connector in Service Manager. If you don't already have one, then you can create one in the Connectors pane under Administration
5. Refresh the list and select the MPs you want to sync.
6. Enable (if not already done so) the connector and sync.

Step 5.