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

[Tim Reimers]

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...."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20230525/5187481f/attachment.htm>