TO enable GUI IN CME Router.

Enabling the HTTP Server
To enable the HTTP server, and specify the path to files for the GUI and a method of user authentication for security, perform the following steps. The HTTP server on a router is disabled by default.

SUMMARY STEPS
1. enable

2. configure terminal

3. ip http server

4. ip http path flash:

5. ip http authentication {aaa | enable | local | tacacs}

6. exit
============================
 ip http server
 ip http authentication aaa
 ip http path flash:gui
===============================

Enabling GUI Access for the System Administrator
To define an initial username and password for a system administrator to access the GUI and enable the GUI to be used to set the time and to add directory listings, perform the following steps.

SUMMARY STEPS
1. enable

2. configure terminal

3. telephony-service

4. web admin system name username {password string | secret {0 | 5} string}

5. dn-webedit

6. time-webedit

7. end

==================================================
telephony-service
 web admin system name maruthi password Maruthi@123
 dn-webedit
 time-webedit
====================================================

CDR Report from CUCM CLI (ISD,STD and Local)

1 By using SQL query we would be able to generate CDR details from CUCM CLI

Here is the query for international calls
Partition= here you should have to mention your international partition

eg : -
run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where finalCalledPartyNumberPartition='PT_Int' and datetimestamporigination between '2011-09-22 00:00:00' and '2011-09-23 23:59:59'


2 Here are the few more queries from CM 

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where datetimestamporigination between '2012-09-22 00:00:00' and '2012-09-23 00:00:00'


 3 This query will give you the details about call disconnection. run sql select 

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,origCause_value,originalCalledPartyNumber,destCause_value from car: tbl_billing_data where datetimestamporigination between '2012-09-23 17:20:00' and '2012-09-23 17:35:00'