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
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
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.)
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.)
Subscribe to:
Posts (Atom)
Popular old posts.
-
Hi Guys Having spent a lot of time with customers working on vPC deployments, I have found quite a few of the gotcha's for vPC that I w...
-
Hi Guys! This blog post is attempting to be the DEFINITIVE guide on Jumbo MTU, It's a topic that DOES MY HEAD IN! There are SO many ...
-
So some of the readers of this blog might already know this little trick, and what's more some of you might be surprised I didn't kn...