Delete Device Collection from SQL

[MarshMan0331]

I have about 20 device collections that won't delete. It promts with a SQL error stating

 

"Collection Cannot be deleted becuase it is refrenced by another collection"

SQLseverity: = 15

SQLStatus: = 5000

StatusCode: = 2147749889

 

But inside the CM console i have looked through all my collections and they are not refrenced.

I am looking for a SQL statement to go into the DB and delete them that way, I would assume it would be similar to deleteing a package (see below)

 

Delete from ContentDPMap where ContentID='CAS00242'

Delete from DistributionStatus where PkgID='CAS00242'

Delete from CI_ContentPackages where PkgID='CAS00242'

Delete from PkgAccess where PkgID='CAS00242'

Delete from SMSPackages_G where PkgID='CAS00242'

Delete from SMSPackages_L where PkgID='CAS00242'

Delete from PkgPrograms_G where PkgID='CAS00242'

Delete from PkgPrograms_G where PkgID='CAS00242'

Delete from PkgServers_G where PkgID='CAS00242'

Delete from PkgServers_L where PkgID='CAS00242'

Delete from PkgStatus_G where ID='CAS00242'

Delete from PkgStatus_L where ID='CAS00242'

Delete from PkgStatusHist where PkgID='CAS00242'

Delete from PkgNotification where PkgID='CAS00242'

 

 

Thank You

[GarthMJ]

What you are trying to do is COMPLETELY unsupported. You can only delete a collect via the console or via the SDK.

[Garrett804]

Check the membership rules for your collections. You must have those listed for membership somewhere.