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

[Jason Aarons]

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
> <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...."
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20230525/b14c0dee/attachment.htm>