[cisco-voip] Question about RISDB queries and ATA devices?

[Tim Reimers]

Hi Ryan, Wes, all --

I only have two nodes, and am checking both....
I wondered if they're registering as SCCP or H.323, so I looked at H.323 as
well - no show there either, only gateway devices.

In UCM web interface under Device>Phones dialog, there are ATAs registered.

Device Protocol shows as SCCP.
Firmware on one selected at random ATA is
ATA030203SCCP051201A.zup

A view of
*admin:show risdb query phoneextn*

*also does not find the DN of any given ATA that I can otherwise find in
the Device*

*I'm not sure what you mean in terms of RTMT.*
*That shows the number of registered phones -- *
*When I did a Device Search, I didn't see a way to select ATAs in specific
- just all other models of device*
*(which didn't work either, so I guess I was doing something wrong somehow)*


*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
> <https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F>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
<https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F>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...."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20230525/fcb2f13c/attachment.htm>