Cisco UCM – How to export data from RTMT

Posted: 2014-07-27 in Cisco, UCM

Intro

RTMT is useful tool in Cisco Unified Communications Manager which used to check different information about the health status of the system. It is dependent on the RisDB, Tomcat, DblMon, A Cisco DB services. Many customers want to export data from RTMT to pdf or excel format and even enhancement request was added for this (CSCsx07193).

In the short manual below I try to give possible workaround for the task above.

Main

RTMT is retrieving the information with RisDB service, so we can use commands under CLI like
admin:show risdb list
misc
phone
phoneextn
cmnode
cmgroup
cmgroupmember
region
regionmatrix
timezone
devicepool
cti
ctiextn
h323
gateway
mediaresource
uone
uoneextn
huntlist
ctimprovider
ctimlist
ctimline
sip
phonefailed
phonestatsupd
cmproduct
cmmodel
cefqrtrequest
cmalarm
cefalarm
genalarm

Really common task is to retrieve information about all phone loads. We have found it under RTMT. Device search -> Phone

rtmt_exp_data_RtmtView

To check the same information under CLI – IP phones registered, active and inactive firmware:

admin:show risdb query phone
———– Phone Information ———–

#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
4, 3, 1, 2, 0, 1, 0, 49,0

DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp, Perfmon Object
SEP6C416A369375, t7841, 10.147.94.124, , 0, 0, 6C416A369375, reg, SIP, 622, yes, 0, 509, malevich, 1, 1404913142, 1, sip78xx.10-1-1SR1-4, sip78xx.10-1-1SR1-4, sip78xx.10-1-1-9, , , 0, , 1404913142, 2
SEP0018B9A0442B, c7941, 10.147.94.204, , 3, 0, 0018B9A0442B, reg, SCCP, 115, yes, 0, 115, allevich, 2, 1404913140, 1, SCCP41.9-3-1SR4-1S, SCCP41.9-3-1SR4-1S, , , , 0, , 1404913140, 2
SEPD0C7891413BC, dx650, 10.147.94.182, , 0, 0, D0C7891413BC, reg, SIP, 647, yes, 0, 532, kalevich, 4, 1404913141, 1, sipdx650.10-1-2-33, sipdx650.10-1-2-33, sipdx650.10-0-2-32, , , 0, , 1404913141, 2
SEP8CB64FF7E2EE, , 10.147.94.133, , 3, 0, 8CB64FF7E2EE, rej, SCCP, 436, yes, 0, 335, NoUserId, 7, 1405069589, 1, , , , , , 0, , 1405069635, 0

—————-
Total count 4
—————-

If customer wants to export the information to the Excel file – just copy/paste the output of the show risdb query phone to the text editor and saved the file as csv (comma separated values), for example with name report.csv

Then just open the file with Excel and you will have a report.

rtmt_exp_data_ExcelView

One difference between RTMT output and CLI command is the device model column: RTMT contains user-friendly presentation of the phone model (e.g. Cisco 7841) and from the CLI you will have corresponding enum value (e.g. 622 for Cisco IP Phone 7841). To see the table of enum values for phone types you can use CLI command below.
run sql SELECT * from TypeModel

If you will try to run the command show risdb query phone on the non-call processing node you will receive error like: openMMF on PhoneTable failed

 

Appendix

Also to export major information about endpoints and services in table format the following commands could be used.

admin:show risdb query phoneextn
———– Phone Extension Information ———–

#extensions, #registered, #unregistered, #rejected, StateId, #ExpUnreg
5, 0, 0, 0, 25, 0

ExtnTblSeq#, PhoneTblSeq#, Name, IPAddr, Extn, Multi, LineStatus
1, 1, SEP6C416A369375, 10.147.94.124, 2024, 1, Reg
2, 2, SEP0018B9A0442B, 10.147.94.204, 2021, 1, Reg
3, 2, SEP0018B9A0442B, 10.147.94.204, 2041, 1, Reg
4, 4, SEPD0C7891413BC, 10.147.94.182, 2022, 1, Reg
5, 4, SEPD0C7891413BC, 10.147.94.182, 2042, 1, Reg
—————-
Total count 5
—————-

admin:show risdb query ctimprovider
———– CTIManager Provider Information ———–

Number of CTIMProviderElement entries: 4

CTIconnectionId, ReasonCode, LoginUserId, IpString, Ipv6String, ProviderName, AppId, time, status, LastActTimeStamp
1, 0, CCMQRTSysUser, 10.48.47.131, , , CCMQRTSysUser-10.48.47.131-44256, Fri Jun 20 11:25:45 2014, Opened, 1403256345
2, 0, UCCX_CTI_1, 10.48.47.135, , , UCCX_CTI_1-10.48.47.135-39606, Fri Jun 20 11:25:49 2014, Opened, 1403256349
3, 0, UCCX_RMCM, 10.48.47.135, , , UCCX_RMCM-10.48.47.135-39607, Fri Jun 20 11:25:49 2014, Opened, 1403256349
7, 0, WDSysUser, 127.0.0.1, , , WDSysUser-127.0.0.1-56211, Tue Jul 1 15:40:06 2014, Opened, 1404222006

—————-
Total count 4
—————-

admin:show risdb query ctimlist
———– CTIManager Device Information ———–

Number of CTIMDeviceElement entries: 21

CTIconnectionId, ReasonCode, DeviceName, RtpString, AssociatedCMIpAddrString, IsMediaControlled, time, status, LastActTimeStamp, IpAddress
2, 0, CtrPr_4019, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4018, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4017, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4016, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4015, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4014, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4013, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4012, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, trgg4005, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, CtrPr_4011, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, trgg4001, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
2, 0, trgg4000, , , false, Fri Jun 20 11:25:49 2014, Opened, 1403256349,
4, 0, SEP0018B9A0442B, , , false, Fri Jun 20 16:00:46 2014, Opened, 1403272846,
5, 0, SEP0018B9A0442B, , , false, Tue Jul 1 13:24:26 2014, Opened, 1404213866,
5, 0, CSFallevich, , , false, Tue Jul 1 13:24:26 2014, Opened, 1404213866,
6, 0, SEP0018B9A0442B, , , false, Tue Jul 1 13:50:35 2014, Opened, 1404215435,
6, 0, CSFallevich, , , false, Tue Jul 1 13:50:35 2014, Opened, 1404215435,
6, 0, SEPD0C7891413BC, , , false, Tue Jul 1 13:50:34 2014, Opened, 1404215434,
6, 0, CSFkalevich, , , false, Tue Jul 1 13:50:34 2014, Opened, 1404215434,
7, 0, SEPD0C7891413BC, , , false, Wed Jul 2 08:02:28 2014, Opened, 1404280948,
7, 0, CSFkalevich, , , false, Wed Jul 2 08:02:28 2014, Opened, 1404280948,

—————-
Total count 21
—————-

admin:show risdb query h323
———– H323 Extension Information ———–

Number of H323 entries: 3

Table StateId: 3

Seq#, H323 Name, product id, Description, IP Address, Reg Status, LastRegTimeStamp, RegStatusChgTimeStamp, LastActTimeStamp, ModelType, ConfigGK, TechPrefix, Zone, ActiveGK, CallSignal, RasAddr, RemoteCM1, RemoteCM2, RemoteCM3, AltGK1, AltGK2, AltGK3, AltGK4, AltGK5, methods, ConfigGKIP, ConfigGKIP Type, ActiveGKIP, ActiveGKIP Type
1, ucm2-1_h323_tcp, 77, 10.48.47.141, 10.48.47.131, N/A, 0, 0, 0, H323 Trunk, , , , , , , 10.48.47.141, , , , , , , , snmp methods, 0, 0
2, 10.147.25.101, 17, ephony h.323 2017, 10.147.25.101, N/A, 0, 0, 0, H323Gateway, , , , , , , , , , , , , , , snmp methods, 0, 0
3, 10.62.84.250, 17, h323gw-2 10.62.84.250, 10.62.84.250, N/A, 0, 0, 0, H323Gateway, , , , , , , , , , , , , , , snmp methods, 0, 0

—————-
Total count 3
—————-

admin:show risdb query sip
———– SIP Information ———–

Number of SIP entries: 5

SIP Name, IPorDNS, Ipv6Addr, Description, DeviceType, ProductId, InPortNumber, OutPortNumber, InTransportType, OutTransportType, Status
astr0_sip_udp, 10.48.47.131, , 10.147.25.144, 131, 95, 5060, 5060, 4, 2, 1
cuc1-1_sip_tcp, 10.48.47.131, , 10.48.47.133, 131, 0, 5060, 5060, 4, 1, 1
imp1-1_sip_tcp, 10.48.47.131, , 10.48.47.134, 131, 95, 5060, 5060, 4, 1, 1
sipgw-1, 10.48.47.131, , 10.62.84.239, 131, 95, 5060, 5060, 4, 2, 1
ucm2-1SipTcp, 10.48.47.131, , 10.48.47.141, 131, 0, 5060, 5060, 4, 1, 1

—————-
Total count 5
—————-

admin:show risdb query gateway
———– Gateway Information ———–

Number of Gateway entries: 0

#registered, #unregistered, #rejected, StateId, #ExpUnreg
0, 0, 0, 2, 0

Seq#, Gateway Name, IPAddress, IPv6Address, Desription, DChannel #, DChannel Status, Perf Object, Reg Status, Model Type, Http Support, #Reg Attempts, Prod Id, Box Prod Id, RegStatChg TimeStamp

—————-
Total count 0
—————-

admin:show risdb query mediaresource
———– Media Resource Information ———–

Number of MediaResource entries 5

Seq#, MediaResource Name, IP Address, Ipv6Addr, Description, Reg Status, Model Type, Http Support, #reg attempts,Product Type, RegChg TimeStamp
1, HW-CFB-239, 10.62.84.239, , Description: 10.62.84.239, Registration status: reg, UNKNOWN: model number == 52, no, 1, 101, 1405328696
2, CFB_2, 10.48.47.131, , Description: CFB_ucm1-1, Registration status: reg, ConferenceBridge, no, 0, 28, 1403504370
3, MOH_2, 10.48.47.131, ::, Description: MOH_ucm1-1, Registration status: reg, MusicOnHold, no, 0, 51, 1404894027
4, MTP_2, 10.48.47.131, ::, Description: MTP_ucm1-1, Registration status: reg, MediaTerminationPoint, no, 0, 30, 1403504370
5, ANN_2, 10.48.47.131, , Description: ANN_ucm1-1, Registration status: reg, UNKNOWN: model number == 126, no, 0, 89, 1403504370

—————-
Total count 5
—————-

Advertisements
Comments
  1. Shyamal says:

    This is an excellent piece of information.Is there a cisco document which tells the table structure in CUCM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s