Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

Search registered phones only in BAT

===finds out registered phones===

  1. From CLI of ALL cucm servers have  ccm service running: “show risdb query phone” (this command is server-based so output is different on different servers)

<Example:>

----------- Phone Information -----------

#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg

5, 2, 0, 2, 3, 0, 0, 170,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

SEP0018733A1DD6, jing1, 10.67.81.60, , 0, 0, 0018733A1DD6, reg, SIP, 119, yes, 7, 119, jihua, 1, 1411521952, 1, SIP70.9-3-1SR4-1S, SIP70.9-3-1SR4-1S, , , , 0, , 1411521952, 2

SEP1C17D340F22A, SEP1C17D340F22A, 10.67.81.61, , 0, 0, 1C17D340F22A, reg, SIP, 540, yes, 0, 427, jihua, 2, 1411319408, 1, sip8961.9-4-1-9, sip8961.9-4-1-9, sip8961.9-3-2-10, , , 0, , 1411319408, 2

CIPC, CIPC, 10.137.76.173, , 3, 0, , unr, SCCP, 30016, yes, 0, 30041, NoUserId, 3, 1411348181, 1, , CIPC-8-6-3-0, , , , 0, , 1411348181, 2

CIPCC, Auto 9010, 10.66.246.236, , 3, 0, , unr, SCCP, 30016, yes, 0, 30041, NoUserId, 4, 1411424392, 1, , CIPC-8-6-3-0, , , , 0, , 1411424392, 2

CSFCCOOPER, , 10.137.76.195, , 0, 0, F4B7E2F7A4C2, unr, SIP, 503, no, 1, 390, ccooper, 5, 1411522066, 1, , Jabber_for_Windows-9.7.0, Jabber_for_Windows-9.7.0, , , 0, , 1411522066, 2

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

Total count 5

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

  1. In output from step 1,  phone registered on this server will show ‘reg’ and unregistered phones will show ‘unr’

===BAT===

  1. Now we have list of MACs of registered phones and we make a BAT custom file like below:

+++++

MAC ADDRESS

SEP0018733A1DD6

SEP1C17D340F22A

+++++

  1. Upload custom file to BAT:a

 

  1. Search phones by using custom file uploaded:

 

 

Version history
Revision #:
1 of 1
Last update:
‎09-23-2014 07:18 PM
Updated by:
 
Labels (1)