I can not delete old Device Pool

[Sergey 1907]

I have misunderstandings. I made a new Device Pool and moved there all the devices that were tied to the old Device Pool. But I cannot delete the old Device Pool, since in the dependencies I see 31 devices that are tied to it in the Device - Device Settings - Device defaults. But in the Device Defaults all devices belong to the new pool. How to find these invisible devices and change their device pool?

[Nithin Eluvathingal]

There Could be gateway,Trunks etc... using   this device pool. 

Check the dependency from Device pool and it gives you  the details of record type which depend  on your Old device Pool.

[Sergey 1907]

Hello Nithin

SPB_DEVICE its old Device Pool and ALL_DEVICE_SPB is new

Spoiler

Devices Pool Screens

 

 

[Nithin Eluvathingal]

 Thats Strange, I believe you might need a restart of CUCM. 

[Sergey 1907]

I agree, this is strange. I noticed this after as I upgraded from 12.5 to 14. I have already rebooted CUCM several times.

[Roger Kallberg]

Reboot will not help. This has been a nuisance for a very long time, in multiple versions, as there are apparently some device defaults that are always assigned to the very first, I believe, device pool that was in the system and these are not seen in the list in the UI.

From what I can recall there is always a DP named Default when you install CM and this is set per default as the device default for all models. If you later decide to rename this DP to something else and then even later try to remove this DP it will not let you as it will still have these hidden references.

Likely there are ways to find and alter this with SQL queries, but I have never made an effort to do this, so I can not help you out with these.

[Sergey 1907]

Hello Roger, nice to meet you )

Unfortunately, according to the schema from Cisco Unified Communications Manager 14.0(1) Database Dictionary, Device Pool (as fkDevicePool) is only for Phones

and run sql select fkdevicepool,name from device nothing gave me

[Roger Kallberg]

Please see these screenshots from a CM 14 system.

Based on this there are defensively more than phones that uses device pools.

I agree with @Nithin Eluvathingal, your best option is to work with TAC on this.

[Sergey 1907]

I think that these may be deprecated devices that are not shown in the GUI. All that is needed for the operation of CUCM itself changes without problems.

And thanks gay’s, I m open case with TAC

[Nithin Eluvathingal]

I suggest to open a ticket with TAC. 

[Maren Mahoney]

The two places I would look are:

Device > Device Settings > Default Device Profile

For every phone model you build, CUCM builds a Default Device Profile for Extension Mobility whether you use EM or not. These may still have the old Device Pool.

Device > Device Settings > Device Defaults

For every phone model that Cisco has, this determines the default settings for auto-registration. You may have the old Device Pool referenced here as well.

If neither of those is it, I think I have an SQL query that will allow you to list devices referencing a specific device pool. Let me know and I'll look it up.

Maren

[Sergey 1907]

Hello Maren

I checked it now. In both locations, there are no device profiles configured. It's empty there. And I looked, it is impossible to explicitly specify the device pool in the default device profiles. Your thought about sql queries interests me

[Maren Mahoney]

First, let me apologize for not reading your original post carefully. I ended up telling you things you already knew.

Second, I've spent the last couple of days (when I had free time) trying to get the hang of SQL Query syntax to figure out a query to answer your question. I have not gotten the hang of it...lol

But, I did come up with a couple of queries that may get you started. I'm having trouble with the "inner join" syntax to get the names come up instead of PKIDs for things. Here is what I do have:

So....What is desired is a list of Device Defaults that are using a particular Device Pool. The following query of the "defaults" table will list those fields, but using PKIDs rather than names:

run sql select fkphonetemplate,tkmodel,tkdeviceprotocol,fkdevicepool from defaults

This can be compared to the output of the following query that lists all Device Pools via PKID with Name:
run sql select pkid,name from devicepool

And that is where I got stuck. I'm just learning programming and queries and such. Perhaps someone with more experience can expand on this and find a single query with joins that will tease out the information you are seeking.

Maren

[Sergey 1907]

Hi Maren

Great job as always.

TAC informed me, that they have found a solution. Use the SQL command to reassign one of the existing devices pools as the default. Tomorrow we will do and I will enable copying the input/output in the SecureCRT to a file for us

[Sergey 1907 · Accepted solution]

As promised, I post the log:

admin:run sql select pkid,name from devicepool
pkid name
==================================== ==============
1ce2c8d3-19c6-6487-12d2-894c97ca6abe BRANCH_POOL
385a99e2-2ba7-b74e-d066-e56c2d92b1bd ALL_DEVICE_SPB

Spoiler

Command Line Interface is starting up, please wait ...

Welcome to the Platform Command Line Interface

VMware Installation:
2 vCPU: Intel(R) Xeon(R) Gold 5217 CPU @ 3.00GHz
Disk 1: 110GB, Partitions aligned
8192 Mbytes RAM

admin:run sql select * from defaults where fkdevicepool like '1b1b9eb6-7803-11d3-bdf0-00108302ead1'
pkid tkmodel loadinformation fkdevicepool fkphonetemplate inactiveloadinformation tkdeviceprotocol resettoggle tkreset versionstamp preferactcodeoverautoreg
==================================== ======= =============== ==================================== ==================================== ======================= ================ =========== ======= =============================================== ========================
7cb6f496-5d7b-11d4-a46b-0060b0fb2ce3 2 1b1b9eb6-7803-11d3-bdf0-00108302ead1 d75a26ee-4c89-4871-9072-d30a4bcda1a3 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f495-5d7b-11d4-a46b-0060b0fb2ce3 3 1b1b9eb6-7803-11d3-bdf0-00108302ead1 4214a0f8-00ca-4a31-bbee-cbc2c490bbb1 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f494-5d7b-11d4-a46b-0060b0fb2ce3 4 1b1b9eb6-7803-11d3-bdf0-00108302ead1 0c09f206-eade-42d5-a4f7-9fd20524ae14 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f497-5d7b-11d4-a46b-0060b0fb2ce3 1 1b1b9eb6-7803-11d3-bdf0-00108302ead1 713f5277-947e-46de-b3d0-447be16e286d 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f498-5d7b-11d4-a46b-0060b0fb2ce3 5 1b1b9eb6-7803-11d3-bdf0-00108302ead1 8862bbe7-c759-46c7-8da8-f433d0cc43d5 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
850741d6-e756-11d4-9e27-0010a4fc1df1 9 1b1b9eb6-7803-11d3-bdf0-00108302ead1 cbb4706e-eb45-4784-a81a-2c8fd0303022 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
a9953e35-5e47-11d4-a46c-0060b0fb2ce3 6 1b1b9eb6-7803-11d3-bdf0-00108302ead1 eb1f730e-600c-4307-8271-95d8d98c7d56 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
9782c464-6768-48ce-8413-924fc5416611 11 1b1b9eb6-7803-11d3-bdf0-00108302ead1 0e58be72-e1c8-4551-a5f0-d221674cfa1e 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
083c3c16-5bad-4bfd-adc7-a0c934373c3c 336 1b1b9eb6-7803-11d3-bdf0-00108302ead1 57759cc0-a08e-4348-a7f9-e79a9ab9719e 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
12d9550c-fad0-46ea-af30-d2961adda407 374 1b1b9eb6-7803-11d3-bdf0-00108302ead1 a59ccc48-2176-4df7-b737-70fe1a947e4c 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
b35e0e56-321c-4e60-80fb-ebd0aeea9d2b 119 1b1b9eb6-7803-11d3-bdf0-00108302ead1 9c9f4e1e-7879-4ad0-842f-a0f253864260 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
4d45eb5b-0c86-43e1-bbec-8e5d4e644f13 119 1b1b9eb6-7803-11d3-bdf0-00108302ead1 fbeafb0e-0224-448e-96ef-9188628b51fe 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
6517d818-93da-4e5a-a92d-de9326598f24 20000 1b1b9eb6-7803-11d3-bdf0-00108302ead1 313a0958-253f-4fa2-bf47-93f85bf86f86 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
97ac4ed3-fd16-45e5-9b21-49e0114a3499 20000 1b1b9eb6-7803-11d3-bdf0-00108302ead1 18be6afa-784f-429b-939b-73655345c043 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
53d9b709-71df-4bd3-a918-cf4ed5405d4d 365 1b1b9eb6-7803-11d3-bdf0-00108302ead1 370684ad-1801-48ff-8c30-f5d41a16db18 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
901003b2-c52d-46cb-9d5c-28f1e481459f 375 1b1b9eb6-7803-11d3-bdf0-00108302ead1 b7fdd4d0-919b-4e81-a689-df15bc000642 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
8fa41265-7637-4a11-8801-552cf7a9cee3 376 1b1b9eb6-7803-11d3-bdf0-00108302ead1 d160fa93-bee9-49ca-8143-4dbb0e84acbb 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
037e906a-7413-4e61-b02a-720bf7490e43 30002 1b1b9eb6-7803-11d3-bdf0-00108302ead1 039fdc76-0b89-4879-9009-c177fda15d1e 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
10c157dd-27cc-4ec1-a728-933e323201c6 30006 1b1b9eb6-7803-11d3-bdf0-00108302ead1 404d3a28-498c-4e1d-9057-2714edf43b7b 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
a663e9fb-71d1-405e-b7a7-e1b7b24c58a3 30006 1b1b9eb6-7803-11d3-bdf0-00108302ead1 7a2a27ee-0a09-403d-9c65-9e99104d843d 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
5665d82f-11b0-4803-9746-c5edb0bcda3b 30007 1b1b9eb6-7803-11d3-bdf0-00108302ead1 b945e350-eda6-4e0e-a35a-820b748e5a01 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
a5103894-4a06-4e8c-8d27-ce5a626fd00e 30007 1b1b9eb6-7803-11d3-bdf0-00108302ead1 62087267-5161-456c-9422-3b48c6c0c76a 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
95cfc2ed-2617-4f13-99e0-bd20d8b0f9eb 30008 1b1b9eb6-7803-11d3-bdf0-00108302ead1 6a96e7ed-a8f4-41d1-8476-74dd1a47c9e0 0 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
b2a04032-f2ac-412f-a1c5-b1f9867d5232 232 1b1b9eb6-7803-11d3-bdf0-00108302ead1 NULL 99 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
0ba39f1b-3cd8-45f0-86fe-11506ef47573 557 1b1b9eb6-7803-11d3-bdf0-00108302ead1 a015bb0a-fdcf-45c1-9dd1-1e8bd8ba5cf4 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
09fb8f1b-4a7c-46cc-93b6-d6297729ddc0 558 1b1b9eb6-7803-11d3-bdf0-00108302ead1 56b214a1-b9e8-44ce-8db0-3369e2a259cb 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
8a531406-961b-4c51-9631-e9dbb74dd97e 594 1b1b9eb6-7803-11d3-bdf0-00108302ead1 NULL 99 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
269676e4-1fb2-4a49-9b88-9a90a192b8c8 645 1b1b9eb6-7803-11d3-bdf0-00108302ead1 1f9180ed-d6f1-417d-96f0-a57c42f20665 11 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f499-5d7b-11d4-a46b-0060b0fb2ce3 30 A001C030 1b1b9eb6-7803-11d3-bdf0-00108302ead1 NULL 99 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f4a0-5d7b-11d4-a46b-0060b0fb2ce3 40 D001M022 1b1b9eb6-7803-11d3-bdf0-00108302ead1 NULL 99 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
7cb6f4a2-5d7b-11d4-a46b-0060b0fb2ce3 42 D00303010033 1b1b9eb6-7803-11d3-bdf0-00108302ead1 NULL 99 f 2 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 f
admin:run sql update defaults set fkdevicepool='385a99e2-2ba7-b74e-d066-e56c2d92b1bd' where fkdevicepool='1b1b9eb6-7803-11d3-bdf0-00108302ead1'
#### one pkid Devices Pool change to pkid other Devices Poos
Rows: 31
#### After that, Devices poll remoove from GUI
admin:run sql select * from devicepool where name ='SPB_DEVICE_POOL'
pkid name fkregion fkdatetimesetting fkcallmanagergroup fkcallingsearchspace_autoregistration fkmediaresourcelist tkcountry fksrst connectionmonitorduration resettoggle tkreset versionstamp fkaarneighborhood fkcallingsearchspace_aar fkcallingsearchspace_mobility fkdevicemobilitygroup fklocation fkphysicallocation tkrevertpriority tkstatus_joinacrosslines tkbarge fkcallingsearchspace_cdpntransform nationalprefix internationalprefix unknownprefix subscriberprefix fkcallingsearchspace_cgpntransform callednationalprefix calledinternationalprefix calledunknownprefix calledsubscriberprefix callednationalstripdigits calledinternationalstripdigits calledunknownstripdigits calledsubscriberstripdigits fkcallingsearchspace_callednational fkcallingsearchspace_calledintl fkcallingsearchspace_calledunknown fkcallingsearchspace_calledsubscriber fkcallingsearchspace_adjunct fkgeolocation fkgeolocationfilter_lp nationalstripdigits internationalstripdigits unknownstripdigits subscriberstripdigits fkcallingsearchspace_cgpnnational fkcallingsearchspace_cgpnintl fkcallingsearchspace_cgpnunknown fkcallingsearchspace_cgpnsubscriber fkviprpublisheddidpatterngroup fkcallingsearchspace_cntdpntransform fkcallingsearchspace_rdntransform fkcallingsearchspace_cgpningressdn fkwirelesslanprofilegroup fkelingroup fkmraservicedomain
==================================== =============== ==================================== ==================================== ==================================== ===================================== ==================================== ========= ==================================== ========================= =========== ======= =============================================== ================= ======================== ============================= ===================== ==================================== ================== ================ ======================== ======= ================================== ============== =================== ============= ================ ================================== ==================== ========================= =================== ====================== ========================= ============================== ======================== =========================== =================================== =============================== ================================== ===================================== ============================ ============= ====================== =================== ======================== ================== ===================== ================================= ============================= ================================ =================================== ============================== ==================================== ================================= ================================== ========================= =========== ==================
044062b4-0dfa-14b8-505c-c61bb512df96 SPB_DEVICE_POOL 1b1b9eb1-7803-11d3-bdf0-00108302ead1 9ec4850a-7748-11d3-bdf0-00108302ead1 d13c4201-7802-11d3-bdf0-00108302ead1 6080768f-2af5-1502-0f87-64fbfb95b1f3 b157d937-9a4c-7edd-499e-80f785340a66 50 cd241e11-4a58-4d3d-9661-f06c912a18a3 -1 f 2 1632516526-49cb6ecf-d29a-48f2-b7c7-e73597911b24 NULL NULL NULL NULL 29c5c1c4-8871-4d1e-8394-0b9181e8c54d NULL 0 2 3 NULL NULL 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
admin:run sql select * from devicepool where name ='BRANCH_POOL'
pkid name fkregion fkdatetimesetting fkcallmanagergroup fkcallingsearchspace_autoregistration fkmediaresourcelist tkcountry fksrst connectionmonitorduration resettoggle tkreset versionstamp fkaarneighborhood fkcallingsearchspace_aar fkcallingsearchspace_mobility fkdevicemobilitygroup fklocation fkphysicallocation tkrevertpriority tkstatus_joinacrosslines tkbarge fkcallingsearchspace_cdpntransform nationalprefix internationalprefix unknownprefix subscriberprefix fkcallingsearchspace_cgpntransform callednationalprefix calledinternationalprefix calledunknownprefix calledsubscriberprefix callednationalstripdigits calledinternationalstripdigits calledunknownstripdigits calledsubscriberstripdigits fkcallingsearchspace_callednational fkcallingsearchspace_calledintl fkcallingsearchspace_calledunknown fkcallingsearchspace_calledsubscriber fkcallingsearchspace_adjunct fkgeolocation fkgeolocationfilter_lp nationalstripdigits internationalstripdigits unknownstripdigits subscriberstripdigits fkcallingsearchspace_cgpnnational fkcallingsearchspace_cgpnintl fkcallingsearchspace_cgpnunknown fkcallingsearchspace_cgpnsubscriber fkviprpublisheddidpatterngroup fkcallingsearchspace_cntdpntransform fkcallingsearchspace_rdntransform fkcallingsearchspace_cgpningressdn fkwirelesslanprofilegroup fkelingroup fkmraservicedomain
==================================== =========== ==================================== ==================================== ==================================== ===================================== ==================================== ========= ==================================== ========================= =========== ======= =============================================== ================= ======================== ============================= ===================== ==================================== ================== ================ ======================== ======= ================================== ============== =================== ============= ================ ================================== ==================== ========================= =================== ====================== ========================= ============================== ======================== =========================== =================================== =============================== ================================== ===================================== ============================ ============= ====================== =================== ======================== ================== ===================== ================================= ============================= ================================ =================================== ============================== ==================================== ================================= ================================== ========================= =========== ==================
1ce2c8d3-19c6-6487-12d2-894c97ca6abe BRANCH_POOL 1b1b9eb1-7803-11d3-bdf0-00108302ead1 9ec4850a-7748-11d3-bdf0-00108302ead1 d13c4201-7802-11d3-bdf0-00108302ead1 NULL b157d937-9a4c-7edd-499e-80f785340a66 50 cd241e11-4a58-4d3d-9661-f06c912a18a3 -1 f 2 1606826893-f8ec2286-0c4c-4161-84ff-6d420473ff1b NULL NULL NULL NULL 29c5c1c4-8871-4d1e-8394-0b9181e8c54d NULL 0 2 3 NULL Default Default Default Default NULL Default Default Default Default NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

admin:run sql update defaults set fkdevicepool='1ce2c8d3-19c6-6487-12d2-894c97ca6abe' where fkdevicepool='044062b4-0dfa-14b8-505c-c61bb512df96'
Rows: 1
#### After that, Devices poll remoove from GUI