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]> 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]> 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] > https://puck.nether.net/mailman/listinfo/cisco-voip > > >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
