Finding UUID for CUCM Objects

[cdnadmin]

Subject: RE: Finding UUID for CUCM Objects
Replied by: Erick Wellnitz on 20-04-2011 05:16:44 PM
UUID is the PKID field in the tables.
This document was generated from CDN thread

Created by: Jamie Lewis on 20-04-2011 05:14:28 PM
Having a difficult time figuring out how to pull the UUID for a CUCM object.  For example, I've created a phone, and when attempting to associate an existing user, dn/line appearance, etc... I'm expected to provide the UUID.  Is this something that is pulled from a specific table in the CUCM Database, or is there another way to pull that ID?
 
Jamie

Subject: RE: Finding UUID for CUCM Objects
Replied by: Jamie Lewis on 20-04-2011 05:22:29 PM

UUID is the PKID field in the tables.

Thanks Erick.  Do you by chance have an example code snippet of how to select that from the CUCM table(s)?

Subject: RE: Finding UUID for CUCM Objects
Replied by: Erick Wellnitz on 21-04-2011 09:58:34 AM

UUID is the PKID field in the tables.


Thanks Erick.  Do you by chance have an example code snippet of how to select that from the CUCM table(s)?

 

Here is a snip of SQL to get the PKID of a phone which I use in a more complex query.
select pkid from device where name='SEP000000111111'

This will return the PKID, or UUID, of the phone with MAC address 000000111111

Download yourself a copy of the data dictionary for whichever version of Communications Manager you are working with.  It's provided me with a tremendous amount of help figuring out how things are related in the system.

 If you hae access to the COmmunications Manager console wither directly or through an SSH client you can run sql commands and see the returned values from there before writing them into your code.

In the command line the query would look something like this:

run sql select PKID from device where name = "SEP000000111111"