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

[Brian V]

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>
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> on behalf of
> Brian V <bvanbens at gmail.com>
> *Date: *Wednesday, August 16, 2017 at 16:54
> *To: *Stephen Welsh <stephen.welsh at unifiedfx.com>
> *Cc: *"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)
>
>
>
> 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> 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> 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
> 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/f56ae58b/attachment.html>