Jump to content


MarshMan0331

Delete Device Collection from SQL

Recommended Posts

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

Share this post


Link to post
Share on other sites

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...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...