Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Bronze

Bulk Delete Phones from 4.1 Database

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Bulk Delete Phones from 4.1 Database

of course there is!

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

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
5 REPLIES
Cisco Employee

Re: Bulk Delete Phones from 4.1 Database

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Bronze

Re: Bulk Delete Phones from 4.1 Database

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.

Cisco Employee

Re: Bulk Delete Phones from 4.1 Database

of course there is!

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

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Hall of Fame Super Red

Re: Bulk Delete Phones from 4.1 Database

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

Bronze

Re: Bulk Delete Phones from 4.1 Database

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

252
Views
0
Helpful
5
Replies