[cisco-voip] [External] Re: Question about RISDB queries and ATA devices?
Hunter Fuller
hf0002 at uah.edu
Thu May 25 14:56:22 EDT 2023
For the programmers out there...
I'm not sure exactly how to do it if you have SKIGW-style names (it
may be possible, I have just never tried). But if you have an
ANA-style name, you can resolve it to a description or a dn using AXL.
Here is how to do it using axlrows (https://github.com/uah/axlrows):
for phone in get_phones(name="ANA5C5D4C4C8000"):
print(phone.description)
print(phone.lines[0][0].dirn.pattern)
BEV - Lobby ATM
5331
I want to say the registration state is all available via SNMP as well.
--
Hunter Fuller (they)
Router Jockey
VBH M-1C
+1 256 824 5331
Office of Information Technology
The University of Alabama in Huntsville
Network Engineering
On Thu, May 25, 2023 at 1:48 PM <nateccie at gmail.com> wrote:
>
> It was broken in newer SUs of 11.5 and 12.5. I’ve relied on this for 20 years, and then it just went away. Oh well to the cloud we go.
>
>
>
> From: Jason Aarons <scubajasona at gmail.com>
> Sent: Thursday, May 25, 2023 12:40 PM
> To: NateCCIE <nateccie at gmail.com>
> Cc: Ryan Ratliff (rratliff) <rratliff at cisco.com>; Tim Reimers <treimers at ashevillenc.gov>; Wes Sisk (wsisk) <wsisk at cisco.com>; cisco-voip <cisco-voip at puck.nether.net>
> Subject: Re: [cisco-voip] Question about RISDB queries and ATA devices?
>
>
>
> It definitely sucks that CUCM 14 SU2 broke this. It was very helpful. Should be an easier way to export Devices } Phone to a csv file for download via GUI. But there is not.
>
>
>
> On Thu, May 25, 2023, 8:09 PM <nateccie at gmail.com> wrote:
>
> What is the goal? I usually get what I want from device/phone, copy it all into the clipboard and paste without formatting into excel and continue on. In older versions of CUCM you can change the rows per page, then edit the URL to make rows per page all of the devices on the system up to many thousands.
>
>
>
> From: cisco-voip <cisco-voip-bounces at puck.nether.net> On Behalf Of Ryan Ratliff (rratliff)
> Sent: Thursday, May 25, 2023 10:46 AM
> To: Tim Reimers <treimers at ashevillenc.gov>; Wes Sisk (wsisk) <wsisk at cisco.com>
> Cc: cisco-voip <cisco-voip at puck.nether.net>
> Subject: Re: [cisco-voip] Question about RISDB queries and ATA devices?
>
>
>
> I’m not surprised the “phone” filter only shows you SEP devices. I was expecting RTMT to give you a friendlier way to browse around and find the ATAs.
>
>
>
> Do any of the other risdb CLI filters give you those devices?
>
> Interrogating the API directly is another option.
> https://developer.cisco.com/docs/sxml/#!risport70-api-reference/selectcmdevice
>
>
>
> -Ryan
>
>
>
> From: cisco-voip <cisco-voip-bounces at puck.nether.net> on behalf of Tim Reimers <treimers at ashevillenc.gov>
> Date: Thursday, May 25, 2023 at 12:06 PM
> To: Wes Sisk (wsisk) <wsisk at cisco.com>
> Cc: cisco-voip <cisco-voip at puck.nether.net>
> Subject: Re: [cisco-voip] Question about RISDB queries and ATA devices?
>
> Hi Wes, Ryan, all
>
>
>
> I'm not seeing any of the registered ATAs showing up in RTMT under a Device Search either -- only SEP devices.
>
>
>
> I gather that you are all expecting that 'show risdb query phone' as well as RTMT should be showing the ATAs registered and counted alongside the SEP devices
>
> so long as the ATAs are running in SCCP mode and not something else...
>
>
>
> Thanks Tim
>
>
>
> On Thu, May 25, 2023 at 10:17 AM Wes Sisk (wsisk) <wsisk at cisco.com> wrote:
>
> Yes, registration information is in RIS not in SQL(informix). I see some other mentions of this, but not clear resolution.
>
>
>
> Note that ATA may follow different CM server resolution and 'show risdb' is per-node. Aka, have you checked all nodes with CM service activated where ATAs might be registered?
>
>
>
> Oh, and ATAs could be h.323 for a while, so are they registering as SCCP?
>
>
>
> -w
>
>
>
> On May 25, 2023, at 9:50 AM, Tim Reimers <treimers at ashevillenc.gov> wrote:
>
>
>
> Hi all -
>
>
>
> I'm trying to find the ACTIVELY REGISTERED devices on my UCM 9.1 system.
>
>
>
> I need to find the list of actively registered ATA 186 devices and their DNs.
>
>
>
> * I'm using "show risdb query phones" command, as documented here among other sites
>
> https://getpractical.co.uk/2021/10/11/cisco-cucm-reports-from-sql-show-risdb/
>
>
>
> That seems to show only the SEPxxxxyyyyzzz devices, aka my 79XX SCCP phones.
>
>
>
> I don't see any ATAxxxxyyyyzzzz devices being returned.
>
> Are they not in the "phone" table of the RISDB?
>
>
>
> Thanks, Tim
>
>
>
> * my understanding is that any variation on the "run sql select" is
>
> simply querying the Oracle? database for _configured_ devices only, and isn't looking
>
> at the memory table of the Callmanager process to see the _currently registered_ devices.
>
> (I've seen a number of other forum posts where people suggested "run sql" commands to gather info, but that is statically configured, not necessarily "registered", so that does not seem appropriate for the info I want).
>
>
>
>
>
>
> --
>
> Quis custodiet ipsos nexus
>
> Tim Reimers
>
> Network Administrator
>
> I.T Services
>
> City of Asheville
>
> treimers at ashevillenc.gov
>
> (desk) 828-259-5512
>
> (cell) 828-552-1585
>
> "That’s no ordinary rabbit packet! That’s the most foul, cruel, and bad tempered badly framed packet you ever set eyes on. Listen, that packet’s got a vicious streak a mile wide, he’s a killer.He’s got huge sharp MTU…eh, he can leap about and cross Vlans…. I warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless little packet on the network, isn’t it now...."
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
>
> --
>
> Quis custodiet ipsos nexus
>
> Tim Reimers
>
> Network Administrator
>
> I.T Services
>
> City of Asheville
>
> treimers at ashevillenc.gov
>
> (desk) 828-259-5512
>
> (cell) 828-552-1585
>
> "That’s no ordinary rabbit packet! That’s the most foul, cruel, and bad tempered badly framed packet you ever set eyes on. Listen, that packet’s got a vicious streak a mile wide, he’s a killer.He’s got huge sharp MTU…eh, he can leap about and cross Vlans…. I warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless little packet on the network, isn’t it now...."
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
More information about the cisco-voip
mailing list