[cisco-voip] CUCM Shared Line Appearance (SIP phones)

[Mark Holloway]

Thanks Nick and Daniel. That is all very helpful.


> On Sep 14, 2015, at 2:35 PM, Barnett, Nick <Nick.Barnett at countryfinancial.com> wrote:
> 
> To add to this, the PKID is generated using newid(), a function defined in the Informix database.
>  
> At one point, I started digging around to see if I could actually locate the formula used within that function, but I wasn’t able to get very far. I was able to find a reference to sqlfunctions within the sysprocedures table. I don’t even know if it is related. According to the Informix documentation I have read, the sysprocedures table stores all procedures, but I’m under the impression this is a function, but it may just be a vocabulary issue on my part. If anyone knows where the actual getid() is stored, I’d be interested in looking at it.
>  
> run sql select * from sysprocedures where procname = "sqlfunctions"
>  
> Thanks,
> Nick
>  
> Disclaimer: IANADBA
>  
> From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Daniel Pagan
> Sent: Monday, September 14, 2015 10:07 AM
> To: Daniel Pagan; Mark Holloway; voip puck
> Subject: Re: [cisco-voip] CUCM Shared Line Appearance (SIP phones)
>  
> Adding to this… This is also the URI contained in the Contact header for SIP requests transmitted *from* the IP phone, allowing CUCM to send future requests to the phone within the same dialog using the PKID URI you’re seeing. The PKID for the DN is obtained by the phone via TFTP configuration file:
>  
> <contact>ae97ba4b-2397-4b52-5ddc-07589fb380ab</contact>
>  
> Hope this helps.
>  
> - Dan
>  
> From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net <mailto:cisco-voip-bounces at puck.nether.net>] On Behalf Of Daniel Pagan
> Sent: Monday, September 14, 2015 10:44 AM
> To: Mark Holloway <mh at markholloway.com <mailto:mh at markholloway.com>>; voip puck <cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>>
> Subject: Re: [cisco-voip] CUCM Shared Line Appearance (SIP phones)
>  
> The request-URI in this case is the PKID of the DN followed by the IP address of the phone. Check it out:
>  
> https://10.10.13.100/ccmadmin/directoryNumberEdit.do?key=ae97ba4b-2397-4b52-5ddc-07589fb380ab <https://urldefense.proofpoint.com/v2/url?u=https-3A__10.10.13.100_ccmadmin_directoryNumberEdit.do-3Fkey-3Dae97ba4b-2D2397-2D4b52-2D5ddc-2D07589fb380ab&d=BQMF-g&c=M-KQspD_LQogCbR-BWCHOaeDEPOhF8vWqHZTaiwxT3c&r=T9uVLZucbHG2NKKKzOrp-o5cpdReHj02PkJJsCVkgfwcv7S0R5lDeFJg2VRbiNih&m=OxWTXBha_SMEwQWX1utNzxe75Aieb7dfByp4DL_a3RI&s=6hMkdEgry-T3tGS32w810c-uNgWFx_BR9AnxzzHmNsM&e=>
>  
> ^^^URL of a test DN.
> Key= ae97ba4b-2397-4b52-5ddc-07589fb380ab
>  
> INVITE sip:ae97ba4b-2397-4b52-5ddc-07589fb380ab at 10.10.31.6:50926;transport=tcp <sip:ae97ba4b-2397-4b52-5ddc-07589fb380ab at 10.10.31.6:50926;transport=tcp> SIP/2.0
>  
> ^^^ Check out the request URI above.
>  
> Hope this helps.
>  
> - Dan
>  
> From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net <mailto:cisco-voip-bounces at puck.nether.net>] On Behalf Of Mark Holloway
> Sent: Saturday, September 12, 2015 8:39 AM
> To: voip puck <cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>>
> Subject: [cisco-voip] CUCM Shared Line Appearance (SIP phones)
>  
> Hi all. When CUCM sends a SIP Invite to shared lines on SIP phones the user portion contains some sort of (what appears to b) a randomly calculated alpha-numeric string. Is there any information or documentation available on how Cisco actually calculates what this string will be? 
>  
> Here is an example of a SIP Invite going to two SIP phones sharing the same phone number
>  
> INVITE sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.81:49422;transport=tcp <sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.81:49422;transport=tcp> SIP/2.0
> INVITE sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.91:51945;transport=tcp <sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.91:51945;transport=tcp> SIP/2.0
>  
>  
> Thanks,
> Mark
>  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150915/1ef6ee4c/attachment.html>