CUCM Informix PKID Matching

Unanswered Question
Jun 24th, 2009

Is there any "run sql" queries that can be run on CUCM 5.x/6.x/7.x servers to correlate a PKID to a phone/translation pattern/etc description.

The reason, I ask is because the "Cisco Role Based security" logs all log a pkid/name. I want to know how to correlate that pkid to something actual pattern or Phone.

Example:

gatewayH323Save: pkid/name 1a8bb71b-7575-1494-0ef6-9d5a58f0aae8

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)
Loading.
Aaron Harrison Wed, 06/24/2009 - 09:57

Hi

You can retrieve the info like so:

run sql select * from h323device where pkid = '1a8bb71b-7575-1494-0ef6-9d5a58f0aae8'

If your device is another type, it may be in another table.

Good bets would be 'device' for phones and so on, or 'mgcp' for mgcp gateways.

Regards

Aaron

Please rate helpful posts....

Christopher Dozier Wed, 06/24/2009 - 10:14

OK, so that give this output:

admin:run sql select * from h323device where pkid = '1a8bb71b-7575-1494-0ef6-9d5a58f0aae8'

pkid fkdevice calleriddn tkcallingpartyselection tkpresentationbit fkdevice_gatekeeper displayie numdigits prefix sigdigits runh225doneverynodeflag tknumberingplan_called tknumberingplan_calling tkpriofnumber_calling tkpriofnumber_called acceptinboundrdnis numberie tkterminal zone technologyprefix endpointaddress1 endpointaddress2 endpointaddress3 signalingport useclientconfiguration activecap enableoutboundfaststart enableinboundfaststart tkmediapayload e164 pathreplacementsupport tktunneledprotocol

==== ======== ========== ======================= ================= =================== ========= ========= ====== ========= ======================= ====================== ======================= ===================== ==================== ================== ======== ========== ==== ================ ================ ================ ================ ============= ====================== ========= ======================= ====================== ============== ==== ====================== ==================

admin:run sql ?

Syntax:

run sql sql_statement

sql_statement mandatory the sql command to run

admin:

So my next question is, how do i get the name or ip address? Is there a way to know the possible "from" values as you said (device, mgcp, etc).

Thanks

Actions

This Discussion