Thanks Nick and Daniel. That is all very helpful.
> On Sep 14, 2015, at 2:35 PM, Barnett, Nick > <nick.barn...@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-boun...@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-boun...@puck.nether.net > <mailto:cisco-voip-boun...@puck.nether.net>] On Behalf Of Daniel Pagan > Sent: Monday, September 14, 2015 10:44 AM > To: Mark Holloway <m...@markholloway.com <mailto:m...@markholloway.com>>; > voip puck <cisco-voip@puck.nether.net <mailto:cisco-voip@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@10.10.31.6:50926;transport=tcp > <sip:ae97ba4b-2397-4b52-5ddc-07589fb380ab@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-boun...@puck.nether.net > <mailto:cisco-voip-boun...@puck.nether.net>] On Behalf Of Mark Holloway > Sent: Saturday, September 12, 2015 8:39 AM > To: voip puck <cisco-voip@puck.nether.net <mailto:cisco-voip@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@10.232.50.81:49422;transport=tcp > <sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2@10.232.50.81:49422;transport=tcp> > SIP/2.0 > INVITE > sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2@10.232.50.91:51945;transport=tcp > <sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2@10.232.50.91:51945;transport=tcp> > SIP/2.0 > > > Thanks, > Mark >
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip