Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Custom query help (Ricardo Stella)
--- Begin Message ---
Thanks - Two questions:
* How can you do multiple reports? It only looks like the last one defined
is shown. I have them as follows:
reports:
- tag: wap_speed
...
reports:
- tag: admin_up_down
...
* Also, looks like I'm not sure how to do this one - Syntax seems correct,
but getting search failed.
reports:
- tag: wap_port_speeds
label: 'WAP Port Speeds'
columns:
- { host: Device_name}
- { ip: ip}
- { port: Port}
- { name: Description}
- { speed: 'Speed'}
query: |
SELECT device.name AS host, device_port.ip, device_port.port,
device_port.name
FROM device_port
LEFT JOIN device_port_properties ON device_port.ip =
device_port_properties.ip
WHERE remote_is_wap
Ricardo.
On Wed, Aug 25, 2021 at 3:42 AM Oliver Gorwits <oli...@cpan.org> wrote:
> Hi Ricardo and Juan
>
> Yes Juan is right, that's the easiest method if you have consistently
> named access points. You can start with the reports here:
>
> https://github.com/netdisco/netdisco/wiki/Custom-Reports
>
> (yes we started a wiki page for helping this)
>
> The first report joins the device and device_port table which is what you
> need to do to get both the hostname (device.dns) and speed
> (device_port.speed).
>
> Alternatively, to select devices which report themselves as APs, join on
> device_port_properties and inspect the remote_is_wap field:
>
> LEFT JOIN device_port_properties ON device_port.ip = device_port_properties.ip
> ...
> WHERE remote_is_wap
>
> Just think about which way round you are doing it: looking for APs with
> ports running less than 1Gbps, or switch ports connected to APs running
> less than 1Gbps.
> It might be easier to do the second because APs have multiple interfaces
> and you only want the uplink to the switch after all.
>
> Good luck,
>
> Oliver.
>
>
>
> On Wed, 25 Aug 2021 at 04:51, Juan Romero <jrom...@auroranetworks.net>
> wrote:
>
>> Try sthg like this on the PSQL DB.
>>
>> Replace:
>>
>>
>>
>> like '%AV%'
>>
>>
>>
>> with a wildcard matching your WAPs hostnames
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -----------------------------------------------------
>>
>> Juan J. Romero
>>
>> Founder & Director
>>
>> email: *jrom...@auroranetworks.net <jrom...@auroranetworks.net>*
>>
>> m: *+61420246579*
>>
>> https://www.auroranetworks.net
>>
>> https://logio.auroranetworks.net
>>
>> Aurora Networks Managed Services
>>
>> ABN: 50 627 553 619
>>
>> 20-24 Premier Street
>>
>> Kogarah, NSW 2217
>>
>>
>>
>> Follow us on Locals:
>>
>> https://cybersec.locals.com/
>>
>> -----Original message-----
>> *From:* Ricardo Stella
>> *Sent:* Wednesday, August 25 2021, 7:52 am
>> *To:* netdisco-users@lists.sourceforge.net
>> *Subject:* [Netdisco] Custom query help
>>
>> Hi folks, not a DBA nor programmer here so figure I ask if someone has
>> done something similar.
>>
>> Trying to do a query or search for say "active access points running at
>> 100mbps", or at least "devices running at less than 1gbps"
>>
>> Any ideas on how to do this via the GUI or command line?
>>
>> TIA
>>
>> --
>> °(((*=*((*===°°°*(((*================================================*
>>
>>
>>
>> _______________________________________________
>>
>> Netdisco mailing list
>> netdisco-users@lists.sourceforge.net
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>>
>> _______________________________________________
>> Netdisco mailing list
>> netdisco-users@lists.sourceforge.net
>> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
>
--
°(((=((===°°°(((================================================
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
