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) <ws...@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 <treim...@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 > > treim...@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@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 treim...@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@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip