Mailing List Archive

You are on the right track looking in RIS. Have you poked around in RTMT yet?.

-Ryan

From: cisco-voip <cisco-voip-bounces@puck.nether.net> on behalf of Tim Reimers <treimers@ashevillenc.gov>
Date: Thursday, May 25, 2023 at 9:51 AM
To: cisco-voip <cisco-voip@puck.nether.net>
Subject: [cisco-voip] Question about RISDB queries and ATA devices?
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@ashevillenc.gov<mailto:treimers@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...."

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@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@ashevillenc.gov<mailto:treimers@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

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@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@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@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

treimers@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...."

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@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@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@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

treimers@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...."

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@puck.nether.net> on behalf of Tim Reimers <treimers@ashevillenc.gov>
Date: Thursday, May 25, 2023 at 12:06 PM
To: Wes Sisk (wsisk) <wsisk@cisco.com>
Cc: cisco-voip <cisco-voip@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@cisco.com<mailto:wsisk@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@ashevillenc.gov<mailto:treimers@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@ashevillenc.gov<mailto:treimers@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<mailto: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

treimers@ashevillenc.gov<mailto:treimers@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...."

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@puck.nether.net> On Behalf Of Ryan Ratliff (rratliff)
Sent: Thursday, May 25, 2023 10:46 AM
To: Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <wsisk@cisco.com>
Cc: cisco-voip <cisco-voip@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@puck.nether.net <mailto:cisco-voip-bounces@puck.nether.net> > on behalf of Tim Reimers <treimers@ashevillenc.gov <mailto:treimers@ashevillenc.gov> >
Date: Thursday, May 25, 2023 at 12:06 PM
To: Wes Sisk (wsisk) <wsisk@cisco.com <mailto:wsisk@cisco.com> >
Cc: cisco-voip <cisco-voip@puck.nether.net <mailto:cisco-voip@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@cisco.com <mailto:wsisk@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@ashevillenc.gov <mailto:treimers@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@ashevillenc.gov <mailto:treimers@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 <mailto: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

treimers@ashevillenc.gov <mailto:treimers@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...."

Not that I could find - which is interesting...

I didn't realize that the ATAs were so "alien" to Cisco such that they
weren't part of the built-in designs.


On Thu, May 25, 2023 at 12:45?PM Ryan Ratliff (rratliff) <rratliff@cisco.com>
wrote:

> 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@puck.nether.net> on behalf of Tim
> Reimers <treimers@ashevillenc.gov>
> *Date: *Thursday, May 25, 2023 at 12:06 PM
> *To: *Wes Sisk (wsisk) <wsisk@cisco.com>
> *Cc: *cisco-voip <cisco-voip@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@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@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@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
>
> treimers@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@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...."

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@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@puck.nether.net> *On Behalf Of *Ryan
> Ratliff (rratliff)
> *Sent:* Thursday, May 25, 2023 10:46 AM
> *To:* Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <
> wsisk@cisco.com>
> *Cc:* cisco-voip <cisco-voip@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@puck.nether.net> on behalf of Tim
> Reimers <treimers@ashevillenc.gov>
> *Date: *Thursday, May 25, 2023 at 12:06 PM
> *To: *Wes Sisk (wsisk) <wsisk@cisco.com>
> *Cc: *cisco-voip <cisco-voip@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@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@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@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
>
> treimers@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@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...."

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@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@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@puck.nether.net> *On Behalf Of *Ryan
>> Ratliff (rratliff)
>> *Sent:* Thursday, May 25, 2023 10:46 AM
>> *To:* Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <
>> wsisk@cisco.com>
>> *Cc:* cisco-voip <cisco-voip@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@puck.nether.net> on behalf of Tim
>> Reimers <treimers@ashevillenc.gov>
>> *Date: *Thursday, May 25, 2023 at 12:06 PM
>> *To: *Wes Sisk (wsisk) <wsisk@cisco.com>
>> *Cc: *cisco-voip <cisco-voip@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@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@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@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
>>
>> treimers@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@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@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...."

Just add the filter on the device/phone page to include directory number and you’ll be good to go.



From: Tim Reimers <treimers@ashevillenc.gov>
Sent: Thursday, May 25, 2023 12:27 PM
To: nateccie@gmail.com
Cc: Ryan Ratliff (rratliff) <rratliff@cisco.com>; Wes Sisk (wsisk) <wsisk@cisco.com>; cisco-voip <cisco-voip@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@ashevillenc.gov <mailto:treimers@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@gmail.com <mailto:nateccie@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@puck.nether.net <mailto:cisco-voip-bounces@puck.nether.net> > On Behalf Of Ryan Ratliff (rratliff)
Sent: Thursday, May 25, 2023 10:46 AM
To: Tim Reimers <treimers@ashevillenc.gov <mailto:treimers@ashevillenc.gov> >; Wes Sisk (wsisk) <wsisk@cisco.com <mailto:wsisk@cisco.com> >
Cc: cisco-voip <cisco-voip@puck.nether.net <mailto:cisco-voip@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@puck.nether.net <mailto:cisco-voip-bounces@puck.nether.net> > on behalf of Tim Reimers <treimers@ashevillenc.gov <mailto:treimers@ashevillenc.gov> >
Date: Thursday, May 25, 2023 at 12:06 PM
To: Wes Sisk (wsisk) <wsisk@cisco.com <mailto:wsisk@cisco.com> >
Cc: cisco-voip <cisco-voip@puck.nether.net <mailto:cisco-voip@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@cisco.com <mailto:wsisk@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@ashevillenc.gov <mailto:treimers@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@ashevillenc.gov <mailto:treimers@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 <mailto: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

treimers@ashevillenc.gov <mailto:treimers@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@ashevillenc.gov <mailto:treimers@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@ashevillenc.gov <mailto:treimers@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...."

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@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@puck.nether.net> *On Behalf Of *Ryan
> Ratliff (rratliff)
> *Sent:* Thursday, May 25, 2023 10:46 AM
> *To:* Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <
> wsisk@cisco.com>
> *Cc:* cisco-voip <cisco-voip@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@puck.nether.net> on behalf of Tim
> Reimers <treimers@ashevillenc.gov>
> *Date: *Thursday, May 25, 2023 at 12:06 PM
> *To: *Wes Sisk (wsisk) <wsisk@cisco.com>
> *Cc: *cisco-voip <cisco-voip@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@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@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@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
>
> treimers@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
>

It was broken in newer SUs of 11.5 and 12.5. I’ve relied on this for 20 years, and then it just went away. Oh well to the cloud we go.



From: Jason Aarons <scubajasona@gmail.com>
Sent: Thursday, May 25, 2023 12:40 PM
To: NateCCIE <nateccie@gmail.com>
Cc: Ryan Ratliff (rratliff) <rratliff@cisco.com>; Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <wsisk@cisco.com>; cisco-voip <cisco-voip@puck.nether.net>
Subject: Re: [cisco-voip] Question about RISDB queries and ATA devices?



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@gmail.com <mailto:nateccie@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@puck.nether.net <mailto:cisco-voip-bounces@puck.nether.net> > On Behalf Of Ryan Ratliff (rratliff)
Sent: Thursday, May 25, 2023 10:46 AM
To: Tim Reimers <treimers@ashevillenc.gov <mailto:treimers@ashevillenc.gov> >; Wes Sisk (wsisk) <wsisk@cisco.com <mailto:wsisk@cisco.com> >
Cc: cisco-voip <cisco-voip@puck.nether.net <mailto:cisco-voip@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@puck.nether.net <mailto:cisco-voip-bounces@puck.nether.net> > on behalf of Tim Reimers <treimers@ashevillenc.gov <mailto:treimers@ashevillenc.gov> >
Date: Thursday, May 25, 2023 at 12:06 PM
To: Wes Sisk (wsisk) <wsisk@cisco.com <mailto:wsisk@cisco.com> >
Cc: cisco-voip <cisco-voip@puck.nether.net <mailto:cisco-voip@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@cisco.com <mailto:wsisk@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@ashevillenc.gov <mailto:treimers@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@ashevillenc.gov <mailto:treimers@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 <mailto: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

treimers@ashevillenc.gov <mailto:treimers@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 <mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

For the programmers out there...
I'm not sure exactly how to do it if you have SKIGW-style names (it
may be possible, I have just never tried). But if you have an
ANA-style name, you can resolve it to a description or a dn using AXL.
Here is how to do it using axlrows (https://github.com/uah/axlrows):

for phone in get_phones(name="ANA5C5D4C4C8000"):
print(phone.description)
print(phone.lines[0][0].dirn.pattern)

BEV - Lobby ATM
5331

I want to say the registration state is all available via SNMP as well.

--
Hunter Fuller (they)
Router Jockey
VBH M-1C
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering


On Thu, May 25, 2023 at 1:48?PM <nateccie@gmail.com> wrote:
>
> It was broken in newer SUs of 11.5 and 12.5. I’ve relied on this for 20 years, and then it just went away. Oh well to the cloud we go.
>
>
>
> From: Jason Aarons <scubajasona@gmail.com>
> Sent: Thursday, May 25, 2023 12:40 PM
> To: NateCCIE <nateccie@gmail.com>
> Cc: Ryan Ratliff (rratliff) <rratliff@cisco.com>; Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <wsisk@cisco.com>; cisco-voip <cisco-voip@puck.nether.net>
> Subject: Re: [cisco-voip] Question about RISDB queries and ATA devices?
>
>
>
> 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@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@puck.nether.net> On Behalf Of Ryan Ratliff (rratliff)
> Sent: Thursday, May 25, 2023 10:46 AM
> To: Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <wsisk@cisco.com>
> Cc: cisco-voip <cisco-voip@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@puck.nether.net> on behalf of Tim Reimers <treimers@ashevillenc.gov>
> Date: Thursday, May 25, 2023 at 12:06 PM
> To: Wes Sisk (wsisk) <wsisk@cisco.com>
> Cc: cisco-voip <cisco-voip@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@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@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 ipsos nexus
>
> Tim Reimers
>
> Network Administrator
>
> I.T Services
>
> City of Asheville
>
> treimers@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 ipsos nexus
>
> Tim Reimers
>
> Network Administrator
>
> I.T Services
>
> City of Asheville
>
> treimers@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
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Interesting. If you try device search by name?
https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/200578-Monitor-Cisco-IP-Phones-Using-Call-Manag.html


If it shows as "registered" in ccmadmin then ccmadmin queries risdb for device status. We're missing something.

-w

On May 25, 2023, at 10:58 AM, Tim Reimers <treimers@ashevillenc.gov> wrote:

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@cisco.com<mailto:wsisk@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@ashevillenc.gov<mailto:treimers@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@ashevillenc.gov<mailto:treimers@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<mailto: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

treimers@ashevillenc.gov<mailto:treimers@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...."

How about a BAT/BPS export?

-w

On May 25, 2023, at 2:26 PM, Tim Reimers <treimers@ashevillenc.gov> wrote:

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@ashevillenc.gov<mailto:treimers@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@gmail.com<mailto:nateccie@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@puck.nether.net<mailto:cisco-voip-bounces@puck.nether.net>> On Behalf Of Ryan Ratliff (rratliff)
Sent: Thursday, May 25, 2023 10:46 AM
To: Tim Reimers <treimers@ashevillenc.gov<mailto:treimers@ashevillenc.gov>>; Wes Sisk (wsisk) <wsisk@cisco.com<mailto:wsisk@cisco.com>>
Cc: cisco-voip <cisco-voip@puck.nether.net<mailto:cisco-voip@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@puck.nether.net<mailto:cisco-voip-bounces@puck.nether.net>> on behalf of Tim Reimers <treimers@ashevillenc.gov<mailto:treimers@ashevillenc.gov>>
Date: Thursday, May 25, 2023 at 12:06 PM
To: Wes Sisk (wsisk) <wsisk@cisco.com<mailto:wsisk@cisco.com>>
Cc: cisco-voip <cisco-voip@puck.nether.net<mailto:cisco-voip@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@cisco.com<mailto:wsisk@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@ashevillenc.gov<mailto:treimers@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@ashevillenc.gov<mailto:treimers@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<mailto: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

treimers@ashevillenc.gov<mailto:treimers@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@ashevillenc.gov<mailto:treimers@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@ashevillenc.gov<mailto:treimers@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...."

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@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@ashevillenc.gov>
> *Sent:* Thursday, May 25, 2023 12:27 PM
> *To:* nateccie@gmail.com
> *Cc:* Ryan Ratliff (rratliff) <rratliff@cisco.com>; Wes Sisk (wsisk) <
> wsisk@cisco.com>; cisco-voip <cisco-voip@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@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@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@puck.nether.net> *On Behalf Of *Ryan
> Ratliff (rratliff)
> *Sent:* Thursday, May 25, 2023 10:46 AM
> *To:* Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <
> wsisk@cisco.com>
> *Cc:* cisco-voip <cisco-voip@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@puck.nether.net> on behalf of Tim
> Reimers <treimers@ashevillenc.gov>
> *Date: *Thursday, May 25, 2023 at 12:06 PM
> *To: *Wes Sisk (wsisk) <wsisk@cisco.com>
> *Cc: *cisco-voip <cisco-voip@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@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@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@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
>
> treimers@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@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@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
>