Bulk Delete Phones from 4.1 Database

Answered Question
Sep 11th, 2008
User Badges:
  • Silver, 250 points or more

I am in the process of migrating phones from 4.1 to 6.1, as I move over phones I delete phones from 4.1, create on 6.1, then setup a route pattern that goes across the Intercluster Trunk however what is happening is the DN's dont completely remove themselves from the 4.1 Database. When it is a small amount of phone it is not a problem so I run a Route Plan Report and manually delete. However the number of phones that I am moving is growing larger and wondering if there was a slick way to remove DN's that are no longer attached to a Phone. I know in 6.1 there is a cool way to Bulk Delete but I assume if there is a workaround for Bulk Deleting in CM 4.1 it might be some SQL Query. Anyone have any ideas.

Correct Answer by Jaime Valencia about 8 years 7 months ago

of course there is!


look at the drop down menu, unassigned DNs is there as an option


HTH


java


if this helps, please rate

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Jaime Valencia Fri, 09/12/2008 - 03:55
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

are you removing the DNs from the unassigned DNs from the route plan report???


they don't completely delete until you remove them from unassigned DNs


HTH


java


if this helps, please rate

shane.orr Fri, 09/12/2008 - 05:04
User Badges:
  • Silver, 250 points or more

Yes I am using the route plan report but in CM 4.1 there is no option to differentiate between DN's that are unassigned and ones that are. So I have to go hunt and peck. So I was looking maybe for some SQL Query to look for any DN's that are not assigned to phones/devices or any other cool trick.

Correct Answer
Jaime Valencia Fri, 09/12/2008 - 05:06
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

of course there is!


look at the drop down menu, unassigned DNs is there as an option


HTH


java


if this helps, please rate

Rob Huffman Fri, 09/12/2008 - 05:06
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hey Shane,


Hope all is well :) Like Java noted I don't think there is a faster way than using the Route Plan Report and choosing "Delete All Found Items".


Hope this helps!

Rob

shane.orr Fri, 09/12/2008 - 05:18
User Badges:
  • Silver, 250 points or more

Sounds good guys. That is manageable. I appreciate the feedback as always.

Actions

This Discussion