Re: [cisco-voip] UCCX Challenge - Reference the Running Script

[Anthony Holloway]

I have thought of that as well.  I like it, but I was wondering if there
was a way to get it from say a single step.  For example, if you could
leverage the com.cisco.app.Application class, or perhaps another class I
don't know about which refers to the running script.

Something like this would be nice (totally made up):

Set this_script = com.cisco.contact.getRunningScript()

On Tue, Nov 27, 2018 at 10:38 PM Bill Talley  wrote:

> Maybe use a Get Trigger Info step to capture the application name,
> followed by Make REST Call to get the script name?
>
> Sent from an iOS device with very tiny touchscreen input keys.  Please
> excude my typtos.
>
> On Nov 27, 2018, at 2:29 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> I have worked out a method to retrieve the running script as a Script
> object, but I'm not super happy with how I did it.  I.e., It's kind of ugly
> looking and complex.
>
> I'm wondering if anyone of you can retrieve a reference to the running
> script, without hard coding the name in the script.  I.e., It should work
> on any script without modification.
>
> E.g., If the App which is executing is called Test and its script which is
> executing is called test.aef, then your script should populate a Script
> variable containing SCRIPT[test.aef].
>
> I don't want to submit my version right away, just so I don't send you
> down any one particular path, but I will share it once a few people have
> responded, or if this gains zero traction after a bit.
>
> Share your solutions!
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] UCCX Challenge - Reference the Running Script

[Bill Talley]

Maybe use a Get Trigger Info step to capture the application name, followed by 
Make REST Call to get the script name? 

Sent from an iOS device with very tiny touchscreen input keys.  Please excude 
my typtos.

> On Nov 27, 2018, at 2:29 PM, Anthony Holloway 
>  wrote:
> 
> I have worked out a method to retrieve the running script as a Script object, 
> but I'm not super happy with how I did it.  I.e., It's kind of ugly looking 
> and complex.
> 
> I'm wondering if anyone of you can retrieve a reference to the running 
> script, without hard coding the name in the script.  I.e., It should work on 
> any script without modification.
> 
> E.g., If the App which is executing is called Test and its script which is 
> executing is called test.aef, then your script should populate a Script 
> variable containing SCRIPT[test.aef].
> 
> I don't want to submit my version right away, just so I don't send you down 
> any one particular path, but I will share it once a few people have 
> responded, or if this gains zero traction after a bit.
> 
> Share your solutions!
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] User device profile conversion

[Stephen Welsh]

Hi Matthew/All,

We have been asked a few times to add support for this, at least as part of a 
Migration of a physical phone to also convert the DeviceProfile too.

There are no native migration features for this operation (even with BAT), but 
we do have a plan on how to do this, and shall start work on the new year, so 
if successful will hopefully have something to share by Cisco Live US 2019.

We are also investigating the migration from IP Communicator to Jabber if that 
is of interest to anyone let us know if you want to test once it’s ready.

Kind Regards

Stephen Welsh
Founder & CTO
UnifiedFX

Sent from my iPad

On 27 Nov 2018, at 21:49, Matthew Loraditch 
mailto:mloradi...@heliontechnologies.com>> 
wrote:

Have you tried one of them on the 8851s? It should let you login, you may not 
need to change anything.

If not probably BAT add the new ones. It’d be cool if Migration FX could do 
these, but I don’t think it can.


Matthew Loraditch​
Sr. Network Engineer

p: 443.541.1518


w: www.heliontechnologies.com|  
e: mloradi...@heliontechnologies.com















From: cisco-voip 
mailto:cisco-voip-boun...@puck.nether.net>> 
On Behalf Of James Dust
Sent: Tuesday, November 27, 2018 11:15 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] User device profile conversion

Afternoon all,

I have around 500 users with end user device profiles for Cisco 797X devices, 
and need to convert these users to 885X profiles.

Can anyone advise the best way to go about this please?

We are running cucm ver 11.









Consider the environment - Think before you print

The contents of this email are confidential to the intended recipient and may 
not be disclosed. Although it is believed that this email and any attachments 
are virus free, it is the responsibility of the recipient to confirm this.

You are advised that urgent, time-sensitive communications should not be sent 
by email. We hereby give you notice that a delivery receipt does not constitute 
acknowledgement or receipt by the intended recipient(s).

Details of Charles Stanley group companies and their regulators (where 
applicable), can be found at this URL 
http://www.charles-stanley.co.uk/contact-us/disclosure/
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] 8865 recent calls breaks with Bluetooth mobile device pairing

[Lelio Fulgenzi]

Just messing around with an 8865. Got Bluetooth mobile device pairing working. 
Imported contacts, too. Works great (although mobile contacts are not 
searchable!).

Thing is, when paired, the recents app breaks. Softkeys show up on bottom but 
that’s it. You can’t even exit. Pairing needs to be deleted and phone reset to 
restore recents.

Got tac case open.

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Finesse Unread Email Queue

[Anthony Holloway]

For your sake, I hope I'm wrong, but I don't think it exists.

It's my observation that Cisco is behind when it comes to omni-channel, and
other companies like Upstream Works are doing omni-channel far better.

I wonder if that's the Cisco master plan: do it just good enough to say you
have it, but not so good that people love it?  Kind of like how they dipped
their toes into Call Recording with Media Sense, but third parties were
just way beyond them, so they closed it down.

After all, Cisco did elect to not continue to support the FB and Twitter
integrations, leaving SM to basically be email and chat only.  Granted, you
can dig RSS feeds, but really, who's doing that?

On Tue, Nov 27, 2018 at 3:42 PM Jason Faraone  wrote:

> I’ve recently migrated our customer service agents over to Cisco Finesse
> for customer email, but I’m not seeing a lot in the way of reporting or
> wallboard support. Specifically, I’d really like to be able to see the
> number of “unread” emails in SocialMiner, so that our agents know how far
> behind on email we are. I don’t see anything like this in CUIC email
> reporting. I can’t just reference the originating Exchange inbox, as
> SocialMiner / UCCX marks them read as it ingests them. Am I just missing
> it, or does it not exist?
> The information in this message may be privileged, "confidential" and
> protected from disclosure and/or intended only for the addressee(s) named
> above. If the reader of this message is not the intended recipient, or an
> employee or agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of the communication is strictly prohibited. If you have received
> this communication in error, please notify us immediately by replying to
> the message and deleting it from your computer. Please consider the
> environment before printing this email.
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] Finesse Unread Email Queue

[Jason Faraone]

I've recently migrated our customer service agents over to Cisco Finesse for 
customer email, but I'm not seeing a lot in the way of reporting or wallboard 
support. Specifically, I'd really like to be able to see the number of "unread" 
emails in SocialMiner, so that our agents know how far behind on email we are. 
I don't see anything like this in CUIC email reporting. I can't just reference 
the originating Exchange inbox, as SocialMiner / UCCX marks them read as it 
ingests them. Am I just missing it, or does it not exist?
The information in this message may be privileged, "confidential" and protected 
from disclosure and/or intended only for the addressee(s) named above. If the 
reader of this message is not the intended recipient, or an employee or agent 
responsible for delivering this message to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of the 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by replying to the message and deleting 
it from your computer. Please consider the environment before printing this 
email.
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] UCCX Challenge - Reference the Running Script

[Anthony Holloway]

I have worked out a method to retrieve the running script as a Script
object, but I'm not super happy with how I did it.  I.e., It's kind of ugly
looking and complex.

I'm wondering if anyone of you can retrieve a reference to the running
script, without hard coding the name in the script.  I.e., It should work
on any script without modification.

E.g., If the App which is executing is called Test and its script which is
executing is called test.aef, then your script should populate a Script
variable containing SCRIPT[test.aef].

I don't want to submit my version right away, just so I don't send you down
any one particular path, but I will share it once a few people have
responded, or if this gains zero traction after a bit.

Share your solutions!
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Lelio Fulgenzi]

Gotcha.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Hunter Fuller 
Sent: Tuesday, November 27, 2018 11:28 AM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

Actually, following my example, they are available as line.display and 
line.displayAscii. But every time I try to update it through AXL using the same 
mechanism I use to update other stuff, it simply doesn't seem to do anything at 
all.
So in other words, I'm not claiming it's impossible to update it that way, but 
I certainly can't do it. :D

--
Hunter Fuller
Network Engineer
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Systems and Infrastructure


On Tue, Nov 27, 2018 at 10:24 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
Are you saying that (ascii) display name and (ascii) alerting name are not AXL 
dippable/updateable information? Yikes.


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Hunter Fuller mailto:hf0...@uah.edu>>
Sent: Tuesday, November 27, 2018 11:14 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: voyp list, cisco-voip 
(cisco-voip@puck.nether.net) 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

I am not doing this, but it could be done pretty easily using Python.
I wrote a little shim library for hitting the AXL API from Python. If we assume 
that the caller ID of the line should be pulled from the first associated end 
user, we can pull the userid, get the name, and set it to the line.
Two gotchas in my example:
1. I am not doing this, personally, so I don't have the code necessary to pull 
the name. But there are lots of Python examples for that.
2. I haven't found a way to update the Caller ID aside from running SQL. Yuck! 
But we are doing it in production, if that makes you feel better...
If you want to try it, the library is here: https://github.com/uah/axlrows 
You're welcome to email me off-list if you have questions about it.

from axlrows import CiscoUCM
ucm = CiscoUCM()
all_lines = ucm.get_lines(routePartitionName='Sys-Ext-PT')
for line in all_lines:
userid = line.associatedEndusers[0][0].userId

#Now we have the userid, and we can look up the name somehow.
name = mystery_name_lookup(userid)

#Now we can set it back to the caller ID
line_pkid = line._uuid.lower().replace('{', '').replace('}', '')
ucm.execute_sql_update(sql="update devicenumplanmap set display = '" + 
name.replace("'", "''") + "' where pkid = '"+ line_pkid + "'")


--
Hunter Fuller
Network Engineer
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Systems and Infrastructure


On Tue, Nov 27, 2018 at 10:00 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

I think this is a good spot for 3rd party/partner development. Basically, hit 
the CUCM database and download DN information. Hit the authoritative directory 
source and download information. Then build an offline database for comparison. 
Based on rules and/or manual input, use CUCM api’s to update out of sync 
display names. *pow*

Darn I should have listened in my programming courses….

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook


From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Tuesday, November 27, 2018 10:42 AM
To: Brian Meade mailto:bmead...@vt.edu>>
Cc: Lelio Fulgenzi mailto:le...@uoguelph.ca>>; Cisco VoIP 
Group mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

First, the tags are too limiting; I wish there were more, and more powerful 
modifiers.

Second, I don't think that works for post device creation, correct?  I.e., CUC 
User Templates are not retroactive

On Tue, Nov 27, 2018 at 9:09 AM Brian Meade 
mailto:bmead...@vt.edu>> wrote:

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Hunter Fuller]

Actually, following my example, they are available as line.display and
line.displayAscii. But every time I try to update it through AXL using the
same mechanism I use to update other stuff, it simply doesn't seem to do
anything at all.

So in other words, I'm not claiming it's impossible to update it that way,
but I certainly can't do it. :D

--
Hunter Fuller
Network Engineer
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Systems and Infrastructure


On Tue, Nov 27, 2018 at 10:24 AM Lelio Fulgenzi  wrote:

> Are you saying that (ascii) display name and (ascii) alerting name are not
> AXL dippable/updateable information? Yikes.
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Hunter Fuller 
> *Sent:* Tuesday, November 27, 2018 11:14 AM
> *To:* Lelio Fulgenzi 
> *Cc:* voyp list, cisco-voip (cisco-voip@puck.nether.net) <
> cisco-voip@puck.nether.net>
> *Subject:* Re: [cisco-voip] Best Practice or Way to bulk update Caller ID
>
>
>
> I am not doing this, but it could be done pretty easily using Python.
>
> I wrote a little shim library for hitting the AXL API from Python. If we
> assume that the caller ID of the line should be pulled from the first
> associated end user, we can pull the userid, get the name, and set it to
> the line.
>
> Two gotchas in my example:
> 1. I am not doing this, personally, so I don't have the code necessary to
> pull the name. But there are lots of Python examples for that.
>
> 2. I haven't found a way to update the Caller ID aside from running SQL.
> Yuck! But we are doing it in production, if that makes you feel better...
>
> If you want to try it, the library is here: https://github.com/uah/axlrows
> You're welcome to email me off-list if you have questions about it.
>
>
> from axlrows import CiscoUCM
> ucm = CiscoUCM()
> all_lines = ucm.get_lines(routePartitionName='Sys-Ext-PT')
>
> for line in all_lines:
>
> userid = line.associatedEndusers[0][0].userId
>
>
> #Now we have the userid, and we can look up the name somehow.
>
> name = mystery_name_lookup(userid)
>
>
> #Now we can set it back to the caller ID
> line_pkid = line._uuid.lower().replace('{', '').replace('}', '')
> ucm.execute_sql_update(sql="update devicenumplanmap set display = '" +
> name.replace("'", "''") + "' where pkid = '"+ line_pkid + "'")
>
>
>
> --
> Hunter Fuller
> Network Engineer
> VBH Annex B-5
> +1 256 824 5331
>
> Office of Information Technology
> The University of Alabama in Huntsville
> Systems and Infrastructure
>
>
>
>
>
> On Tue, Nov 27, 2018 at 10:00 AM Lelio Fulgenzi  wrote:
>
>
>
> I think this is a good spot for 3rd party/partner development. Basically,
> hit the CUCM database and download DN information. Hit the authoritative
> directory source and download information. Then build an offline database
> for comparison. Based on rules and/or manual input, use CUCM api’s to
> update out of sync display names. **pow**
>
>
>
> Darn I should have listened in my programming courses….
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Tuesday, November 27, 2018 10:42 AM
> *To:* Brian Meade 
> *Cc:* Lelio Fulgenzi ; Cisco VoIP Group <
> cisco-voip@puck.nether.net>
> *Subject:* Re: [cisco-voip] Best Practice or Way to bulk update Caller ID
>
>
>
> First, the tags are too limiting; I wish there were more, and more
> powerful modifiers.
>
>
>
> Second, I don't think that works for post device creation, correct?  I.e.,
> CUC User Templates are not retroactive
>
>
>
> On Tue, Nov 27, 2018 at 9:09 AM Brian Meade  wrote:
>
> The Line Templates used for Quick User/Phone Add and Self-Provisioning
> allow you to use tags in various fields:
>
> #FirstName#
>
> #LastName#
>
> #UserID#
>
> #Email#
>
> #Department#
>
> #Manager#
>
> #PrimaryExtension#
>
> #Extension#
>
> #LineIndex#
>
> #DeviceName#
>
> #Product#
>
> #Protocol#
>
>
>
> I've been trying to use this feature more and more lately.  I do wish
> there was some API calls around this feature though.
>
>
>
> On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi  wrote:
>
> After all this, it certainly would be nice to be able to do this
> automatically. Either tied to or not tied to a userid or telephone number
> or 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Lelio Fulgenzi]

Are you saying that (ascii) display name and (ascii) alerting name are not AXL 
dippable/updateable information? Yikes.


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Hunter Fuller 
Sent: Tuesday, November 27, 2018 11:14 AM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

I am not doing this, but it could be done pretty easily using Python.
I wrote a little shim library for hitting the AXL API from Python. If we assume 
that the caller ID of the line should be pulled from the first associated end 
user, we can pull the userid, get the name, and set it to the line.
Two gotchas in my example:
1. I am not doing this, personally, so I don't have the code necessary to pull 
the name. But there are lots of Python examples for that.
2. I haven't found a way to update the Caller ID aside from running SQL. Yuck! 
But we are doing it in production, if that makes you feel better...
If you want to try it, the library is here: https://github.com/uah/axlrows 
You're welcome to email me off-list if you have questions about it.

from axlrows import CiscoUCM
ucm = CiscoUCM()
all_lines = ucm.get_lines(routePartitionName='Sys-Ext-PT')
for line in all_lines:
userid = line.associatedEndusers[0][0].userId

#Now we have the userid, and we can look up the name somehow.
name = mystery_name_lookup(userid)

#Now we can set it back to the caller ID
line_pkid = line._uuid.lower().replace('{', '').replace('}', '')
ucm.execute_sql_update(sql="update devicenumplanmap set display = '" + 
name.replace("'", "''") + "' where pkid = '"+ line_pkid + "'")


--
Hunter Fuller
Network Engineer
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Systems and Infrastructure


On Tue, Nov 27, 2018 at 10:00 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

I think this is a good spot for 3rd party/partner development. Basically, hit 
the CUCM database and download DN information. Hit the authoritative directory 
source and download information. Then build an offline database for comparison. 
Based on rules and/or manual input, use CUCM api’s to update out of sync 
display names. *pow*

Darn I should have listened in my programming courses….

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Tuesday, November 27, 2018 10:42 AM
To: Brian Meade mailto:bmead...@vt.edu>>
Cc: Lelio Fulgenzi mailto:le...@uoguelph.ca>>; Cisco VoIP 
Group mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

First, the tags are too limiting; I wish there were more, and more powerful 
modifiers.

Second, I don't think that works for post device creation, correct?  I.e., CUC 
User Templates are not retroactive

On Tue, Nov 27, 2018 at 9:09 AM Brian Meade 
mailto:bmead...@vt.edu>> wrote:
The Line Templates used for Quick User/Phone Add and Self-Provisioning allow 
you to use tags in various fields:
#FirstName#
#LastName#
#UserID#
#Email#
#Department#
#Manager#
#PrimaryExtension#
#Extension#
#LineIndex#
#DeviceName#
#Product#
#Protocol#

I've been trying to use this feature more and more lately.  I do wish there was 
some API calls around this feature though.

On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
After all this, it certainly would be nice to be able to do this automatically. 
Either tied to or not tied to a userid or telephone number or directory entry. 
Or any combination thereof.

Connection does it, even if not completely well (display name doesn’t get 
updated upon directory update), why not CallManager?


-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook


On Nov 26, 2018, at 6:50 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Don't forget the Alerting Name field.  

Re: [cisco-voip] User device profile conversion

[James Dust]

Hi Matthew,

Yes it does indeed work, however we have noticed a few issues here and there 
which we have reported to Cisco via our 3rd party maintainer.

Cisco have recommended we convert the profiles to fix the issues we are seeing.

Thanks for responding.

Kind regards

James















From: Matthew Loraditch [mailto:mloradi...@heliontechnologies.com]
Sent: 27 November 2018 16:19
To: James Dust; cisco-voip@puck.nether.net
Subject: RE: User device profile conversion

Have you tried one of them on the 8851s? It should let you login, you may not 
need to change anything.

If not probably BAT add the new ones. It’d be cool if Migration FX could do 
these, but I don’t think it can.



Matthew Loraditch​

Sr. Network Engineer


p: 443.541.1518



w: www.heliontechnologies.com

 |

e: mloradi...@heliontechnologies.com


[cid:image001.png@01D4866D.2F42EF20]


[Facebook]



[Twitter]


[LinkedIn]







From: cisco-voip  On Behalf Of James Dust
Sent: Tuesday, November 27, 2018 11:15 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] User device profile conversion

Afternoon all,

I have around 500 users with end user device profiles for Cisco 797X devices, 
and need to convert these users to 885X profiles.

Can anyone advise the best way to go about this please?

We are running cucm ver 11.









Consider the environment - Think before you print

The contents of this email are confidential to the intended recipient and may 
not be disclosed. Although it is believed that this email and any attachments 
are virus free, it is the responsibility of the recipient to confirm this.

You are advised that urgent, time-sensitive communications should not be sent 
by email. We hereby give you notice that a delivery receipt does not constitute 
acknowledgement or receipt by the intended recipient(s).

Details of Charles Stanley group companies and their regulators (where 
applicable), can be found at this URL 
http://www.charles-stanley.co.uk/contact-us/disclosure/

Consider the environment - Think before you print

The contents of this email are confidential to the intended recipient and may 
not be disclosed. Although it is believed that this email and any attachments 
are virus free, it is the responsibility of the recipient to confirm this.

You are advised that urgent, time-sensitive communications should not be sent 
by email. We hereby give you notice that a delivery receipt does not constitute 
acknowledgement or receipt by the intended recipient(s).

Details of Charles Stanley group companies and their regulators (where 
applicable), can be found at this URL 
http://www.charles-stanley.co.uk/contact-us/disclosure/

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] User device profile conversion

[Matthew Loraditch]

Have you tried one of them on the 8851s? It should let you login, you may not 
need to change anything.

If not probably BAT add the new ones. It'd be cool if Migration FX could do 
these, but I don't think it can.


Matthew Loraditch
Sr. Network Engineer
p: 443.541.1518
w: www.heliontechnologies.com | e: mloradi...@heliontechnologies.com
From: cisco-voip  On Behalf Of James Dust
Sent: Tuesday, November 27, 2018 11:15 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] User device profile conversion

Afternoon all,

I have around 500 users with end user device profiles for Cisco 797X devices, 
and need to convert these users to 885X profiles.

Can anyone advise the best way to go about this please?

We are running cucm ver 11.









Consider the environment - Think before you print

The contents of this email are confidential to the intended recipient and may 
not be disclosed. Although it is believed that this email and any attachments 
are virus free, it is the responsibility of the recipient to confirm this.

You are advised that urgent, time-sensitive communications should not be sent 
by email. We hereby give you notice that a delivery receipt does not constitute 
acknowledgement or receipt by the intended recipient(s).

Details of Charles Stanley group companies and their regulators (where 
applicable), can be found at this URL 
http://www.charles-stanley.co.uk/contact-us/disclosure/
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] User device profile conversion

[James Dust]

Afternoon all,

I have around 500 users with end user device profiles for Cisco 797X devices, 
and need to convert these users to 885X profiles.

Can anyone advise the best way to go about this please?

We are running cucm ver 11.









Consider the environment - Think before you print

The contents of this email are confidential to the intended recipient and may 
not be disclosed. Although it is believed that this email and any attachments 
are virus free, it is the responsibility of the recipient to confirm this.

You are advised that urgent, time-sensitive communications should not be sent 
by email. We hereby give you notice that a delivery receipt does not constitute 
acknowledgement or receipt by the intended recipient(s).

Details of Charles Stanley group companies and their regulators (where 
applicable), can be found at this URL 
http://www.charles-stanley.co.uk/contact-us/disclosure/

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Hunter Fuller]

I am not doing this, but it could be done pretty easily using Python.

I wrote a little shim library for hitting the AXL API from Python. If we
assume that the caller ID of the line should be pulled from the first
associated end user, we can pull the userid, get the name, and set it to
the line.

Two gotchas in my example:
1. I am not doing this, personally, so I don't have the code necessary to
pull the name. But there are lots of Python examples for that.
2. I haven't found a way to update the Caller ID aside from running SQL.
Yuck! But we are doing it in production, if that makes you feel better...

If you want to try it, the library is here: https://github.com/uah/axlrows
You're welcome to email me off-list if you have questions about it.

from axlrows import CiscoUCM
ucm = CiscoUCM()
all_lines = ucm.get_lines(routePartitionName='Sys-Ext-PT')
for line in all_lines:
userid = line.associatedEndusers[0][0].userId

#Now we have the userid, and we can look up the name somehow.
name = mystery_name_lookup(userid)

#Now we can set it back to the caller ID
line_pkid = line._uuid.lower().replace('{', '').replace('}', '')
ucm.execute_sql_update(sql="update devicenumplanmap set display = '" +
name.replace("'", "''") + "' where pkid = '"+ line_pkid + "'")


--
Hunter Fuller
Network Engineer
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Systems and Infrastructure


On Tue, Nov 27, 2018 at 10:00 AM Lelio Fulgenzi  wrote:

>
>
> I think this is a good spot for 3rd party/partner development. Basically,
> hit the CUCM database and download DN information. Hit the authoritative
> directory source and download information. Then build an offline database
> for comparison. Based on rules and/or manual input, use CUCM api’s to
> update out of sync display names. **pow**
>
>
>
> Darn I should have listened in my programming courses….
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Tuesday, November 27, 2018 10:42 AM
> *To:* Brian Meade 
> *Cc:* Lelio Fulgenzi ; Cisco VoIP Group <
> cisco-voip@puck.nether.net>
> *Subject:* Re: [cisco-voip] Best Practice or Way to bulk update Caller ID
>
>
>
> First, the tags are too limiting; I wish there were more, and more
> powerful modifiers.
>
>
>
> Second, I don't think that works for post device creation, correct?  I.e.,
> CUC User Templates are not retroactive
>
>
>
> On Tue, Nov 27, 2018 at 9:09 AM Brian Meade  wrote:
>
> The Line Templates used for Quick User/Phone Add and Self-Provisioning
> allow you to use tags in various fields:
>
> #FirstName#
>
> #LastName#
>
> #UserID#
>
> #Email#
>
> #Department#
>
> #Manager#
>
> #PrimaryExtension#
>
> #Extension#
>
> #LineIndex#
>
> #DeviceName#
>
> #Product#
>
> #Protocol#
>
>
>
> I've been trying to use this feature more and more lately.  I do wish
> there was some API calls around this feature though.
>
>
>
> On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi  wrote:
>
> After all this, it certainly would be nice to be able to do this
> automatically. Either tied to or not tied to a userid or telephone number
> or directory entry. Or any combination thereof.
>
>
>
> Connection does it, even if not completely well (display name doesn’t get
> updated upon directory update), why not CallManager?
>
>
>
>
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
>
> On Nov 26, 2018, at 6:50 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Don't forget the Alerting Name field.  This is also Caller ID, but like in
> reverse.
>
>
>
> Never having had to perform this action before, I would be curious as to
> how many records are "out of sync".
>
>
>
> Try running the following, or a similar SQL query to see who isn't lining
> up correctly:
>
>
>
> *run sql select \*
>
> *limit 25 \*
>
> *u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern,
> dn.alertingname, dn.alertingnameascii, la.display, la.displayascii,
> la.label \*
>
> *from devicenumplanmap as la \*
>
> *left join numplan as dn on la.fknumplan = dn.pkid \*
>
> *left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber \*
>
> *where \*
>
> *(u.telephonenumber is not null and u.firstname is not null and u.lastname
> is not null) and \*
>
> 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Lelio Fulgenzi]

I think this is a good spot for 3rd party/partner development. Basically, hit 
the CUCM database and download DN information. Hit the authoritative directory 
source and download information. Then build an offline database for comparison. 
Based on rules and/or manual input, use CUCM api’s to update out of sync 
display names. *pow*

Darn I should have listened in my programming courses….

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Tuesday, November 27, 2018 10:42 AM
To: Brian Meade 
Cc: Lelio Fulgenzi ; Cisco VoIP Group 

Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

First, the tags are too limiting; I wish there were more, and more powerful 
modifiers.

Second, I don't think that works for post device creation, correct?  I.e., CUC 
User Templates are not retroactive

On Tue, Nov 27, 2018 at 9:09 AM Brian Meade 
mailto:bmead...@vt.edu>> wrote:
The Line Templates used for Quick User/Phone Add and Self-Provisioning allow 
you to use tags in various fields:
#FirstName#
#LastName#
#UserID#
#Email#
#Department#
#Manager#
#PrimaryExtension#
#Extension#
#LineIndex#
#DeviceName#
#Product#
#Protocol#

I've been trying to use this feature more and more lately.  I do wish there was 
some API calls around this feature though.

On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
After all this, it certainly would be nice to be able to do this automatically. 
Either tied to or not tied to a userid or telephone number or directory entry. 
Or any combination thereof.

Connection does it, even if not completely well (display name doesn’t get 
updated upon directory update), why not CallManager?


-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook


On Nov 26, 2018, at 6:50 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Don't forget the Alerting Name field.  This is also Caller ID, but like in 
reverse.

Never having had to perform this action before, I would be curious as to how 
many records are "out of sync".

Try running the following, or a similar SQL query to see who isn't lining up 
correctly:

run sql select \
limit 25 \
u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern, dn.alertingname, 
dn.alertingnameascii, la.display, la.displayascii, la.label \
from devicenumplanmap as la \
left join numplan as dn on la.fknumplan = dn.pkid \
left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber \
where \
(u.telephonenumber is not null and u.firstname is not null and u.lastname is 
not null) and \
(concat(concat(u.firstname, ' '), lastname) <> dn.alertingname or 
concat(concat(u.firstname, ' '), lastname) <> la.display) \
order by u.lastname, u.firstname

Legend
Limit - Feel free to increase/decrease/remove the limit command
Offending Records - Feel free to add/remove/modify the offending record finder. 
 I.e., This filter only matches the AD first + last against alerting and 
display, and also it assumes your DNs are \+1[2-9]XX[2-9]XX formatted, and 
your AD telephoneNumbers are +1[2-9]XX[2-9]XX formatted, so it removes the 
\ on the DN for lining up records with the right function, 12 characters in.

*The funky looking concat commands are because of two reasons: 1) the CLI 
parser wont let me use pipes to concat, and 2) the concat function only can 
concat two fields at once, so we have to run it twice to insert the space 
between names.  Else, you might be able to pull the displayname field instead.  
In my case this is Lastname, Firstname, so concatenating the first and last on 
my own was better.

The output will look something like this:

telephonenumber firstname lastname dnorpattern   alertingname   
alertingnameascii  displaydisplayascii  
 label
=== =  = 
== == 
== == 
===
+16125551212Anthony   Holloway \+16125551212 Tony Holloway  
Tony Holloway  Tony Holloway  Tony Holloway 
 Tony Holloway - 1212

Legend
AD Fields (Once per account)
DN Fields (Once per DN)
Line Appearance Fields (Can exist multiple times for 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Anthony Holloway]

First, the tags are too limiting; I wish there were more, and more powerful
modifiers.

Second, I don't think that works for post device creation, correct?  I.e.,
CUC User Templates are not retroactive

On Tue, Nov 27, 2018 at 9:09 AM Brian Meade  wrote:

> The Line Templates used for Quick User/Phone Add and Self-Provisioning
> allow you to use tags in various fields:
> #FirstName#
> #LastName#
> #UserID#
> #Email#
> #Department#
> #Manager#
> #PrimaryExtension#
> #Extension#
> #LineIndex#
> #DeviceName#
> #Product#
> #Protocol#
>
> I've been trying to use this feature more and more lately.  I do wish
> there was some API calls around this feature though.
>
> On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi  wrote:
>
>> After all this, it certainly would be nice to be able to do this
>> automatically. Either tied to or not tied to a userid or telephone number
>> or directory entry. Or any combination thereof.
>>
>> Connection does it, even if not completely well (display name doesn’t get
>> updated upon directory update), why not CallManager?
>>
>>
>>
>> *-sent from mobile device-*
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>> On Nov 26, 2018, at 6:50 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Don't forget the Alerting Name field.  This is also Caller ID, but like
>> in reverse.
>>
>> Never having had to perform this action before, I would be curious as to
>> how many records are "out of sync".
>>
>> Try running the following, or a similar SQL query to see who isn't lining
>> up correctly:
>>
>> *run sql select \*
>> *limit 25 \*
>> *u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern,
>> dn.alertingname, dn.alertingnameascii, la.display, la.displayascii,
>> la.label \*
>> *from devicenumplanmap as la \*
>> *left join numplan as dn on la.fknumplan = dn.pkid \*
>> *left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber
>> \*
>> *where \*
>> *(u.telephonenumber is not null and u.firstname is not null and
>> u.lastname is not null) and \*
>> *(concat(concat(u.firstname, ' '), lastname) <> dn.alertingname or
>> concat(concat(u.firstname, ' '), lastname) <> la.display) \*
>> *order by u.lastname, u.firstname *
>>
>> *Legend*
>> Limit - Feel free to increase/decrease/remove the limit command
>> Offending Records - Feel free to add/remove/modify the offending record
>> finder.  I.e., This filter only matches the AD first + last against
>> alerting and display, and also it assumes your DNs are
>> \+1[2-9]XX[2-9]XX formatted, and your AD telephoneNumbers
>> are +1[2-9]XX[2-9]XX formatted, so it removes the \ on the DN for
>> lining up records with the right function, 12 characters in.
>>
>> *The funky looking concat commands are because of two reasons: 1) the CLI
>> parser wont let me use pipes to concat, and 2) the concat function only can
>> concat two fields at once, so we have to run it twice to insert the space
>> between names.  Else, you might be able to pull the displayname field
>> instead.  In my case this is Lastname, Firstname, so concatenating the
>> first and last on my own was better.
>>
>> The output will look something like this:
>>
>> *telephonenumber firstname lastname dnorpattern   alertingname
>>alertingnameascii  display
>> displayascii   label*
>> *=== =  =
>> == ==
>> == ==
>> ===*
>> *+16125551212Anthony   Holloway \+16125551212 Tony Holloway
>> Tony Holloway  Tony Holloway  Tony
>> Holloway  Tony Holloway - 1212*
>>
>> *Legend*
>> AD Fields (Once per account)
>> DN Fields (Once per DN)
>> Line Appearance Fields (Can exist multiple times for every appearance
>> this DN exists on)
>>
>> From there, I would bring the data into MS Excel, filter, sort, fix,
>> etc., and then I would use the AXL SQL Toolkit to submit each update
>> individually.  Once for the DN and once for the line, per correction.  This
>> will automatically reset phones, just like a BAT operation would.
>>
>> E.g.,
>>
>> *Update the DN fields*
>> *update numplan set alertingname = 'Anthony Holloway', alertingnameascii
>> = 'Anthony Holloway' where dnorpattern = '\+16125551212'*
>>
>> *Update the LA fields*
>> *update devicenumplanmap set display = 'Anthony Holloway', displayascii =
>> 'Anthony Holloway' where fknumplan = (select pkid from numplan where
>> dnorpattern = '\+16125551212')*
>>
>> With any approach you 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Brian Meade]

The Line Templates used for Quick User/Phone Add and Self-Provisioning
allow you to use tags in various fields:
#FirstName#
#LastName#
#UserID#
#Email#
#Department#
#Manager#
#PrimaryExtension#
#Extension#
#LineIndex#
#DeviceName#
#Product#
#Protocol#

I've been trying to use this feature more and more lately.  I do wish there
was some API calls around this feature though.

On Mon, Nov 26, 2018 at 11:39 PM Lelio Fulgenzi  wrote:

> After all this, it certainly would be nice to be able to do this
> automatically. Either tied to or not tied to a userid or telephone number
> or directory entry. Or any combination thereof.
>
> Connection does it, even if not completely well (display name doesn’t get
> updated upon directory update), why not CallManager?
>
>
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
> On Nov 26, 2018, at 6:50 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Don't forget the Alerting Name field.  This is also Caller ID, but like in
> reverse.
>
> Never having had to perform this action before, I would be curious as to
> how many records are "out of sync".
>
> Try running the following, or a similar SQL query to see who isn't lining
> up correctly:
>
> *run sql select \*
> *limit 25 \*
> *u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern,
> dn.alertingname, dn.alertingnameascii, la.display, la.displayascii,
> la.label \*
> *from devicenumplanmap as la \*
> *left join numplan as dn on la.fknumplan = dn.pkid \*
> *left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber \*
> *where \*
> *(u.telephonenumber is not null and u.firstname is not null and u.lastname
> is not null) and \*
> *(concat(concat(u.firstname, ' '), lastname) <> dn.alertingname or
> concat(concat(u.firstname, ' '), lastname) <> la.display) \*
> *order by u.lastname, u.firstname *
>
> *Legend*
> Limit - Feel free to increase/decrease/remove the limit command
> Offending Records - Feel free to add/remove/modify the offending record
> finder.  I.e., This filter only matches the AD first + last against
> alerting and display, and also it assumes your DNs are
> \+1[2-9]XX[2-9]XX formatted, and your AD telephoneNumbers
> are +1[2-9]XX[2-9]XX formatted, so it removes the \ on the DN for
> lining up records with the right function, 12 characters in.
>
> *The funky looking concat commands are because of two reasons: 1) the CLI
> parser wont let me use pipes to concat, and 2) the concat function only can
> concat two fields at once, so we have to run it twice to insert the space
> between names.  Else, you might be able to pull the displayname field
> instead.  In my case this is Lastname, Firstname, so concatenating the
> first and last on my own was better.
>
> The output will look something like this:
>
> *telephonenumber firstname lastname dnorpattern   alertingname
>alertingnameascii  display
> displayascii   label*
> *=== =  =
> == ==
> == ==
> ===*
> *+16125551212Anthony   Holloway \+16125551212 Tony Holloway
>   Tony Holloway  Tony Holloway  Tony
> Holloway  Tony Holloway - 1212*
>
> *Legend*
> AD Fields (Once per account)
> DN Fields (Once per DN)
> Line Appearance Fields (Can exist multiple times for every appearance this
> DN exists on)
>
> From there, I would bring the data into MS Excel, filter, sort, fix, etc.,
> and then I would use the AXL SQL Toolkit to submit each update
> individually.  Once for the DN and once for the line, per correction.  This
> will automatically reset phones, just like a BAT operation would.
>
> E.g.,
>
> *Update the DN fields*
> *update numplan set alertingname = 'Anthony Holloway', alertingnameascii =
> 'Anthony Holloway' where dnorpattern = '\+16125551212'*
>
> *Update the LA fields*
> *update devicenumplanmap set display = 'Anthony Holloway', displayascii =
> 'Anthony Holloway' where fknumplan = (select pkid from numplan where
> dnorpattern = '\+16125551212')*
>
> With any approach you take, there are going to be one-off cases you'll
> likely need to manually handle, and not too mention, your environment may
> have sticking points which completely prevent you from being able to use
> bulk tools.  E.g., Your fields are all jacked up, your DNs don't line up
> with your AD telephoneNumbers, etc.
>
> If you think you'll have to perform this activity more than once, then I
> would suggest 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Lelio Fulgenzi]

You just had to bring up Jabber caller ID lookups, didn’t you. 


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Tuesday, November 27, 2018 9:29 AM
To: Lelio Fulgenzi 
Cc: Ryan Huff ; Cisco VoIP Group 

Subject: Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

Probably because CUC is only updating the user account, which CUCM also does; 
CUC is not updating other Objects like DNs and Line Appearances.  There's no 
perfect solution, because of us, the users/humans which make up the system.  
Just look at how they tried to do caller ID lookups with Jabber, which pulls 
straight from AD, but even that has false matches from time to time.

On Mon, Nov 26, 2018 at 10:38 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
After all this, it certainly would be nice to be able to do this automatically. 
Either tied to or not tied to a userid or telephone number or directory entry. 
Or any combination thereof.

Connection does it, even if not completely well (display name doesn’t get 
updated upon directory update), why not CallManager?


-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook


On Nov 26, 2018, at 6:50 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Don't forget the Alerting Name field.  This is also Caller ID, but like in 
reverse.

Never having had to perform this action before, I would be curious as to how 
many records are "out of sync".

Try running the following, or a similar SQL query to see who isn't lining up 
correctly:

run sql select \
limit 25 \
u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern, dn.alertingname, 
dn.alertingnameascii, la.display, la.displayascii, la.label \
from devicenumplanmap as la \
left join numplan as dn on la.fknumplan = dn.pkid \
left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber \
where \
(u.telephonenumber is not null and u.firstname is not null and u.lastname is 
not null) and \
(concat(concat(u.firstname, ' '), lastname) <> dn.alertingname or 
concat(concat(u.firstname, ' '), lastname) <> la.display) \
order by u.lastname, u.firstname

Legend
Limit - Feel free to increase/decrease/remove the limit command
Offending Records - Feel free to add/remove/modify the offending record finder. 
 I.e., This filter only matches the AD first + last against alerting and 
display, and also it assumes your DNs are \+1[2-9]XX[2-9]XX formatted, and 
your AD telephoneNumbers are +1[2-9]XX[2-9]XX formatted, so it removes the 
\ on the DN for lining up records with the right function, 12 characters in.

*The funky looking concat commands are because of two reasons: 1) the CLI 
parser wont let me use pipes to concat, and 2) the concat function only can 
concat two fields at once, so we have to run it twice to insert the space 
between names.  Else, you might be able to pull the displayname field instead.  
In my case this is Lastname, Firstname, so concatenating the first and last on 
my own was better.

The output will look something like this:

telephonenumber firstname lastname dnorpattern   alertingname   
alertingnameascii  displaydisplayascii  
 label
=== =  = 
== == 
== == 
===
+16125551212Anthony   Holloway \+16125551212 Tony Holloway  
Tony Holloway  Tony Holloway  Tony Holloway 
 Tony Holloway - 1212

Legend
AD Fields (Once per account)
DN Fields (Once per DN)
Line Appearance Fields (Can exist multiple times for every appearance this DN 
exists on)

From there, I would bring the data into MS Excel, filter, sort, fix, etc., and 
then I would use the AXL SQL Toolkit to submit each update individually.  Once 
for the DN and once for the line, per correction.  This will automatically 
reset phones, just like a BAT operation would.

E.g.,

Update the DN fields
update numplan set alertingname = 'Anthony Holloway', alertingnameascii = 
'Anthony Holloway' where dnorpattern = '\+16125551212'

Update the LA fields
update devicenumplanmap set display = 'Anthony Holloway', displayascii = 
'Anthony Holloway' where fknumplan 

Re: [cisco-voip] Best Practice or Way to bulk update Caller ID

[Anthony Holloway]

Probably because CUC is only updating the user account, which CUCM also
does; CUC is not updating other Objects like DNs and Line Appearances.
There's no perfect solution, because of us, the users/humans which make up
the system.  Just look at how they tried to do caller ID lookups with
Jabber, which pulls straight from AD, but even that has false matches from
time to time.

On Mon, Nov 26, 2018 at 10:38 PM Lelio Fulgenzi  wrote:

> After all this, it certainly would be nice to be able to do this
> automatically. Either tied to or not tied to a userid or telephone number
> or directory entry. Or any combination thereof.
>
> Connection does it, even if not completely well (display name doesn’t get
> updated upon directory update), why not CallManager?
>
>
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
> On Nov 26, 2018, at 6:50 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Don't forget the Alerting Name field.  This is also Caller ID, but like in
> reverse.
>
> Never having had to perform this action before, I would be curious as to
> how many records are "out of sync".
>
> Try running the following, or a similar SQL query to see who isn't lining
> up correctly:
>
> *run sql select \*
> *limit 25 \*
> *u.telephonenumber, u.firstname, u.lastname, dn.dnorpattern,
> dn.alertingname, dn.alertingnameascii, la.display, la.displayascii,
> la.label \*
> *from devicenumplanmap as la \*
> *left join numplan as dn on la.fknumplan = dn.pkid \*
> *left join enduser as u on right(dn.dnorpattern, 12) = u.telephonenumber \*
> *where \*
> *(u.telephonenumber is not null and u.firstname is not null and u.lastname
> is not null) and \*
> *(concat(concat(u.firstname, ' '), lastname) <> dn.alertingname or
> concat(concat(u.firstname, ' '), lastname) <> la.display) \*
> *order by u.lastname, u.firstname *
>
> *Legend*
> Limit - Feel free to increase/decrease/remove the limit command
> Offending Records - Feel free to add/remove/modify the offending record
> finder.  I.e., This filter only matches the AD first + last against
> alerting and display, and also it assumes your DNs are
> \+1[2-9]XX[2-9]XX formatted, and your AD telephoneNumbers
> are +1[2-9]XX[2-9]XX formatted, so it removes the \ on the DN for
> lining up records with the right function, 12 characters in.
>
> *The funky looking concat commands are because of two reasons: 1) the CLI
> parser wont let me use pipes to concat, and 2) the concat function only can
> concat two fields at once, so we have to run it twice to insert the space
> between names.  Else, you might be able to pull the displayname field
> instead.  In my case this is Lastname, Firstname, so concatenating the
> first and last on my own was better.
>
> The output will look something like this:
>
> *telephonenumber firstname lastname dnorpattern   alertingname
>alertingnameascii  display
> displayascii   label*
> *=== =  =
> == ==
> == ==
> ===*
> *+16125551212Anthony   Holloway \+16125551212 Tony Holloway
>   Tony Holloway  Tony Holloway  Tony
> Holloway  Tony Holloway - 1212*
>
> *Legend*
> AD Fields (Once per account)
> DN Fields (Once per DN)
> Line Appearance Fields (Can exist multiple times for every appearance this
> DN exists on)
>
> From there, I would bring the data into MS Excel, filter, sort, fix, etc.,
> and then I would use the AXL SQL Toolkit to submit each update
> individually.  Once for the DN and once for the line, per correction.  This
> will automatically reset phones, just like a BAT operation would.
>
> E.g.,
>
> *Update the DN fields*
> *update numplan set alertingname = 'Anthony Holloway', alertingnameascii =
> 'Anthony Holloway' where dnorpattern = '\+16125551212'*
>
> *Update the LA fields*
> *update devicenumplanmap set display = 'Anthony Holloway', displayascii =
> 'Anthony Holloway' where fknumplan = (select pkid from numplan where
> dnorpattern = '\+16125551212')*
>
> With any approach you take, there are going to be one-off cases you'll
> likely need to manually handle, and not too mention, your environment may
> have sticking points which completely prevent you from being able to use
> bulk tools.  E.g., Your fields are all jacked up, your DNs don't line up
> with your AD telephoneNumbers, etc.
>
> If you think you'll have to perform this activity more than once, then I
> would suggest