I think Kenneth will get mad at me for not making this public sooner, but I was searching through my archives to find some other script that I'd shared (at some earlier point) and came across THIS request, for which I happen to already have some awesomeness whipped up.<br>
<br>enjoy,<br><br>###show me all the service parameter crap that isnt set to the default<br><br>run sql \<br>SELECT PN.name AS CM_Name, TS.name AS Service_Name, PC.paramname AS Parameter, PC.paramvalue AS Cur_Value, PCD.paramvalue AS Default_Value from processconfig PC \<br>
JOIN processconfigdefaults PCD ON PCD.paramname LIKE PC.paramname \<br>JOIN processnode PN ON PN.pkid = PC.fkprocessnode \<br>JOIN typeservice TS ON TS.enum = PC.tkservice \<br>WHERE PCD.paramvalue != PC.paramvalue \<br>ORDER BY PN.name, PC.paramname<br>
<br>add in an "AND TS.enum = whatever" if you only want to see the changed parameters <br><br><br>example:<br><br><br>admin:run sql \<br>SELECT PN.name AS CM_Name, TS.name AS Service_Name, PC.paramname AS Parameter, PC.paramvalue AS Cur_Value, PCD.paramvalue AS Default_Value from processconfig PC \<br>
JOIN processconfigdefaults PCD ON PCD.paramname LIKE PC.paramname \<br>JOIN processnode PN ON PN.pkid = PC.fkprocessnode \<br>JOIN typeservice TS ON TS.enum = PC.tkservice \<br>WHERE PCD.paramvalue != PC.paramvalue \<br>ORDER BY PN.name, PC.paramname<br>
cm_name service_name parameter cur_value default_value <br>============== ================= =============================== ========= ============= <br>192.168.1.10 Cisco CallManager CdrEnabled T F <br>
192.168.1.10 Cisco CallManager CdrLogCallsWithZeroDurationFlag T F <br>192.168.1.10 Cisco CTIManager SdlTraceTotalNumFiles 250 375 <br>192.168.1.100 Cisco CallManager CdrEnabled T F <br>
192.168.1.100 Cisco CallManager SdlTraceTotalNumFiles 375 250 <br>192.168.1.100 Cisco CTIManager SdlTraceTotalNumFiles 250 375 <br>192.168.1.11 Cisco CallManager CdrEnabled T F <br>
192.168.1.11 Cisco CallManager CdrLogCallsWithZeroDurationFlag T F <br>192.168.1.11 Cisco CallManager SdlTraceTotalNumFiles 375 250 <br>192.168.1.11 Cisco CTIManager SdlTraceTotalNumFiles 250 375 <br>
<br><br><br>enjoy,<br> Peter Slow =)<br><br><br><br><br><br><div class="gmail_quote">On Thu, Feb 16, 2012 at 3:37 PM, Lelio Fulgenzi <span dir="ltr"><<a href="mailto:lelio@uoguelph.ca">lelio@uoguelph.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:10pt;font-family:Verdana">Thanks Wes!<div class="im"><span><br><br><span name="x"></span>---<br>
Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
Cooking with unix is easy. You just sed it and forget it. <br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr></div><b>From: </b>"Wes Sisk" <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>><br>
<b>To: </b>"Lelio Fulgenzi" <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>><br><b>Cc: </b>"cisco-voip voyp list" <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
<b>Sent: </b>Thursday, February 16, 2012 2:34:17 PM<br><b>Subject: </b>Re: [cisco-voip] SQL query to dump enterprise/system parameters<div><div class="h5"><br><br>run sql select * from processconfig<div>run sql select * from processconfigdefaults</div>
<div><br></div><div>/wes</div><div><br><div><div>On Feb 16, 2012, at 11:07 AM, Lelio Fulgenzi wrote:</div><br><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div>
<div style="font-size:10pt;font-family:Verdana"><br>Is there an SQL query that I can run on the CLI to give me a fairly easily readable output of what the current enterprise and/or system parameters are?<span> </span><br>
<br>I still haven't figured out a way to print or take a visual snapshot to compare after work.<br><br>Lelio<br><br><span><br><span></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it.<span> </span><br> - LFJ (with apologies to Mr. Popeil)<br>
<span></span><br></span><br></div>_______________________________________________<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/mailman/listinfo/cisco-voip</a><br>
</div></span></div><br></div></div></div></div></div><br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br>