[cisco-voip] Report or query to find phones with web server enabled?

[Raffi Rodrigo]

alguem tem sala da cisco webex que possa me ajuda

Em sex., 2 de abr. de 2021 às 08:51, Adam Pawlowski <ajp26 at buffalo.edu>
escreveu:

> It’s sort of annoying to do this, the common configuration settings don’t
> show up in the device configuration table unless you’ve explicitly enabled
> it there.
>
>
>
> If you’re looking at the device level, this seems to work just poking
> around:
>
>
>
> run sql ccm select device.name as name from device inner join devicexml4k
> on device.pkid = devicexml4k.fkdevice where devicexml4k.xml LIKE
> "%<webAccess>0</webAccess>%"
>
>
>
> As it is of course intuitive, webAccess being set to 0 appears to mean
> enabled, and 1 means disabled.
>
>
>
> If you don’t override the setting with the check, neither appears in the
> table that’s querying.
>
>
>
> Best,
>
>
>
> Adam
>
>
>
>
>
> *From:* cisco-voip <cisco-voip-bounces at puck.nether.net> *On Behalf Of *Nick
> Barnett
> *Sent:* Friday, April 2, 2021 11:09 AM
> *To:* cisco-voip <cisco-voip at puck.nether.net>
> *Subject:* [cisco-voip] Report or query to find phones with web server
> enabled?
>
>
>
> Does anyone have a way to do this? This setting is stored in the device
> specific settings for the phone, so retrieving the entry in the device
> table isn't sufficient. There is also the advanceddeviceconfigparams table,
> but I can't figure out how to interract with it properly.
>
>
>
> Usually I start out with something simple like:
>
> select * from device where name='SEPDEADBEEF1234'
>
>
>
> and then I can drill down, my next attempt was:
>
> select * from advanceddeviceconfigparams where fkdevice='PKID-OF-MY-PHONE'
>
>
>
> which returned nothing
>
>
>
> then I went to my lab cluster and did:
>
> select * from advanceddeviceconfigparams
>
>
>
> and nothing came back.
>
>
>
> I was expecting a list of UUIDs and settings to come back that I would
> then continue to step through until I got the data I needed. So I guess I
> don't know how device table interracts with advanceddeviceconfigparams.
> What am i missing here?
>
>
>
> Any help is appreciated.
>
>
>
> Thanks,
>
> Nick
>
>
> _______________________________________________
> 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/20210402/ac8d7ab1/attachment.htm>