I recently migrated users from an 8.6 to 11.5 cluster and, between fixing all of the table errors caused by db changes between versions, we ended up with 45,000 subscribed services for 8,000 endpoints. Exporting and re-importing was going to be a nightmare so I exported some tables to an SQLite server and set about playing with SQL. I now have a working statement which deleted 37,000 entries out of the database and left the unique entries.
run sql delete from telecastersubscribedservice where pkid not in (select max(pkid) from telecastersubscribedservice group by fkdevice, fktelecasterservice having max(pkid) is not null)
Since this is a delete on the raw database table, you're on your own if it breaks. Take a backup (run it up in the lab and test on the backup) before using on a live system. The SQL works on my external db and the query runs correctly as an SQL select on the live system. Deleting a single entry from that table using SQL has the desired effect and I've found no issues, but I've yet to run it in anger. I've posted it here as I've hit this issue in the past and I can't see any better articles so I hope that this helps if you need it.
Les stations de radio en ligne sont devenues l'une des formes de partage des médias les plus populaires dans la ecouter radio en ligne société d'aujourd'hui. La radio Internet est maintenant disponible sur tous les principaux modems de câbles et sans fil ...
This document describes the details about the Cisco Collaboration Endpoint software upgrade error “File too large”, and guides through the possible workarounds to upgrade the endpoint to the desired version.
we have recently announced a new Webex Events service with a best-in-class virtual event experience that is video-centric, intelligent, and simple to use.
Some highlights (features of new Webex Events that were not there with existing/c...
The purpose of this document is to present the different troubleshooting steps to take when some service from the Cisco IM & Presence Service Server have not started gracefully.
The States of a service
The IM&P ...
This event had place on Tuesday 20th, April 2021 at 10hrs PDT
What is the Real-Time Monitoring Tool (RTMT) and how do I use it? In addition to an overview of the components of the tool and the interface, attendees learned how to use ...