cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3021
Views
0
Helpful
1
Replies

Show risdb query phone - Command Output Issues in CUCM CLI

Matthew Martin
Level 5
Level 5

Hello All,

 

CUCM: 10.5.2.13900-12

I seem to be having an issue when running the command "show risdb query phone".

After I run this command I should be seeing about 250+ devices getting printed out. However, at seemingly random points in the output it will just stop and jump to the "admin:" command prompt without finishing printing the output fully. For example, this most recent attempt printed about 80 devices, and half way through the 80th line, it just stops and prints the cmd prompt right in the middle of that line, see below:

admin:show risdb query phone
----------- Phone Information -----------

#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
258, 256, 250, 6, 2, 0, 0, 10596,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 
SEP68EFBDB37C41, 2838 - Wireless (U), 10.51.2.43, , 0, 0, 68EFBDB37C41, reg, SCCP, 484, yes, 1, 371, NoUserId, 1, 1554908473, 1, CP7925G-1.4.7.3, , , , , 0, , 1554908473, 2
SEP00260B5DDE80, 2352 - John DOe (U), 10.10.124.153, , 3, 0, 00260B5DDE80, reg, SCCP, 115, yes, 0, 115, NoUserId, 291, 1552343659, 1, SCCP41.9-4-2SR1-1S, SCCP41.9-4-2SR1-1S, , , , 0, , 1552343659, 2
SEPAC44F21169BB, 2098 - Conference Room (C), 10.10.124.180, , 0, 0, AC44F21169BB, reg, SIP, 659, yes, 1, 544, NoUserId, 3, 1554904913, 1, sip8831.9-3-3-TO-10-3-1-v2, sip8831.9-3-3-TO-10-3-1-v2, , , , 0, , 1554904913, 2
SEPAC44F2116FDE, 2625 - Conference Room 2 (C), 10.10.124.18, , 0, 0, AC44F2116FDE, reg, SIP, 659, yes, 0, 544, NoUserId, 4, 1546532576, 1, sip8831.9-3-3-TO-10-3-1-v2, sip8831.10-3-1SR4b-1-NA, , , , 0, , 1546532576, 2
SEPAC44F2116B0B, 2626 - Boardroom Conference Phone (C), 10.10.124.150, , 0, 0, AC44F2116B0B, reg, SIP, 659, yes, 0, 544, NoUserId, 5, 1549252995, 1, sip8831.9-3-3-TO-10-3-1-v2, sip8831.9-3-3-TO-10-3-1-v2, , , , 0, , 1549252995, 2
SEPAC44F2117271, 2627 - Conference Room Phone (C), 10.10.124.197, , 0, 0, AC44F2117271, reg, SIP, 659, yes, 0, 544, NoUserId, 6, 1553810004, 1, sip8831.9-3-3-TO-10-3-1-v2, sip8831.9-3-3-TO-10-3-1-v2, , , , 0, , 1553810004, 2
.................
.......cut...........
.................
SEP001FCAE8763E, 2125 - Mike, 10.10.124.166, , 3, 0, 001FCAE8763E, reg, SCCP, 115, yes, 0, 115, NoUserId, 105, 1549253654, 1, SCCP41.9-4-2SR1-1S, SCCP41.9-4-2SR1-1S, , , , 0, , 1549253654, 2
SEP3037A616294F, 2041 - John, 10.8.2.14, , 3, 0, 3037A616294F, reg, SCCP, 115, yes, 0, 115, NoUserId, 106, 1553880581, 1, SCCP41.9-4-2SR1-1S, SCCP41.9-4-2SR1-1S, , , , 0, , 1553880581, 2
SEP001AA1B48B8A, 2136 - Heather (A), 10.10.124.66, , 3, 0, 001AA1B48B8A, reg, SCCP, 115, yes, 0, 115, NoUserId, 107, 1553742257, 1, SCCP41.9-4-2SR1-1S, SCCP41.9-4-2SR1-1S, , , , 0, , 1553742257, 2
SEP3037A6162EAC, 2351 - Reggie (A), 10.10.124.151, , 3, 0, 3037A6162EAC, reg, SCCP, 115, yes, 0, 115, NoUserId, 108, 1553014146, 1, SCCP41.9-4-2SR1-1S, SCCP41.9-4-2SR1-1S, , , , 0, , 1553014146, 2
SEP001FCAE87B9A, 2357 - Sue (U), 10.10.124.186, , 3, 0, 001FCAE87B9A, reg, SCCP, 115, yes, 0, 115admin:

Any idea why this would be doing this? It appears to end on a different line whenever the command is run. The above example, which I just ran, printed out about 105 devices, when I should be seeing 258 according to the #TotalPhones column at the start of the output.

I tried a few different terminals, like Putty, linux gnome-terminal, etc... and I get the same results in each.

 

UPDATE: If I run "show risdb query phone file phoneTable", and I then view that file, it does contain all the info. However, I need the output in stdout after the command is run.

Thanks in Advance,

Matt

1 Reply 1

Marcos Eusebio
Level 1
Level 1

Hi Matthew,

How many nodes are in your CUCM cluster? You need to run the command on each node.