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

Thu Jun 1 19:55:53 EDT 2023

This is the way to do it. I add filters all the time to add additional
columns under the Device->Phone page.

On Thu, May 25, 2023, 2:37 PM <nateccie at gmail.com> wrote:

> Just add the filter on the device/phone page to include directory number
> and you’ll be good to go.
>
>
>
> *From:* Tim Reimers <treimers at ashevillenc.gov>
> *Sent:* Thursday, May 25, 2023 12:27 PM
> *To:* nateccie at gmail.com
> *Cc:* Ryan Ratliff (rratliff) <rratliff at cisco.com>; 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?
>
>
>
> Sorry, sent before being ready...
>
>
>
> What I was hoping for was a list of all the registered active ATAs that
> would INCLUDE the DN on them.
>
> As it is -- if I simply use the admin website, as you said, I can get a
> list of all the devices that are registered.
>
>
>
> I've actually got the individual ATAs downloaded that way, and sorted by
> "Registered" in a Google Sheet.
>
>
>
> I cannot easily also match those up with the DNs.
>
> I suppose one could probably then write some sort of SQL command that
> would specify a long-ish list of ATA device names to query for DN.
>
>
>
> It may be time to just ask an Intern to click on each ATA that's
> registered and collect the DN and description.
>
>
>
> I thought about asking one of our DB people to do that --
>
> But they'd want a project set up, and require a complete list of the table
> schema, the IP/TCP port and data connection, etc
>
> to do things as they're used to, with a direct SQL connection to query
> against.
>
> They're not used to having to operate the way Cisco does with CLI only
> access to SQL in a limited fashion.
>
> And I get why Cisco does that... not arguing that point.
>
>
>
>
>
>
>
>
>
> On Thu, May 25, 2023 at 2:18 PM Tim Reimers <treimers at ashevillenc.gov>
> wrote:
>
> Nate, I may have to do that.
>
>
>
> I just thought I was crazy that ATAs don't show up in
>
> show risdb query phone
>
>
>
> T
>
>
>
> On Thu, May 25, 2023 at 2:08 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...."
>
>
>
>
> --
>
> *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...."
>
>
>
>
> --
>
> *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/20230601/5a23a962/attachment.htm>