Wednesday, September 24, 2014

How to navigate around the CUCM Database using run sql, show tech systables and more tips

Hi Guys

so you may already know about the run sql command, but when it comes to finding what you need... sometimes it's tricky to  work out the structure of the table, or even what table you might want to look at.

Here is how to see a list of tables:


admin:show tech systables
------------------------Show tech system tables-----------------------


SYSTEM TABLES
tabnameapplicationusercapfmapdynamic
applicationuserdevicemap
applicationuserdirgroupmap
applicationusernumplanmap
appserver
appserverapplicationusermap



Here is how to see all the entries for that table:

admin:show tech table srst
------------------------ Show tech table -------------------


 Table
Output is in /cm/trace/dbl/srst_table1411574818655.out
Use "file view activelog /cm/trace/dbl/srst_table1411574818655.out" command to see output







admin:file view activelog /cm/trace/dbl/srst_table1411574818655.out
2014-09-24 12:07:21,271 INFO  [ClassExecutionThread] cli.CliSettings - VMware = false

pkid                                 name                ipaddr1       port1 ipaddr2 port2 ipaddr3 port3 usermodifiable tksrstoption certificate issecure certificateproviderport sipipaddr1 sipipaddr2 sipipaddr3 sipport1 sipport2 sipport3 resettoggle tkreset
==================================== =================== ============= ===== ======= ===== ======= ===== ============== ============ =========== ======== ======================= ========== ========== ========== ======== ======== ======== =========== =======
c80cafe0-af65-43d6-a1f1-435ad998bd26 Use Default Gateway               2000          2000          2000  f              2                        f        2445                                                     5060     5060     5060     f           2



So now I know what the columns are, I can run sql queries:


admin:run sql select pkid, ipaddr1, name from SRST
pkid                                 ipaddr1       name
==================================== ============= ===================
c80cafe0-af65-43d6-a1f1-435ad998bd26               Use Default Gateway
cd241e11-4a58-4d3d-9661-f06c912a18a3               Disable
3bc40e86-e06f-4e4a-9679-a6ef5d7f6d05 192.168.36.1 MIKE_SRST
65cd53b4-3c1a-413f-acc9-c92f0eff9a52 192.168.44.5  DAVE_SRST
f5ad268e-7a37-8d6e-9783-f415ca3c9629 10.1.1.5 PETE SRST




Full shout out to ucguerrilla for this (How to get a list of fast dials and speed dials using SQL)

Hi Guys!

First of all full props to ucguerrilla for what i am about to post, His website: http://www.ucguerrilla.com

Is AWESOME for UC Engineers and has some great great stuff


Anyway he has two entries about extracting fast dials and speed dials from CUCM using sql queries that I found very useful, here is the sql query to extract fast dials:


select uid.userid,  fd.personalfastdialindex, fd.phonenumber as fastdialdest,        pab.firstname as AddressBookFirstName, pab.lastname as AddressBookLastName from personalphonebook as fd inner join enduser as uid on fd.fkenduser=uid.pkid      inner join typepersonalphonenumber as tppn on fd.tkpersonalphonenumber=tppn.enum      left outer join personaladdressbook as pab on fd.fkpersonaladdressbook=pab.pkid order by uid.userid, fd.personalfastdialindex

Here is his relevant blog posts:

http://www.ucguerrilla.com/2012/05/querying-fast-dials-using-sql-queries.html

 

Tuesday, September 9, 2014

vSwitch Updates

vSwitch Updates:

vMotion support for networks with less than 100ms RTT, vMotion between "Data Centers" (not literal data centers, just the VMWare construct called "Data center") and "officially" supporting vMotion over routed networks (which has been happening for a while but was never officially supported.)