Skip to content

Delete Device Collection from SQL

Featured Replies

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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.