[cisco-voip] SQL query to dump enterprise/system parameters
Lelio Fulgenzi
lelio at uoguelph.ca
Mon Apr 16 13:33:43 EDT 2012
cool. thanks. i'll check that one out too.
---
Lelio Fulgenzi, B.A.
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Cooking with unix is easy. You just sed it and forget it.
- LFJ (with apologies to Mr. Popeil)
----- Original Message -----
From: "Erick B." <erickbee at gmail.com>
To: "Lelio Fulgenzi" <lelio at uoguelph.ca>
Cc: "Peter Slow" <peter.slow at gmail.com>, "cisco-voip voyp list" <cisco-voip at puck.nether.net>
Sent: Monday, April 16, 2012 12:35:32 PM
Subject: Re: [cisco-voip] SQL query to dump enterprise/system parameters
Screenpresso free version does that to.
On Mon, Apr 16, 2012 at 11:05 AM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:
> neat. very neat. to follow up on my original request (can't remember if i
> did), i found this simple tool which, for now, easily allows you to select a
> window to automatically scroll and print to printer or PDF.
>
> http://www.faststone.org/FSCaptureDetail.htm
>
> 20 bucks. Not very expensive at all.
>
>
>
>
> ---
> Lelio Fulgenzi, B.A.
> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Cooking with unix is easy. You just sed it and forget it.
> - LFJ (with apologies to Mr. Popeil)
>
>
> ________________________________
> From: "Peter Slow" <peter.slow at gmail.com>
> To: "Lelio Fulgenzi" <lelio at uoguelph.ca>
> Cc: "Wes Sisk" <wsisk at cisco.com>, "cisco-voip voyp list"
> <cisco-voip at puck.nether.net>
> Sent: Wednesday, April 11, 2012 10:18:38 AM
>
> Subject: Re: [cisco-voip] SQL query to dump enterprise/system parameters
>
> 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.
>
> enjoy,
>
> ###show me all the service parameter crap that isnt set to the default
>
> run sql \
> 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 \
> JOIN processconfigdefaults PCD ON PCD.paramname LIKE PC.paramname \
> JOIN processnode PN ON PN.pkid = PC.fkprocessnode \
> JOIN typeservice TS ON TS.enum = PC.tkservice \
> WHERE PCD.paramvalue != PC.paramvalue \
> ORDER BY PN.name, PC.paramname
>
> add in an "AND TS.enum = whatever" if you only want to see the changed
> parameters
>
>
> example:
>
>
> admin:run sql \
> 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 \
> JOIN processconfigdefaults PCD ON PCD.paramname LIKE PC.paramname \
> JOIN processnode PN ON PN.pkid = PC.fkprocessnode \
> JOIN typeservice TS ON TS.enum = PC.tkservice \
> WHERE PCD.paramvalue != PC.paramvalue \
> ORDER BY PN.name, PC.paramname
> cm_name service_name parameter cur_value
> default_value
> ============== ================= =============================== =========
> =============
> 192.168.1.10 Cisco CallManager CdrEnabled T
> F
> 192.168.1.10 Cisco CallManager CdrLogCallsWithZeroDurationFlag T
> F
> 192.168.1.10 Cisco CTIManager SdlTraceTotalNumFiles 250
> 375
> 192.168.1.100 Cisco CallManager CdrEnabled T
> F
> 192.168.1.100 Cisco CallManager SdlTraceTotalNumFiles 375
> 250
> 192.168.1.100 Cisco CTIManager SdlTraceTotalNumFiles 250
> 375
> 192.168.1.11 Cisco CallManager CdrEnabled T
> F
> 192.168.1.11 Cisco CallManager CdrLogCallsWithZeroDurationFlag T
> F
> 192.168.1.11 Cisco CallManager SdlTraceTotalNumFiles 375
> 250
> 192.168.1.11 Cisco CTIManager SdlTraceTotalNumFiles 250
> 375
>
>
>
> enjoy,
> Peter Slow =)
>
>
>
>
>
> On Thu, Feb 16, 2012 at 3:37 PM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:
>>
>> Thanks Wes!
>>
>>
>> ---
>> Lelio Fulgenzi, B.A.
>> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
>> (519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)
>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> Cooking with unix is easy. You just sed it and forget it.
>> - LFJ (with apologies to Mr. Popeil)
>>
>>
>> ________________________________
>> From: "Wes Sisk" <wsisk at cisco.com>
>> To: "Lelio Fulgenzi" <lelio at uoguelph.ca>
>> Cc: "cisco-voip voyp list" <cisco-voip at puck.nether.net>
>> Sent: Thursday, February 16, 2012 2:34:17 PM
>> Subject: Re: [cisco-voip] SQL query to dump enterprise/system parameters
>>
>>
>> run sql select * from processconfig
>> run sql select * from processconfigdefaults
>>
>> /wes
>>
>> On Feb 16, 2012, at 11:07 AM, Lelio Fulgenzi wrote:
>>
>>
>> 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?
>>
>> I still haven't figured out a way to print or take a visual snapshot to
>> compare after work.
>>
>> Lelio
>>
>>
>> ---
>> Lelio Fulgenzi, B.A.
>> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
>> (519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)
>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> Cooking with unix is easy. You just sed it and forget it.
>> - LFJ (with apologies to Mr. Popeil)
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120416/102d26a8/attachment.html>
More information about the cisco-voip
mailing list