[cisco-voip] Does anyone know if there is a CLI SQL command to determine the CUCM server ID (GUID type value)

Wed Aug 16 17:57:25 EDT 2017

Filter by typeprocessnoderole / tkprocessnoderole<https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm#typeprocessnoderole>

Types of server roles within a cluster: 1 = Voice (default) and 2 = IM and Presence

https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm#typeprocessnoderole

Regards,
Divin

From: Brian V <bvanbens at gmail.com>
Date: Wednesday, August 16, 2017 at 17:46
To: Divin John <dijohn at cisco.com>, "cisco-voip at puck.nether.net" <cisco-voip at puck.nether.net>
Subject: Re: [cisco-voip] Does anyone know if there is a CLI SQL command to determine the CUCM server ID (GUID type value)

That worked.  Thanks !!

This should give you the Publisher.
run sql select * from processnode where tknodeusage =0  <== returns publisher(s)  includes IMP servers

admin:run sql select * from typenodeusage
enum name       moniker
==== ========== =====================
0    Publisher  NODE_USAGE_PUBLISHER
1    Subscriber NODE_USAGE_SUBSCRIBER

On Wed, Aug 16, 2017 at 4:22 PM, Divin John (dijohn) <dijohn at cisco.com<mailto:dijohn at cisco.com>> wrote:
Hey!

This should give you the Publisher.
run sql select * from processnode where tknodeusage =0

admin:run sql select * from typenodeusage
enum name       moniker
==== ========== =====================
0    Publisher  NODE_USAGE_PUBLISHER
1    Subscriber NODE_USAGE_SUBSCRIBER

From: cisco-voip <cisco-voip-bounces at puck.nether.net<mailto:cisco-voip-bounces at puck.nether.net>> on behalf of Brian V <bvanbens at gmail.com<mailto:bvanbens at gmail.com>>
Date: Wednesday, August 16, 2017 at 16:54
To: Stephen Welsh <stephen.welsh at unifiedfx.com<mailto:stephen.welsh at unifiedfx.com>>
Cc: "cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>" <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>>
Subject: Re: [cisco-voip] Does anyone know if there is a CLI SQL command to determine the CUCM server ID (GUID type value)

Thanks !
The "first" PKID in this case didn't match the publisher.  But I think I know why in this case.
This customer was forced to rebuild and restore a few of the CUCM nodes including the publisher.
I'm guessing this might change the order of the PKIDs we're searching for.
Your Query
admin:run sql select first 1 pkid from processnode where systemnode='f' order by rowid
pkid
====================================
42a06662-6152-fe3f-634f-027fe4351e2a  <=  not the publisher, actually a 2nd CUCM subscriber

My hack at modifying it.....
admin:run sql select pkid from processnode where systemnode='f' order by rowid
pkid
====================================
42a06662-6152-fe3f-634f-027fe4351e2a  - CUCM sub 2
6511274e-ef86-5d23-7816-ae2828ce760a - CUCM sub 1
b632ddbe-ab5a-4df4-957c-c0a3e4d04a2f  <= this is my publisher, verified from the browser URL value
e017e6b7-8b60-2e9b-1a71-e10f88652204 - IMP 1
f5957263-d806-ea5f-83b9-c2ea670310a3 - IMP2
admin:
Is there another way to query to ask for the publisher node specifically? or another way of ensuring its the publisher that gets returned ?

I also tested this on a lab cluster that was never restored and your original query does match up with the publisher ID.

On Wed, Aug 16, 2017 at 3:41 PM, Stephen Welsh <stephen.welsh at unifiedfx.com<mailto:stephen.welsh at unifiedfx.com>> wrote:
Hi,

Try this out from the platform CLI:

run sql select first 1 pkid from processnode where systemnode='f' order by rowid

Kind Regards

Stephen Welsh
CTO
UnifiedFX

On 16 Aug 2017, at 21:37, Brian V <bvanbens at gmail.com<mailto:bvanbens at gmail.com>> wrote:

See the below example from the web browser (You can find the Server ID in CUCM by logging into CM Administration in the Pub > System > Server > Select Pub. The server ID is the same as the Server ID listed at the end of the page URL:)
<image.png>
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170816/d5ec2006/attachment.html>