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

[Danny2210]

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

[Danny2210 · Accepted solution]

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