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 <[email protected]> Date: Wednesday, August 16, 2017 at 17:46 To: Divin John <[email protected]>, "[email protected]" <[email protected]> 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) <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> on behalf of Brian V <[email protected]<mailto:[email protected]>> Date: Wednesday, August 16, 2017 at 16:54 To: Stephen Welsh <[email protected]<mailto:[email protected]>> Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
