[cisco-voip] SQL query to dump enterprise/system parameters

[Peter Slow]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120411/a29cd26a/attachment.html>