[cisco-voip] [External] Re: Is it possible to bulk export phones from CLI or API?
Hunter Fuller
hf0002 at uah.edu
Thu Feb 18 14:37:58 EST 2021
If you want to use it to match everything, just delete the word "where" and
everything after it. If you don't specify a "where" clause it matches
everything.
I'm sure you won't want to bother with axlrows since you already have what
you need, but here is one way you could have done it. It is not possible to
use axlrows to do it for device profiles because we don't use those so I
haven't written that - sorry.
>>> phones = get_phones(name="SEP700B4F9C44B8")
for phone in phones:
dirn_uuid = phone.lines[0][0].dirn._uuid
dirn = get_suds_client().service.getLine(uuid=dirn_uuid)[0][0] #hack
print(phone.name + "," + phone.description + "," + dirn.pattern +
"," + dirn.shareLineAppearanceCssName[0])
SEP700B4F9C44B8,Hunter Fuller (Cisco 8851 SIP) - Home,5331,COS-Unlimited-CSS
--
Hunter Fuller (they)
Router Jockey
VBH Annex B-5
+1 256 824 5331
Office of Information Technology
The University of Alabama in Huntsville
Network Engineering
On Thu, Feb 18, 2021 at 1:31 PM Louis Koekemoer (MEA) <
Louis.Koekemoer at dimensiondata.com> wrote:
> Alan,
>
>
>
> This is exactly what I am looking for. I will use it like below, as I am
> interested in all. What would I change to do the same for UDP, as not every
> user necessarily has a jabber or physical phone device
>
>
>
> run sql select device.name, device.description, numplan.dnorpattern,
> routepartition.name, callingsearchspace.name, devicenumplanmap.e164mask,
> devicepool.name, devicenumplanmap.busytrigger,
> devicenumplanmap.maxnumcalls from numplan inner join devicenumplanmap on
> numplan.pkid = devicenumplanmap.fknumplan inner join device on
> devicenumplanmap.fkdevice = device.pkid inner join routepartition on
> routepartition.pkid = numplan.fkroutepartition inner join
> callingsearchspace on callingsearchspace.pkid =
> numplan.fkcallingsearchspace_sharedlineappear inner join devicepool on
> device.fkdevicepool = devicepool.pkid where numplan.dnorpattern like '%'
>
>
>
> *From:* Alan Libbee <alan.libbee at umgc.edu>
> *Sent:* Thursday, 18 February 2021 21:12
> *To:* Louis Koekemoer (MEA) <Louis.Koekemoer at dimensiondata.com>;
> cisco-voip <cisco-voip at puck.nether.net>
> *Subject:* Re: Is it possible to bulk export phones from CLI or API?
>
>
>
>
>
> Louis,
>
>
>
> Below is a query you can run from the CLI in CallManager over ssh. You can
> change the end from '24%' to any number you want, similar to directory
> number starts with 24. You can modify this query or build a similar one to
> get the fields you are looking for.
>
>
>
> run sql select device.name, device.description, numplan.dnorpattern,
> routepartition.name, callingsearchspace.name, devicenumplanmap.e164mask,
> devicepool.name, devicenumplanmap.busytrigger,
> devicenumplanmap.maxnumcalls from numplan inner join devicenumplanmap on
> numplan.pkid = devicenumplanmap.fknumplan inner join device on
> devicenumplanmap.fkdevice = device.pkid inner join routepartition on
> routepartition.pkid = numplan.fkroutepartition inner join
> callingsearchspace on callingsearchspace.pkid =
> numplan.fkcallingsearchspace_sharedlineappear inner join devicepool on
> device.fkdevicepool = devicepool.pkid where numplan.dnorpattern like '24%'
>
>
>
> Example Output:
>
>
>
> name description dnorpattern
> name name e164mask name busytrigger
> maxnumcalls
>
> =============== ============================================== ===========
> ======= ================= ========== ========== =========== ===========
>
> CSFBLAH CSF for Blah 2408675309
> Internal_PT Long_Distance 12408675309 Example 1 2
>
>
>
>
>
> Hope this helps.
>
>
>
> -Alan
>
>
>
>
> ------------------------------
>
> *From:* cisco-voip <cisco-voip-bounces at puck.nether.net> on behalf of
> Louis Koekemoer (MEA) <Louis.Koekemoer at dimensiondata.com>
> *Sent:* Thursday, February 18, 2021 1:44 PM
> *To:* cisco-voip <cisco-voip at puck.nether.net>
> *Subject:* [cisco-voip] Is it possible to bulk export phones from CLI or
> API?
>
>
>
> Hi,
>
>
>
> I recently upgraded my CUCM clusters to CUCM 12.5su3. I hit a bit of an
> issue. 2 bugs. 1 on exporting all devices or all UDP, all details and 2
> generating UDP reports or Phone reports. I need to do these on a weekly
> basis and I have 3 cluster with around 7000-1000 UDP per cluster and up to
> 33000 phones/devices per cluster. Now as per the below it breaks on around
> 700-800 devices. I logged a TAC case and this is what TAC identified.
> Firstly the customer is not happy with bleeding edge(Not released yet). I
> am not very clued up on API’s but is there possible a way I can either
> “export” all devices, all details via cli or with a API? I have a few more
> clusters to upgrade but all put on hold due to this.
>
>
>
>
>
> 1. https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvv67192
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbst.cloudapps.cisco.com%2Fbugsearch%2Fbug%2FCSCvv67192&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983601572%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=sr4n26vQfEhwnrWn392hbBjP46n073g2vTLyw5SKnf0%3D&reserved=0>
>
>
>
> *Symptom:*
>
> Export of Bulk Phones Job , stays in "Processing" State and does not
> "Completes"
>
> Export of Bulk UDP Job , stays in "Processing" State and does not
> "Completes"
>
>
>
> *Conditions:*
>
> Export fails if it's more than 520 phone records through Phone -> Export
> Phone/UDP -> All Details
>
>
>
> *Workaround:*
>
> 1. Export phones around 400 records through Phone -> Export Phone ->
> Specific Details
>
> 2. Export 800+ records through Import/Export -> Export operation.
>
>
>
>
>
> *The known fixed version is CCM.12.5(1.14900.42) but is going to be
> released in late February.*
>
>
>
> 2. https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvw44625
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbst.cloudapps.cisco.com%2Fbugsearch%2Fbug%2FCSCvw44625&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983611566%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=VzD5xg%2By8XySV2dAZahQ20SSd%2BalkdWJRGa9nOvm5r0%3D&reserved=0>
>
>
>
>
>
> *Symptom:*
>
> When customer submits bat job for (Bulk Administration --> Phones -->
> Generate Phone Reports) failed event can be observed from Job Scheduler
> page.
>
>
>
> Issue started after upgrading to CUCM 12.5 SU3
>
>
>
> *Conditions:*
>
> Generate Phone Report under Bulk Administration
>
>
>
> *Workaround:*
>
> While Generating the Phone Report,
>
> Bulk Administration --> Phones --> Generate Phone Reports after selecting
> mandatory fields,
>
> under IP Phone services fields two checkboxes are there for speed dial
> services and IP Phone services, if the user can checked those boxes and run
> the job Report will generate successfully
>
>
>
> *The known fixed version is CCM.12.5(1.14900.42) but is going to be
> released in late February.*
>
>
>
> [image: ddlogo]
>
> *Louis Koekemoer (MEA) *
>
> *Engineer - IPT - L4 *
>
> *m. *+27 71 6808790
>
> *t.* +27 11 5754317
>
> *email. *louis.koekemoer at dimensiondata.com
>
> *dimensiondata.com
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dimensiondata.com%2F&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983611566%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=mHZOq8WiLH5ONsLtsuSEz311srS6dWDi5GfGScyMVjA%3D&reserved=0>
> *
>
> [image: ddtwitter]
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FDiDataMEA&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983621560%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=P3VxRmJGNwBYdX5esUANZSABBxH%2FalQelYxRR%2Bnx4sU%3D&reserved=0>
>
> [image: ddlinkedin]
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fdimension-data-middle-east-and-africa&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983641549%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=3PmUo1tpbkznjoiK7%2B0q7WqJluszHAMnVLTTSER3MkY%3D&reserved=0>
>
> [image: ddfacebook]
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FDiDataMEA&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983651540%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=alo66IOqggKMBQEaZhsjEcLtLTYJQtm5k3t0L4nPLhE%3D&reserved=0>
>
> [image: ddinstagram]
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2F_dimensiondata_&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983671533%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=VOKNK6mCRmNqB5CLgaIziULRzSd9zYSNE3Kkcq%2FJEVs%3D&reserved=0>
>
> [image: Logo]
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dimensiondata.com%2F&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983671533%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Rn2NtjxVoAEuveElN3wcO2f2VNt6ScZhjJe0Ujob8bQ%3D&reserved=0>
>
> .
>
> .
>
> This email and all contents are subject to the following disclaimer:
> https://www.dimensiondata.com/email-disclaimer
> <https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dimensiondata.com%2Femail-disclaimer&data=04%7C01%7Calan.libbee%40umgc.edu%7C75ff6196f22345bf3a8308d8d43d9df9%7C704ce3d6a4bf4e098516d52840c9f7a9%7C1%7C0%7C637492708983681526%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=F%2BnptdrOsp%2FK9ZTzT5%2FKSKl3mpFQsEAb5TqzRUfuLZ4%3D&reserved=0>
>
>
>
> itevomcid
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4859 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 8214 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 8498 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 8246 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 800 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 5571 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210218/a617d173/attachment-0002.png>
More information about the cisco-voip
mailing list