<div dir="ltr">That worked. Thanks !!<br><br><br><p class="MsoNormal">This should give you the Publisher.</p>
<p class="MsoNormal"><b>run sql select * from processnode where tknodeusage =0 <== returns publisher(s) includes IMP servers<br></b></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">admin:run sql select * from typenodeusage</p>
<p class="MsoNormal">enum name moniker</p>
<p class="MsoNormal">==== ========== =====================</p>
<p class="MsoNormal">0 Publisher NODE_USAGE_PUBLISHER</p>
1 Subscriber NODE_USAGE_SUBSCRIBER</div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 16, 2017 at 4:22 PM, Divin John (dijohn) <span dir="ltr"><<a href="mailto:dijohn@cisco.com" target="_blank">dijohn@cisco.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" link="blue" vlink="purple" lang="EN-US">
<div class="m_3157788660352024975WordSection1">
<p class="MsoNormal">Hey!<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">This should give you the Publisher.<u></u><u></u></p>
<p class="MsoNormal">run sql select * from processnode where tknodeusage =0<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">admin:run sql select * from typenodeusage<u></u><u></u></p>
<p class="MsoNormal">enum name moniker<u></u><u></u></p>
<p class="MsoNormal">==== ========== =====================<u></u><u></u></p>
<p class="MsoNormal">0 Publisher NODE_USAGE_PUBLISHER<u></u><u></u></p>
<p class="MsoNormal">1 Subscriber NODE_USAGE_SUBSCRIBER<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">cisco-voip <<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.<wbr>nether.net</a>> on behalf of Brian V <<a href="mailto:bvanbens@gmail.com" target="_blank">bvanbens@gmail.com</a>><br>
<b>Date: </b>Wednesday, August 16, 2017 at 16:54<br>
<b>To: </b>Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com" target="_blank">stephen.welsh@unifiedfx.com</a>><br>
<b>Cc: </b>"<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>" <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
<b>Subject: </b>Re: [cisco-voip] Does anyone know if there is a CLI SQL command to determine the CUCM server ID (GUID type value)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Thanks !<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">The "first" PKID in this case didn't match the publisher. But I think I know why in this case.<u></u><u></u></p>
</div>
<p class="MsoNormal">This customer was forced to rebuild and restore a few of the CUCM nodes including the publisher.
<u></u><u></u></p>
</div>
<p class="MsoNormal">I'm guessing this might change the order of the PKIDs we're searching for.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Your Query<br>
admin:<span style="color:blue">run sql select first 1 pkid from processnode where systemnode='f' order by rowid</span><br>
pkid <wbr> <br>
==============================<wbr>====== <br>
42a06662-6152-fe3f-634f-<wbr>027fe4351e2a <b><= not the publisher, actually a 2nd CUCM subscriber</b><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">My hack at modifying it.....<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">admin:<span style="color:#a64d79">run sql select pkid from processnode where systemnode='f' order by rowid</span><br>
pkid <wbr> <br>
==============================<wbr>====== <br>
42a06662-6152-fe3f-634f-<wbr>027fe4351e2a - CUCM sub 2<br>
6511274e-ef86-5d23-7816-<wbr>ae2828ce760a - CUCM sub 1 <br>
b632ddbe-ab5a-4df4-957c-<wbr>c0a3e4d04a2f <b><= this is my publisher, verified from the browser URL value</b><br>
e017e6b7-8b60-2e9b-1a71-<wbr>e10f88652204 - IMP 1<br>
f5957263-d806-ea5f-83b9-<wbr>c2ea670310a3 - IMP2<br>
admin:<u></u><u></u></p>
</div>
<p class="MsoNormal">Is there another way to query to ask for the publisher node specifically? or another way of ensuring its the publisher that gets returned ?<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
I also tested this on a lab cluster that was never restored and your original query does match up with the publisher ID.<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, Aug 16, 2017 at 3:41 PM, Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com" target="_blank">stephen.welsh@unifiedfx.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Try this out from the platform CLI:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">run sql select first 1 pkid from processnode where systemnode='f' order by rowid<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Kind Regards<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Stephen Welsh<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">CTO<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">UnifiedFX<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On 16 Aug 2017, at 21:37, Brian V <<a href="mailto:bvanbens@gmail.com" target="_blank">bvanbens@gmail.com</a>> wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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:)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><image.png><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/<wbr>mailman/listinfo/cisco-voip</a><u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</blockquote></div><br></div>