SIP URI in Invite to CSF Device

[JaySchiller]

Hello!

I am looking at CUCM SIP Traces, specifically the SIP INVITES.

SIP INVITES that are being send to a CSF Device (Jabber Softphone for example) will look like this;

09570472.001 |08:17:46.291 |AppInfo |SIPTcp - wait_SdlSPISignal: Outgoing SIP TCP message to x.x.x.x on port 49942 index 157025
[185285318,NET]
INVITE sip:645ebe89-829a-6012-964f-53bed8a6dc89@x.x.x.x:49942;transport=tls SIP/2.0

What is this:  645ebe89-829a-6012-964f-53bed8a6dc89   ?

To me this looks like a pkid of a DN or Device or whatever from the CUCM. 
Would I be able to identify what User, Dn or Device this is if I ONLY have this?

Kind regards, 

Jay

[Roger Kallberg]

It is quite likely a PKID of the directory number. There are SQL query options for this, but before we go into that it would be good if you verify the assumption by going to this url https://<FQDN of a node in the CM cluster>:8443/ccmadmin/directoryNumberEdit.do?key=645ebe89-829a-6012-964f-53bed8a6dc89

[JaySchiller]

Hello!

Ok. I am in our Lab now and I did some Tests.

Using the URL you suggested only brings: The item with key "6ece656a-b3e8-c416-7dbd-7d063cc6f5db" was not found in the database. Please select another item to view.

But when I open the DN in CUCM admin and check the URL I get this:

https://XXXXXX:8443/ccmadmin/directoryNumberEdit.do?key=52b03350-ea91-530e-5287-e6df74c77f95&mapkey=6ece656a-b3e8-c416-7dbd-7d063cc6f5db&devicekey=fc9b681e-2d39-2535-21dd-b29a62a68dbf&index=1

So I did a few more SQL Selects. The table I was looking for is "devicenumplanmap".
run sql select * from devicenumplanmap where pkid='6ece656a-b3e8-c416-7dbd-7d063cc6f5db'
gives you fkdevice and fknumplan.

You can open https://XXXXX/ccmadmin/phoneEdit.do?key=fc9b681e-2d39-2535-21dd-b29a62a68dbf (fkdevice value) to open the device or https://XXXXXX:8443/ccmadmin/directoryNumberEdit.do?key=52b03350-ea91-530e-5287-e6df74c77f95 (fknumplan value) to open the DN directly.

Awesome. That was exactly what I was looking for. Thank you very much for the push in the right direction.