<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>cool. thanks. i'll check that one out too.<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 id="zwchr"><b>From: </b>"Erick B." <erickbee@gmail.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>"Peter Slow" <peter.slow@gmail.com>, "cisco-voip voyp list" <cisco-voip@puck.nether.net><br><b>Sent: </b>Monday, April 16, 2012 12:35:32 PM<br><b>Subject: </b>Re: [cisco-voip] SQL query to dump enterprise/system parameters<br><br>Screenpresso free version does that to.<br><br>On Mon, Apr 16, 2012 at 11:05 AM, Lelio Fulgenzi <lelio@uoguelph.ca> wrote:<br>> neat. very neat. to follow up on my original request (can't remember if i<br>> did), i found this simple tool which, for now, easily allows you to select a<br>> window to automatically scroll and print to printer or PDF.<br>><br>> http://www.faststone.org/FSCaptureDetail.htm<br>><br>> 20 bucks. Not very expensive at all.<br>><br>><br>><br>><br>> ---<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>><br>><br>> ________________________________<br>> From: "Peter Slow" <peter.slow@gmail.com><br>> To: "Lelio Fulgenzi" <lelio@uoguelph.ca><br>> Cc: "Wes Sisk" <wsisk@cisco.com>, "cisco-voip voyp list"<br>> <cisco-voip@puck.nether.net><br>> Sent: Wednesday, April 11, 2012 10:18:38 AM<br>><br>> Subject: Re: [cisco-voip] SQL query to dump enterprise/system parameters<br>><br>> I think Kenneth will get mad at me for not making this public sooner, but I<br>> was searching through my archives to find some other script that I'd shared<br>> (at some earlier point) and came across THIS request, for which I happen to<br>> 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<br>> Parameter, PC.paramvalue AS Cur_Value, PCD.paramvalue AS Default_Value from<br>> 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<br>> 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<br>> Parameter, PC.paramvalue AS Cur_Value, PCD.paramvalue AS Default_Value from<br>> 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<br>> default_value<br>> ============== ================= =============================== =========<br>> =============<br>> 192.168.1.10 Cisco CallManager CdrEnabled T<br>> F<br>> 192.168.1.10 Cisco CallManager CdrLogCallsWithZeroDurationFlag T<br>> F<br>> 192.168.1.10 Cisco CTIManager SdlTraceTotalNumFiles 250<br>> 375<br>> 192.168.1.100 Cisco CallManager CdrEnabled T<br>> F<br>> 192.168.1.100 Cisco CallManager SdlTraceTotalNumFiles 375<br>> 250<br>> 192.168.1.100 Cisco CTIManager SdlTraceTotalNumFiles 250<br>> 375<br>> 192.168.1.11 Cisco CallManager CdrEnabled T<br>> F<br>> 192.168.1.11 Cisco CallManager CdrLogCallsWithZeroDurationFlag T<br>> F<br>> 192.168.1.11 Cisco CallManager SdlTraceTotalNumFiles 375<br>> 250<br>> 192.168.1.11 Cisco CTIManager SdlTraceTotalNumFiles 250<br>> 375<br>><br>><br>><br>> enjoy,<br>> Peter Slow =)<br>><br>><br>><br>><br>><br>> On Thu, Feb 16, 2012 at 3:37 PM, Lelio Fulgenzi <lelio@uoguelph.ca> wrote:<br>>><br>>> Thanks Wes!<br>>><br>>><br>>> ---<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>>><br>>><br>>> ________________________________<br>>> From: "Wes Sisk" <wsisk@cisco.com><br>>> To: "Lelio Fulgenzi" <lelio@uoguelph.ca><br>>> Cc: "cisco-voip voyp list" <cisco-voip@puck.nether.net><br>>> Sent: Thursday, February 16, 2012 2:34:17 PM<br>>> Subject: Re: [cisco-voip] SQL query to dump enterprise/system parameters<br>>><br>>><br>>> run sql select * from processconfig<br>>> run sql select * from processconfigdefaults<br>>><br>>> /wes<br>>><br>>> On Feb 16, 2012, at 11:07 AM, Lelio Fulgenzi wrote:<br>>><br>>><br>>> Is there an SQL query that I can run on the CLI to give me a fairly easily<br>>> readable output of what the current enterprise and/or system parameters<br>>> are?<br>>><br>>> I still haven't figured out a way to print or take a visual snapshot to<br>>> compare after work.<br>>><br>>> Lelio<br>>><br>>><br>>> ---<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>>><br>>><br>>> _______________________________________________<br>>> cisco-voip mailing list<br>>> cisco-voip@puck.nether.net<br>>> https://puck.nether.net/mailman/listinfo/cisco-voip<br>>><br>>><br>>> _______________________________________________<br>>> cisco-voip mailing list<br>>> cisco-voip@puck.nether.net<br>>> https://puck.nether.net/mailman/listinfo/cisco-voip<br>>><br>><br>><br>> _______________________________________________<br>> cisco-voip mailing list<br>> cisco-voip@puck.nether.net<br>> https://puck.nether.net/mailman/listinfo/cisco-voip<br>><br></div></body></html>