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

[Brian V]

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/e079cb9f/attachment.html>