CUCM CLI output formatting to Excel

CUCM CLI contains various useful commands.

show risdb query phone

Is able to show phone registration information with an query followed a number of information:

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

Show phone and number:

admin:show risdb query phoneextn

----------- Phone Extension Information -----------

#extensions, #registered, #unregistered, #rejected, StateId

4, 0, 0, 0, 44

ExtnTblSeq#, PhoneTblSeq#, Name, IPAddr, Extn, Multi, LineStatus

1, 1, SEP02004C4F4F50, 142.100.64.100, 2001, 1, Reg

2, 2, SEP00AAAAAAAA01, 142.100.64.111, 2002, 1, Reg

3, 2, SEP00AAAAAAAA01, 142.100.64.111, 2000, 1, Reg

4, 3, SEPBBBBBBBBBBBB, 142.100.64.111, 2014, 1, Reg

----------------

Total count 4

----------------

Save the main data portion.

formating:

Formatted