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

[Lelio Fulgenzi]

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) 


----- Original Message -----
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 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120416/5ef59bbc/attachment.html>