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]> 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]> on behalf of > Brian V <[email protected]> > *Date: *Wednesday, August 16, 2017 at 16:54 > *To: *Stephen Welsh <[email protected]> > *Cc: *"[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) > > > > 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
