Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

You may experience some slow load times, errors, and slight inconsistencies. We ask for your patience as we finalize the launch. Thank you.

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our beta test area to get started.

CUCM Informix PKID Matching

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

  • IP Telephony
2 REPLIES
Super Bronze

Re: CUCM Informix PKID Matching

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....

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Re: CUCM Informix PKID Matching

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

1204
Views
3
Helpful
2
Replies