cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
442
Views
10
Helpful
1
Replies
Danny2210
Beginner

CSCvm84172 - Jabber for Windows does not show hunt pilot information - 1

Will there be a fix for this on Cisco 7800 and 8800 phones at some point?

We have over 400 Hunt Pilots and it would be a lot of work to just put quotation marks and then delete them in a later update.

 

Thanks

Danny

1 ACCEPTED SOLUTION

Accepted Solutions
Danny2210
Beginner

We found a quick solution for that issue.

We ran two SQL statements in the publisher CLI to put quotation marks to every hunt pilot:

 

run sql update numplan set alertingname = CONCAT('"',alertingname) where tkpatternusage=7 AND alertingname NOT LIKE '\"%'
run sql update numplan set alertingname = CONCAT(alertingname,'"') where tkpatternusage=7 AND alertingname NOT LIKE '%\"'

 

We needed to use two statements because the CONCAT in CUCM only supports 2 arguments, so we put quotation marks in front in the first statement and behind in the second one. We also added a condition to check, if the pilot already has quotation marks.

 

tkpatternusage=7 declares a numplan entry (dn or pattern) as hunt pilot.

 

 

Best Regards

Danny

 

 

View solution in original post

1 REPLY 1
Danny2210
Beginner

We found a quick solution for that issue.

We ran two SQL statements in the publisher CLI to put quotation marks to every hunt pilot:

 

run sql update numplan set alertingname = CONCAT('"',alertingname) where tkpatternusage=7 AND alertingname NOT LIKE '\"%'
run sql update numplan set alertingname = CONCAT(alertingname,'"') where tkpatternusage=7 AND alertingname NOT LIKE '%\"'

 

We needed to use two statements because the CONCAT in CUCM only supports 2 arguments, so we put quotation marks in front in the first statement and behind in the second one. We also added a condition to check, if the pilot already has quotation marks.

 

tkpatternusage=7 declares a numplan entry (dn or pattern) as hunt pilot.

 

 

Best Regards

Danny

 

 

View solution in original post